OK,
This means you have very poor performance on your server.
Maybe some poor db response time...
NB : if you configured db host as "localhost", try and change it to "127.0.0.1".

Also try and check your server resourced : maybe RAM is over used, and your server is using swap, which can cause very long response times.

Also check your apache error log and MySql log file.

I checked the database connection as well as apache logs and MySQL logs as well, but i could not see anything problematic.
The database connection is done using 127.0.0.1.
Also I believe server performance should not be problematic because we also have other websites stored on VPS, including our own CRM+eCommerce which handles more than hundreds of thousand records very efficiently without any problem. With Ideal Server Load 0.02 (11 CPU), Memory usage up to 40% and 51% disk size doesn't seem to be performance issue. Also I was able to log into ProjeQtOr only once from user account. It took so much time to login and it asked to set new password. Setting password also required so much time but later it was working well after login but still slow than usual. This happened only once, now if i try to log in, the login page shows the message that login accepted but does not load dashboard and freezes.

Do you have a "heavy" database ?
How many projects, activitities ?

It is possible that you export your database (and possibly anonymize it) and send it to me for testing ?

Hello,

Yes i believe we have very heavy database, Its because one of our staff member added Project's Menu items as sub projects and i guess we have approx more than 50 projects. Also i am not sure but history's and all would be in thousands of records.

I will export the database and send it to you in any possible way and let you know of that. However i did not understand what you mean by anonymize it.

Hi,

50 projects is not heavy.
1000 projects is.

Anonymize is to replace all names so that you don't provide confidential data.

Hi, I was trying to anonymize database but i could not find user table, There are models named as User and UserOld in project files but i could not find any database for it. Can you please provide me which is the table used for storing the users?

Object User extends UserMain.
In UserMain, you find $_databaseTableName = 'resource';
This means that table for user object is resource (this tabe is shared by User, Resource and Contact)

Hi,

Sorry for the delay in reply, some other issues came up.

I have exported database and anonymized the resource table. Uploading database with this message. It was not allowing me to upload .sql file, so i compressed it to .zip.

Hi,

Sorry for the delay in reply, some other issues came up.

I have exported database and anonymized the resource table. Can you please tell me how should i send you database? I tried to send you private message but it does not have any option to upload file.

send it to support@projeqtor.org

Hello,

I have sent email with zip file of database attached to the email address you mentioned. You will find projeqtor.sql after extracting it.

Please let me know if you don't receive it. I have sent email with subject "Database for ProjeQtOr which is having problem with account logins."

Thank You

File received.
Thnaks.

Will investigate.

Hi,

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

Thank You

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.

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. http://www.projeqtor.org/en/forum/2-submit-issues/6358-program-halts-when-changing-the-project-of-an-activity
2. http://www.projeqtor.org/en/forum/2-submit-issues/6805-unable-to-change-dates-to-validated-end-dates-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.

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.

Hi,

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