Last modified: 2010-06-28 21:08:24 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T26153, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 24153 - Database error "Column 'fi_img_timestamp' cannot be null" on page edit/move
Database error "Column 'fi_img_timestamp' cannot be null" on page edit/move
Status: RESOLVED FIXED
Product: MediaWiki extensions
Classification: Unclassified
FlaggedRevs (Other open bugs)
unspecified
All All
: Normal major with 1 vote (vote)
: ---
Assigned To: Aaron Schulz
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2010-06-28 09:48 UTC by Daniel Tar
Modified: 2010-06-28 21:08 UTC (History)
2 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Daniel Tar 2010-06-28 09:48:50 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
Comment 1 Tisza Gergő 2010-06-28 10:10:01 UTC
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
Comment 2 Tisza Gergő 2010-06-28 10:14:15 UTC
Note that the article where the error occured does not have any images, just a red link to an image.
Comment 3 Daniel Tar 2010-06-28 10:20:57 UTC
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)
Comment 4 Aaron Schulz 2010-06-28 15:57:02 UTC
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.
Comment 5 Aaron Schulz 2010-06-28 21:08:24 UTC
(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

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links