Hello everyone. I am experiencing issues with installing the latest version of 21.04 GVM today. Before I had no issues running my script but now I am experiencing this new error after I install postgres
and continue setting my gmvd
:
(gvmd:30504): md manage-WARNING **: 15:35:15.381: sql_exec_internal: PQexec failed: ERROR: relation "nvt_preferences" does not exist
Which continues towards these issues:
> (gvmd:30504): md manage-WARNING **: 15:35:15.382: sql_exec_internal: SQL: CREATE OR REPLACE FUNCTION vts_verification_str () RETURNS text AS $$ WITH pref_str AS ( SELECT name, substring(name, '^(.*?):') AS oid, substring (name, '^.*?:([^:]+):') AS pref_id, (substring (name, '^.*?:([^:]+):') || substring (name, '^[^:]*:[^:]*:[^:]*:(.*)') || value) AS pref FROM nvt_preferences ), nvt_str AS ( SELECT (SELECT nvts.oid || max(modification_time) || coalesce (string_agg(pref_str.pref, '' ORDER BY (pref_id COLLATE "C.UTF-8")), '')) AS vt_string FROM nvts LEFT JOIN pref_str ON nvts.oid = pref_str.oid GROUP BY nvts.oid ORDER BY (nvts.oid COLLATE "C.UTF-8") ASC ) SELECT coalesce (string_agg (nvt_str.vt_string, ''), '') FROM nvt_str$$ LANGUAGE SQL STABLE;
I would appreciate any help.