Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2005
    Location
    Earth.
    Posts
    19
    Plugin Contributions
    0

    Default Lost the Configuration Menu

    I mistakenly have lost the configuration_group table (and thus the menu from within the admin) by executing the code below. I was trying to get the MultiGeoZone to appear on the menu.

    DROP TABLE IF EXISTS configuration_group;
    CREATE TABLE configuration_group (
    configuration_group_id int(11) NOT NULL auto_increment,
    configuration_group_title varchar(64) NOT NULL default '',
    configuration_group_description varchar(255) NOT NULL default '',
    sort_order int(5) default NULL,
    visible int(1) default '1',
    PRIMARY KEY (configuration_group_id),
    KEY idx_visible_zen (visible)
    ) TYPE=MyISAM;


    Does anyone know the SQL code or patch to get it back please?

  2. #2
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Lost the Configuration Menu

    Assuming v1.3.x
    and
    Assuming you had no custom mods installed
    and
    Assuming the table is still empty now

    Code:
    INSERT INTO configuration_group VALUES ('1', 'My Store', 'General information about my store', '1', '1');
    INSERT INTO configuration_group VALUES ('2', 'Minimum Values', 'The minimum values for functions / data', '2', '1');
    INSERT INTO configuration_group VALUES ('3', 'Maximum Values', 'The maximum values for functions / data', '3', '1');
    INSERT INTO configuration_group VALUES ('4', 'Images', 'Image parameters', '4', '1');
    INSERT INTO configuration_group VALUES ('5', 'Customer Details', 'Customer account configuration', '5', '1');
    INSERT INTO configuration_group VALUES ('6', 'Module Options', 'Hidden from configuration', '6', '0');
    INSERT INTO configuration_group VALUES ('7', 'Shipping/Packaging', 'Shipping options available at my store', '7', '1');
    INSERT INTO configuration_group VALUES ('8', 'Product Listing', 'Product Listing configuration options', '8', '1');
    INSERT INTO configuration_group VALUES ('9', 'Stock', 'Stock configuration options', '9', '1');
    INSERT INTO configuration_group VALUES ('10', 'Logging', 'Logging configuration options', '10', '1');
    INSERT INTO configuration_group VALUES ('11', 'Regulations', 'Regulation options', '16', '1');
    INSERT INTO configuration_group VALUES ('12', 'E-Mail Options', 'General settings for E-Mail transport and HTML E-Mails', '12', '1');
    INSERT INTO configuration_group VALUES ('13', 'Attribute Settings', 'Configure products attributes settings', '13', '1');
    INSERT INTO configuration_group VALUES ('14', 'GZip Compression', 'GZip compression options', '14', '1');
    INSERT INTO configuration_group VALUES ('15', 'Sessions', 'Session options', '15', '1');
    INSERT INTO configuration_group VALUES ('16', 'GV Coupons', 'Gift Vouchers and Coupons', '16', '1');
    INSERT INTO configuration_group VALUES ('17', 'Credit Cards', 'Credit Cards Accepted', '17', '1');
    INSERT INTO configuration_group VALUES ('18', 'Product Info', 'Product Info Display Options', '18', '1');
    INSERT INTO configuration_group VALUES ('19', 'Layout Settings', 'Layout Options', '19', '1');
    INSERT INTO configuration_group VALUES ('20', 'Website Maintenance', 'Website Maintenance Options', '20', '1');
    INSERT INTO configuration_group VALUES ('21', 'New Listing', 'New Products Listing', '21', '1');
    INSERT INTO configuration_group VALUES ('22', 'Featured Listing', 'Featured Products Listing', '22', '1');
    INSERT INTO configuration_group VALUES ('23', 'All Listing', 'All Products Listing', '23', '1');
    INSERT INTO configuration_group VALUES ('24', 'Index Listing', 'Index Products Listing', '24', '1');
    INSERT INTO configuration_group VALUES ('25', 'Define Page Status', 'Define Main Pages and HTMLArea Options', '25', '1');
    INSERT INTO configuration_group VALUES (30, 'EZ-Pages Settings', 'EZ-Pages Settings', 30, '1');
    .

    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
    Sep 2005
    Location
    Earth.
    Posts
    19
    Plugin Contributions
    0

    Default Re: Lost the Configuration Menu

    Perfect! Many thanks!

 

 

Similar Threads

  1. v150 Upgrade from v1.3 to 1.5 ...now the configuration menu is empty
    By ionoloso in forum Upgrading to 1.5.x
    Replies: 1
    Last Post: 17 May 2012, 10:42 PM
  2. v150 How the module administrator configuration options menu?
    By kira9119 in forum Customization from the Admin
    Replies: 3
    Last Post: 3 May 2012, 11:03 AM
  3. What do the Values mean under the Configuration Menu?
    By maderstrains.com in forum General Questions
    Replies: 4
    Last Post: 2 Jun 2009, 10:49 PM
  4. Replies: 9
    Last Post: 9 Mar 2009, 08:31 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