I've checked in the DB with phpmyadmin and found out that ar_text is a line in the archive table.
After googling, I found on http://www.gridcenter.isi.edu/mediawiki-1.5rc4/maintenance/tables.sql this about ar_text:
ar_text mediumblob NOT NULL default ''
So that means that the default is empty?
And according to what I found, my thing is configured correctly.
Is there a way to see the actual SQL query?
Simon
-----Original Message----- From: mediawiki-l-bounces@Wikimedia.org [mailto:mediawiki-l-bounces@Wikimedia.org] On Behalf Of Simon Renshaw Sent: 14 juillet, 2006 11:17 To: MediaWiki announcements and site admin list Subject: [Mediawiki-l] File delete error
Hi,
I tried to delete a file that was uploaded on my Wiki and got 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 "Article::doDeleteArticle". MySQL returned error "1364: Field 'ar_text' doesn't have a default value (localhost)".
Any idea what is causing this? That DB was originally running on MySQL 4 so maybe I forgot to do something when I imported it to version 5. But everything else is working fine on the Wiki.
I'm running:
MediaWiki: 1.6.6 PHP: 5.0.5 (cgi-fcgi) MySQL: 5.0.22-community-nt
Will update to 1.7 soon :)
Thanks! Simon _______________________________________________ MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l