Password problems

[Teadiez]

Okay, tried that...didn't work. My site is still up and I'm still able to connect to my login page.

I cut and pasted that code and got an error, saying "Table xyz.admin doesn't exist". But, at least I didn't lost everything again! Its a step...

[DrByte]

What are all your table names like? In phpMyAdmin, do you see a table named "admin"? or do all your tables have some sort of prefix on them? like "fred_" or "zen_" or "sunny_" ?
If so, that's what the FAQ text is talking about in the small print under the SQL code where it talks about prefixes.

So, if your table name is actually zen_admin then change the DELETE FROM admin and INSERT INTO admin to read DELETE FROM zen_admin and INSERT INTO zen_admin

[Teadiez]

Okay, saw that I do have a prefix, so I tried that also. Still got that error. Grrrrrr. Seems like something so simple!!

[DrByte]

What's the exact new error message?

What's the DB_PREFIX in your configure.php file? Is that the prefix you added in the SQL code?

What's the DB_DATABASE in your configure.php file? Is that the database you selected in phpMyAdmin from the pulldown on the left side of the screen? (there may not be a pulldown if you have only one database in your hosting account)

[Teadiez]

Same error.

Prefix is zen_, and I did use that. Only one database.

[DrByte]

With respect, it's not going to say "Table xyz.admin doesn't exist" if you used "zen_admin". It would instead say "Table xyz.zen_admin doesn't exist".
So if the actual error is really still saying just "admin", then it means you didn't put the prefix in correctly.

[Teadiez]

Wait, should I actually be using the ID I use when I log in with the prefix? Or zen_admin? I don't use 'Admin' to log in.

My brain is fried. I really appreciate all your time with me.

[Teadiez]

SQL query:

DELETE FROM admin WHERE admin_name = 'zen_admin';

MySQL said: Documentation
#1146 - Table 'tig1210604264656.admin' doesn't exist

[Teadiez]

That's the error message. Cut and pasted.

[DrByte]

No.

The FAQ article says:

In v1.5.x use this:


Open your phpMyAdmin (supplied by your hosting company), select your store's database, then click the "SQL" tab and run this query:

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

If you are using a prefix for your database tables, you'll naturally need to add that prefix to the table name above.
ie. "DELETE FROM prefix_admin ... " and "INSERT INTO prefix_admin ..." ... replacing "prefix_" with your actual tablename prefix.