I’m upgrading my zabbix to a clean install on a new Centos8.4 machine (MariaDB).
After import old sql,restart zabbix-server ,Web page can open but can’t login,watch zabbix log
tail -f /var/log/zabbix/zabbix_server.log
After import old sql,restart zabbix-server ,Web page can open but can’t login,watch zabbix log
tail -f /var/log/zabbix/zabbix_server.log
9332:20181010:174337.188 [Z3005] query failed: [1050] Table 'tag_filter' already exists [create table tag_filter ( `tag_filterid` bigint unsigned not null, `usrgrpid` bigint unsigned not null, `groupid` bigint unsigned not null, `tag` varchar(255) default '' not null, `value` varchar(255) default '' not null, primary key (tag_filterid)
Fix:
Login mysql
use zabbix; drop table tag_filter;
Similar Posts:
- mysql: [Err] 1075 – Incorrect table definition; there can be only one auto column and it must be d…
- MYSQL ERROR 1005 (HY000): Can’t create table [How to Solve]
- [Solved] MySQL query reports an error: Legal mix of settlements
- In Oracle, an error is reported: ora-00904
- MySQL timestamp set default value error Invalid default value reason and solution
- [Err] 1214 – The used table type doesn’t support FULLTEXT indexes
- [Solved] Mybatis multi-table query error: Column ‘id’ in field list is ambiguous
- When mysql creates a table, set timestamp DEFAULT NULL error 1067-Invalid default value for’updated_at’
- [Solved] MYSQL Error: BIGINT UNSIGNED value is out of range
- [Solved] MYSQL5.6 Error: ERROR 1709 (HY000): Index column size too large. The maximum column size is 767 bytes.