Last modified: 2010-05-15 15:28:23 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T2746, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 746 - Error each time adding or editing
Error each time adding or editing
Status: RESOLVED INVALID
Product: MediaWiki
Classification: Unclassified
General/Unknown (Other open bugs)
1.3.x
Other Linux
: Normal major (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2004-10-19 17:07 UTC by Paul Burney
Modified: 2010-05-15 15:28 UTC (History)
0 users

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Paul Burney 2004-10-19 17:07:54 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".
Comment 1 Brion Vibber 2004-10-19 19:00:48 UTC
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.
Comment 2 Paul Burney 2004-10-19 19:21:18 UTC
(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!

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links