Last modified: 2010-05-15 15:28:23 UTC
I get this error each time when adding or editing a page or section. The change does actually go through, though. I'm using MediaWiki on a web host with MySQL 3.23.x. I don't think it supports the multiple table delete syntax you are using. -------------------------------- Database error From Lotsa A database query syntax error has occurred. This could be because of an illegal search query (see Searching Lotsa), or it may indicate a bug in the software. The last attempted database query was: DELETE linkscc FROM linkscc,brokenlinks WHERE lcc_pageid=bl_from AND bl_to='Help_talk:Editing' from within function "". MySQL returned error "1064: You have an error in your SQL syntax near 'linkscc FROM linkscc,brokenlinks WHERE lcc_pageid=bl_from AND bl_to='Help_talk:E' at line 1".
Edit your LocalSettings.php and change this line: $wgDBmysql4 = $wgEnablePersistentLC = true; to this: $wgDBmysql4 = $wgEnablePersistentLC = false; If the incorrect line was produced by the installer script, please reopen and provide some details on how you installed MediaWiki so we can try to reproduce the incorrect configuration generation.
(In reply to comment #1) > If the incorrect line was produced by the installer script, please reopen and provide some details on how you installed > MediaWiki so we can try to reproduce the incorrect configuration generation. My fault. I ran the installer on a local dev server using MySQL 4 and then just copied the files up to the web host server. Thank you!