Site

Erreur SQL: [AdoDatabase.executeCommand] : [MySQL][ODBC 5.1 Driver][mysqld-5.0.45-community-nt]Duplicate entry '527-ocsVisibility' for key 1 : INSERT INTO xrm_object_mask (object_oid, verb, iso_sid, m0) SELECT IsoT0.`_oid` AS IsoF0, 'ocsVisibility' AS IsoF1, 'site' AS IsoF2, IF((SUM(IsoT4.m0) IS NULL ),0,SUM(IsoT4.m0)) AS IsoF3 FROM (ocsNewsEvent_card AS IsoT0 LEFT JOIN ocs_card_ocsVisibility AS IsoT2 On ((IsoT0.`_oid` = IsoT2.`_from`) AND (IsoT2.iso_sid <> ''))) LEFT JOIN xrm_category_mask AS IsoT4 On (IsoT2.`_to` = IsoT4.oid) GROUP BY IsoT0.`_oid` INSERT INTO xrm_object_mask (object_oid, verb, iso_sid, m0) SELECT IsoT0.`_oid` AS IsoF0, 'ocsVisibility' AS IsoF1, 'site' AS IsoF2, IF((SUM(IsoT4.m0) IS NULL ),0,SUM(IsoT4.m0)) AS IsoF3 FROM (ocsNewsEvent_card AS IsoT0 LEFT JOIN ocs_card_ocsVisibility AS IsoT2 On ((IsoT0.`_oid` = IsoT2.`_from`) AND (IsoT2.iso_sid <> ''))) LEFT JOIN xrm_category_mask AS IsoT4 On (IsoT2.`_to` = IsoT4.oid) GROUP BY IsoT0.`_oid` INSERT INTO xrm_object_mask (object_oid, verb, iso_sid, m0) SELECT IsoT0.`_oid` AS IsoF0, 'ocsVisibility' AS IsoF1, 'site' AS IsoF2, IF((SUM(IsoT4.m0) IS NULL ),0,SUM(IsoT4.m0)) AS IsoF3 FROM (ocsNewsEvent_card AS IsoT0 LEFT JOIN ocs_card_ocsVisibility AS IsoT2 On ((IsoT0.`_oid` = IsoT2.`_from`) AND (IsoT2.iso_sid <> ''))) LEFT JOIN xrm_category_mask AS IsoT4 On (IsoT2.`_to` = IsoT4.oid) GROUP BY IsoT0.`_oid`