Serendipity Forums

Posted: **Fri Jun 23, 2006 7:46 am**

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?

Posted: **Fri Jun 23, 2006 10:56 am**

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

Posted: **Fri Jun 23, 2006 12:16 pm**

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

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

Thanks and thanks again!

Posted: **Fri Jun 23, 2006 12:33 pm**

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

Serendipity Forums

Migrating problems...

Migrating problems...

Re: Migrating problems...