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

[wwwursa]

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

[DrByte]

The correct FAQ article is: http://www.zen-cart.com/content.php?...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