OSCommerce (Error: Invalid administrator login attempt)

The error may occur while trying to login to your oscommerce admin panel.

1. Open your database management tool (PhpMyAdmin or similar)

2. Open the SQL tab at the top

3. Into the SQL query window paste the following query and press Go button:

1
2
3
4
5
6
7
DROP TABLE IF EXISTS administrators;
CREATE TABLE administrators (
id int NOT NULL auto_increment,
user_name varchar(32) binary NOT NULL,
user_password varchar(40) NOT NULL,
PRIMARY KEY (id)
);

4. When the query is complete open your osCommerce admin panel. You’ll be notified that there are no administrator account. Type your new admin username and password.

Now the admin account has been successfully created. Type the admin details again to enter the admin panel

Quoted from : Template Monster

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s