Supose someone Droped Configuration group in sql?

[starynightskyz]

lets "pretend" I have a friend ( wink wink ) that accidently dropped the configuration_group from her sql. and of course the dumb a** didn't do a backup first.

 

I,, I mean "she" would like to know what configuration group handles? (where will I start finding errors on the site?)

 

And is there a place where the original sql configuration group,for oscommerce can be found and re inserted into the data base?

 

Or would it be wiser with all the contributions requiring sql, to just scrap the whole darn thing and start over?

 

OMG I can't stop lauging,and pouting at the same time.

 

What happend was, in configuration group I clicked the tick mark beside a row that had something to do with wishlist. and clicked drop, thinking it would only drop the wishlist stuff.

 

but no, the whole section disapeared. My bad

 

It's not a live site, so at the end of the day lesson learned and it's no biggy to start over but for I don't look forward to adding all the extra contribs again.

 

So if anyone alot wizer than me, wants to make a recomendation ... and have a laugh, feel free.

 

Nancy :D

[Guest]

Hi Nancy,

 

You chose a good one to drop ! >_<

 

Many contributions add fields to the configuration group. You could create and reload the default settings and then look for errors for the contributions you added.

 

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');

 

 

If no errors appear, then you may not have added any contributions that required configuration_group changes.

 

 

Chris

[multimixer]

You can double check if missing configuration group id's, if you go to table configuration, sort it by configuration group id and then see if there are any numbers that don't exist in the table configuration group.

 

I would delete any configuration id's that have not a matching configuration group id, and then run the sql's of all addons again