Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

1264 Error Got you down?


Recommended Posts

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:



Nothing unreal exists

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...