Error in query

[SarkyStu]

Hi,

Newbie to Zabbix, so please be kind!

I've installed an instance and upgraded so currently running Zabbix 6.4.20 with Mysql ver 8.0.40 on Linux (oracle 9.5).

I have exported out templates, hosts, etc, from a previous Zabbix install and imported successfully into the new environment.

However, the "Problems" on the dashboard view and under Monitoring gives an "Error in Query" error at the top of the window.

Error in query [SELECT t.acknowledgeid,t.userid,t.eventid,t.clock,t.messa ge,t.action,t.old_severity,t.new_severity,t.suppre ss_until,t.taskid FROM acknowledges t WHERE t.eventid IN (53,84)] [Unknown column 't.suppress_until' in 'field list'] [zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → Widgets\Problems\Actions\WidgetView->doAction() → CScreenProblem::makeData() → CScreenProblem::getExDataProblems() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CProblem->get() → CProblem->addRelatedObjects() → CApiService->select() → DBselect() → trigger_error() in include/db.inc.php:248]

It won't allow for Acknowledging or Suppressing the problems.

Any ideas as to how to rectify this issue please?

[cyber]

Unknown column 't.suppress_until' in 'field list'

Something is not right with your DB schema, missing columns... As you say you upgraded, did everything go well with that? Too many possibilities here to suggest looking to this or that place..