ryanbehrman Posted April 4, 2007 Posted April 4, 2007 I've installed oscommerce-2.2ms2-060817 and I run PHP Version 5.1.4 and MySQL Version 5.0.24. MySQL 5.x doesn't allow empty strings inserted into integer fields. osCommerce inserts empty strings into integer fields e.g. in Admin->Catalog->Categories/Products, setting Manufacturer="none" results in an error "Out of range value adjusted for column 'manufacturers_id' at row 1" Is there a contribution or update that fixes this problem in osCommerce on a global basis?
ryanbehrman Posted April 4, 2007 Author Posted April 4, 2007 I've installed oscommerce-2.2ms2-060817 and I run PHP Version 5.1.4 and MySQL Version 5.0.24. MySQL 5.x doesn't allow empty strings inserted into integer fields. osCommerce inserts empty strings into integer fields e.g. in Admin->Catalog->Categories/Products, setting Manufacturer="none" results in an error "Out of range value adjusted for column 'manufacturers_id' at row 1" Is there a contribution or update that fixes this problem in osCommerce on a global basis? I think I may have found the solution. I have not yet performed the changes in update-20060817.txt. I didn't realise that this needs to be done ON TOP of installing oscommerce-2.2ms2-060817. Have I found the solution? Do I need to apply the changes in the document now?
ryanbehrman Posted April 4, 2007 Author Posted April 4, 2007 I think I may have found the solution. I have not yet performed the changes in update-20060817.txt. I didn't realise that this needs to be done ON TOP of installing oscommerce-2.2ms2-060817. Have I found the solution? Do I need to apply the changes in the document now? This is not the fix. The MySQL 5 Compatibility changes have already been applied to this milestone. So the problem is elsewhere. Does anybody know the fix?
Guest Posted April 4, 2007 Posted April 4, 2007 I've installed oscommerce-2.2ms2-060817 and I run PHP Version 5.1.4 and MySQL Version 5.0.24. MySQL 5.x doesn't allow empty strings inserted into integer fields. osCommerce inserts empty strings into integer fields e.g. in Admin->Catalog->Categories/Products, setting Manufacturer="none" results in an error "Out of range value adjusted for column 'manufacturers_id' at row 1" Is there a contribution or update that fixes this problem in osCommerce on a global basis? where this problem happens? with your local server or with the live site?
ryanbehrman Posted April 4, 2007 Author Posted April 4, 2007 where this problem happens? with your local server or with the live site? With my local server.
jasonabc Posted April 5, 2007 Posted April 5, 2007 http://www.oscommerce.com/forums/index.php?sho...p;#entry1007338 Jason My Contributions: Paypal Payflow PRO | Rollover Category Images | Authorize.net Invoice Number Fix
Guest Posted April 5, 2007 Posted April 5, 2007 With my local server. ok yes, make sure you setup the sql-mode as it is shown in jason's post. Because if it was a shared live server you would need to do plenty of mods.
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.