MySQL osCommerce Problem

[JMoney]

On the bottom of 2 of my shopping carts ran by osCommerce, there is the following text:

1062 - Duplicate entry '2147483647' for key 1

insert into sessions values ('b06851119ad9c72806b98cc84175c4f3', '1222513181', 'cart|O:12:\"shoppingcart\":4:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:12:\"content_type\";b:0;}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"USD\";navigation|O:17:\"navigationhistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:9:\"index.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:5:\"cPath\";s:2:\"35\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}')

[TEP STOP]

I've tried reinstalling OSC, dumping the database and reinstalling that, checking chomding and I haven't been able to figure out why it won't go away. It also prohibits me from adding new products/categories. I only have this on 2 of my sites and I have about 5 others that run the same version of OSC with just as much or more products.

[DYM-Mike]

After a few seconds of searching I'm directed to the offical osCommerce forums where this exact error is addressed and diagnosed.

http://forums.oscommerce.com/index.php?showtopic=188718

I have had this problem a few days now, and THIS FIXED IT!

THOSE WHO ARE SEARCHING for duplicate errors fixes, PLEASE TRY THIS STEP!

I changed my Auto_Increment to the last id in the column so it continued where it left off.

Be sure you do not delete auto_increment, otherwise it will continue to produce the error.

Thanks again for your post!

[JMoney]

Alright, thank you for that. I've ran a search for the "auto_increment" but did not find it and am not sure which table to look for it in.