huanhuan
Jun 2 2008, 09:20 AM
When going to Add Product
MySQL Error Occured
1366: Incorrect integer value: '' for column 'stock_level' at row 1
QUERY = INSERT INTO CubeCart_inventory (`productCode`, `name`, `cat_id`, `description`, `image`, `price`, `sale_price`, `stock_level`, `useStockLevel`, `digital`, `digitalDir`, `prodWeight`, `taxType`, `showFeatured`) VALUES ('a', 'aafsa', '4', 'afafsafa', '', '45', '21', '', '1', '0', '', '1', '1', '1')
bsmither
Jun 2 2008, 09:42 PM
I see this all the time on the installation where I have MySQL set for "Strict_Mode". I think all commercial hosting providers do not set this (might be a feature of MySQL 5 only). But if you are managing your own hosting space, look in the file my.ini (in your MySQL installation folder probably).
Read this thread:
http://forums.cubecart.com/index.php?showtopic=25396Strict mode causes problems when CC wants to populate a field with a zero-length string.