Last modified: 2010-05-15 15:48:31 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 8581 - Database query syntax error (Special:Ancientpages, MySQL)
Database query syntax error (Special:Ancientpages, MySQL)
Product: MediaWiki
Classification: Unclassified
Special pages (Other open bugs)
All Linux
: High major (vote)
: ---
Assigned To: Nobody - You can work on this!
Depends on:
  Show dependency treegraph
Reported: 2007-01-11 16:18 UTC by Paul Gu
Modified: 2010-05-15 15:48 UTC (History)
0 users

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


Description Paul Gu 2007-01-11 16:18:32 UTC
from within function "". MySQL returned error "1064: You have an error in your
SQL syntax; check the manual that corresponds to your MySQL server version for
the right syntax to use near 'epoch FROM rev_timestamp) as value FROM
`wiki_page`, `wiki_revision` WHERE' at line 4 (".
Comment 1 Greg Sabino Mullane 2007-01-11 17:36:42 UTC
What does Special:Version show?
Comment 2 Paul Gu 2007-01-11 18:06:42 UTC
It shows     *  MediaWiki: 1.9.0   * PHP: 5.1.6 (cgi)    * MySQL: 5.0.27-standard.

You could find by click link:
Comment 3 Greg Sabino Mullane 2007-01-11 18:09:03 UTC
What is $wgDBtype set to in LocalSettings.php? It should be "mysql" if you are
using mysql. That's why you are getting that error: it thinks you are not using
Comment 4 Paul Gu 2007-01-11 18:22:35 UTC
I'm using "$wgDBtype      = $db_wgDBtype" in LocalSettings.php, and $db_wgDBtype
is included through paulgudbpass.php. For some reason, the LocalSettings.php
didn't get the $db_wgDBtype which is "mysql".

I changed $wgDBtype to "mysql" in LocalSettings.php and it works.


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