Results 1 to 10 of 30

Hybrid View

  1. #1
    Join Date
    Mar 2005
    Posts
    561
    Plugin Contributions
    4

    Default Re: Anyone any good at SQL? Can you help?

    A nice blank table with the headings title value and action with a heading above saying quick updates.

  2. #2
    Join Date
    Mar 2005
    Posts
    561
    Plugin Contributions
    4

    Default Re: Anyone any good at SQL? Can you help?

    I just tried running this...
    Code:
    INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES ('300', 'Quick Updates', 'Here you can configure what you will be able to modify in Quick Updates.', '300', '1');
    INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Display the model.', 'QUICKUPDATES_DISPLAY_MODEL', 'true', 'Enable/Disable the model displaying', 300, 1, '2003-06-04 05:04:11', '2003-06-04 04:18:06', NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
    and it failed at the first.

  3. #3
    Join Date
    Mar 2005
    Posts
    561
    Plugin Contributions
    4

    Default Re: Anyone any good at SQL? Can you help?

    If anyone else has any ideas for me to try I would be very greatful.

  4. #4
    Join Date
    May 2006
    Posts
    68
    Plugin Contributions
    0

    Default Re: Anyone any good at SQL? Can you help?

    Reesey,
    as was explained above the problem is the configure ID
    its trying to use 300 and its already in use

    try this

    Code:
    INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES ('', 'Quick Updates', 'Here you can configure what you will be able to modify in Quick Updates.', '300', '1');
    by using '' rather than an number it will auto increment

  5. #5
    Join Date
    Mar 2005
    Posts
    561
    Plugin Contributions
    4

    Default Re: Anyone any good at SQL? Can you help?

    Hi, thanks for your reply.
    300 isnt being used by anything else as I ran the docs suggestion above first

    I tied your suggestion and it worked, any suggestion as for the rest of it as I still get the same error....
    ERROR: Cannot insert configuration_key "" because it already exists

    Thanking you in advance.

  6. #6
    Join Date
    Jan 2004
    Posts
    66,446
    Plugin Contributions
    81

    Default Re: Anyone any good at SQL? Can you help?

    So, if you "have" the configuration group #300 (evidenced by the group appearing on the admin Configuration menu), then simply do the inserts for the "configuration" table.


    Pardon the obvious question, but ... are you sure you're running this on the right database?
    .

    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.

  7. #7
    Join Date
    Mar 2005
    Posts
    561
    Plugin Contributions
    4

    Default Re: Anyone any good at SQL? Can you help?

    Hi Doc,
    That is what I have been trying and I get the above error.

    Yes I am running this on the right database as there is only one there.

 

 

Similar Threads

  1. Problems with installation
    By bmw2182 in forum Installing on a Linux/Unix Server
    Replies: 8
    Last Post: 1 Aug 2008, 05:32 PM
  2. Problems with XAMPP installation
    By Marlake in forum Installing on a Windows Server
    Replies: 6
    Last Post: 26 Mar 2008, 07:11 PM
  3. How to get Group Pricing (per Item) to work with QuickUpdates?
    By Gamer in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 0
    Last Post: 14 Feb 2008, 04:22 PM
  4. Problems with Installation
    By monicagallien in forum Installing on a Linux/Unix Server
    Replies: 10
    Last Post: 29 Jun 2006, 10:56 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