[SOLVED] Users unable to login after upgrading to most current release

File received.
Thnaks.

Will investigate.

Hi,

I could reproduce.
Connection with admin correct
Connection with other profiles : not ending loop.
It happens that scripts come to a time limit....

So I looked at the usezd and found many (many) affectations : more that 200 affectations per user, with only 120 projects in database.
And many affectations where referencing non existing projects (id of project is displayed instead of Name of project).

So I did some cleanup :Deleted more than 500 lines
And now I can connect

I also noticed that some affectations had startDate end endDate set to '0000-00-00'.
So also did some cleanup :Does not change anything on connection, but much more clean.

Do you have any idea of how you got these affectations ?
(some without a project and some with zero dates)
I could never reproduce such issue as ProjeQtOr will refuse such things.

Hi,

Maybe the import of project may have brought issues, but I'm not really sure.

The proposed script will only delete some affectations, so you won't loose activity of projects data.
The only risk is that someone loosed access to some project, but it will be easy to create another affectation if needed.
But this risk is really small as the script deletes affectations referencing the id of a project that does not exist in the project table.
So have a backup of your database and run the script. It will fix the issue.