Re: MySql syntax error using PHPWiki
| From: | Mikhail U. Petrov | Date: | Thu, 10 Jun 2004 12:03:17 +0000 |
| Subject: | Re: MySql syntax error using PHPWiki | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-34706@lists.php.net to get a copy of this message | ||
Hi!
You missed table definition:
... FROM my_table where ...
Wednesday, June 9, 2004, 12:57:02 PM, PHPDiscuss wrote:
PPNaml> Greetings,
PPNaml> I'm trying to set up a PHPWiki using Apache 2.0.49, PHP 4.3.7, PEAR 4.1.0,
PPNaml> and PHPWiki 1.3.10.
PPNaml> I get this error when trying to load index.php:
PPNaml> "C:\Program Files\Apache
PPNaml> Group\Apache2\htdocs\lib\WikiDB\backend\PearDB.php:778: Fatal[256]:
PPNaml> wikidb_backend_mysql: fatal database error
PPNaml> DB Error: syntax error
PPNaml> (SELECT sess_data FROM WHERE sess_id='8e7d43511c4184e42da9ed552e431332'
PPNaml> [nativecode=You have an error in your SQL syntax. Check the manual that
PPNaml> corresponds to your MySQL server version for the right syntax to use near
PPNaml> 'WHERE sess_id='8e7d43511c4184e42da9ed552e431332'' at line 1])"
PPNaml> It seems that the SQL syntax is incorrect as no table is included in the
PPNaml> SQL statement. Is it something to do with adding a "'prefix' =>
PPNaml> ''," line
PPNaml> to $DBParams in index.php? Is it something else entirely?
PPNaml> Any help is appreciated.
PPNaml> James.
--
Best regards,
Mikhail U. Petrov
mailto:mikhail@begun.ru