Help - Search - Members - Calendar
Full Version: MySQL Error Occured!
CubeCart Forums > CubeCart Version 3 > Installation & Upgrade Help (Version 3)
huanhuan
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
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=25396

Strict mode causes problems when CC wants to populate a field with a zero-length string.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.