Migrating problems...

[wientanz]

Hi!

I had Serendipity running on my home server (where it worked perfectly), then migrated it to a whole different server. Everything worked fine. All new data got imported, the uploads folder was moved and everyting.

My Problem now is that I keep getting the following mysql error message when I try to make a new entry:

Code: Select all

INSERT INTO serendipity_entries (title,timestamp,body,extended,isdraft,allow_comments,moderate_comments,exflag,comments,last_modified,author,authorid) values ('Test', '1151014238', 'Test ', '', 'false', 'true', 'false', '0', '0', '1151014238', 'Stefan', '1')
/ Duplicate entry '0' for key 1

Any idea?

[garvinhicking]

Hi!

By migrating your database tables you did not seem to also migrate primary keys and auto_increment values.

Check your original SQL DB tables and set the auto_increment and primary values accordingly; or make sure your SQL dump really contains the keys and auto_increment attributes!

HTH,
Garvin

[wientanz]

checking, checking... you're absolutely right! Damn phpmyadmin...

Thanks, that will need a little handiwork now... :-/

Thanks and thanks again!

[garvinhicking]

Hi!

You're welcome. I think the easiest way would be this:

Install a completely fresh new installation on your new server. Then you will have the DB structure you need. Just empty all date and import your old data into the new structure, and you're done.

Best regards,
Garvin