Firefox PHP

Invalid id

Posted by shel_holtz 
Invalid id
February 12, 2005 06:04PM
I've been using Phorum 3 for years. Suddenly, when trying to create a new phorum, I got this error:

Could not create table nav. Database server said "Invalid default value for 'id'"

Any idea what I can do to fix this? Thanks!

Re: Invalid id
February 12, 2005 10:55PM
Am I right that you are using mysql-4.1.x ?

Re: Invalid id
March 28, 2005 02:19PM
I`ve got the same Problem with mysql 4.1.10 ...

What should i do !?
Re: Invalid id
March 28, 2005 05:56PM
new install? then use phorum5.
for an existing install ... mysql-4.1.x has stricter checking for the create-table statements.
you need to remove the default-value from the auto-increment-columns in db/mysql.php

Re: Invalid id
January 19, 2006 04:53PM
I have the same problem, and I found the file but what exactly must I change in de db/mysql.php file? could you be more specific please.

much obliged...
Sorry, you do not have permission to post/reply in this forum.