|
|
Posted by Erwin Moller on 07/03/06 16:46
Marcus wrote:
> 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.
Hi,
I think pass should be a string.
Does:
SELECT AES_DECRYPT('pass', 'asdf') FROM `test`
also produce an error?
Regards,
Erwin Moller
PS: Beats me why direct executing does not produce an error.
PHPMyAdmin must be fiddling around before executing...
Navigation:
[Reply to this message]
|