I've been experiencing a few problems with the admin of my site and each time I try to correct something I make things worse.

Initially I had a problem with the database saying an extra column had been added to one of the tables and was unrecognised. So I deleted the database and reinstalled it from a backup. This seems to be running fine from the front end but the problem I have now is that I can't log into my admin page at all. Each time I try to log in the page resets itself (wipes all the fields clear and looks like it's just been loaded), unless I use a username or password that it doesn't recognise in which case I get a message saying that the username or password is not recognised.

I clicked the link for a new password which I tried (several times) but the page just reloads blank.

Hunting around this forum I came across the following code to reset both user name and password:

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

but I get the same result - the page just resets itself.

As I can't get into the admin page I'm not sure which version of Zen cart I'm running but I believe it's the latest one. I have the Cherry Zen override running - in case that makes a difference.

Anyone any suggestions as to what I do next?

Any help would be appreciated.