Rich Cloutier
2008-05-02 20:37:49 UTC
Message: 1
Date: Thu, 1 May 2008 16:44:43 -0400
Subject: Re: [Citrusdb-users] Billing Module Query Failure
To: "For users of CitrusDB discussion"
Content-Type: text/plain; charset=ISO-8859-1
I think this may have to do with the sql_mode setting, it's may
default to something different when running under windows vs. linux.
In linux it's empty by default, and in windows it's strict.
Can you check that in the my.ini file, or by running the query: SELECT
@@global.sql_mode, @@session.sql_mode, @@sql_mode;
I thought this worked in strict, but I guess not. I'll have to change
my sql_mode and find out.
Paul
All 3 of those settings are the same as follows:Date: Thu, 1 May 2008 16:44:43 -0400
Subject: Re: [Citrusdb-users] Billing Module Query Failure
To: "For users of CitrusDB discussion"
Content-Type: text/plain; charset=ISO-8859-1
I think this may have to do with the sql_mode setting, it's may
default to something different when running under windows vs. linux.
In linux it's empty by default, and in windows it's strict.
Can you check that in the my.ini file, or by running the query: SELECT
@@global.sql_mode, @@session.sql_mode, @@sql_mode;
I thought this worked in strict, but I guess not. I'll have to change
my sql_mode and find out.
Paul
'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
Rich C.