Posted by Marcus on 07/03/06 16:28

Hello,

I am having a problem with a query in phpMyAdmin... it works fine on my
localhost, but the exact same query produces an error in phpMyAdmin on
my server:

localhost: PHP 4.3.11, MySQL 4.1.12, phpMyAdmin 2.8.1
server: PHP 4.3.11, MySQL 4.1.12, phpMyAdmin 2.6.3-pl1

SELECT AES_DECRYPT(pass, 'asdf') FROM `test`

This query works fine on my local phpMyAdmin, and also works fine
through a php script on my server, but when I try it with phpMyAdmin on
my server it produces the following error:

#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 '( pass , 'asdf' ) FROM `test` LIMIT 0, 30' at line 1

The only thing I could find online was that this error might arise if
there is a space between AES_DECRYPT and (, but obviously there isn't in
this case, so I am stumped. I have been copy/pasting so I know the
query is the same. Thanks a lot for your help.

[Back to original message]