Author: gu.paul
Description:
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)".
Version: 1.9.x
Severity: major
OS: Linux
URL: http://paulgu.com/wiki/Special:Ancientpages
gu.paul wrote:
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
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.
gu.paul wrote:
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.