Hi,
While trying to find out why the “anonymous” user does not work correctly, I tried deleting it through the interface prior to re-enabling the collabora app.
When deleting it through the admin-interface, I get the following SQL-error (NOTE: I use Postgresql):
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=1005)
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=1005)
UNION
(SELECT ‘calendar’ AS app,“total” AS type,count(egw_cal.cal_id) AS count FROM egw_cal WHERE egw_cal.cal_owner=1005)
UNION
(SELECT ‘addressbook’ AS app,“total” AS type,count(egw_addressbook.contact_id) AS count FROM egw_addressbook WHERE egw_addressbook.contact_owner=‘1005’)
UNION
(SELECT ‘infolog’ AS app,info_type AS type,count(egw_infolog.info_id) AS count FROM egw_infolog WHERE egw_infolog.info_owner=1005 GROUP BY info_type)
UNION
(SELECT ‘resources’ AS app,“total” AS type,count(egw_resources.res_id) AS count FROM egw_resources WHERE egw_resources.res_creator=1005)
UNION
(SELECT ‘timesheet’ AS app,“total” AS type,count(egw_timesheet.ts_id) AS count FROM egw_timesheet WHERE egw_timesheet.ts_owner=1005)
UNION
(SELECT ‘tracker’ AS app,“total” AS type,count(egw_tracker.tr_id) AS count FROM egw_tracker WHERE egw_tracker.tr_creator=1005)
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=1005)
UNION
(SELECT ‘bookmarks’ AS app,“total” AS type,count(egw_bookmarks.bm_id) AS count FROM egw_bookmarks WHERE egw_bookmarks.bm_owner=1005)
ERROR: column “total” does not exist
LINE 1: (SELECT ‘openid’ AS app,“total” AS type,count(egw_openid_cli…
There are double quotes ( " ) around the word , and single quotes ( ’ ) around the app-names.
–
Joost
