Log in

View Full Version : Problem Updating User Table - DB Error 1064


Kinneas
08-22-2007, 08:40 AM
When trying to update a user record directly in phpmyadmin, I am getting the following error.

SQL query:

A

MySQL said: Documentation
#1064 - 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 'A' at line 1


This happens even if I just click edit, make no changes and try to save the record again.

I really don't understand MySQL that well, so make sure your explanations are in "idiotproof" terms ;)

Thanks in advance.

Eikinskjaldi
08-22-2007, 10:29 AM
Update your users in admincp, not phpmyadmin.

Kinneas
08-22-2007, 10:39 AM
If I was able to, I would have, however it's a field which isn't updateable in admincp.

Anyway, found the problem, looks like it's because of the way I was accessing phpmyadmin.
Thanks anyway.