Last modified: 2007-01-13 05:15:49 UTC
i moved wiki from a windows xpsp2
PHP: 5.1.4 (apache2handler)
on to a linux system
PHP: 4.3.10-16 (apache2handler)
(i did save the database for version 4)
==Very big problem with wiki, MySQL returned error "1048==
It appears to be fine and I can log in as the admin, but it seems like whenever I try to
write to the database, like when changing the text on the page, or adding a user, etc., I
get the following error:
A database query syntax error has occurred. This may indicate a bug in the software. The
last attempted database query was:
(SQL query hidden)
from within function "Revision::insertOn". MySQL returned error "1048: Column 'old_id'
cannot be null (localhost)".
I have researched and tried everything I can think of, but still no luck.
This sounds like a damaged database; for instance it appears to be missing the
auto_increment setting on text.old_id column.
Probably most likely is due to the way the database was transferred to the older
version of MySQL.
Since this is old and sounds like a problem with the database transferrence, I'm
going to go ahead and close this INVALID.