[URGENT] User still cannot be assigned to projects

[Elliot-Construct]

I have had a quick little look at the projects.js and I cannot find the issue with the user search function. It seems to be a pretty urgent error that needs fixing urgently.

I am also unable to assign a project (Locked OR Unlocked)

[Elliot-Construct]

Duplicate of #146

[Elliot-Construct]

Duplicate of #152

This is not a unique unquantifiable problem. It's urgent and a lot of people must be affected.

FYI I am using a reverse proxy and I am on a subdomain.

[mtierltd]

Please upload your nextcloud logfile from the time when the error occurs.

[Elliot-Construct]

There is no nextcloud log entry associated with the incomplete action(s) on any level (Debug included)

[Elliot-Construct]

Here is chrome's console log: portal.constructmediagroup.com-1653384992900.log

[mtierltd]

Please also provide the http server configuration block for your nextcloud installation.

[Elliot-Construct]

portal.constructmediagroup.com.conf.txt

Will replace with dummy data later for users who might benefit from this.

[Elliot-Construct]

Also I use a squid reverse proxy on pfsense CE to actually serve the website.

It's on a different virtual machine on the same network

[Elliot-Construct]

I manually added my user to the project and now I am able to assign different time recordings to projects. But when I try and get a timeline of work it is just showing '*' for the name of each work item.

It's the same in the Reports section

[daxid]

We are also suffering this issue. It seems to me that it started right after the upgrade to Nextcloud 23.

@Elliot-Construct what version of NC are you running ?

@mtierltd do you think it is plausible ? If so we can run tests to confirm and/or help in any other way to see this resolved. (btw thanks for the app, it gets the job done event with the rough edges :-)

[cfgardiner]

We are also suffering this issue. It seems to me that it started right after the upgrade to Nextcloud 23.

@Elliot-Construct what version of NC are you running ?

@mtierltd do you think it is plausible ? If so we can run tests to confirm and/or help in any other way to see this resolved. (btw thanks for the app, it gets the job done event with the rough edges :-)

Unfortunately not. I just upgraded from 20.something_or_other to latest, largely because of this extremely annoying issue. If there was any "featured" alternative, I wouldn't touch Timetracker. This bug has been going on for so long. Obviously not properly tested. I've also just upgraded SuSE to Leap 15.3 to get latest php and so on. Didn't help either.

Wondering is it because my nextcloud is running one level below server root? /srv/www/htdocs/nextcloud

It's a real PITA to have to manually modify the postgres DB every time just to be able to log hours on a new project.

[cfgardiner]

Just my observation on this extremely annoying bug. If I hadn't figured out how to update the postgres database manually this would be a show stopper. Going to the 'Users' field always says "The results could not be loaded", as documented at least twice above. So where does this tool search for users? Is there something broken there? I have 61 users on my nextcloud so the tool is obviously not querying the users or not reading the returned list correctly. In fact if I add a user manually through the database and then lock the project for editing, the user gets lost and I have to go back to editing the postgres db manually again. If this is a problem, my database name is nextcloud_db. I see some installations just have nextcloud as database name.

No more observations at the moment.

[cfgardiner]

There does seem to be a bug here in line #333. Just tried to create a dummy project. It is true that the project table is sparse (some IDs not present) but this is due to projects which were deleted. Maybe I'll try and regenerate the whole project table.

And if you want some tables to play with, the dumps of the tables are below.

No idea why the bug complains about Key (id)=(28). There are only 20 projects. BTW, the only table I modify manually is oc_timetracker_user_to_project. The manual update works, until I add a new project or try to edit a project.

timetracker_err_make_project.txt

timetracker_err_tables.txt .

[mxc]

Maybe this will help. It seems the ajax query is malformed. https://github.com/mtierltd/timetracker/issues/152#issuecomment-1035406457

[wunschadresse]

What I am also wondering about is the following: When the project is not locked, should it appear for all userse who you are using time tracker? I would assume so, but projects created by me (as admin) do not show for others.

[Maromax74]

Same problem here, any news ?

In this way is not possible to use the app.

[rnagy]

Same problem here, any news ?

In this way is not possible to use the app.

Please attach your nextcloud log from the relevant timeframe when you are searching for a user to assign.

[Maromax74]

I simply have no ability to select existing users. it seems that timetracker does not have access from the user DB. But I've no logs about it.

[rnagy]

So there is nothing in your nextcloud.log?

[Maromax74]

No, nothing related to TimeTracker. I don't receive any warning about it during filling simply users are not loaded and it is impossible to write in this field

[rnagy]

Anything in the browser's developer console?

[Maromax74]

Nothing. I click on users, for half a second appears "searching..." and after that "The results could not be loaded"