Post by tavakoli » Mon Mar 25, 2019 10:27 pm

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.
Last edited by tavakoli on Tue Mar 26, 2019 10:17 pm, edited 1 time in total.

Newbie

Posts

Joined
Mon Mar 25, 2019 10:20 pm

Post by rjcalifornia » Tue Mar 26, 2019 10:56 am

tavakoli wrote:
Mon Mar 25, 2019 10:27 pm
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/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.
That error means a negative number is out of range for an UNSIGNED INT.

Some info about it:

https://stackoverflow.com/questions/184 ... n-opencart
https://stackoverflow.com/questions/662 ... -value-fix

Image
A2 Hosting features: Shared Turbo Boost, Managed Warp 1, Unmanaged Hyper 1, and Warp 2 Turbo


Active Member

Posts

Joined
Fri Sep 02, 2011 1:19 pm
Location - Worldwide

Post by tavakoli » Wed Mar 27, 2019 12:22 am

rjcalifornia wrote:
Tue Mar 26, 2019 10:56 am
tavakoli wrote:
Mon Mar 25, 2019 10:27 pm
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/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.
That error means a negative number is out of range for an UNSIGNED INT.

Some info about it:

https://stackoverflow.com/questions/184 ... n-opencart
https://stackoverflow.com/questions/662 ... -value-fix
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. Thanks

Newbie

Posts

Joined
Mon Mar 25, 2019 10:20 pm

Post by tavakoli » Wed Mar 27, 2019 6:53 pm

i changed the table from INT to something else and it works now.
Can someone please delete this forum completely?

Newbie

Posts

Joined
Mon Mar 25, 2019 10:20 pm
Who is online

Users browsing this forum: No registered users and 197 guests