Todor Petkov wrote:
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.
Unfortunately, switching to ANSI mode doesn't work at all. All
authentication done by vpopmail doesn't work when ANSI is on...
