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

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 Log in 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 Log in 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 Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.033 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.