jReviews :: Customer support forum

I apologize for the lack of documentation, but I preferred to release the beta as soon as possible since so many users were waiting for it. I've only migrated one jReviews installation and that was the demo site. If you would like to share your steps, then please do so you can help others. Here's what I did using phpMyAdmin:

1. Export core table data (not structure) using the complete insert option. Complete insert is important because the table fields are somewhat different. You only need to export data for the core tables:

jos_content, jos_categories, jos_sections, jos_content_frontpage, jos_content_rating (optional if you are using core ratings anywhere on your site).

Alternatively you can use the migrator application in J1.5, but I haven't used this so you need to hit the Joomla.org site for that.

Now import it in your new site.

2. Export jreviews tables including table structure and data and select the drop tables option. By now you should've already installed jReviews on your new site. Because the table structure is exactly the same and because some tables contain columns for custom fields, you must use the drop tables options so they are re-created with the correct columns.

Now import it in your new site.

This works well for english, but might produce problems for languages with special characters if you are moving from a non-ut8 site. Unfortunately I don't know the steps to convert from non-utf8 to utf8 at the moment. If anyone does this, please share.

I have a clean install of joomla 1.5.  I was under the impression that jr reviews would not be difficult to install. Is it difficult with this release?

Thanks.

That is definitely more complicated, even without jReviews. For instance if you have sections and categories with certain ids in your Joomla 1.0 site that already exist in your Joomla 1.5 you need to change those ids which needs to be changed in the sections table, category table and content table for the content item belonging to those categories. The same goes for content ids, and that affects the jReviews comments table which stores those ids for each review.

This is a complicated migration, without even considering jReviews, if you have overlapping section,category and content ids and you should hire someone with Joomla and mysql expertise to help you with it.

Why don't you rename the table from bak_ to jos_ ? If you export it, you need to edit it and do a search replace of bak_ for jos_ because changing the file name doesn't do anything to the table names.

Hey!


Easy!

Used Dreamweaver and replaced all bak.... with jos....

Works!

Hi,

You can ignore the captcha table. This is used to store temporary information and should actually be cleared automatically, so obviously something is not right.

For the export:
1) Under Struktur, check boxes 1,3,4 as you have on your image
2) Under Data, check first and last boxes only

Once you export you will have an sql file or compressed sql file and you can import by selecting this file or copying the contents in the sql window, but given the size it's better to import using the file.

The most important thing here for data integrity is that the ids of the articles in the jos_content table still match the pids of the reviews in the jreviews_comments_table. Otherwise your reviews will be assigned to random articles.

If you are having problem with the size, you can export the tables separately as well.

The jReviews tables didn't change at all. My recommendation is you follow the steps in the original post where all tables are listed. Don't export the table structure, just the data, and use the complete insert option:


In point 2. you can also export only the data if you have already installed jReviews in the new site.