Hi, On 16.5.2006 16:57, Arthur Kerpician wrote: <cut>
> There are other SELECT command logged which are ok: > select pw_name, pw_passwd, pw_uid, pw_gid, pw_gecos, pw_dir, pw_shell , > pw_clear_passwd from vpopmail where pw_name = "postmaster" and pw_domain > = "domain.com" > Dont have any idea what's with that odd SELECT... I have posted similar question several weeks ago, but nobody answered. One of my colleagues found the reason for this error: in MySQL 4.1.x (I think in 5.1 too) the default sql_mode is '': mysql> show global variables like 'sql_mode'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | sql_mode | | +---------------+-------+ mysql> \s -------------- mysql Ver 14.7 Distrib 4.1.18, for pc-linux-gnu (i686) using EditLine wrapper This means you can not have query like: SELECT a FROM b WHERE c="d" The query should be: SELECT a FROM b WHERE c='d' The solution is to run MySQL in ANSI mode or to replace all double quotes in vmysql.h with single quotes. Hope this helps.
pgpu0BA8Gelg1.pgp
Description: PGP signature
