Last modified: 2010-05-15 15:48:31 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 T10581, the corresponding Phabricator task for complete and up-to-date bug report information.
First Last Prev Next    This bug is not in your last search results.
Bug 8581 - Database query syntax error (Special:Ancientpages, MySQL)
Database query syntax error (Special:Ancientpages, MySQL)
Status: RESOLVED INVALID
Product: MediaWiki
Classification: Unclassified
Special pages (Other open bugs)
1.9.x
All Linux
: High major (vote)
: ---
Assigned To: Nobody - You can work on this!
http://paulgu.com/wiki/Special:Ancien...
:
Depends on:
Blocks:
  Show dependency tree / graph
 
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: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

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 (192.168.2.7)".
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: http://paulgu.com/wiki/Special:Version
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
mysql.
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.

Thanks.
Note You need to log in before you can comment on or make changes to this bug.
First Last Prev Next    This bug is not in your last search results.

Navigation
Links