Zen Cart Logo
Forums / Customization from the Admin / Error message -- #1146 - Table 'classyca_poscheap.admin' doesn't exist

Error message -- #1146 - Table 'classyca_poscheap.admin' doesn't exist

Views: 1,138

Results 1 to 2 of 2
08 Sep 2013, 12:16
#1
wwwursa avatar

wwwursa

Zen Follower

Join Date:
Oct 2007
Posts:
163
Plugin Contributions:
0

Error message -- #1146 - Table 'classyca_poscheap.admin' doesn't exist

I had not used Zen CArt for awhile and when I did I was n ot able to enter
the correct USERNAME ID. I know the password is correct becasue I was able to get a new one.

In a ZC forum article is shows how to go back to a default Username ID
name of Admin.
In the article it suggests going to PHPMyAdmin and installing the following code.

I have not changed the ZC version in about 7 years. I used the following code

DELETE FROM admin WHERE admin_name = 'Admin';
INSERT INTO admin (admin_name, admin_email, admin_pass, admin_level)
VALUES ('Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);

When I run this I get the following error.
MySQL said: Documentation
#1146 - Table 'classyca_poscheap.admin' doesn't exist

Thanks for any help.

BILL

08 Sep 2013, 17:12
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: Error message -- #1146 - Table 'classyca_poscheap.admin' doesn't exist

The correct FAQ article is: http://www.zen-cart.com/content.php?44-how-do-i-change-or-reset-my-admin-password

And the small print there mentions that if your ZC is set up to add tablename-prefixes then you'll need to insert that prefix before "admin" in two places:

DELETE FROM admin ...
INSERT INTO admin ...

would become:

DELETE FROM zen_admin ...
INSERT INTO zen_admin ...

or

DELETE FROM fred_admin ...
INSERT INTO fred_admin ...

etc

So ... go look in your /includes/configure.php for the DB_PREFIX value, and make the appropriate substitution