ProjeQtOr free project management software - [SOLVED] Users unable to login after upgrading to most current release - Page 7 - ProjeQtOr
 

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

More
24 Feb 2016 20:19 #37 by babynus
File received.
Thnaks.

Will investigate.

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
27 Feb 2016 13:06 #38 by iconic
Hi,

Did you get time to look into this? Please provide update with this issue.

Thank You

Please Log in or Create an account to join the conversation.

More
28 Feb 2016 10:37 #39 by babynus
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 :
DELETE FROM affectation WHERE idProject NOT IN (SELECT id FROM project);
Deleted more than 500 lines
And now I can connect :woohoo:

I also noticed that some affectations had startDate end endDate set to '0000-00-00'.
So also did some cleanup :
UPDATE affectation SET startDate=NULL WHERE startDate='0000-00-00';
UPDATE affectation SET endDate=NULL WHERE endDate='0000-00-00';
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.

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
28 Feb 2016 10:59 #40 by iconic
Hello,

This is really strange. I don't understand why we had such wrong entries. I remember we had issues with changing project or setting dates before. The more information about those problems is available from the links below.

1. www.projeqtor.org/en/forum/2-submit-issu...oject-of-an-activity
2. www.projeqtor.org/en/forum/2-submit-issu...or-request-end-dates

I think this is the reason behind this kind of database entries. Any ways I am glad that you can reproduce the issue and know how to fix it. But I am still not sure If i delete those affections with query you have mentioned, wouldn't it would loose our data? The database is the only reason behind all this, otherwise I would have just installed projeqtor from scratch.

Thank You and please let me know if i can safely delete those affections with the query you have provided.

Please Log in or Create an account to join the conversation.

More
28 Feb 2016 18:57 #41 by babynus
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.

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
29 Feb 2016 16:10 #42 by iconic
Hi,

Thank You, it worked as you said, I made changes in database now we can log in.

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.044 seconds