If I try to edit a cloned scan configuration, i.e. “full and fast”, this fails with the sql error in the log:
-> 1: Create the clone:
event config:MESSAGE:2026-02-25 06h17.44 utc:105: Scan config Full and fast Clone 1 (42824512-ba79-46e7-b761-f0796c464778) has been created by admin
-> 2: Try to edit the clone:
2026-02-25 06:17:47.368 UTC [174] gvmd@gvmd ERROR: ORDER BY “name” is ambiguous at character 1677
md manage:WARNING:2026-02-25 06h17.47 utc:115: sql_exec_internal: PQexec failed: ERROR: ORDER BY “name” is ambiguous
LINE 1: …ND nvts.oid = nvt_selectors.family_or_nvt ORDER BY name ASC;
^
md manage:WARNING:2026-02-25 06h17.47 utc:115: sql_exec_internal: SQL: SELECT id, uuid, name, comment, creation_time, modification_time, creation_time AS created, modification_time AS modified, ‘’ AS _owner, 0, oid, modification_time AS version, name, cve, tag, category, family, cvss_base, cvss_base AS severity, cvss_base AS cvss, qod, qod_type, solution_type, tag AS script_tags, solution, summary, insight, affected, impact, detection, solution_method, coalesce (epss_score, 0.0) AS epss_score, coalesce (epss_percentile, 0.0) AS epss_percentile, epss_cve, epss_severity, coalesce (max_epss_score, 0.0) AS max_epss_score, coalesce (max_epss_percentile, 0.0) AS max_epss_percentile, max_epss_cve, max_epss_severity, discovery FROM nvts WHERE family = ‘Settings’ EXCEPT SELECT nvts.id, nvts.uuid, nvts.name, nvts.comment, nvts.creation_time, nvts.modification_time, nvts.creation_time AS created, nvts.modification_time AS modified, ‘’ AS _owner, 0, oid, modification_time AS version, nvts.name, cve, tag, category, nvts.family, cvss_base, cvss_base AS severity, cvss_base AS cvss, qod, qod_type, solution_type, tag AS script_tags, solution, summary, insight, affected, impact, detection, solution_method, coalesce (epss_score, 0.0) AS epss_score, coalesce (epss_percentile, 0.0) AS epss_percentile, epss_cve, epss_severity, coalesce (max_epss_score, 0.0) AS max_epss_score, coalesce (max_epss_percentile, 0.0) AS max_epss_percentile, max_epss_cve, max_epss_severity, discovery FROM nvt_selectors, nvts WHERE nvts.family = ‘Settings’ AND nvt_selectors.name = ‘82f79a36-27db-4d74-9c25-5633cbf7d895’ AND nvt_selectors.family = ‘Settings’ AND nvt_selectors.type = 2 AND nvt_selectors.exclude = 1 AND nvts.oid = nvt_selectors.family_or_nvt ORDER BY name ASC;
md manage:WARNING:2026-02-25 06h17.47 utc:115: next: sql_exec_internal failed
I use the latest community edition docker-compose.yaml setup.
Regards
Mike