Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2007
    Posts
    152
    Plugin Contributions
    0

    Default 1062 Duplicate entry '1-1' for key 1 ????

    ok i am trying to set up option name manager for colour, size that seems to be fine when i goto option value manager to set up gold and silver options i am getting this message, anyone know why:

    1062 Duplicate entry '1-1' for key 1
    in:
    [insert into zc_products_options_values (products_options_values_id, language_id, products_options_values_name, products_options_values_sort_order) values ('1', '1', 'Silver', '2')]
    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.

    ZC version is (You are presently using: v1.3.9g)

    Egg

  2. #2
    Join Date
    Apr 2007
    Posts
    152
    Plugin Contributions
    0

    Default Re: 1062 Duplicate entry '1-1' for key 1 ????

    sorted it i went into php myadmin and found the relivent table and deleted the options tried again and it works.

    Egg

  3. #3
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: 1062 Duplicate entry '1-1' for key 1 ????

    Thanks for the update that this is working and for post the solution that you used to fix this ...

    NOTE: please check that table that you still have a record for:
    products_options_values_id language_id products_options_values_name products_options_values_sort_order
    0 1 TEXT 0
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

 

 

Similar Threads

  1. 1062 Duplicate entry '' for key 2
    By Shavelieva in forum General Questions
    Replies: 0
    Last Post: 17 Nov 2007, 06:07 AM
  2. 1062 Duplicate entry '0' for key 1
    By knitengale in forum General Questions
    Replies: 8
    Last Post: 12 Jul 2006, 12:50 AM
  3. 1062 Duplicate entry '0' for key 1
    By marckasten in forum General Questions
    Replies: 3
    Last Post: 12 Jun 2006, 06:19 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