Aktuelle Prüfung der Datenbankintegrität



  • Was ist hier das Problem?

    Auszug aus der "Über" Churchtools Seite

    Aktuelle Prüfung der Datenbankintegrität
    Es gibt Problem(e) betreffend Tabelle(n) cdb_gemeindeperson_gruppe_archive => cdb_gemeindeperson.
    Es gibt Problem(e) betreffend Tabelle(n) cdb_gruppentreffen => cdb_gruppe.

    SELECT gemeindeperson_id id FROM {cdb_gemeindeperson_gruppe_archive} WHERE gemeindeperson_id IS NOT NULL AND gemeindeperson_id NOT IN ( SELECT id FROM {cdb_gemeindeperson} )

    found dead constraint in cdb_gemeindeperson_gruppe_archive.gemeindeperson_id
    entry with id 636 referenzes non existing value in cdb_gemeindeperson.id
    found dead constraint in cdb_gemeindeperson_gruppe_archive.gemeindeperson_id
    entry with id 636 referenzes non existing value in cdb_gemeindeperson.id
    found dead constraint in cdb_gemeindeperson_gruppe_archive.gemeindeperson_id
    entry with id 1252 referenzes non existing value in cdb_gemeindeperson.id
    found dead constraint in cdb_gemeindeperson_gruppe_archive.gemeindeperson_id
    entry with id 1252 referenzes non existing value in cdb_gemeindeperson.id
    found dead constraint in cdb_gemeindeperson_gruppe_archive.gemeindeperson_id
    entry with id 1252 referenzes non existing value in cdb_gemeindeperson.id
    found dead constraint in cdb_gemeindeperson_gruppe_archive.gemeindeperson_id
    entry with id 1252 referenzes non existing value in cdb_gemeindeperson.id
    found dead constraint in cdb_gemeindeperson_gruppe_archive.gemeindeperson_id
    entry with id 1252 referenzes non existing value in cdb_gemeindeperson.id
    found dead constraint in cdb_gemeindeperson_gruppe_archive.gemeindeperson_id
    entry with id 1252 referenzes non existing value in cdb_gemeindeperson.id
    found dead constraint in cdb_gemeindeperson_gruppe_archive.gemeindeperson_id
    entry with id 1252 referenzes non existing value in cdb_gemeindeperson.id
    found dead constraint in cdb_gemeindeperson_gruppe_archive.gemeindeperson_id
    entry with id 1252 referenzes non existing value in cdb_gemeindeperson.id
    found dead constraint in cdb_gemeindeperson_gruppe_archive.gemeindeperson_id
    entry with id 1252 referenzes non existing value in cdb_gemeindeperson.id
    found dead constraint in cdb_gemeindeperson_gruppe_archive.gemeindeperson_id
    entry with id 1252 referenzes non existing value in cdb_gemeindeperson.id
    found dead constraint in cdb_gemeindeperson_gruppe_archive.gemeindeperson_id
    entry with id 1252 referenzes non existing value in cdb_gemeindeperson.id
    found dead constraint in cdb_gemeindeperson_gruppe_archive.gemeindeperson_id
    entry with id 1252 referenzes non existing value in cdb_gemeindeperson.id
    found dead constraint in cdb_gemeindeperson_gruppe_archive.gemeindeperson_id
    entry with id 1252 referenzes non existing value in cdb_gemeindeperson.id
    found dead constraint in cdb_gemeindeperson_gruppe_archive.gemeindeperson_id
    entry with id 1252 referenzes non existing value in cdb_gemeindeperson.id
    found dead constraint in cdb_gemeindeperson_gruppe_archive.gemeindeperson_id
    entry with id 1252 referenzes non existing value in cdb_gemeindeperson.id

    SELECT gruppe_id id FROM {cdb_gruppentreffen} WHERE gruppe_id IS NOT NULL AND gruppe_id NOT IN ( SELECT id FROM {cdb_gruppe} )
    found dead constraint in cdb_gruppentreffen.gruppe_id
    entry with id 44 referenzes non existing value in cdb_gruppe.id