Hello,
I'm using Zabbix 7.0 Beta 3. I use my database server externally. I am getting errors in the interface stating that some tables are missing in the database. Is there a command to repair the database?
I'm using Zabbix 7.0 Beta 3. I use my database server externally. I am getting errors in the interface stating that some tables are missing in the database. Is there a command to repair the database?
- Error in query [SELECT i.itemid,i.name,i.lifetime_type,i.enabled_lifetime _type FROM items i WHERE i.flags=1 AND 1=0] [Unknown column 'i.lifetime_type' in 'field list'] [zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostList->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CDiscoveryRule->get() → DBselect() → trigger_error() in include/db.inc.php:248]
- Error in query [SELECT t.hostid,t.parent_hostid,t.status,t.ts_delete,t.ts _disable,t.disable_source FROM host_discovery t WHERE t.hostid IN (10084,10614,10621,10622,10623,10624,10625,10626,1 0627,10628,10629,10630,10631,10632,10633,10634,106 35,10636,10637,10638,10639,10640,10641,10642,10643 ,10644,10645,10646,10647,10648,10649,10650,10651,1 0652,10653,10654,10655,10656,10657,10658,10659,106 60,10661,10662,10663,10664,10665,10666,10667,10967 )] [Unknown column 't.status' in 'field list'] [zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerHostList->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CApiService->select() → DBselect() → trigger_error() in include/db.inc.php:248]