Hi Jordy, I run in the same problems, with the difference that X5 2022.x won't create all tables required for a new database, whatever I tried. I fixed that now manually and it works fine.

Regarding your question, the way to go depends on your setup. If you have only a new webspace, which is connected to the old database or a new webspace together with a new database. In both cases it would be wise to export first all old tables, with the export function of your database admin console (hosting package) in standard format to disk.

Afterwards I would made a full upload of your new website to an empty webspace with X5. In case you have special configured files like .htaccess, Google Tag Manager etc. you could leave them on, but it is better to clean up the other old files first. Because you start from a new template, the database table names will be different now. Test your website and check the number of tables created in the database. For any review object and the blog, you should find a separate table like w5_template number_object ID_comments. In my case 50% where missing, the whole review section and the dynamic_products table. If you are lucky and the tables are there, import one of the saved table backup files and check which of the new tables (correct object ID) fits to it. Save this new table name to clipboard, delete the table and rename the imported table to the new name. Make a test if the comments are there. The same procedure for the other objects.

If none of these tables were created, you have to find out the object numbers either from the html source code of the page or by enabling the php error engine in the hosting package. In the last case you should see something like below, where in bold the missing table name is mentioned:

Fatal error: Uncaught mysqli_sql_exception: Table 'mydomain.w5_v1z94kte_29_36_comments' doesn't exist in /mydomain/res/x5engine.php:6172 Stack trace:.....

Hi Martin

Thank you for your reply. I will look in to it ;).

Shame that X5 doesn't do something about this so it is easy to change from template/website without losing the reviews.

I use the same website and same domainname ect. Only have I made a new template and copied all to the new website (still need to upload it) but I will not risk to lose the reviews.

So I will investigate my webspace where I can find those files.

Hi Martin

I can't find those files? I have like 100 folders on my webspace ... Do you know in what folder I must look/search?

I spend over one hour already but I don't find it ...

thanks

Hi Jordy,

you have to login into your SQL-Database not into your webspace.

You will find the right parameters in the "Export Website to Internet" under Connection/Database or open it directly from your hosting panel under PHP/Database settings.

He John, you are totally right and that is a very good hint!

Normally, I leave the backup folders live only during the testing phase and delete it afterwards. I like a clear overview look.