mysql - 错误 : Unclosed quote @ 37

Question

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

此查询在本地主机上运行良好，

上传到服务器后出现问题

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 

请帮帮我，

谢谢

Answer 1

尝试更新 phpMyAdmin 版本，请参阅此链接:phpMyAdmin Bug