Accidently erased database table

[soulfinger]

I accidently erased the "configuration" table in mysql database. I'm trying to create a new one but I don't know how many fields there are in this table. Can anyone help me out on this. Thanks

[Guest]

Oh my! You're in a pickle for sure.....In your original download is a file called oscommerce.sql. It is inside the catalaog/install directory. Open it up with a text editor. You will find a section that looks like this:

 

DROP TABLE IF EXISTS configuration;

CREATE TABLE configuration (

 configuration_id int NOT NULL auto_increment,

 configuration_title varchar(64) NOT NULL,

 configuration_key varchar(64) NOT NULL,

 configuration_value varchar(255) NOT NULL,

 configuration_description varchar(255) NOT NULL,

 configuration_group_id int NOT NULL,

 sort_order int(5) NULL,

 last_modified datetime NULL,

 date_added datetime NOT NULL,

 use_function varchar(255) NULL,

 set_function varchar(255) NULL,

 PRIMARY KEY (configuration_id)

);

 

Copy that section into your phpMyAdmin under the tab that says SQL and then click the "go". That should restore your configuration table.

[Guest]

and I thought I was the only one who did things like that! :lol:

[soulfinger]

Thanks for you help. I already re-installed the back up site. I just got to add some products that I didn't have on their before. I wish I waited. You guys are way cool.