SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails

  • Hello


    thread counter update happening this




    Promlem ?


    fix


    Code
    1. SET GLOBAL FOREIGN_KEY_CHECKS=0;
  • This is no fix, this will break functionality of the software because it relies on working foreign keys. You need to add all foreign keys again and make sure that any operation that would have been done by working foreign keys is done manually before.


    That’s definitely a huge amount of work. The alternative would be to setup a second WoltLab Suite and use the import to transfer your data from the broken database to the new one – which should have working foreign keys.