Details

    • High
    • GroupShare synchronisation was not working any more if some TMs have to be deleted.

    Description

      problem

      Using GroupShare TM synchronisation is not working due the error:

      Zend_Db_Statement_Exception: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`
      DB1001`.`LEK_languageresources_customerassoc`, CONSTRAINT `fk_LEK_languageresources_customerassoc_languageresources` FOREIGN KEY (`languageResourceId`) REFERENCES `LEK_
      languageresources` (`id), query was: DELETE FROM `LEK_languageresources` WHERE (`LEK_languageresources`.`id` = 2098) 

      Reason is, that the DB DELETE constraint was replace with a RESTRICT constraint.

      solution

      Delete the customer associations manually.
       
       
       

       
       
       
       

       

      Attachments

        Issue Links

          Activity

            People

              aleksandar Aleksandar Mitrev
              tlauria Thomas Lauria
              Sanya Mikhliaiev
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: