Error when deleting Accounts

Hello, when I delete account I have this error in System Log

I’m using PHP 7.0 version

Sat Oct  7 14:28:43 2017 [10814][1][FATAL]  Query Failed: SELECT id FROM accountkpis WHERE accountkpis.account_id = '1292b97d-5b2d-e59b-8175-59d8aca153aa' AND accountkpis.deleted=0: MySQL error 1146: Table 'admin_PHgceiGLrf.accountkpis' doesn't exist
Sat Oct  7 14:28:43 2017 [10814][1][FATAL]  Query Failed: SELECT id FROM accountkpis WHERE accountkpis.account_id = '1bd51a98-fe4f-5624-fc24-59d8ac259158' AND accountkpis.deleted=0: MySQL error 1146: Table 'admin_PHgceiGLrf.accountkpis' doesn't exist
Sat Oct  7 14:28:43 2017 [10814][1][FATAL]  Query Failed: SELECT id FROM accountkpis WHERE accountkpis.account_id = '25551b2d-5797-6b55-cf09-59d8ac1dc63d' AND accountkpis.deleted=0: MySQL error 1146: Table 'admin_PHgceiGLrf.accountkpis' doesn't exist
Sat Oct  7 14:28:43 2017 [10814][1][FATAL]  Query Failed: SELECT id FROM accountkpis WHERE accountkpis.account_id = '2c6f9210-c23b-ad8c-e38b-59d8ac4a276d' AND accountkpis.deleted=0: MySQL error 1146: Table 'admin_PHgceiGLrf.accountkpis' doesn't exist
Sat Oct  7 14:28:43 2017 [10814][1][FATAL]  Query Failed: SELECT id FROM accountkpis WHERE accountkpis.account_id = '2f6106bc-c920-a6b8-9b60-59d8aced28cb' AND accountkpis.deleted=0: MySQL error 1146: Table 'admin_PHgceiGLrf.accountkpis' doesn't exist
Sat Oct  7 14:28:43 2017 [10814][1][FATAL]  Query Failed: SELECT id FROM accountkpis WHERE accountkpis.account_id = '36a7e95c-5fa6-2212-82fd-59d8ac7c01b3' AND accountkpis.deleted=0: MySQL error 1146: Table 'admin_PHgceiGLrf.accountkpis' doesn't exist
Sat Oct  7 14:28:43 2017 [10814][1][FATAL]  Query Failed: SELECT id FROM accountkpis WHERE accountkpis.account_id = '39010a27-43be-a1e3-ecf4-59d8ac23fc40' AND accountkpis.deleted=0: MySQL error 1146: Table 'admin_PHgceiGLrf.accountkpis' doesn't exist
Sat Oct  7 14:28:44 2017 [10814][1][FATAL]  Query Failed: SELECT id FROM accountkpis WHERE accountkpis.account_id = '40d95742-f31c-012a-98a1-59d8ac1bb9fe' AND accountkpis.deleted=0: MySQL error 1146: Table 'admin_PHgceiGLrf.accountkpis' doesn't exist
Sat Oct  7 14:28:44 2017 [10814][1][FATAL]  Query Failed: SELECT id FROM accountkpis WHERE accountkpis.account_id = '4a73363b-c90a-c34a-f626-59d8acbca804' AND accountkpis.deleted=0: MySQL error 1146: Table 'admin_PHgceiGLrf.accountkpis' doesn't exist
Sat Oct  7 14:28:44 2017 [10814][1][FATAL]  Query Failed: SELECT id FROM accountkpis WHERE accountkpis.account_id = '532311aa-9d48-96cd-9fd6-59d8ac75b00a' AND accountkpis.deleted=0: MySQL error 1146: Table 'admin_PHgceiGLrf.accountkpis' doesn't exist
Sat Oct  7 14:28:44 2017 [10814][1][FATAL]  Query Failed: SELECT id FROM accountkpis WHERE accountkpis.account_id = '5d15af9e-9b94-da26-1a3a-59d8ac8ee8a6' AND accountkpis.deleted=0: MySQL error 1146: Table 'admin_PHgceiGLrf.accountkpis' doesn't exist
Sat Oct  7 14:28:44 2017 [10814][1][FATAL]  Query Failed: SELECT id FROM accountkpis WHERE accountkpis.account_id = '681267c6-d52e-0f8a-846c-59d8ac6c28f1' AND accountkpis.deleted=0: MySQL error 1146: Table 'admin_PHgceiGLrf.accountkpis' doesn't exist
Sat Oct  7 14:28:44 2017 [10814][1][FATAL]  Query Failed: SELECT id FROM accountkpis WHERE accountkpis.account_id = '714670a7-15fb-dc39-d660-59d8ac6920f8' AND accountkpis.deleted=0: MySQL error 1146: Table 'admin_PHgceiGLrf.accountkpis' doesn't exist
Sat Oct  7 14:28:44 2017 [10814][1][FATAL]  Query Failed: SELECT id FROM accountkpis WHERE accountkpis.account_id = '79d3b432-bd2f-2c5b-1233-59d8ac6ddc5a' AND accountkpis.deleted=0: MySQL error 1146: Table 'admin_PHgceiGLrf.accountkpis' doesn't exist
Sat Oct  7 14:28:44 2017 [10814][1][FATAL]  Query Failed: SELECT id FROM accountkpis WHERE accountkpis.account_id = '82dedc5a-8a2e-58f3-79d1-59d8ac74bab9' AND accountkpis.deleted=0: MySQL error 1146: Table 'admin_PHgceiGLrf.accountkpis' doesn't exist
Sat Oct  7 14:28:44 2017 [10814][1][FATAL]  Query Failed: SELECT id FROM accountkpis WHERE accountkpis.account_id = '86d30467-88f2-e04e-d3f8-59d8acd4e623' AND accountkpis.deleted=0: MySQL error 1146: Table 'admin_PHgceiGLrf.accountkpis' doesn't exist
Sat Oct  7 14:28:44 2017 [10814][1][FATAL]  Query Failed: SELECT id FROM accountkpis WHERE accountkpis.account_id = '8c00c189-69e5-2091-bcba-59d8ac9efac4' AND accountkpis.deleted=0: MySQL error 1146: Table 'admin_PHgceiGLrf.accountkpis' doesn't exist
Sat Oct  7 14:28:44 2017 [10814][1][FATAL]  Query Failed: SELECT id FROM accountkpis WHERE accountkpis.account_id = '96ecd6b8-bfde-9399-cc9c-59d8ac9db0ad' AND accountkpis.deleted=0: MySQL error 1146: Table 'admin_PHgceiGLrf.accountkpis' doesn't exist
Sat Oct  7 14:28:44 2017 [10814][1][FATAL]  Query Failed: SELECT id FROM accountkpis WHERE accountkpis.account_id = 'a16904bd-392e-faca-e37d-59d8ac21fac4' AND accountkpis.deleted=0: MySQL error 1146: Table 'admin_PHgceiGLrf.accountkpis' doesn't exist
Sat Oct  7 14:28:44 2017 [10814][1][FATAL]  Query Failed: SELECT id FROM accountkpis WHERE accountkpis.account_id = 'aa7737b6-b1f2-c928-2df3-59d8ac7b9a66' AND accountkpis.deleted=0: MySQL error 1146: Table 'admin_PHgceiGLrf.accountkpis' doesn't exist
Sat Oct  7 14:28:44 2017 [10814][1][FATAL]  Query Failed: SELECT id FROM accountkpis WHERE accountkpis.account_id = 'b2de8b13-bad4-694e-c1b8-59d8acd3affa' AND accountkpis.deleted=0: MySQL error 1146: Table 'admin_PHgceiGLrf.accountkpis' doesn't exist
Sat Oct  7 14:28:44 2017 [10814][1][FATAL]  Query Failed: SELECT id FROM accountkpis WHERE accountkpis.account_id = 'bba92e5f-35db-2ccf-85d0-59d8aca486b0' AND accountkpis.deleted=0: MySQL error 1146: Table 'admin_PHgceiGLrf.accountkpis' doesn't exist
Sat Oct  7 14:28:44 2017 [10814][1][FATAL]  Query Failed: SELECT id FROM accountkpis WHERE accountkpis.account_id = 'c4b536e7-bb09-3c13-ead0-59d8acaa24ad' AND accountkpis.deleted=0: MySQL error 1146: Table 'admin_PHgceiGLrf.accountkpis' doesn't exist
Sat Oct  7 14:28:44 2017 [10814][1][FATAL]  Query Failed: SELECT id FROM accountkpis WHERE accountkpis.account_id = 'cdfb0171-1027-4410-9654-59d8ac0a5b2e' AND accountkpis.deleted=0: MySQL error 1146: Table 'admin_PHgceiGLrf.accountkpis' doesn't exist
Sat Oct  7 14:28:44 2017 [10814][1][FATAL]  Query Failed: SELECT id FROM accountkpis WHERE accountkpis.account_id = 'd74b4db5-bd9d-4369-7049-59d8acd76eb2' AND accountkpis.deleted=0: MySQL error 1146: Table 'admin_PHgceiGLrf.accountkpis' doesn't exist
Sat Oct  7 14:28:44 2017 [10814][1][FATAL]  Query Failed: SELECT id FROM accountkpis WHERE accountkpis.account_id = 'dfae62fd-2e6a-13c4-90f8-59d8ac936212' AND accountkpis.deleted=0: MySQL error 1146: Table 'admin_PHgceiGLrf.accountkpis' doesn't exist
Sat Oct  7 14:28:44 2017 [10814][1][FATAL]  Query Failed: SELECT id FROM accountkpis WHERE accountkpis.account_id = 'e8accc85-3a64-5000-2f6c-59d8ac37e495' AND accountkpis.deleted=0: MySQL error 1146: Table 'admin_PHgceiGLrf.accountkpis' doesn't exist
Sat Oct  7 14:28:44 2017 [10814][1][FATAL]  Query Failed: SELECT id FROM accountkpis WHERE accountkpis.account_id = 'f1a4435e-d8c9-7936-75f4-59d8ac54e083' AND accountkpis.deleted=0: MySQL error 1146: Table 'admin_PHgceiGLrf.accountkpis' doesn't exist

Hello Nevals,

thank you for your report, I could fix this bug and pushed it to the repository.
Just pull the latest version or update this 3 files:
/include/language/de_DE.lang.php
/include/language/en_us.lang.php
/include/modules.php

After that, please go to Admin->Repair->Quick Repair and Rebuild:
/index.php?module=Administration&action=repair

1 Like