Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2006
    Posts
    7
    Plugin Contributions
    0

    Error 1062 Duplicate Entry

    Hi, this is my first post even though i've been messing around with Zencart since April.
    I get this error when I try to run the Column_Layout_Grid_SQL:

    "1062 Duplicate entry 'PRODUCT_LISTING_LAYOUT_STYLE' for key 2
    in:
    [INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Product Listing - Layout Style', 'PRODUCT_LISTING_LAYOUT_STYLE', 'rows', 'Select the layout style:
    Each product can be listed in its own row (rows option) or products can be listed in multiple columns per row (columns option)', '8', '40', NULL, now(), NULL, 'zen_cfg_select_option(array("rows", "columns"),');]
    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 have recently upgraded from 1.3.2 to 1.3.5.

    I am working on my local computer so I do not have a link to show.

    All of the products are still only lining up on the left side.

    Any help would be greatly appreciated.

    Thanks,
    Cliff

  2. #2
    Join Date
    Jan 2004
    Posts
    66,444
    Plugin Contributions
    279

    Default Re: Error 1062 Duplicate Entry

    "Duplicate entry" suggests that you've already run the SQL previously.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  3. #3
    Join Date
    Aug 2006
    Posts
    7
    Plugin Contributions
    0

    Default Re: Error 1062 Duplicate Entry

    Thanks for the quick reply. I did run it previously on my 1.3.2 cart so i thought I had to run it again when I upgraded. So I guess you're saying that the SQL is already installed.

    That being said, I am stil only getting 1 column rather than the 3 that are in my product listing layout. Do you have any ideas why?

    Thanks,
    Cliff

 

 

Similar Threads

  1. v151 error: 1062 : Duplicate entry
    By Kevin205 in forum General Questions
    Replies: 5
    Last Post: 18 Apr 2014, 02:15 PM
  2. v151 1062 Duplicate Entry Error Help
    By firstcapitalfirearms in forum General Questions
    Replies: 1
    Last Post: 18 Jan 2014, 01:30 AM
  3. 1062 Duplicate entry '0' for key 1 Error - 1.3.6-->1.3.8a
    By Ellume in forum Upgrading from 1.3.x to 1.3.9
    Replies: 24
    Last Post: 10 Jun 2008, 07:34 AM
  4. Error 1062 Duplicate Entry
    By Betsysue in forum Upgrading from 1.3.x to 1.3.9
    Replies: 1
    Last Post: 31 May 2008, 04:12 PM

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