[Mediawiki-l] Wikimedia Database Error

[Denny Vrandecic]

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 at ish.de>
To: <mediawiki-l at 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 at Wikimedia.org
> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l