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

Wikimedia Bugzilla is closed!

Wikimedia has migrated from Bugzilla to Phabricator. Bug reports should be created and updated in Wikimedia Phabricator instead. Please create an account in Phabricator and add your Bugzilla email address to it.
Wikimedia Bugzilla is read-only. If you try to edit or create any bug report in Bugzilla you will be shown an intentional error message.
In order to access the Phabricator task corresponding to a Bugzilla report, just remove "static-" from its URL.
You could still run searches in Bugzilla or access your list of votes but bug reports will obviously not be up-to-date in Bugzilla.
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