Syntax error or access violation, message from server
Hi,
Have downloaded and installed version 6005 of opmanager last week. I was adding a url monitor when the following error appeared :
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 's 834DG Router_URL_Poll','10.0.0.252_Poll') ORDER BY Alert.MODT"; 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 's 834DG Router_URL_Poll','10.0.0.252_Poll') ORDER BY Alert.MODT"
I get this error everytime i attempt to open the alarm page. I have shut the system down & done a repairdb.bat. Can not clear message & therefore can not see alarms !
I was trying to monitor the web interface of Alan's router. (as it seems to stop functioning intermitantly). If i going admin -> Url monitoring. The monitor called "Alan's 834DG Router" is present. I can edit it, but can not delete it. (If i could delete it, would the problem go away).
The problem isn't something simple like the use of " ' " in "Alan's" is it.
Any help would be appreciated, as without alarms working, i might have to reinstall. This installation is on a 2003 Web Server SP1.
Have downloaded and installed version 6005 of opmanager last week. I was adding a url monitor when the following error appeared :
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 's 834DG Router_URL_Poll','10.0.0.252_Poll') ORDER BY Alert.MODT"; 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 's 834DG Router_URL_Poll','10.0.0.252_Poll') ORDER BY Alert.MODT"
I get this error everytime i attempt to open the alarm page. I have shut the system down & done a repairdb.bat. Can not clear message & therefore can not see alarms !
I was trying to monitor the web interface of Alan's router. (as it seems to stop functioning intermitantly). If i going admin -> Url monitoring. The monitor called "Alan's 834DG Router" is present. I can edit it, but can not delete it. (If i could delete it, would the problem go away).
The problem isn't something simple like the use of " ' " in "Alan's" is it.
Any help would be appreciated, as without alarms working, i might have to reinstall. This installation is on a 2003 Web Server SP1.