Hi,
We are using Opencart V. 2.0.1.1 since 2015 and we added more than 4000 products till now, but now all of a sudden we cannot add new products!
Actually as I add a new product, it gets done successfully, but then you do not find it anywhere, and I get this error in reports:
PHP Notice: Error: Out of range value for column 'product_id' at row 1<br />Error No: 167<br />INSERT INTO oc_product SET model = '809336', sku = '', upc = '', ean = '', jan = '', isbn = '', mpn = '', location = '', quantity = '1', minimum = '1', subtract = '1', stock_status_id = '9', date_available = '2019-03-25', manufacturer_id = '0', shipping = '1', price = '0', points = '0', weight = '0', weight_class_id = '1', length = '0', width = '0', height = '0', length_class_id = '1', status = '1', tax_class_id = '0', sort_order = '1', date_added = NOW() in /var/www/xxxx/xxxxxxxxxx/xxxxxxxxx/system/library/db/mysqli.php on line 40
But I can still add new products via Excel file through an Import/Export module which we also have from the beginning and we use it often.
We have German and English Languages and I need both, read some forum which said delete German, but I cannot do that.
That error means a negative number is out of range for an UNSIGNED INT.tavakoli wrote: ↑Mon Mar 25, 2019 10:27 pmHi,
We are using Opencart V. 2.0.1.1 since 2015 and we added more than 4000 products till now, but now all of a sudden we cannot add new products!
Actually as I add a new product, it gets done successfully, but then you do not find it anywhere, and I get this error in reports:
PHP Notice: Error: Out of range value for column 'product_id' at row 1<br />Error No: 167<br />INSERT INTO oc_product SET model = '809336', sku = '', upc = '', ean = '', jan = '', isbn = '', mpn = '', location = '', quantity = '1', minimum = '1', subtract = '1', stock_status_id = '9', date_available = '2019-03-25', manufacturer_id = '0', shipping = '1', price = '0', points = '0', weight = '0', weight_class_id = '1', length = '0', width = '0', height = '0', length_class_id = '1', status = '1', tax_class_id = '0', sort_order = '1', date_added = NOW() in /var/www/vhosts/HOST/HOST/system/library/db/mysqli.php on line 40
But I can still add new products via Excel file through an Import/Export module which we also have from the beginning and we use it often.
We have German and English Languages and I need both, read some forum which said delete German, but I cannot do that.
Some info about it:
https://stackoverflow.com/questions/184 ... n-opencart
https://stackoverflow.com/questions/662 ... -value-fix
A2 Hosting features: Shared Turbo Boost, Managed Warp 1, Unmanaged Hyper 1, and Warp 2 Turbo
I read those two threads but I dont know what to do exactly, please help me more, if I should change some settings please give me exact instructions how and where to do it. Thanksrjcalifornia wrote: ↑Tue Mar 26, 2019 10:56 amThat error means a negative number is out of range for an UNSIGNED INT.tavakoli wrote: ↑Mon Mar 25, 2019 10:27 pmHi,
We are using Opencart V. 2.0.1.1 since 2015 and we added more than 4000 products till now, but now all of a sudden we cannot add new products!
Actually as I add a new product, it gets done successfully, but then you do not find it anywhere, and I get this error in reports:
PHP Notice: Error: Out of range value for column 'product_id' at row 1<br />Error No: 167<br />INSERT INTO oc_product SET model = '809336', sku = '', upc = '', ean = '', jan = '', isbn = '', mpn = '', location = '', quantity = '1', minimum = '1', subtract = '1', stock_status_id = '9', date_available = '2019-03-25', manufacturer_id = '0', shipping = '1', price = '0', points = '0', weight = '0', weight_class_id = '1', length = '0', width = '0', height = '0', length_class_id = '1', status = '1', tax_class_id = '0', sort_order = '1', date_added = NOW() in /var/www/xxxxxx/xxxxxxxx/xxxxxxxxxxxx/system/library/db/mysqli.php on line 40
But I can still add new products via Excel file through an Import/Export module which we also have from the beginning and we use it often.
We have German and English Languages and I need both, read some forum which said delete German, but I cannot do that.
Some info about it:
https://stackoverflow.com/questions/184 ... n-opencart
https://stackoverflow.com/questions/662 ... -value-fix
Who is online
Users browsing this forum: No registered users and 197 guests