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