View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - 1ere install, impossible de se connecter - Page 2 - ProjeQtOr
 
 

1ere install, impossible de se connecter

More
24 Sep 2014 20:21 - 24 Sep 2014 20:21 #7 by babynus
Hi,

Table "user" has been replaced with table "resource" in V3.0.0, for PostgreSql compatibility.
So it is normal you don't have a "user" table.

The select for "user" gives me a hint.
It seems some test gives a weird result on your configuration.
1) On what OS / version is running your PHP server ?
What version of PHP ?
What version of MySql ?

2) could you check content of parameterValue in table parameter for parameterCode='dbVersion'
What version do you get ?

3) can you try simply to comment line 32 in /tool/loginCheck.php
//User::setOldUserStyle();
and try to connect again

4) if it works, could you please try to replace lines 31 to 33 in /tool/loginCheck.php with this :
if (Sql::getDbVersion() and Sql::getDbVersion()!=$version and version_compare(substr(Sql::getDbVersion(),1), '3.0.0','<')) {
  	User::setOldUserStyle();
  }
Test again. If it works, I'll keep this as fix for next version.

Babynus
Administrator of ProjeQtOr web site
Last edit: 24 Sep 2014 20:21 by babynus.

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

More
24 Sep 2014 22:19 #8 by Hesiode
1/ Linux CentOS 6.4
php 5.4.32
mysql 5.5

2/ 0.3.0 (??)
in projektor.php i have 4.4.2

in logs i feel script stop before end :
the last line :
2014-09-24 22:01:24 ===== TRACE ===== =====================================
2014-09-24 22:01:24 ===== TRACE =====
2014-09-24 22:01:24 ===== TRACE ===== VERSION V3.2.0
2014-09-24 22:01:24 ===== TRACE =====
2014-09-24 22:01:24 ===== TRACE ===== Table "opportunity" altered.
2014-09-24 22:01:25 ===== TRACE ===== Table "risk" altered.
2014-09-24 22:01:25 ===== TRACE ===== 1 lines inserted into table "importable".
2014-09-24 22:01:25 ===== TRACE ===== 1 lines inserted into table "linkable".
2014-09-24 22:01:25 ===== TRACE ===== Table "health" created.
2014-09-24 22:01:25 ===== TRACE ===== 5 lines inserted into table "health".
2014-09-24 22:01:25 ===== TRACE ===== 1 lines inserted into table "menu".
2014-09-24 22:01:25 ===== TRACE ===== 7 lines inserted into table "habilitation".
2014-09-24 22:01:25 ===== TRACE ===== Table "project" altered.
2014-09-24 22:01:25 ===== TRACE ===== 1 lines inserted into table "report".
2014-09-24 22:01:25 ===== TRACE ===== 1 lines inserted into table "reportparameter".
2014-09-24 22:01:25 ===== TRACE ===== Table "audit" created.
2014-09-24 22:01:25 ===== TRACE ===== Index "auditUser" created.
2014-09-24 22:01:25 ===== TRACE ===== Index "auditSessionId" created.
2014-09-24 22:01:25 ===== TRACE ===== 1 lines inserted into table "menu".
2014-09-24 22:01:25 ===== TRACE ===== 7 lines inserted into table "habilitation".
2014-09-24 22:01:25 ===== TRACE ===== Table "auditsummary" created.

I do a new install and its the same thing (but not at the same place) :
2014-09-24 22:17:42 ===== TRACE ===== =====================================
2014-09-24 22:17:42 ===== TRACE =====
2014-09-24 22:17:42 ===== TRACE ===== VERSION V3.3.0
2014-09-24 22:17:42 ===== TRACE =====
2014-09-24 22:17:42 ===== TRACE ===== Table "today" created.
2014-09-24 22:17:43 ===== TRACE ===== Index "todayUser" created.
2014-09-24 22:17:43 ===== TRACE ===== Table "todayparameter" created.
2014-09-24 22:17:43 ===== TRACE ===== Index "todayParameterUser" created.
2014-09-24 22:17:43 ===== TRACE ===== Index "todayParameterReport" created.
2014-09-24 22:17:43 ===== TRACE ===== Index "todayParameterToiday" created.
2014-09-24 22:17:43 ===== TRACE ===== 2 lines inserted into table "today".
2014-09-24 22:17:43 ===== TRACE ===== 2 lines inserted into table "today".
2014-09-24 22:17:43 ===== TRACE ===== 2 lines inserted into table "today".
2014-09-24 22:17:43 ===== TRACE ===== 2 lines inserted into table "today".
2014-09-24 22:17:43 ===== TRACE ===== 2 lines inserted into table "today".

may be i should increase set_time_limit ?

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

More
24 Sep 2014 23:30 #9 by babynus
You're right, the issue is here : upgrade is uncomplete.

I should have checked on your previous post : you must get 127 tables.

You solution is correct : increase set_tilme_limit
In fact the script does it, if PHP setting allows it.

Another way is to update database step by step, playing wih $version in /tool/projeqtor.php.
(usefull for hosted versions when provider will not change set_time_limit)
Fist set to V1.0.0 and go to login screen (that should show upgrade in progress message) and log in as admin.
Don't go further, set $version to V2.0.0 and do same thing again.
And so on until you get to V4.4.2.
To go faster, as log file shows, you can go directly to V3.3.0 and then to V4.4.2 (two steps only)

Babynus
Administrator of ProjeQtOr web site

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

More
25 Sep 2014 21:51 #10 by Hesiode
Hi,

Finally i have make install on my local computer and i make database dump and import on my server.
Dont know why my server is so slow...

Anyway, thank you for your help

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

More
26 Sep 2014 10:14 #11 by protion
Hello

The slowness has to come from the hardware configuration or software emulation php, not the soft
Bonjour

La lenteur doit venir de la configuration matériel ou du logiciel d'émulation php, et non du soft

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

Moderators: babynusprotion
Time to create page: 0.040 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.