SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Member
    Join Date
    Aug 2008
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Angry MySQL osCommerce Problem

    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.

  2. #2
    SitePoint Member DYM-Mike's Avatar
    Join Date
    Jul 2006
    Location
    Melbourne
    Posts
    18
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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!

  3. #3
    SitePoint Member
    Join Date
    Aug 2008
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •