SQL error modifying Contact Group

[luniversity]

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

[sreinhardt]

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

[luniversity]

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).

[sreinhardt]

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.

[luniversity]

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.

[abrist]

What condition are your db tables in?

Code: Select all

tail -50 /var/log/mysqld.log

[luniversity]

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