MySql syntax error using PHPWiki
| From: | (PHPDiscuss - PHP Newsgroups and mailing lists) | Date: | Wed, 09 Jun 2004 08:57:02 +0000 |
| Subject: | MySql syntax error using PHPWiki | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-34705@lists.php.net to get a copy of this message | ||
Greetings,
I'm trying to set up a PHPWiki using Apache 2.0.49, PHP 4.3.7, PEAR 4.1.0,
and PHPWiki 1.3.10.
I get this error when trying to load index.php:
"C:\Program Files\Apache
Group\Apache2\htdocs\lib\WikiDB\backend\PearDB.php:778: Fatal[256]:
wikidb_backend_mysql: fatal database error
DB Error: syntax error
(SELECT sess_data FROM WHERE sess_id='8e7d43511c4184e42da9ed552e431332'
[nativecode=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
'WHERE sess_id='8e7d43511c4184e42da9ed552e431332'' at line 1])"
It seems that the SQL syntax is incorrect as no table is included in the
SQL statement. Is it something to do with adding a "'prefix' =>
''," line
to $DBParams in index.php? Is it something else entirely?
Any help is appreciated.
James.