database move, write doesn't work any more
Closed, InvalidPublic
Actions

Assigned To

None

Authored By

	• bzimport
	Aug 3 2006, 12:46 PM

Description

Author: florijnterstal

Description:
i moved wiki from a windows xpsp2
MediaWiki: 1.6.7
PHP: 5.1.4 (apache2handler)
MySQL: 5.0.22-community-nt

on to a linux system
MediaWiki: 1.6.7
PHP: 4.3.10-16 (apache2handler)
MySQL: 4.0.24_Debian-10sarge1-log

(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:

Code:
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.

gr.janis

Version: unspecified
Severity: minor
OS: Linux
Platform: PC

Details

Reference: bz6915

Event Timeline

• bzimport raised the priority of this task from to Low.Nov 21 2014, 9:16 PM

• bzimport added a project: MediaWiki-General.

• bzimport set Reference to bz6915.

• bzimport added a subscriber: Unknown Object (MLST).

• bzimport created this task.Aug 3 2006, 12:46 PM

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.

database move, write doesn't work any moreClosed, InvalidPublicActions

Description

Very big problem with wiki, MySQL returned error "1048

Details

Event Timeline

database move, write doesn't work any more
Closed, InvalidPublic
Actions