Datenbankfehler beim Löschen eines Accounts

StefS 2021-10-11 19:05:05 UTC #1

Ich versuche als Admin einen Nutzer aus dem System zu löschen, aber da gibt es nur einen Datenbankfehelr in Return und nichts passiert.

Angemeldet als Admin
Admin -> Benutzerkonten
Rechtsklick auf zu löschenden Account -> Löschen

“Datenbank Fehler
Invalid SQL: (SELECT ‘openid’ AS app,‘total’ AS type,count(egw_openid_clients.client_id) AS count FROM egw_openid_clients WHERE egw_openid_clients.client_creator=1)
UNION
(SELECT ‘importexport’ AS app,‘total’ AS type,count(egw_importexport_definitions.definition_id) AS count FROM egw_importexport_definitions WHERE egw_importexport_definitions.owner=1)
UNION
(SELECT ‘calendar’ AS app,‘total’ AS type,count(egw_cal.cal_id) AS count FROM egw_cal WHERE egw_cal.cal_owner=1)
UNION
(SELECT ‘addressbook’ AS app,‘total’ AS type,count(egw_addressbook.contact_id) AS count FROM egw_addressbook WHERE egw_addressbook.contact_owner=‘1’)
UNION
(SELECT ‘infolog’ AS app,info_type AS type,count(egw_infolog.info_id) AS count FROM egw_infolog WHERE egw_infolog.info_owner=1 GROUP BY info_type)
UNION
(SELECT ‘projectmanager’ AS app,‘total’ AS type,count(egw_pm_projects.pm_id) AS count FROM egw_pm_projects WHERE egw_pm_projects.pm_creator=1)
UNION
(SELECT ‘resources’ AS app,‘total’ AS type,count(egw_resources.res_id) AS count FROM egw_resources WHERE egw_resources.res_creator=1)
UNION
(SELECT ‘timesheet’ AS app,‘total’ AS type,count(egw_timesheet.ts_id) AS count FROM egw_timesheet WHERE egw_timesheet.ts_owner=1)
UNION
(SELECT ‘tracker’ AS app,‘total’ AS type,count(egw_tracker.tr_id) AS count FROM egw_tracker WHERE egw_tracker.tr_creator=1)
UNION
(SELECT ‘smallpart’ AS app,‘total’ AS type,count(egw_smallpart_courses.course_id) AS count FROM egw_smallpart_courses WHERE egw_smallpart_courses.course_owner=1)
UNION
(SELECT ‘bookmarks’ AS app,‘total’ AS type,count(egw_bookmarks.bm_id) AS count FROM egw_bookmarks WHERE egw_bookmarks.bm_owner=1)
Table ‘egw_ct.egw_smallpart_courses’ doesn’t exist (1146)”

Anmerkung - die Anwendung “smallparts” ist (wie ein paar andere auch) nicht installiert da sie nicht benötigt/genutzt wird (weniger Sachen eingerichtet = weniger potenzielle Fehlerquellen).
Das ging früher auch immer problemlos mit den verschiedenen Anwendungen, nur bei der Integration von Smallparts scheint hier nicht bedacht zu sein, das das jemand nicht nutzen will

Viele Grüße,
Stefan Seide

RalfBecker 2021-10-12 07:18:00 UTC #2

@ngegw can you please have a look. Looks like we don’t check the app is installed, before trying to query or delete the users entries.

Ralf

ngegw 2021-10-12 17:15:24 UTC #3

This is strange.
We are going through $GLOBALS[‘egw_info’][‘apps’], checking the Link registry, and the associated table definitions.

It looks like EGroupware thinks the app is installed, but the database does not have the tables.

I was able to get a situation where smallpart was in $GLOBALS[‘egw_info’][‘apps’] by uninstalling it while logged in, but it was no longer in the Link registry, and could not get the table definitions so it got left out.

I was able to reproduce this error by deleting the tables from the database while the app was still installed. In this case, the fix was to properly remove the app in /setup.

StefS 2021-10-12 18:06:16 UTC #4

The system was updated from older eroupware version (initial was a 19.1)
without small-parts support some time ago but never tried to delete user
since then. Just updated from version to version since then after new
ones were released.

And smallparts was never installed via application setup
(/egroupware/setup). It was in the state after egroupware was updated
from old version without smallparts to current version (with some minor
increments since them, but i am not sure if i updated to all versions in
between up to current one or missed some of them).

Tomorrow i will try to install and uninstall smallparts again and check
if user deletion works than.

Best regards,
Stefan Seide

StefanU 2021-10-14 07:24:25 UTC #5

Hi Stefan.

It is neither useful nor beneficial to uninstall an application that comes with EGroupware.
If you do not need an application, simply remove the execution rights (for the affected groups).

When I read up there: What kind of installation is this? Not a standard Docker installation, is it?
Or how did you manage that?:

Stefan U.

StefS 2021-10-14 08:29:44 UTC #6

Update - installed smallparts and uninstalled it afterwards via /egroupware/setup.
Now user can be deleted without error message.
Seems to be an problem related through having updated from version before smallparts to current version.

@StefanU
Standard-Installation auf Basis Eurer Debian-Pakete (welche intern ja Docker nutzen). Alle Updates sind mittels Eurer neuen Debian-Pakete erfolgt. Datenbank ist ein eigenes System (MariaDB) und NGinx davor (mit eurer NGinx-config)