Raumliste wirft nur noch SQL Error

tim.becker

Hallo zusammen,

beim Aufruf der Räume erhalten wir nur noch einen SQL Error:

Database error : Query error: 'SELECT obj_main.isys_obj__id AS '__id__', obj_main.isys_obj__id 'isys_cmdb_dao_category_g_global__id', (CONCAT(obj_main.isys_obj__title, ' {', obj_main.isys_obj__id, '}') ) 'isys_cmdb_dao_category_g_global__title' , (SELECT CONCAT_WS(' > ', (SELECT CONCAT(isys_obj__title , ' {', isys_obj__id, '}') FROM isys_obj WHERE sub5.isys_catg_location_list__isys_obj__id = isys_obj__id),(SELECT CONCAT(isys_obj__title , ' {', isys_obj__id, '}') FROM isys_obj WHERE sub4.isys_catg_location_list__isys_obj__id = isys_obj__id),(SELECT CONCAT(isys_obj__title , ' {', isys_obj__id, '}') FROM isys_obj WHERE sub3.isys_catg_location_list__isys_obj__id = isys_obj__id),(SELECT CONCAT(isys_obj__title , ' {', isys_obj__id, '}') FROM isys_obj WHERE sub2.isys_catg_location_list__isys_obj__id = isys_obj__id),(SELECT CONCAT(isys_obj__title , ' {', isys_obj__id, '}') FROM isys_obj WHERE sub1.isys_catg_location_list__isys_obj__id = isys_obj__id)) AS title FROM isys_catg_location_list AS main LEFT JOIN isys_catg_location_list AS sub1 ON sub1.isys_catg_location_list__isys_obj__id = main.isys_catg_location_list__parentid LEFT JOIN isys_catg_location_list AS sub2 ON sub2.isys_catg_location_list__isys_obj__id = sub1.isys_catg_location_list__parentid LEFT JOIN isys_catg_location_list AS sub3 ON sub3.isys_catg_location_list__isys_obj__id = sub2.isys_catg_location_list__parentid LEFT JOIN isys_catg_location_list AS sub4 ON sub4.isys_catg_location_list__isys_obj__id = sub3.isys_catg_location_list__parentid LEFT JOIN isys_catg_location_list AS sub5 ON sub5.isys_catg_location_list__isys_obj__id = sub4.isys_catg_location_list__parentid LEFT JOIN isys_obj as objMain ON objMain.isys_obj__id = main.isys_catg_location_list__isys_obj__id WHERE main.isys_catg_location_list__isys_obj__id = obj_main.isys_obj__id AND main.isys_catg_location_list__status = 2 ) 'isys_cmdb_dao_category_g_location__location_path' , (CONCAT(DATE_FORMAT(obj_main.isys_obj__created, '%d.%m.%Y %H:%i:%s'), ' (' , obj_main.isys_obj__created_by, ')') ) 'isys_cmdb_dao_category_g_global__created' , (CONCAT(DATE_FORMAT(obj_main.isys_obj__updated, '%d.%m.%Y %H:%i:%s'), ' (' , obj_main.isys_obj__updated_by, ')') ) 'isys_cmdb_dao_category_g_global__changed' , (SELECT CONCAT("{#", isys_cmdb_status__color, "} ", isys_cmdb_status__title) FROM isys_cmdb_status WHERE obj_main.isys_obj__isys_cmdb_status__id = isys_cmdb_status__id AND isys_cmdb_status__status = 2 ) 'isys_cmdb_dao_category_g_global__cmdb_status' , (( SELECT min(IF(locate(chars.n, obj_main.isys_obj__title) = 0, LENGTH(obj_main.isys_obj__title), locate(chars.n, obj_main.isys_obj__title))) as position FROM (SELECT 0 as n UNION SELECT 1 as n UNION SELECT 2 as n UNION SELECT 3 as n UNION SELECT 4 as n UNION SELECT 5 as n UNION SELECT 6 as n UNION SELECT 7 as n UNION SELECT 8 as n UNION SELECT 9 as n) chars )) as `sorting_index` FROM isys_obj AS obj_main WHERE TRUE AND obj_main.isys_obj__isys_obj_type__id = 26 AND obj_main.isys_obj__status = 2 GROUP BY obj_main.isys_obj__id ': Subquery returns more than 1 row

Idoit Version: i-doit 1.18.2 PRO

Die Listenkonfiguration wurde bereits überschrieben und zurückgesetzt - hilft leider nicht.

Es ist weiterhin möglich Raumobjekte anzulegen und z.b. über die Standortbeziehung auch aufzurufen.

Was können wir tun?

Viele Grüße
Tim

Michael Huhn

Hallo @tim-becker,

anscheinend existieren hier mehrfache Einträge.
Bitte führe mal die beiden Operationen mit einem Admin Benutzer aus und schau mal ob es geholfen hat.

tim.becker

@Michael-Overkamp

Danke.

Ich sehe in der Tat, in dem übergeordneten Objekt > Räumlich zugeordnete Objekte doppelte Einträge, mit der selben ID:

Die Funktion findet Einträge, der Fehler besteht danach aber weiterhin. Die Anzahl der Raumeinträge ist auch gleichbleibend.

Deleting duplicate single-value categorie entries...
Deleting duplicate entries in global category "Standort"... Error!
Error!
[...]
Error!
(50) Duplicate single value entries found and deleted.
Removing duplicate category assignments...
Done!

tim.becker

Ich habe die Einträge nun manuell aus der Tabelle isys_catg_location_list entfernt. Nun lädt die Liste wieder.