Hi Jason,
Thanks. I tried this but it didn't help - still got the error.
I looked a bit further into that SQL statement and it turns out that only
MySQL 4.0.0 and greater support multiple tables in DELETE statements.
I searched around the code a bit (not enough CVS skill to go looking at
histories yet ;) and there are at least four such DELETE statements in the
installation that have this issue.
The installation that causes problems (contains above statements) is:
mediawiki-1.1.0
The installation that works OK for me on other (MySQL 3.23) computers is:
mediawiki-20031107
I'm not sure what the best solution is?!
- Sven
-----Original Message-----
From: mediawiki-l-bounces(a)Wikimedia.org
[mailto:mediawiki-l-bounces@Wikimedia.org]On Behalf Of Jason Smithson
Sent: 04 January 2004 20:03
To: MediaWiki announcements and site admin list
Subject: Re: [Mediawiki-l] Mediawiki on Sourceforge
On Sun, Jan 04, 2004 at 05:11:32PM -0000, Sven Latham wrote:
Apologies. It IS 1.3:
Apache/1.3.29 (Debian GNU/Linux) PHP/4.1.2 mod_ssl/2.8.14 OpenSSL/0.9.7b
mod_perl/1.29
MySQL version is 3.23.56
PHP version 4.1.2 is 'latest Debian stable version' so I'm told, so the
admin isn't keen to update (I don't admin that server). I noticed on the
Mediawiki pages that 4.3 or greater is recommended, and that
issues might
crop up with 4.2 and earlier - could this be one
of them?
I believe I ran into this same issue on my mediawiki debian
stable install as well.
The solution was to install a more recent version of PHP that had
been backported:
From:
http://wiki.breakset.com/wiki/breakset_wiki:Installing
added:
deb
http://debian.moolfreet.com ./
to:
/etc/apt/source-list
and then installed a backported later version of php4 as root via:
# apt-get update
# apt-get upgrade
The version is now 4.3.4 and I have not seen any SQL error messages since.
I do intend on adding this information to the mediawiki
documentation ASAP.
Hope this helps.
- Jason
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)Wikimedia.org
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l