Cannot log into admin, or user login after moving servers

version: 1.3.8

I moved 2 zencarts to the same server they worked okay, when i moved this last one I cannot log in to admin or as a customer.

I ran the fix cache utility and also tried to reset the admin user/pass with the utilty but get this error message:

Failed to execute SQL : SQL 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); failed : 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 'INSERT INTO admin (admin_name, admin_email, admin_pass, admin_level) VALUES ('Ad' at line 1

I think the sql and php is a higher version on this server but as i said the other 2 worked fine?

Andy

I meant to say when i try to log in as admin I do not get any error message. The login box just clears...

andyase:

I meant to say when i try to log in as admin I do not get any error message. The login box just clears...
That's a sessions and/or cookies problem, not a password problem. A password problem will say so. A session/cookie problem will say nothing.