CODEWITHSUNDEEP
mysql
Naveen D Almeida
Naveen D Almeida

Reputation: 877

ERROR: Unclosed quote @ 37

Query SELECT * FROM user WHERE username = 'Omnion' AND disable_flag = '0'

this Query working fine in the Localhost,

after uploaded into server, it gives the problem

Error
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

    ERROR: Unclosed quote @ 37
    STR: '
    SQL: SELECT * FROM user WHERE username = \'Omnion\' AND disable_flag = \'0\'
     LIMIT 0, 30 

    SQL query: 

    SELECT * FROM user WHERE username = \'Omnion\' AND disable_flag = \'0\' LIMIT 0, 30

    MySQL said: 

    #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 '\'Omnion\' AND disable_flag = \'0\'
    LIMIT 0, 30' at line 1

Step 1 Step 2

Please help me,

Thank you

Upvotes: 2

Views: 2399

Answers (2)

Guest
Guest

Reputation: 11

I was having the same problem. Whenever I issued a SQL command that contained a quote in it, it was giving me "ERROR: Unclosed quote". My phpMyAdmin version is 2.11.9.6 and the MySQL version is 5.1.55. After much frustration and research and I resolved it as follows:

The error was occurring only if I use the phpMyAdmin using the link provided on my Yahoo MySQL database panel. I found out that I can access the phpMyAdmin administration tool directly without going through the link provided on the Yahoo Web Hosting MySQL database panel. To go directly to phpMyAdmin, www.yourdomain.com/phpmyadmin

It will open up the administration panel that looks similar to the one opened up from the Yahoo MySQL database panel. You log in using the same MySQL database user id and password. The SQL commands work perfectly fine from this panel.

Note: If you do not have the www.yourdomain.com/phpmyadmin sub directory, you may have to install the phpMyAdmin tool by going to the Web Hosting Control Panel/Other Site Building Tools, etc...

Upvotes: 0

abc
abc

Reputation: 157

Try to update version of phpMyAdmin, see this link: phpMyAdmin Bug

Upvotes: 2

Related Questions