05-27-2020, 07:28 AM
I try to migrate the pandora db version 6.0 to version 7.0. But I got an error " ERROR 1054 (42S22) at line 145: Unknown column 'ip_target' in 'tpolicy_modules' ", I'm using pandora FMS 7 ubuntu 18.04
>>mysql --version
mysql Ver 14.14 Distrib 5.7.30, for Linux (x86_64) using EditLine wrapper
ERROR 1101 (42000): BLOB, TEXT, GEOMETRY or JSON column 'unit' can't have a default value
ALTER TABLE tpolicy_modules ADD COLUMN `ip_target`varchar(100) default '';
ALTER TABLE tpolicy_modules ADD COLUMN `dynamic_next` bigint(20) NOT NULL default '0';
ERROR 1060 (42S21): Duplicate column name 'dynamic_next'
(c) 2006-2018 Artica Soluciones Tecnológicas. Contents of this wiki are under Create Common Attribution v3 licence. | pandorafms.com | pandorafms.org