you'll need to confirm whether or not you are using prefixes on the database. Easy to do in phpmyadmin...does the admin table just say admin or does it say zen_admin or something like that.
Mike
GeekHost - Zen Cart Certified & PCI Compliant Hosting
The Zen Cart Forum...Better than a monitor covered with post-it notes!
Posted via Mobile Device
When I run this command:
DROP TABLE IF EXISTS admin;
CREATE TABLE admin (
admin_id int(11) NOT NULL auto_increment,
admin_name varchar(32) NOT NULL default '',
admin_email varchar(96) NOT NULL default '',
admin_pass varchar(40) NOT NULL default '',
admin_level tinyint(1) NOT NULL default '1',
PRIMARY KEY (admin_id),
KEY idx_admin_name_zen (admin_name)
) TYPE=MyISAM;
then the message I receive is this:
Your SQL query has been executed successfully
SQL query:
DROP TABLE IF EXISTS admin;# MySQL returned an empty result set (i.e. zero rows).
CREATE TABLE admin(
admin_id int( 11 ) NOT NULL AUTO_INCREMENT ,
admin_name varchar( 32 ) NOT NULL default '',
admin_email varchar( 96 ) NOT NULL default '',
admin_pass varchar( 40 ) NOT NULL default '',
admin_level tinyint( 1 ) NOT NULL default '1',
PRIMARY KEY ( admin_id ) ,
KEY idx_admin_name_zen( admin_name )
) TYPE = MYISAM ;# MySQL returned an empty result set (i.e. zero rows).
Now, you can see if the table consists of any prefix or not.
I have not much knowledge about this php and all that.
If you can help me, then i will be very thankful to you.
regards and hoping to receive an answer early.
I found it ......
it is zen_admin in the table.
now what to do, please reply soon... thanks.
These are the sql statements that you need. Notice the only thing I changed was to put the zen_ before the table name.
thenCode:DROP TABLE IF EXISTS zen_admin; CREATE TABLE zen_admin ( admin_id int(11) NOT NULL auto_increment, admin_name varchar(32) NOT NULL default '', admin_email varchar(96) NOT NULL default '', admin_pass varchar(40) NOT NULL default '', admin_level tinyint(1) NOT NULL default '1', PRIMARY KEY (admin_id), KEY idx_admin_name_zen (admin_name) ) TYPE=MyISAM;
take notice of the difference Admin (username), admin (password)Code:INSERT INTO zen_admin VALUES (1, 'Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);
Mike
GeekHost - Zen Cart Certified & PCI Compliant Hosting
The Zen Cart Forum...Better than a monitor covered with post-it notes!
I pasted the same codes given by you in SQL tab.
the first code and then closed the run query window and then again opened it and pasted the second code.
But I am still unable to login using username Admin and password admin.
please suggest where am I wrong.
thanks.
The Admin login page has a link to "Resend Password". Have you tried that?
Note: you would have to verify that "zen_admin" TABLE is using one of your eMail addresses.
How can I check that the zen_admin table is using my email address : muteyaar######################
please help me, I am in real trouble.
or can you please check out my control panel and repair the thing?
I looked up at the zen_admin table and found that the admin name is muteyaar and the admin email is muteyaar###################### , which my own email address.
now what should I do? please suggest.
thanks.
Bookmarks