View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Wrong process to update from 1.7.2 to 1.8.0 ? - ProjeQtOr

Prochaines sessions de formation

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)


Jeudi 7 juin (10h30-12h)

 
 

Planifiez avec ProjeQtOr

18 et 19 juin (9h - 12h30)

 
 

Administrez avec ProjeQtOr

25 et 26 juin (9h - 12h30)

 

 

 

Wrong process to update from 1.7.2 to 1.8.0 ?

More
19 Oct 2011 17:32 #1 by fredparis
I'm trying to upgrade to 1.8.0.

I use Wamp on my own laptop :
- Apache 2.2.21
- Php 5.3.8
- Mysql 5.5.16

I have made a backup of my database first.
I have unzipped the 1.8.0 file into my www directory.
I start the new application and set the values of my actual database into parameters form.

After the 'ok' message, I log with 'admin'/'admin' user, and an error message become.

'8 nouveaux paramètres ajoutés en version V1.8.0
____________________________________________

1 ERRORS DURING UPDATE TO VERSION V1.8.0
DETAILS CAN BE FOUND IN LOG FILE.'

When I click on OK button, I see a white screen with this message :
'ERROR : Une erreur est survenue le 2011-10-19 à 17:07:32'

The log file is the following :

2011-10-19 17:06:29 ***** ERROR ***** Error on SqlElement to get 'isLdap' for Class 'User' : field 'isLdap' not found in Database.
2011-10-19 17:06:29 ===== TRACE =====
2011-10-19 17:06:29 ===== TRACE ===== =====================================
2011-10-19 17:06:29 ===== TRACE =====
2011-10-19 17:06:29 ===== TRACE ===== DataBase actual Version = V1.7.2
2011-10-19 17:06:29 ===== TRACE ===== ProjectOR actual Version = V1.8.0
2011-10-19 17:06:29 ===== TRACE =====
2011-10-19 17:06:29 ===== TRACE ===== =====================================
2011-10-19 17:06:29 ===== TRACE =====
2011-10-19 17:06:29 ===== TRACE ===== VERSION V1.8.0
2011-10-19 17:06:29 ===== TRACE =====
2011-10-19 17:06:29 ===== TRACE ===== Table "pj_indicator" created.
2011-10-19 17:06:30 ===== TRACE ===== 14 lines inserted into table "pj_indicator".
2011-10-19 17:06:30 ===== TRACE ===== Table "pj_indicatorable" created.
2011-10-19 17:06:30 ===== TRACE ===== 8 lines inserted into table "pj_indicatorable".
2011-10-19 17:06:30 ===== TRACE ===== Table "pj_indicatorableindicator" created.
2011-10-19 17:06:30 ===== TRACE ===== Table "pj_indicatorableindicator" altered.
2011-10-19 17:06:30 ===== TRACE ===== 33 lines inserted into table "pj_indicatorableindicator".
2011-10-19 17:06:31 ===== TRACE ===== Table "pj_indicatordefinition" created.
2011-10-19 17:06:31 ===== TRACE ===== Table "pj_indicatordefinition" altered.
2011-10-19 17:06:32 ===== TRACE ===== Table "pj_indicatorvalue" created.
2011-10-19 17:06:32 ===== TRACE ===== Table "pj_indicatorvalue" altered.
2011-10-19 17:06:32 ===== TRACE ===== Table "pj_alert" created.
2011-10-19 17:06:32 ===== TRACE ===== 5 lines inserted into table "pj_parameter".
2011-10-19 17:06:33 ===== TRACE ===== Table "pj_delayunit" created.
2011-10-19 17:06:33 ===== TRACE ===== 5 lines inserted into table "pj_delayunit".
2011-10-19 17:06:33 ===== TRACE ===== Table "pj_delay" created.
2011-10-19 17:06:33 ===== TRACE ===== 6 lines inserted into table "pj_delay".
2011-10-19 17:06:33 ===== TRACE ===== 1 lines inserted into table "pj_menu".
2011-10-19 17:06:33 ===== TRACE ===== 3 lines inserted into table "pj_habilitation".
2011-10-19 17:06:33 ===== TRACE ===== 1 lines updated into table "pj_menu".
2011-10-19 17:06:33 ===== TRACE ===== 1 lines updated into table "pj_menu".
2011-10-19 17:06:33 ===== TRACE ===== 1 lines inserted into table "pj_menu".
2011-10-19 17:06:34 ===== TRACE ===== 3 lines inserted into table "pj_habilitation".
2011-10-19 17:06:34 ===== TRACE ===== 1 lines inserted into table "pj_menu".
2011-10-19 17:06:34 ===== TRACE ===== 3 lines inserted into table "pj_habilitation".
2011-10-19 17:06:34 ===== TRACE ===== Table "pj_affectation" altered.
2011-10-19 17:06:35 ===== TRACE ===== 17 lines updated into table "pj_affectation".
2011-10-19 17:06:35 ===== TRACE ===== 1 lines inserted into table "pj_parameter".
2011-10-19 17:06:35 ===== TRACE ===== 1 lines inserted into table "pj_menu".
2011-10-19 17:06:35 ===== TRACE ===== 7 lines inserted into table "pj_habilitation".
2011-10-19 17:06:35 ===== TRACE ===== 1 lines inserted into table "pj_accessprofile".
2011-10-19 17:06:35 ===== TRACE ===== 7 lines inserted into table "pj_accessright".
2011-10-19 17:06:35 ===== TRACE ===== 1 lines inserted into table "pj_menu".
2011-10-19 17:06:35 ===== TRACE ===== 1 lines updated into table "pj_menu".
2011-10-19 17:06:35 ===== TRACE ===== 2 lines inserted into table "pj_habilitation".
2011-10-19 17:06:36 ===== TRACE ===== 1 lines updated into table "pj_habilitation".
2011-10-19 17:06:36 ===== TRACE ===== Table "pj_project" altered.
2011-10-19 17:06:36 ***** ERROR ***** [1146] Erreur SQL : Table 'projectorria.planningelement' doesn't exist<br/><br/>UPDATE `pj_project` SET sortOrder = (select wbsSortable from planningelement pe
where pe.refType='Project' and pe.refId=`pj_project`.id);

2011-10-19 17:06:36 ===== TRACE ===== <br/>***** SQL ERROR WHILE EXECUTING SQL REQUEST *****
2011-10-19 17:06:36 ===== TRACE =====
2011-10-19 17:06:36 ===== TRACE ===== Erreur SQL : Table 'projectorria.planningelement' doesn't exist<br/><br/>UPDATE `pj_project` SET sortOrder = (select wbsSortable from planningelement pe
where pe.refType='Project' and pe.refId=`pj_project`.id);

2011-10-19 17:06:36 ===== TRACE =====
2011-10-19 17:06:36 ===== TRACE ===== *************************************************
2011-10-19 17:06:36 ===== TRACE =====
2011-10-19 17:06:36 ===== TRACE ===== 0 lines updated into table "pj_type".
2011-10-19 17:06:36 ===== TRACE ===== 2 lines inserted into table "pj_parameter".
2011-10-19 17:06:36 ===== TRACE ===== 6 lines inserted into table "pj_indicatordefinition".
2011-10-19 17:06:37 ===== TRACE ===== Table "pj_work" altered.
2011-10-19 17:06:37 ===== TRACE ===== Table "pj_plannedwork" altered.
2011-10-19 17:06:37 ===== TRACE ===== Table "pj_planningelement" altered.
2011-10-19 17:06:38 ===== TRACE ===== Table "pj_assignment" altered.
2011-10-19 17:06:38 ===== TRACE ===== Table "pj_user" altered.
2011-10-19 17:06:38 ===== TRACE ===== 2 lines inserted into table "pj_parameter".
2011-10-19 17:06:38 ===== TRACE ===== 1 lines updated into table "pj_accessright".
2011-10-19 17:06:38 ===== TRACE ===== Parameter $paramldap_allow_login added
2011-10-19 17:06:38 ===== TRACE ===== Parameter $paramLdap_base_dn added
2011-10-19 17:06:38 ===== TRACE ===== Parameter $paramLdap_host added
2011-10-19 17:06:38 ===== TRACE ===== Parameter $paramLdap_port added
2011-10-19 17:06:38 ===== TRACE ===== Parameter $paramLdap_version added
2011-10-19 17:06:38 ===== TRACE ===== Parameter $paramLdap_search_user added
2011-10-19 17:06:38 ===== TRACE ===== Parameter $paramLdap_search_pass added
2011-10-19 17:06:38 ===== TRACE ===== Parameter $paramLdap_user_filter added
2011-10-19 17:06:38 ===== TRACE =====
2011-10-19 17:06:38 ===== TRACE ===== DATABASE UPDATED
2011-10-19 17:06:38 ===== TRACE ===== WITH 1 ERROR
2011-10-19 17:06:38 ===== TRACE =====
2011-10-19 17:06:40 ===== TRACE ===== =====================================
2011-10-19 17:06:40 ===== TRACE =====
2011-10-19 17:06:40 ===== TRACE ===== 1 ERRORS DURING UPDATE TO VERSION V1.8.0
2011-10-19 17:06:40 ===== TRACE =====
2011-10-19 17:06:40 ===== TRACE ===== =====================================
2011-10-19 17:06:40 ===== TRACE =====
2011-10-19 17:07:32 ===== TRACE ===== NEW CONNECTED USER 'admin'
2011-10-19 17:07:32 ***** ERROR ***** ERROR *****
2011-10-19 17:07:32 ***** ERROR ***** on file 'C:\wamp\www\projectorria\tool\projector.php' at line (1340)
2011-10-19 17:07:32 ***** ERROR ***** cause = file_get_contents() [<a href='function.file-get-contents'>function.file-get-contents</a>]: php_network_getaddresses: getaddrinfo failed: Hôte inconnu.



Thanks for help,

Please Connexion or Create an account to join the conversation.

More
19 Oct 2011 21:14 #2 by babynus
Hi,

2 issues :

1) Deployment error, one request without used prefix.
The concerned request is not major if you don't have many project, as it is just used to improve sort order of projects in project list.
Just go to screen Project and save on each project. All will be back to normal.*
=> Ticket #447 registered.

2) On your server cannnot contact remote server.
So function checking new version fails.
Change line 1340 in /tool/projector.php from
$currentVersion=file_get_contents($checkUrl);
to
$currentVersion=null;
This will correct your issue.
NB : this only concern Adminb connection. Other users can connect as they never use this function.
=> Ticket #446 registered

Regards

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
20 Oct 2011 00:11 #3 by fredparis
Hi Babynus,

I use issue #2.
It works fine !

I'm on 1.8.0 now !

Thanks a lot,

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.046 seconds

Paramétrages de cookies

×

Cookies fonctionnels

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

Veuillez vous connecter pour voir vos activités!

Autres cookies

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