My PHPMyAdmin always warn me
A comma or a closing bracket was expected
when I try to use a function.
Although it displays warnings, the SQL statements can be successfully executed.
For example ,here's a piece of SQL code
INSERT INTO payments (`amount`,`alloted`, `dateadded`, `modified`, `userid`)
VALUES ( 100, DATE_ADD( NOW(), INTERVAL 6 MONTH),NOW(),NOW(),139107 )
When typing the function 'NOW()', the red underline comes up, it's really, REAAALYYY annoying
Same errors come up when typing all kinds of sql functions
I've tried re-installing phpmyadmin but it doesn't work at all. This bug only occurs when I'm using ubuntu on my web server, the warning messages never comes up when I debuggling on localhost.
here's the common error message.
Error
Static analysis:
4 errors were found during analysis.
A comma or a closing bracket was expected (near "(" at position 40)
Unexpected token. (near "'123'" at position 41)
Unexpected token. (near ")" at position 46)
Unexpected token. (near ")" at position 47)
SQL query:
INSERT INTO accounts(pw) VALUES(PASSWORD('123'))