Re: MySql syntax error using PHPWiki

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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:mikhail@xxxxxxxx

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux