Migrate Jom Comment from Joomla 1.0 to Joomla 1.5 PDF Print E-mail
Friday, 20 June 2008
  1. Export jos_jomcomment from your old database (you can use phpMyAdmin). If you have another prefix on the table, like mos_ you need to open the exported file with Wordpad and replace all instances of mos_jomcomment with jos_jomcomment.
  2. Drop jom_comment from your new database.
  3. Import your old exported jos_jomcomment table.
  4. Run the following SQL quries (you can use phpMyAdmin):


ALTER TABLE `jos_jomcomment` CHANGE `comment` `comment` TEXT CHARACTER SET binary NOT NULL ; ALTER TABLE `jos_jomcomment` CHANGE `comment` `comment` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL

 ALTER TABLE `jos_jomcomment` CHANGE `title` `title` VARCHAR(200) CHARACTER SET binary NOT NULL ; ALTER TABLE `jos_jomcomment` CHANGE `title` `title` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;

ALTER TABLE `jos_jomcomment` CHANGE `name` `name` VARCHAR(200) CHARACTER SET binary NOT NULL ; ALTER TABLE `jos_jomcomment` CHANGE `name` `name` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;

 
Next >