Can't log into admin

[Ajeh]

You are most welcome ... thanks for letting us know that this worked for you in resetting the Admin password ...

[zcnb]

You are most welcome ... thanks for letting us know that this worked for you in resetting the Admin password ...

Thank YOU, Ajeh. You have helped me numerous times in the past and this is yet another such time (even though I didn't post any question, just did a good search).

One minor clarification: I didn't reset the Admin password (I had it already, along with the Admin email address). What I amazingly forgot was the Admin Username (it wasn't 'Admin' or 'admin'). Funny and frustrating at the same time...

[paffum]

I've done the step to reset it but I still have a blank page in both IE & Firefox. What else could be wrong? I think I'm missing a file. When I first installed zen cart I used to have 97 files and today when I logged in to phpmyadmin I had 95, after I ran the reset codes I have 96, What file could I be missing?

[RStrikers]

how do I determine my admin username. I signed up today but it won't allow me to log into my admin area. says wrong admin username or password. I know the password is correct

[Ajeh]

If you look at the post #2 of this thread ... I have it spelled out for you how to rebuild the admin table of your database so that you can then login and reset your password ...

[RStrikers]

so how do I get to phpmyadmin...

[Ajeh]

phpMyAdmin should be in the Control Panel for your domain ...

If you cannot locate this, you will want to contact your hosting site for additional help with your server and utilizing this application ...

[paffum]

This is what it appears after I run the first step,


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).

and when I run the second step this is what I get,

Error

SQL query:

NSERT INTO admin VALUES ( 1, 'Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1 )

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NSERT INTO admin VALUES (1, 'Admin', 'admin@localhost', '351683ea4e19efe34874b50' at line 1

What should I do???

[Ajeh]

Looks like you missed the I on the word INSERT ...

[callow]

I can not login too

When I use right user name and password it refreshs login page instead of proceeding admin-index page. If -either- password or username is wrong it gives "You entered the wrong username or password." warning message.

My solution is : If I am using Firefox, if there are multiple tabs or not, all firefox windows must be closed down.. Reopen fresh firefox window and try again to access, that time it enters admin area. OR, if it fails to enter in firefox, I do open another internet explorer window from there I am able to access. What could be causing it I don't know but something regarding the way browser's handling of zen cart/php codes. Or maybe something new, trojan (even my multiple trojan cleaners can not detect) or else causing failed access attempt

I hope this may help some of you.