Trace info for #145, #152, #155, #177, Users cannot be assigned to projects

[cfgardiner]

The bug reported e.g. in issues #145, #152, #155, #177, "Users cannot be assigned to projects" which is really a show stopper, still seems to be hanging in there.

The issue seems to start when creating a new project and would appear to be triggered by an issue with indices in the oc_timetracker_user_to_project table "an exception occurred while executing a query: SQLSTATE[23505]: Unique violation.7 ERROR: duplicate key value violates unique constraint". See line 336 in timetracker_err_make_project.txt.

Log file extract and sample tables are contained in the links below. Additional comments made under issue #177.

Repeated here for increased visibility.

timetracker_err_make_project.txt
timetracker_err_tables.txt

[cfgardiner]

I took the risk and updated all indices in the table oc_timetracker_user_to_project. Looks like something upset themat some stage. Creating a project now works. However, editing an existing project to add a user still doesn't.

As soon as I try to edit the project all assigned users, including the user who created the project, are deleted. The entry for the creating user is also removed from oc_timetracker_user_to_project. The record is dropped from the database.

Strangely, I can see the users being queried in the nextcloud log file but none appear in the "Edit Project" window, just the message "The results could not be loaded" as shown e.g. in #177