1 (edited by gleb 2006-03-10 12:23)

Topic: Migate problem/error message: Unable to create topic

I´m trying to change my webhost at the moment but I do encounter some problems with the migration of the mysql database.

From MySQL 4.1.15 to target MySQL 4.0.24 ("downgrade" that is)

I´ve managed to export/import my database to my new host...When I export from MySQL 4.1.15 (the old host) I simply choose compability mode MYSQL40, otherwise it won´t work in MySQL 4.0.24 (the new host). So far so good...but when I try to post a new thread/topic I get the following error message:

"File: /customers/cssforumet.se/cssforumet.se/httpd.www/post.php
Line: 288

PunBB reported: Unable to create topic

Database reported: Duplicate entry '0' for key 1 (Errno: 1062)"



When I try to answer someones thread I get the following error message:

File: /customers/cssforumet.se/cssforumet.se/httpd.www/post.php
Line: 180

PunBB reported: Unable to create post

Database reported: Duplicate entry '0' for key 1 (Errno: 1062)



The things I´ve tested to solve the problem is:
*repair database
*db management tool
*Rebuild search index via administrationpanel.
*Fresh installed copy of punBB

So is there anyone with sql knowledge? My knowledge is about "0" big_smile

Cheers!

Re: Migate problem/error message: Unable to create topic

Maybe a bit late answer but make sure that auto_increment on the id column in the topics and posts tables.

3

Re: Migate problem/error message: Unable to create topic

Yepp to late hehe...but it´s all workin fine now. The forum got a wellneeded restart hehe...thanx anyway big_smile