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.