Cacti / plugin_syslog

Syslog Plugin for Cacti
GNU General Public License v2.0
21 stars 16 forks source link

setup.php does not create hash columns required. #64

Closed jdcoats closed 5 years ago

jdcoats commented 5 years ago

I had to manually create the columns after upgrade so I could edit alert rules.

ALTER TABLE syslog_alert ADD hash VARCHAR(32) NULL AFTER id; ALTER TABLE syslog_remove ADD hash VARCHAR(32) NULL AFTER id; ALTER TABLE syslog_reports ADD hash VARCHAR(32) NULL AFTER id;

cigamit commented 5 years ago

Wrong syntax Dan

ALTER TABLE syslog_alert ADD COLUMN hash VARCHAR(32) NOT NULL default '' AFTER id; ...

jdcoats commented 5 years ago

I did go back and change that after looking at the setup.php, thanks for confirming

—— Dan

cigamit commented 5 years ago

Going to go ahead and close this one.