missing administrator table

[nyrainman]

I cannot log into my cart and come to find out that the administrators table in the database is missing. The cart was installed using cPanel features, either Fantastico or QuickInstall and all worked fine until now. Since the table is missing I cannot change or create a password.

 

Any advise?

[Guest]

@@nyrainman

 

Advice: Create the table by using PHPMYADMIN in your hosting control panel. Here is the SQL statement to run.

 

CREATE TABLE administrators (

id int NOT NULL auto_increment,

user_name varchar(255) binary NOT NULL,

user_password varchar(60) NOT NULL,

PRIMARY KEY (id)

);

 

 

Then, go to your admin directory where you will be prompted to create a new username and password. DONE

 

 

 

Chris

[MrPhil]

1. Talk with your host to find out why the table disappeared. Database tables should NOT just evaporate like that. It's even possible that your site was hacked and needs to be cleaned up.

 

2. Learn to back up both the site files AND the database, AND how to check that they're good, AND how to restore them. You'll need to do so some day (like yesterday). Don't rely on your host's backups as your primary backup -- keep your own.

 

3. Install and maintain applications such as osC natively through .zip install files from this site. Bundlers and "one click" installers like Fantastico, QuickInstall, and Softaculous are fine for exploring new applications without much effort, but they tend to install in odd ways, with extra stuff you may not want, and get snippy if you try to update not through them. Real production installations should always be done natively.