PDA

Zobacz pełną wersję : JPortal2 -> Joomla 1.5



Wolek
04-11-2009, 18:15
Witam,
jestem posiadaczem strony na silniku JPortal 2 . Silnik jest już nie odświeżany, nikt nad tym nie pracuje i postanowiłem zainstalować Joomla 1.5 i moje pytanie brzmi jak wykonać taką migracje ? Laikiem jestem w sprawach joomli i jportal'u , znam się b.dobrze na phpbb i php fusion napewno taka wiedza mi pomoże.

Jezeli jest już taki temat, to proszę o link, jeszcze nie połapałem się nad całą waszą stroną.

pyziak
04-11-2009, 18:56
z mojej wiedzy to nie ma takiego migratora (mogę się mylić), jeżeli stary portal jest bardzo mocno rozbudowany, to trzeba porównać strukturę baz i napisać scrypt, który je dopasuje. Jeżeli natomiast nie jest zbyt duży to trzeba przenieść ręcznie.

psych
16-03-2010, 04:49
znalezione w sieci http://michal.ozorkow.net/2008/05/26/jportal2joomla/ SQLowy skrypt do komentarzy :


TRUNCATE TABLE `jos_content`;

TRUNCATE TABLE `jos_content_frontpage`;

TRUNCATE TABLE `jos_akocomment`;

INSERT INTO jos_content (`id`, `title`, `introtext`, `fulltext`, `state`, `sectionid`, `catid`, `created`, `created_by`, `publish_up`) SELECT `id`, `title`, `text`, `textcd`, '1', '1', '1', `date`, '62', `date` FROM portalnews WHERE portalnews.stat != 3;

INSERT INTO jos_content_frontpage (`content_id`, `ordering`) SELECT `id`, 2782-`id` FROM portalnews WHERE portalnews.stat != 3;

INSERT INTO jos_akocomment (`name`, `title`, `comment`, `date`, `published`, `contentid`) SELECT `name`, `title`, `text`, `date`, '1', `wid` FROM portalcomments WHERE portalcomments.what = 'news';

UPDATE jos_content SET `title`= REPLACE(`title`, '\\"', '"'), `introtext`= REPLACE(`introtext`, '\\"', '"'), `fulltext`= REPLACE(`fulltext`, '\\"', '"');

UPDATE jos_akocomment SET `title`= REPLACE(`title`, '\\"', '"'), `comment`= REPLACE(`comment`, '\\"', '"');

UPDATE jos_content SET `introtext`= REPLACE(`introtext`, '', '<i>'), `introtext`= REPLACE(`introtext`, '', '</i>'), `introtext`= REPLACE(`introtext`, '', '<u>'), `introtext`= REPLACE(`introtext`, '', '</u>'), `introtext`= REPLACE(`introtext`, '', '<b>'), `introtext`= REPLACE(`introtext`, '', '</b>'), `fulltext`= REPLACE(`fulltext`, '', '<i>'), `fulltext`= REPLACE(`fulltext`, '', '</i>'), `fulltext`= REPLACE(`fulltext`, '', '<u>'), `fulltext`= REPLACE(`fulltext`, '', '</u>'), `fulltext`= REPLACE(`fulltext`, '', '<b>'), `fulltext`= REPLACE(`fulltext`, '', '</b>');

UPDATE jos_akocomment SET `comment`= REPLACE(`comment`, '', '<i>'), `comment`= REPLACE(`comment`, '', '</i>'), `comment`= REPLACE(`comment`, '', '<u>'), `comment`= REPLACE(`comment`, '', '</u>'), `comment`= REPLACE(`comment`, '', '<b>'), `comment`= REPLACE(`comment`, '', '</b>');

poza tym jeszcze potrzebowałem poprawić kodowanie:

UPDATE `jos_beta_content` SET `introtext` = REPLACE(`introtext`, '³', 'ł');
UPDATE `jos_beta_content` SET `introtext` = REPLACE(`introtext`, '£', 'Ł');
UPDATE `jos_beta_content` SET `introtext` = REPLACE(`introtext`, 'ó', 'ó');
UPDATE `jos_beta_content` SET `introtext` = REPLACE(`introtext`, 'Ó', 'Ó');
UPDATE `jos_beta_content` SET `introtext` = REPLACE(`introtext`, 'ê', 'ę');
UPDATE `jos_beta_content` SET `introtext` = REPLACE(`introtext`, 'Ê', 'Ę');
UPDATE `jos_beta_content` SET `introtext` = REPLACE(`introtext`, '±', 'ą');
UPDATE `jos_beta_content` SET `introtext` = REPLACE(`introtext`, '¡', 'Ą');
UPDATE `jos_beta_content` SET `introtext` = REPLACE(`introtext`, '¶', 'ś');
UPDATE `jos_beta_content` SET `introtext` = REPLACE(`introtext`, '¦', 'Ś');
UPDATE `jos_beta_content` SET `introtext` = REPLACE(`introtext`, 'æ', 'ć');
UPDATE `jos_beta_content` SET `introtext` = REPLACE(`introtext`, 'Æ', 'Ć');
UPDATE `jos_beta_content` SET `introtext` = REPLACE(`introtext`, 'ñ', 'ń');
UPDATE `jos_beta_content` SET `introtext` = REPLACE(`introtext`, 'Ñ', 'Ń');
UPDATE `jos_beta_content` SET `introtext` = REPLACE(`introtext`, '¿', 'ż');
UPDATE `jos_beta_content` SET `introtext` = REPLACE(`introtext`, '¯', 'Ż');
UPDATE `jos_beta_content` SET `introtext` = REPLACE(`introtext`, '¼', 'ź');
UPDATE `jos_beta_content` SET `introtext` = REPLACE(`introtext`, '¬', 'Ź');

UPDATE `jos_beta_content` SET `title` = REPLACE(`title`, '³', 'ł');
UPDATE `jos_beta_content` SET `title` = REPLACE(`title`, '£', 'Ł');
UPDATE `jos_beta_content` SET `title` = REPLACE(`title`, 'ó', 'ó');
UPDATE `jos_beta_content` SET `title` = REPLACE(`title`, 'Ó', 'Ó');
UPDATE `jos_beta_content` SET `title` = REPLACE(`title`, 'ê', 'ę');
UPDATE `jos_beta_content` SET `title` = REPLACE(`title`, 'Ê', 'Ę');
UPDATE `jos_beta_content` SET `title` = REPLACE(`title`, '±', 'ą');
UPDATE `jos_beta_content` SET `title` = REPLACE(`title`, '¡', 'Ą');
UPDATE `jos_beta_content` SET `title` = REPLACE(`title`, '¶', 'ś');
UPDATE `jos_beta_content` SET `title` = REPLACE(`title`, '¦', 'Ś');
UPDATE `jos_beta_content` SET `title` = REPLACE(`title`, 'æ', 'ć');
UPDATE `jos_beta_content` SET `title` = REPLACE(`title`, 'Æ', 'Ć');
UPDATE `jos_beta_content` SET `title` = REPLACE(`title`, 'ñ', 'ń');
UPDATE `jos_beta_content` SET `title` = REPLACE(`title`, 'Ñ', 'Ń');
UPDATE `jos_beta_content` SET `title` = REPLACE(`title`, '¿', 'ż');
UPDATE `jos_beta_content` SET `title` = REPLACE(`title`, '¯', 'Ż');
UPDATE `jos_beta_content` SET `title` = REPLACE(`title`, '¼', 'ź');
UPDATE `jos_beta_content` SET `title` = REPLACE(`title`, '¬', 'Ź');

UPDATE `jos_beta_content` SET `fulltext` = REPLACE(`fulltext`, '³', 'ł');
UPDATE `jos_beta_content` SET `fulltext` = REPLACE(`fulltext`, '£', 'Ł');
UPDATE `jos_beta_content` SET `fulltext` = REPLACE(`fulltext`, 'ó', 'ó');
UPDATE `jos_beta_content` SET `fulltext` = REPLACE(`fulltext`, 'Ó', 'Ó');
UPDATE `jos_beta_content` SET `fulltext` = REPLACE(`fulltext`, 'ê', 'ę');
UPDATE `jos_beta_content` SET `fulltext` = REPLACE(`fulltext`, 'Ê', 'Ę');
UPDATE `jos_beta_content` SET `fulltext` = REPLACE(`fulltext`, '±', 'ą');
UPDATE `jos_beta_content` SET `fulltext` = REPLACE(`fulltext`, '¡', 'Ą');
UPDATE `jos_beta_content` SET `fulltext` = REPLACE(`fulltext`, '¶', 'ś');
UPDATE `jos_beta_content` SET `fulltext` = REPLACE(`fulltext`, '¦', 'Ś');
UPDATE `jos_beta_content` SET `fulltext` = REPLACE(`fulltext`, 'æ', 'ć');
UPDATE `jos_beta_content` SET `fulltext` = REPLACE(`fulltext`, 'Æ', 'Ć');
UPDATE `jos_beta_content` SET `fulltext` = REPLACE(`fulltext`, 'ñ', 'ń');
UPDATE `jos_beta_content` SET `fulltext` = REPLACE(`fulltext`, 'Ñ', 'Ń');
UPDATE `jos_beta_content` SET `fulltext` = REPLACE(`fulltext`, '¿', 'ż');
UPDATE `jos_beta_content` SET `fulltext` = REPLACE(`fulltext`, '¯', 'Ż');
UPDATE `jos_beta_content` SET `fulltext` = REPLACE(`fulltext`, '¼', 'ź');
UPDATE `jos_beta_content` SET `fulltext` = REPLACE(`fulltext`, '¬', 'Ź');