Nagios Support Forum

I have a contact group that I'm trying to modify. This group has only one account. I'm trying to remove the existing user and add two more and I keep getting the syntax error below. I've tried removing the only user, then tried adding the other 2 users...everything I try gives me the same error:

Error while inserting data into the database:
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 'Group', `active`='1', `config_id`=1, `last_modified`=NOW(), `members`=1' at line 1

Can you show the queries you were running? Also it is highly suggested to do this via CCM instead of raw queries.

Yes sir, I was using CCM to make the changes. That error message above is what I got. Of course, I'm a couple version behind (nagios XI2012R1.2; CCM 1.02).

Ah sorry, I figured from the error that it was a raw query. I'm going to have to do a 2012r1.2 install to test. I know it works now, but I dont know at what point it would have been patched. Obviously the quickest fix I would suggest is updating at least to the newest 2012 version of r2.8, but understandable if that might not be possible.

Actually, I'm trying to get this system ready to upgrade to the latest version, but I was trying to fix the existing errors first. I'm sure I'll have another post on upgrading later. But thanks for looking into it.

What condition are your db tables in?

I ended up deleting this contactgroup via CCM and re-creating it. This resolved my issue.