Guest huanhuan Posted June 2, 2008 Share Posted June 2, 2008 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') Quote Link to comment Share on other sites More sharing options...
bsmither Posted June 2, 2008 Share Posted June 2, 2008 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.