473,897 Members | 2,525 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

phpMyAdmin problem

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(pas s, '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.
Jul 3 '06 #1
5 3053
Rik
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(pas s, 'asdf') FROM `test`

What does this do?
SELECT AES_DECRYPT(`pa ss`, 'asdf') FROM `test`

Grtz,
--
Rik Wasmus
Jul 3 '06 #2
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(pas s, '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('pa ss', '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...
Jul 3 '06 #3
Erwin Moller wrote:
Hi,

I think pass should be a string.
Does:
SELECT AES_DECRYPT('pa ss', '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...
Erwin,

Thanks, but 'pass' shouldn't be the string, because in this case it is
the name of the column. I think you are probably right about phpMyAdmin
fiddling around, but I am not aware of any differences between the 2
versions that would cause this. Any other ideas?
Jul 3 '06 #4
Rik wrote:
>
What does this do?
SELECT AES_DECRYPT(`pa ss`, 'asdf') FROM `test`

Grtz,
Rik,

Thanks for the feedback, your thought was a good one but unfortunately
didn't work when I tried it. I get the same message, just now with the
back ticks:

#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
Jul 3 '06 #5
Marcus wrote:
Erwin Moller wrote:
>Hi,

I think pass should be a string.
Does:
SELECT AES_DECRYPT('pa ss', '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...

Erwin,
Hi Marcus,
>
Thanks, but 'pass' shouldn't be the string, because in this case it is
the name of the column.
Aha, ok, I didn't know that.

I think you are probably right about phpMyAdmin
fiddling around, but I am not aware of any differences between the 2
versions that would cause this. Any other ideas?
Nope. :-/

Good luck,

Erwin Moller

Jul 4 '06 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
2880
by: JimC | last post by:
I have PHP installed on a Windows XP platform using IIS as server. When updating a MySQL database field set to MEDIUMTEXT in phpMyAdmin, the transaction seems to fail if the text contains more than a few hundred characters. The update is actually made successfully, but afterwards, the server cannot locate the phpMyAdmin page as requested by the client browser. I get a "Page cannot be found" error. Clicking on Update from the browser...
7
6461
by: SCS | last post by:
Running PHP 4.5.7 PHPMyAdmin 2.5.7-pl1 IIS 6 I am thrying to get phpmyadmin to work, but whenever I click a link or try to browse a database I get a 404 error, because the PmaAbsoluteUri auto-detection is nor working properly. Im pretty sure it is a problem with my php.ini file, but Im not sure where to look... can someone please help
4
37025
by: Stefan Mueller | last post by:
I've just installed phpMyAdmin. If I have the line $cfg = 'http://localhost/php/phpmyadmin'; in my config.inc.php I can login to phpMyAdmin without any problems from my local machine. But it's not working from the Internet. To access it from the Internet I have modify the line $cfg = 'http://www.myserver.com/php/phpmyadmin';
3
3051
by: mojo jojo | last post by:
This may really be a phpMyAdmin problem, I think - but keen to hear your thoughts. Any help appreciated. Using phpMyAdmin to export an entire database works fine - I get a mydatabase.sql file. Restoring (using phpMyAdmin) usually work fine. However, if any of the data in any of the fields contains the '#' character, it bombs out citing a syntax error. I have tried escaping the character with '\' to no avail - still gives syntax errors.
0
3489
by: NewbieSupreme | last post by:
I'm using PHPMyAdmin on an Apache2Triad install (latest version; 5.x.x, which installs PHP5 and PHPMyAdmin 2.8 as well). In Access, I exported a table to a text file, tab-delimited, text qualifyer of "none" (this is how I read to do it from newsgroups). When I use the Query window in phpmyadmin to import the text file, it waits a while, then returns an error: #1064 - You have an error in your SQL syntax; check the manual that...
2
6811
by: Victor | last post by:
Could anybody kindly point me to a clue in the following enigma : I have phpMyAdmin - 2.8.2.4 and MySQL - 4.1.13-nt. In the phpMyAdmin opened in any browser I am able to enter and store Russian characters in the DB; I cal also call the data back to display them in the phpMyAdmin. When I try to do the same from my own page, only some garbage with double as many characters as an original word gets stored in the DB (at least I see it...
1
2478
by: bill | last post by:
I have created a database with phpMyAdmin, without problem. I can save and retrieve from the database without problem (programatically) But, when I want to browse the database with phpMYAdmin, the browse button is grayed out and when I move the cursor over it I get a red X displayed. I have use phpMyAdmin on (1) prior database I was designing, and did not have that problem.
2
3980
by: pfletch750 | last post by:
I am running Vista Ultimate on a Asus P5LD2 motherboard with a 2.8 GHz Intel D CPU, 3 GB of memory and lots of disk space. No problems with other applications or services. IIS 7.0 is installed and running, and I can browse to files in inetpub/wwwroot. I have just installed PHP 4.4.7 (this is for testing and the target server doesn't support 5.x) and the latest version of MySQL (5.0.37). Both seem to be working properly. Browsing a test file...
8
8903
by: Jonathan Sachs | last post by:
I just tried to install phpMyAdmin on my system, and I can't get it to work. When I tried to run the setup procedure (setup.php) I got the following message: Fatal error: session_start() : Failed to initialize storage module: user (path: C:\...\Temp\php\session) in D\...\phpMyAdmin\libraries\session.inc.php on line 86 I set up the config file by hand, then tried to run phpMyAdmin and got the same error.
0
9990
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9837
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
11250
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10939
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9655
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
8031
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7183
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
2
4292
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3299
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.