All Triggers of this host

[sgoodliff]

Hello,

I'm running 1.1beta2 and think i've found the following problem.

When trying to add actions it works when I select "This Trigger Only" from the drop down but when I select "All Triggers of this host" I get the following error, which is a bit of a pain, when I've got a lot of systems to add.



SQL error: Column count doesn't match value count at row 1
Query: insert into actions (triggerid,userid,good,delay,nextcheck,subject,mes sage,scope,severity,recipientmaxrepeats,repeatdela y) values (10007,7,1,30,0,'*Automatically generated*','*Automatically generated*',1,0,1,0,600)


Any Suggestions ? Is this me doing something wrong or a bug with 1.1beta2, I know doing the same thing on 1.1alpha10 worked.

Cheers

Steve Goodliff

[elkor]

did you upgrade your database from alpha10 to beta2?

[sgoodliff]

I tried the upgrade path but it error'd, I should of kept the errors but didn't. So I copied the data from the old db and imported it into the beta2 one.

I also have a test zabbix set up with a just the beta2 database straight from the tarball and I added a host and tried to add some actions to that host and it came up with the same errors.

[sgoodliff]

Bug Fix

Hello,

The php in include/actions.inc.php has a typo in it.

The following SQL works better, the typo was that recipientmaxrepeats was one word.


$sql="insert into actions (triggerid,userid,good,delay,nextcheck,subject,mes sage,scope,severity,recipient,maxrepeats,repeatdel ay) values (".$row["hostid"].",$id,$good,$delay,0,'*Automatically generated*','*Automatically generated*',$scope,$severity,$recipient,$maxrepeat s,$repeatdelay)";