I've just installed 1.4.6 after downloading it from sourceforge.
When I update the a page, I get this 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 "LinkCache::preFill". MySQL returned error "1064: You have an error in your SQL syntax near 'FOR UPDATE' at line 3 (mysql.webxess.net)".
Despite this, the page still updates correctly. Same happens with page creation.
Graham
Graham Chiu wrote:
I've just installed 1.4.6 after downloading it from sourceforge.
When I update the a page, I get this 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 "LinkCache::preFill". MySQL returned error "1064: You have an error in your SQL syntax near 'FOR UPDATE' at line 3 (mysql.webxess.net)".
What's your MySQL version?
-- brion vibber (brion @ pobox.com)
The host is running 3.23.32
On 7/8/05, Brion Vibber brion@pobox.com wrote:
What's your MySQL version?
-- brion vibber (brion @ pobox.com)
Graham
Is there some change I can make to the mysql statement so that it becomes compatible with this ealier version of mysql?
On 7/8/05, Graham Chiu compkarori@gmail.com wrote:
The host is running 3.23.32
On 7/8/05, Brion Vibber brion@pobox.com wrote:
What's your MySQL version?
-- brion vibber (brion @ pobox.com)
Graham
Can anyone help here?
I talked to the company hosting my site, and they said that they do not know if, or when, they will be upgrading their mysql version.
Graham
On 7/9/05, Graham Chiu compkarori@gmail.com wrote:
Is there some change I can make to the mysql statement so that it becomes compatible with this ealier version of mysql?
Graham Chiu wrote:
The host is running 3.23.32
Support for SELECT ... FOR UPDATE was added in MySQL 3.23.36, released on March 27, 2001 (over four years ago).
We use this construct extensively; while it's _possible_ you may be able to get the software to work by manually removing all uses, I can make no guarantees that it'll work or there isn't some other problem.
The minimum baseline we expect to work is the software versions included in Debian GNU/Linux 3.0 ('Woody'). For MySQL, this is version 3.23.49.
-- brion vibber (brion @ pobox.com)
mediawiki-l@lists.wikimedia.org