SQL error after a migration

15 years 8 months ago #71729 by billbeaver
SQL error after a migration was created by billbeaver
I posted this in the fireboard forum but want to post it here as I am using fireboard 1.04, Joomla 1.0.15 and cb 1.1.

Migrated a large site from one server to another that took several days. Used Plesk Migration Manager which effectively clones the site.

This error appears now when someone tries to post to the fireboard forum.

[code:1]Duplicate entry \’0\’ for key 1 SQL=INSERT INTO jos_fb_whoisonline (`userid` ,[/code:1]
...

An entry already exists, I tried deleting the entry but the same error, removing cookies, same

thanks

Please Log in to join the conversation.

15 years 8 months ago #71741 by billbeaver
Replied by billbeaver on topic Re:SQL error after a migration SOLVED
The Plesk migration doesn't set any auto-increment in the PRIMARY KEYS for the tables in mySql. So I want back to the old site and exported the databases through phpMyAdmin and then imported them to the new site databases.

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.578 seconds

Facebook Twitter LinkedIn