i've compiled and installed netmrg correctly. but table creation makes a syntax error (one of the field name seems to be a reserved word in MySQL5) is there a workaround ? --> i don't want to downgrade my db!
CREATE TABLE conditions(
id int( 11 ) NOT NULL AUTO_INCREMENT ,
event_id int( 11 ) NOT NULL default '0',
value bigint( 20 ) NOT NULL default '0',
condition smallint( 6 ) NOT NULL default '0',
logic_condition smallint( 6 ) NOT NULL default '0',
value_type smallint( 6 ) NOT NULL default '0',
PRIMARY KEY ( id ) ,
KEY event_id( event_id )
) TYPE = MYISAM ;
MySQL said Documentation
#1064 - 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 '"condition" smallint(6) NOT NULL default '0',
logic_condition smallint(6) NOT' at line 5
i've found a workaround
in the file "share/netmrg.mysql", you have to add
and then, add quotes to
"condition" smallint(6) NOT NULL default '0',
You can also put backticks around the table name (`condition`).
I'm afraid it might become a problem in the gatherer and php scripts also; you might want to go through those and do the same thing (I recommend the backticks).
You might also want to report this as a bug in our bugs database http//bugs.netmrg.net
Thanks for this fix, I had been struggling to figure this out for a day now and I am no MySQL expert.