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.

Bug 8581 - Database query syntax error (Special:Ancientpages, MySQL)


Summary:	Database query syntax error (Special:Ancientpages, MySQL)

Status:	RESOLVED INVALID

Product:	MediaWiki
Classification:	Unclassified
Component:	Special pages (Other open bugs)
Version:	1.9.x
Hardware:	All Linux

Importance:	High major (vote)
Target Milestone:	---
Assigned To:	Nobody - You can work on this!

URL:	http://paulgu.com/wiki/Special:Ancien...
Whiteboard:
Keywords:

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)
CC List:	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.

Wikimedia Bugzilla is closed!

Search

Personal tools

Navigation

Links