Dang! Configuration Table Zapped!

[gezuvor]

Okay, I can be less than perfectly analytical when I install or uninstall mods to my software. In this case, I think I hosed my configuration table.

 

Basically, I installed a modification to allow for more photos in the product listing and it didn't work. So, I took it out and managed to mess up my dbase in the process. After some hacking, I managed to get it stabilized but I think there is some content/functionality missing.

 

When I go to the admin page for the site and click Configuration, I see this:

 

 

When I go to the phpMyAdmin site and click on the Configuration table, I get this:

 

When I click on the Configuration Group table, I get this:

 

Any comments? Can somebody share what these should look like? I'm feeling a bit foolish and would like to be able to recover this myself.

 

Thanks, ~Rich

[gezuvor]

Nobody? Can I at least get a description or image of what these two tables should look like? A hint on how to rebuild the db?? Anyone?

[Gil_e_n]

Have you tried restoring from backup?

 

Your configuration table looks right, but I'd check to see if there's anything in it. (Click check all, and the browse button. That looks like it's different in your version of phpmyadmin, so I can't say any more.)

[gezuvor]

Thank you Gillian!

 

I am able to browse the Configuration table, but not the Configuration Group table. I assume that I should be able to do that??

[Gil_e_n]

Yeah. Looking at it in my phpmyadmin, it's the one that has the missing data from your admin section. Looking at the base oscommerce sql file that came with it, the query you probably want to run is:

DROP TABLE IF EXISTS configuration_group;
CREATE TABLE configuration_group (
 configuration_group_id int NOT NULL auto_increment,
 configuration_group_title varchar(64) NOT NULL,
 configuration_group_description varchar(255) NOT NULL,
 sort_order int(5) NULL,
 visible int(1) DEFAULT '1' NULL,
 PRIMARY KEY (configuration_group_id)
);

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', 'Cache', 'Caching configuration options', '11', '1');
INSERT INTO configuration_group VALUES ('12', 'E-Mail Options', 'General setting for E-Mail transport and HTML E-Mails', '12', '1');
INSERT INTO configuration_group VALUES ('13', 'Download', 'Downloadable products options', '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');

 

That's the base osc configuratioN_group table. If you've added any contributions that affect that, then obviously you'll have to add them back in. I don't have any quick suggestions for that, I'm afraid.

[gezuvor]

Yeah!!! Gillian is my hero!!!

 

:thumbsup: