Last modified: 2010-06-28 21:08:24 UTC
When we try to edit or move Singularity ( Játék )[1] page on huwiki we get the following error message: Column 'fi_img_timestamp' cannot be null As you can see in the page history[2], an anon started the page, then edited by a bot and checked by an editor. I have tried to reproduce the error, but the try was unsuccessful. [1] http://hu.wikipedia.org/wiki/Singularity_%28_J%C3%A1t%C3%A9k_%29 [2] http://hu.wikipedia.org/w/index.php?title=Singularity_%28_J%C3%A1t%C3%A9k_%29&action=history
Both article and image namespace are under FlagRevs in huwiki; the bug is probably related to the FlagRev code update. The same error message occurs (and is reproducible) when someone tries to move an image; see previous report at http://flaggedrevs.labs.wikimedia.org/wiki/Wikimedia:Pending_Changes_issues#SQL_error_on_image_renaming
Note that the article where the error occured does not have any images, just a red link to an image.
I have made some further tests. This error occours every time when somebody tries to put a non-existent image to a page. (in the FlaggedRevision::insertOn function)
Old NULL usage for NON-NULL col with a DEFAULT probably only works for UPDATES (http://dev.mysql.com/doc/refman/5.0/en/data-type-defaults.html)...though it worked locally, odd. Fixed in r68662 with DEFAULT.
(In reply to comment #4) > Old NULL usage for NON-NULL col with a DEFAULT probably only works for UPDATES > (http://dev.mysql.com/doc/refman/5.0/en/data-type-defaults.html)...though it > worked locally, odd. > > Fixed in r68662 with DEFAULT. Grr...broken link...should be http://dev.mysql.com/doc/refman/5.0/en/data-type-defaults.html