kirikintha Posted January 15, 2007 Posted January 15, 2007 Hi everyone - new to this forum, but I have consistently seen this error come up using the OS commerce engine, and I figured I should point this out for everyone. 1264 - Out of range value adjusted for column (whatever) Since OS commerce was originally developed for older version of php mysql, it has problems using the newer version of MYSQL5 - specifically many of the insert statements die, since mysql5 has a mush stricter way of dealing with table data. So, after about five of these errors, I decided that on my local server running mysql5, I would not downgrade to mysql4. Just not practical for me. But there is a solution - google this query: "disable strict GLOBAL SQL_MODE mysql 5" What this does is allow the MYSQL5 server to act like MYSQL 4 I used set @@globa.sql_mode="MYSQL40" in my admin tool - there are a number of posts for it, depending on your setup. this also seems to combat many of the sql import issues as well. NOTE: I am not aware of if this has any security implications, so honestly I am going to have to figure out why all the auto-increment insert statements are failing when using '' as the value for the auto-increment column. This is what is at the heart of messing it up - and I only know enough to get me that far. Hopefully there is a way to make it easy to replace the variable with something that mysql5 likes! cheers! :thumbsup: -paul Nothing unreal exists
Recommended Posts
Archived
This topic is now archived and is closed to further replies.