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 On Wed, Apr 30, 2008 at 4:29 PM, Rich Cloutier <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] wrote: > > Message: 3 > > Date: Wed, 30 Apr 2008 10:24:12 -0400 > > From: "Paul Yasi" <[EMAIL PROTECTED]> > > Subject: Re: [Citrusdb-users] Billing Module Query Failure > > To: "For users of CitrusDB discussion" > > <citrusdb-users@lists.sourceforge.net> > > Message-ID: > > <[EMAIL PROTECTED]> > > Content-Type: text/plain; charset=ISO-8859-1 > > > > That's odd, the schema should allow the creditcard_number, > > creditcard_expire, and rerun_date to be inserted as null values and > > mysql puts in zeroes for you. Did you happen to use any particular > > windows gui tool to import the default citrus database schema? It > > looks like there may be some kind of bug that may not create the > > proper schema, http://bugs.mysql.com/bug.php?id=36250 > > > > `creditcard_number` bigint(16) default NULL, > > `creditcard_expire` smallint(4) unsigned zerofill default NULL, > > `rerun_date` date default NULL, > > > > Paul > > > The schema is correct as created with the Windows command line client > for MySQL. > > To recreate the bug, do the following: > > Edit the Default Billing for the Example customer and erase the contents > of the "Credit Card Expire" field. > > Try to Save Changes. > > I did this in yesterday's CVS version and got the following error message: > > 1366: Incorrect integer value: '' for column 'creditcard_expire' at row 1 > > Query: > > UPDATE billing SET name = 'Example Customer', company = 'Example > Company', street = 'Example St', city = 'ExampleCity', state = 'ABC', > zip = '12345', country = 'USA', phone = '555-555-5555', fax = > '555-555-5556', billing_type = '7', creditcard_number = > '5000000000000001', creditcard_expire = '', billing_status = '', > next_billing_date = '2007-10-07', from_date = '2007-10-07', > payment_due_date = '2007-10-07', rerun_date = '0000-00-00', notes = '', > pastdue_exempt = 'n', po_number = '', contact_email = '' WHERE id = 1 > > As you can see, the program is trying to update the creditcard_expire > field with an empty string, not a zero. However note that I could not > set the variable '$creditcard_expire' to null or unset it and get the > query to work. I'm not sure why. > > Since the form fields always submit strings, it seems you need to > convert them to the proper data type before executing the query. (I > tried doing this in the initialization phase, and it didn't work, > because on load, the field had a value, so was not initialized.) > > Rich C. > > ------------------------------------------------------------------------- > This SF.net email is sponsored by the 2008 JavaOne(SM) Conference > Don't miss this year's exciting event. There's still time to save $100. > Use priority code J8TL2D2. > > http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone > _______________________________________________ > Citrusdb-users mailing list > Citrusdb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/citrusdb-users > -- The CitrusDB Project | http://www.citrusdb.org Open Source Customer Care & Billing System ------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone _______________________________________________ Citrusdb-users mailing list Citrusdb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/citrusdb-users
