Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1264 Error Got you down?


kirikintha

Recommended Posts

Posted

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

Archived

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

×
×
  • Create New...