MySql Issues
I am getting this error as of tonight and I cannot seem to figure out what it means.
Exception occured while forming SQL to get Total Count; nested exception is: java.sql.SQLException: Syntax error or access violation, message from server: "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 'WHERE Alert.ID >0' at line 1"
I just edited the database config file to use my own instance of mySql which is 4.12 and on port 3306. Please let me know what I need to do to resolve this. Thanks
Exception occured while forming SQL to get Total Count; nested exception is: java.sql.SQLException: Syntax error or access violation, message from server: "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 'WHERE Alert.ID >0' at line 1"
I just edited the database config file to use my own instance of mySql which is 4.12 and on port 3306. Please let me know what I need to do to resolve this. Thanks