tonysebay:
Hi All I searched High and low for this but found nothing. So here is my problem I added all my items using EPA and as always it went in with no problem, but now I wanted to add a new product and it came back with this ID 2147483647 I know this is the magic number for the end or last product
so when I went to add one more product this popped up
1062 Duplicate entry '2147483647' for key 1
in:
[insert into products (products_quantity, products_type, products_model, products_price, products_date_available, products_weight, products_status, products_virtual, products_tax_class_id, manufacturers_id, products_quantity_order_min, products_quantity_order_units, products_priced_by_attribute, product_is_free, product_is_call, products_quantity_mixed, product_is_always_free_shipping, products_qty_box_status, products_quantity_order_max, products_sort_order, products_discount_type, products_discount_type_from, products_price_sorter, products_image, products_date_added, master_categories_id) values ('1', '1', '2321', '2', null, '0', '1', '0', '0', '0', '1', '1', '0', '0', '0', '1', '0', '1', '0', '0', '0', '0', '0', '', now(), '388')]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
I downloaded my store with EPA and the last Item # was 2147483647
the one before that ID number is 98378 any Ideas how to reset this?
when I go into Tools/EPA/ the Index Mode: products_id it says
Next products table id: 2147483647 how do I reset that back to 98379?
Thanks for your help.
And Happy Holidays to All!
In Answering my own question I did a search for 2147483647 on my sql server and got a bunch of matches the one where I fixed the problem was in 1 match(es) inside table *products_to_categories I changed *2147483647 to 1
then went back to see and it was fixed. I am writing this here so if it ever happens again I can fix it fast!
Anyway Hope this helps someone else in the years to come :)
Tony
