Manual talk:Oldimage table

Image deletion
Note: MediaWiki does not keep all revisions of the pictures like it does with articles. You can delete each revision on the image page. If you delete the image article, all images (revisions) are permanently deleted. You can restore the image article, but not the image.

This is said to be false: Why? Tested with MW 1.9.2

Table versions v1.8/v1.9 identical?
Went through the stuff several times; but for the life of me I could not find any difference! -andy 84.149.70.11 09:52, 8 December 2007 (UTC)

Database 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 "LocalFile::getHistory". MySQL returned error "1054: Unknown column 'oi_sha1' in 'field list' (localhost)". Error SQL query:
 * by 24.188.124.145 00:34, 12 January 2009 (UTC) (w:User:Bud0011).
 * MediaWiki:1.14alpha
 * URL: http://csanimefan.com/ggs/wiki/gcg/index.php?title=File:GCG_Logo.png
 * Got this error when trying to look at the file page.
 * After looking at the page, i ran phpmyadmin with the gained knowledge and got this:

ALTER TABLE `oldimage` ADD  `oi_sha1` VARBINARY( 32 ) NOT NULL DEFAULT NULL

MySQL said:


 * 1) 1067 - Invalid default value for 'oi_sha1'

You can't use DEFAULT NULL on a NOT NULL table. If NULL is not allowed, making it the default is silly, no? Try without "NOT NULL"; -- Duesentrieb ⇌ 13:18, 13 January 2009 (UTC)

Anyway, adding the column should have been done by the updater. Did you run the update script after installing new mediawiki code? -- Duesentrieb ⇌ 13:19, 13 January 2009 (UTC)