My System where I'm runnig wikimedia from: Redhat v9 Apache 2.0.48 PHP 4.3.5RC2 mySQL 4.0
Everytime I make an update of a page, or start a new page, or delete a page, or whatever, there comes a error message:
Database Error
DELETE linkscc FROM linkscc,brokenlinks WHERE lcc_pageid=bl_from AND bl_to='Linux_Installationshilfen' aus der Funktion "". MySQL meldete den Fehler "1064: You have an error in your SQL syntax near 'linkscc FROM linkscc,brokenlinks WHERE lcc_pageid=bl_from AND bl_to='Linux_Insta' at line 1". "
Hi,
I think I had the same problem once, and this is what Brion told me then:
On Jan 4, 2004, at 08:42, Denny Vrandecic wrote:
aus der Funktion "". MySQL meldete den Fehler "1064: You have an error in your SQL syntax near 'linkscc FROM linkscc,brokenlinks WHERE lcc_pageid=bl_from AND bl_to='Hilfe'' at line 1". <<
The action is performed, but I'd like to patch the error away...
Looks like a MySQL 3.x problem. The linkscc table is used to cache link lookup data and speeds up page display a bit, but isn't actually necessary. Things should work if you disable it...
Try putting this in your LocalSettings.php: $wgEnablePersistentLC = false;
I'll see if we can detect this for the next version...
-- brion vibber (brion @ pobox.com)
And it did help for me. Maybe it helps you too.
Best regards, Denny
----- Original Message ----- From: kritop@ish.de To: mediawiki-l@Wikimedia.org Sent: Friday, February 13, 2004 2:16 PM Subject: [Mediawiki-l] Wikimedia Database Error
My System where I'm runnig wikimedia from: Redhat v9 Apache 2.0.48 PHP 4.3.5RC2 mySQL 4.0
Everytime I make an update of a page, or start a new page, or delete a page, or whatever, there comes a error message:
Database Error
DELETE linkscc FROM linkscc,brokenlinks WHERE lcc_pageid=bl_from AND bl_to='Linux_Installationshilfen' aus der Funktion "". MySQL meldete den Fehler "1064: You have an error in
your
SQL syntax near 'linkscc FROM linkscc,brokenlinks WHERE lcc_pageid=bl_from
AND
bl_to='Linux_Insta' at line 1". " _______________________________________________ MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
Thanks very much, Denny -- that's fixed it for me!
Dan Carlson
On Feb 13, 2004, at 3:43 PM, Denny Vrandecic wrote:
Hi,
I think I had the same problem once, and this is what Brion told me then:
On Jan 4, 2004, at 08:42, Denny Vrandecic wrote:
aus der Funktion "". MySQL meldete den Fehler "1064: You have an error in your SQL syntax near 'linkscc FROM linkscc,brokenlinks WHERE lcc_pageid=bl_from AND bl_to='Hilfe'' at line 1". <<
The action is performed, but I'd like to patch the error away...
Looks like a MySQL 3.x problem. The linkscc table is used to cache link lookup data and speeds up page display a bit, but isn't actually necessary. Things should work if you disable it...
Try putting this in your LocalSettings.php: $wgEnablePersistentLC = false;
I'll see if we can detect this for the next version...
-- brion vibber (brion @ pobox.com)
And it did help for me. Maybe it helps you too.
Best regards, Denny
----- Original Message ----- From: kritop@ish.de To: mediawiki-l@Wikimedia.org Sent: Friday, February 13, 2004 2:16 PM Subject: [Mediawiki-l] Wikimedia Database Error
My System where I'm runnig wikimedia from: Redhat v9 Apache 2.0.48 PHP 4.3.5RC2 mySQL 4.0
Everytime I make an update of a page, or start a new page, or delete a page, or whatever, there comes a error message:
Database Error
DELETE linkscc FROM linkscc,brokenlinks WHERE lcc_pageid=bl_from AND bl_to='Linux_Installationshilfen' aus der Funktion "". MySQL meldete den Fehler "1064: You have an error in
your
SQL syntax near 'linkscc FROM linkscc,brokenlinks WHERE lcc_pageid=bl_from
AND
bl_to='Linux_Insta' at line 1". " _______________________________________________ MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
mediawiki-l@lists.wikimedia.org