Tuba Posted November 2, 2009 Share Posted November 2, 2009 Hi, I have just upload 3.0.20 and tried to disable Print Order Form, but I am getting this error message: MySQL Error Occured 1264: Out of range value adjusted for column 'default' at row 2 QUERY = UPDATE CubeCart_Modules SET `status`='0', `default`= '' WHERE module = 'gateway' AND folder = 'Print_Order_Form' I have done several cubecart but this is the first time i have had this problem. Has anyone got any suggestions to get round the problem. Quote Link to comment Share on other sites More sharing options...
bsmither Posted November 3, 2009 Share Posted November 3, 2009 Of the several CC installs, is this one using any different version or installation of MySQL? It *looks* to me as if this installation of MySql does NOT like it when the query tries to put a NULL value (default equals empty string) in a column declared to be NOT NULL. Even though the schema has a default value (o) assigned to this column, I've stumbled across MySql installations that still complain about no data for a NOT NULL column. Quote Link to comment Share on other sites More sharing options...
Tuba Posted November 3, 2009 Author Share Posted November 3, 2009 Thanks for your reply, I have solved it I had impleneted CubeCart using MySql 5, but for whatever reason if will not work with 5, so I have re-implemented using MySql 4 and all works fine. Quote Link to comment Share on other sites More sharing options...
bsmither Posted November 4, 2009 Share Posted November 4, 2009 MySQL 5 has added a DBMS-wide protocol called "STRICT_TRANS_TABLES". (OK, it's been awhile - maybe it was in MySQL 4 as well.) See: http://forums.cubecart.com/index.php?showtopic=25396 http://forums.cubecart.com/index.php?showtopic=28650 http://forums.cubecart.com/index.php?showtopic=34148 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.