Hi there, I did a back up and migrate task of the database from one site to 2 different addresses on the same server and in one it works while it doesn't in the other... basically I am experiencing some database problem with my taxonomy tables now. I keep on getting this message:
user warning: Duplicate entry '205' for key 1 query: INSERT INTO term_data (tid, name, description, vid, weight) VALUES (205, 'qwerty', '', 11, 0)
for any new term I add to my taxonomy list even if they are totally brand new and any term I add is not shown in the available terms list. Do you have any hint?
Thanks

Comments

ronan’s picture

ronan commented
Category: bug » support

it sounds like your sequences table did not get properly backed up or fully restored. Since one of the restores worked it sounds like it was a problem with the second restore. Perhaps it timed out before all tables were fully imported.

You could try dropping all tables in the database and restoring again and make sure all tables are recreated.

Let me know if you're able to get this resolved.

Thanks
Ronan

ronan’s picture

ronan commented
Status: Active » Closed (fixed)