Results 1 to 7 of 7
  1. #1
    Join Date
    Apr 2006
    Location
    Largo, Florida USA
    Posts
    102
    Plugin Contributions
    0

    Default Duplicate entry error

    HELP!
    After messing up a car that was running perfectly, I am getting the following error after creating my test user login - but it does create the acoount.

    1062 Duplicate entry '150' for key 1
    in:
    [insert into customers_info (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created, customers_info_source_id) values ('150', '0', now(), '11')]

    I had installed the How Did You Hear About Us? and I accidently uploaded the files intended for INCLUDES to the ADMIN/INCLUDES folder. I cannot remember if I had made any other changes between the backup and the mistake.

    I am running 1.37

  2. #2
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: Duplicate entry error

    You could start by re-loading the correct module files to the correct locations

    If that does not correct - re-load the 1.3.7 files (hope that you are using the overrides system) check the site.
    If it is functioning correctly then reload the module files

    If using the overrides system and still no joy - try switching to the classic template and checking if this fixes it look at your overrides files
    Zen-Venom Get Bitten

  3. #3
    Join Date
    Apr 2006
    Location
    Largo, Florida USA
    Posts
    102
    Plugin Contributions
    0

    Default Re: Duplicate entry error

    Thanks
    Yes I am using the awesome Silverfish template, but I went hog wild and installed the PO module, Call in Credit Card Number, the Invoice module, shipping insurance (I shop on the accessory isle).
    Which folders should I reupload?
    I reuploaded the How Did You Hear About Us and it works, plus that entire cart works, just get the message when we create our accounts to test site.
    Templates?
    Default Templates?

    Thanks for the fast response time.

  4. #4
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: Duplicate entry error

    Well that complicates things with all the mods - -

    Try switching to the classis template first and if this corrects the issue then it localizes the issue to only those files that are in the silver fish template if not then you need to start looking at each mod and determine what if any core files have been replaced. make a list of these.

    Then you can proceed files by file to see what changes it back - or start with the file list and look at the files on your server on or about the date and after that you recall this issue began. The date of files changed after a certian date are the ones that should have created the error action
    Zen-Venom Get Bitten

  5. #5
    Join Date
    Apr 2006
    Location
    Largo, Florida USA
    Posts
    102
    Plugin Contributions
    0

    Default Re: Duplicate entry error

    I feel comfortable tackeling this, tell me what software is better WinDiff or ??compare?? - where can I learn about these programs - any threads here?

  6. #6
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: Duplicate entry error

    BeyondCompare is the Dve's favored tool but costs.

    WinDiff or winMerge are free to use and function

    I do not think the you should require a tutorial as they are fairly straight forward

    How many files are you looking at that have been altered about the time that this error occurred?
    Zen-Venom Get Bitten

  7. #7
    Join Date
    Apr 2006
    Location
    Largo, Florida USA
    Posts
    102
    Plugin Contributions
    0

    Default Re: Duplicate entry error

    I swaped templates to Classic and got the same error, so I went back to the Silver Fish. Everything worked until I copied over files, the admin panel shows the field but it is blank. I am using 1.3.7

    ID# Last Name
    Asc</B> Desc</B> First Name
    Asc</B> Desc Company
    Asc</B> Desc</B> Account Created
    Asc</B> Desc</B> Referred By
    Asc</B> Desc</B> Last Login
    Asc</B> Desc</B> Pricing Group
    Asc</B> Desc</B> Authorized
    Asc</B> Desc</B> Action

    I am not sure exactly which files I am looking at. I plan on unziping the modules and printing out the directories on paper to see which files overlap unless you suggest an alternative.

    Here are my files - can you elimiante any for me ahead of time?

    how_did_you_hear_about_us_1.3.6

    captialize_signup_fields_v1.0b

    faxphone_payment_v1.0

    xsell-sidebox

    printable_pricelist_1.1.1

    optional_shipping_insurance_module_2b

    invoice_1.3

    purchase order module

    ** EDITED *** Never ever post in a forum, email, newsletter etc. the zenid or zenAdminID or you will be doomed!!
    Last edited by Ajeh; 22 Feb 2007 at 04:59 PM.

 

 

Similar Threads

  1. v151 Error: Duplicate entry in admin_activity_log
    By lat9 in forum General Questions
    Replies: 7
    Last Post: 4 Dec 2017, 02:56 AM
  2. PHP Fatal error: 1062 Duplicate entry Error, cannot fix table
    By RoboPhung in forum General Questions
    Replies: 5
    Last Post: 10 Apr 2013, 09:03 PM
  3. Database error - Duplicate Entry
    By PortraitArtist in forum Installing on a Linux/Unix Server
    Replies: 1
    Last Post: 30 Dec 2010, 03:14 PM
  4. Duplicate entry error
    By frazeks in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 31 Jul 2009, 06:48 PM

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
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR