Found database query error while purging server.

  • Hi,

    These are the steps I took.

    1. Create a server template.
    2. Create 2 objects from template.
    3. Archived the templates
    4. Deleted the templates
    5. Final step, purge the templates gives me the following error:

    isys_exception_database : Query error: 'DELETE FROM isys_obj WHERE isys_obj__id = '775'': Cannot delete or update a parent row: a foreign key constraint fails (idoit_data/isys_catg_file_list, CONSTRAINT isys_catg_file_list_ibfk_2 FOREIGN KEY (isys_catg_file_list__isys_obj__id) REFERENCES isys_obj (isys_obj__id) ON DELETE NO ACTION ON UPDATE)

    This happens on the page:


    My Idoit data:

    Operating System UNIX/Linux, Linux OK
    PHP Version 5.2.6-1+lenny9 (>5.2.3 recommended) OK
    i-doit Code Version 0.9.9-3
    i-doit Database Version 0.9.9-3 Revision 6172

Log in to reply

Datenschutz / Privacy Policy