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' => ''," 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:[EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
