2016-11-23 12:43:29.871 ===== TRACE ===== =====================================
2016-11-23 12:43:29.871 ===== TRACE ===== 
2016-11-23 12:43:29.871 ===== TRACE ===== DataBase actual Version = V5.5.1
2016-11-23 12:43:29.871 ===== TRACE ===== ProjeQtOr actual Version = V6.0.1
2016-11-23 12:43:29.871 ===== TRACE ===== 
2016-11-23 12:43:29.871 ===== TRACE ===== =====================================
2016-11-23 12:43:29.871 ===== TRACE ===== 
2016-11-23 12:43:29.871 ===== TRACE ===== VERSION V5.5.2
2016-11-23 12:43:29.871 ===== TRACE ===== 
2016-11-23 12:43:29.887 ===== TRACE =====  17 lines updated into table "menu".
2016-11-23 12:43:29.890 ===== TRACE =====  2 lines updated into table "menu".
2016-11-23 12:43:29.892 ===== TRACE =====  0 lines deleted from table "tempupdate".
2016-11-23 12:43:30.074 ===== TRACE =====  Table "tempupdate" altered.
2016-11-23 12:43:30.079 ===== TRACE =====  0 lines inserted into table "tempupdate".
2016-11-23 12:43:30.081 ===== TRACE =====  0 lines updated into table "work".
2016-11-23 12:43:30.084 ===== TRACE =====  0 lines deleted from table "work".
2016-11-23 12:43:30.087 ===== TRACE =====  0 lines deleted from table "work".
2016-11-23 12:43:30.089 ===== TRACE =====  0 lines deleted from table "tempupdate".
2016-11-23 12:43:30.093 ===== TRACE =====  Index "work" dropped.
2016-11-23 12:43:30.257 ===== TRACE =====  Index "workReference" created.
2016-11-23 12:43:30.257 ===== TRACE ===== 
2016-11-23 12:43:30.257 ===== TRACE ===== DATABASE UPDATED
2016-11-23 12:43:30.257 ===== TRACE =====  WITH NO ERROR
2016-11-23 12:43:30.257 ===== TRACE ===== 
2016-11-23 12:43:30.257 ===== TRACE ===== =====================================
2016-11-23 12:43:30.257 ===== TRACE ===== 
2016-11-23 12:43:30.257 ===== TRACE ===== VERSION V5.5.3
2016-11-23 12:43:30.257 ===== TRACE ===== 
2016-11-23 12:43:30.261 ===== TRACE =====  16 lines updated into table "menu".
2016-11-23 12:43:30.265 ===== TRACE =====  0 lines deleted from table "accessright".
2016-11-23 12:43:30.270 ===== TRACE ===== 
2016-11-23 12:43:30.270 ===== TRACE ===== DATABASE UPDATED
2016-11-23 12:43:30.270 ===== TRACE =====  WITH NO ERROR
2016-11-23 12:43:30.270 ===== TRACE ===== 
2016-11-23 12:43:30.271 ===== TRACE ===== =====================================
2016-11-23 12:43:30.271 ===== TRACE ===== 
2016-11-23 12:43:30.271 ===== TRACE ===== VERSION V6.0.0
2016-11-23 12:43:30.271 ===== TRACE ===== 
2016-11-23 12:43:30.321 ===== TRACE =====  Table "product" altered.
2016-11-23 12:43:30.362 ===== TRACE =====  Table "version" altered.
2016-11-23 12:43:30.411 ===== TRACE =====  Table "action" altered.
2016-11-23 12:43:30.470 ===== TRACE =====  Table "dependency" altered.
2016-11-23 12:43:30.505 ===== TRACE =====  Table "testcaserun" altered.
2016-11-23 12:43:30.512 ===== TRACE =====  21 lines updated into table "parameter".
2016-11-23 12:43:30.514 ===== TRACE =====  0 lines updated into table "parameter".
2016-11-23 12:43:30.516 ===== TRACE =====  0 lines updated into table "parameter".
2016-11-23 12:43:30.520 ===== TRACE =====  0 lines updated into table "product".
2016-11-23 12:43:30.524 ===== TRACE =====  0 lines updated into table "version".
2016-11-23 12:43:30.527 ===== TRACE =====  1 lines inserted into table "report".
2016-11-23 12:43:30.541 ===== TRACE =====  7 lines inserted into table "reportparameter".
2016-11-23 12:43:30.558 ===== TRACE =====  3 lines inserted into table "habilitationreport".
2016-11-23 12:43:30.565 ===== TRACE =====  7 lines inserted into table "parameter".
2016-11-23 12:43:30.603 ===== TRACE =====  Table "baseline" created.
2016-11-23 12:43:30.611 ===== TRACE =====  Index "baselineProject" created.
2016-11-23 12:43:30.617 ===== TRACE =====  Index "baselineUser" created.
2016-11-23 12:43:30.630 ===== TRACE =====  Table "plannedworkbaseline" created.
2016-11-23 12:43:30.637 ===== TRACE =====  Index "plannedworkbaselineWorkDate" created.
2016-11-23 12:43:30.643 ===== TRACE =====  Index "plannedworkbaselineRef" created.
2016-11-23 12:43:30.649 ===== TRACE =====  Index "plannedworkbaselineBaseline" created.
2016-11-23 12:43:30.688 ===== TRACE =====  Table "planningelementbaseline" created.
2016-11-23 12:43:30.702 ===== TRACE =====  Index "planningelementbaselineBaseline" created.
2016-11-23 12:43:30.708 ===== TRACE =====  Index "planningelementbaselineRef" created.
2016-11-23 12:43:30.715 ===== TRACE =====  Index "planningelementbaselineProject" created.
2016-11-23 12:43:30.717 ***** ERROR ***** Exception-[42883] SQLSTATE[42883]: Undefined function: 7 ERREUR:  la fonction wbssortable(integer) n'existe pas at character 77
HINT:  Aucune fonction ne correspond au nom donné et aux types d'arguments.
Vous devez ajouter des conversions explicites de type.
2016-11-23 12:43:30.717 ***** ERROR *****    For query : CREATE INDEX planningelementbaselineWbsSortable ON planningelementbaseline (wbsSortable(255));
2016-11-23 12:43:30.717 ***** ERROR *****    Strack trace :
2016-11-23 12:43:30.717 ***** ERROR *****    #0 Sql->query called at [/home/wwwroot/projeqtor/db/maintenanceFunctions.php:71]
2016-11-23 12:43:30.717 ***** ERROR *****    #1 runScript called at [/home/wwwroot/projeqtor/db/maintenance.php:101]
2016-11-23 12:43:30.717 ***** ERROR *****    #2 include called at [/home/wwwroot/projeqtor/tool/loginCheck.php:135]
2016-11-23 12:43:30.718 ===== TRACE ===== 
2016-11-23 12:43:30.718 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V6.0.0 (see above message)
2016-11-23 12:43:30.718 ===== TRACE ===== 
2016-11-23 12:43:30.718 ===== TRACE ===== *************************************************
2016-11-23 12:43:30.718 ===== TRACE ===== 
2016-11-23 12:43:30.721 ===== TRACE =====  1 lines inserted into table "reportparameter".
2016-11-23 12:43:30.729 ===== TRACE =====  85 lines inserted into table "parameter".
2016-11-23 12:43:30.740 ===== TRACE =====  85 lines inserted into table "parameter".
2016-11-23 12:43:30.750 ===== TRACE =====  85 lines inserted into table "parameter".
2016-11-23 12:43:30.757 ===== TRACE =====  85 lines inserted into table "parameter".
2016-11-23 12:43:30.764 ===== TRACE =====  85 lines inserted into table "parameter".
2016-11-23 12:43:30.772 ===== TRACE =====  85 lines inserted into table "parameter".
2016-11-23 12:43:30.779 ===== TRACE =====  85 lines inserted into table "parameter".
2016-11-23 12:43:30.804 ===== TRACE =====  Table "organization" created.
2016-11-23 12:43:30.812 ===== TRACE =====  Index "resourceOrganization" created.
2016-11-23 12:43:30.815 ===== TRACE =====  1 lines inserted into table "menu".
2016-11-23 12:43:30.821 ===== TRACE =====  1 lines inserted into table "habilitation".
2016-11-23 12:43:30.827 ===== TRACE =====  1 lines inserted into table "accessright".
2016-11-23 12:43:30.832 ===== TRACE =====  8 lines inserted into table "accessright".
2016-11-23 12:43:30.837 ===== TRACE =====  1 lines inserted into table "menu".
2016-11-23 12:43:30.843 ===== TRACE =====  9 lines inserted into table "habilitation".
2016-11-23 12:43:30.848 ===== TRACE =====  1 lines inserted into table "habilitation".
2016-11-23 12:43:30.856 ===== TRACE =====  1 lines inserted into table "habilitation".
2016-11-23 12:43:30.863 ===== TRACE =====  7 lines inserted into table "accessright".
2016-11-23 12:43:30.867 ***** ERROR ***** Exception-[42804] SQLSTATE[42804]: Datatype mismatch: 7 ERREUR:  la colonne « mandatorydescription » est de type numeric mais l'expression est de type boolean
LINE 2: ('Organization', 'Department', '10',0,false,'DEPT'),
                                              ^
HINT:  Vous devez réécrire l'expression ou lui appliquer une transformation de type.
2016-11-23 12:43:30.867 ***** ERROR *****    For query : INSERT INTO type (scope, name, sortOrder, idle, mandatoryDescription, code) VALUES
('Organization', 'Department', '10',0,false,'DEPT'),
('Organization', 'Unit', '20',0,false,'UNIT'),
('Organization', 'Location', '30',0,false,'LOC');
2016-11-23 12:43:30.867 ***** ERROR *****    Strack trace :
2016-11-23 12:43:30.867 ***** ERROR *****    #0 Sql->query called at [/home/wwwroot/projeqtor/db/maintenanceFunctions.php:71]
2016-11-23 12:43:30.867 ***** ERROR *****    #1 runScript called at [/home/wwwroot/projeqtor/db/maintenance.php:101]
2016-11-23 12:43:30.867 ***** ERROR *****    #2 include called at [/home/wwwroot/projeqtor/tool/loginCheck.php:135]
2016-11-23 12:43:30.868 ===== TRACE ===== 
2016-11-23 12:43:30.868 ===== TRACE ===== Error # 2 => SQL error while executing maintenance query for version V6.0.0 (see above message)
2016-11-23 12:43:30.868 ===== TRACE ===== 
2016-11-23 12:43:30.868 ===== TRACE ===== *************************************************
2016-11-23 12:43:30.868 ===== TRACE ===== 
2016-11-23 12:43:30.871 ===== TRACE =====  1 lines inserted into table "reportcategory".
2016-11-23 12:43:30.876 ===== TRACE =====  1 lines inserted into table "report".
2016-11-23 12:43:30.881 ===== TRACE =====  3 lines inserted into table "habilitationreport".
2016-11-23 12:43:30.889 ===== TRACE =====  3 lines inserted into table "reportparameter".
2016-11-23 12:43:30.894 ===== TRACE =====  1 lines inserted into table "report".
2016-11-23 12:43:30.899 ===== TRACE =====  3 lines inserted into table "habilitationreport".
2016-11-23 12:43:30.904 ===== TRACE =====  7 lines inserted into table "reportparameter".
2016-11-23 12:43:30.909 ===== TRACE =====  1 lines inserted into table "report".
2016-11-23 12:43:30.927 ===== TRACE =====  3 lines inserted into table "habilitationreport".
2016-11-23 12:43:30.933 ===== TRACE =====  6 lines inserted into table "reportparameter".
2016-11-23 12:43:30.938 ===== TRACE =====  1 lines inserted into table "menu".
2016-11-23 12:43:30.943 ===== TRACE =====  1 lines inserted into table "menu".
2016-11-23 12:43:30.948 ===== TRACE =====  1 lines updated into table "menu".
2016-11-23 12:43:30.951 ===== TRACE =====  1 lines updated into table "menu".
2016-11-23 12:43:30.953 ===== TRACE =====  1 lines updated into table "menu".
2016-11-23 12:43:30.957 ===== TRACE =====  1 lines updated into table "menu".
2016-11-23 12:43:30.960 ===== TRACE =====  1 lines updated into table "menu".
2016-11-23 12:43:30.963 ===== TRACE =====  1 lines updated into table "menu".
2016-11-23 12:43:30.966 ===== TRACE =====  1 lines updated into table "menu".
2016-11-23 12:43:30.968 ===== TRACE =====  1 lines updated into table "menu".
2016-11-23 12:43:30.971 ===== TRACE =====  1 lines updated into table "menu".
2016-11-23 12:43:30.973 ===== TRACE =====  1 lines updated into table "menu".
2016-11-23 12:43:30.994 ===== TRACE =====  Table "budgetelement" created.
2016-11-23 12:43:30.001 ===== TRACE =====  Index "budgetelementRef" created.
2016-11-23 12:43:31.067 ===== TRACE =====  Table "project" altered.
2016-11-23 12:43:31.075 ===== TRACE =====  Index "projectOrganization" created.
2016-11-23 12:43:31.199 ===== TRACE =====  Table "planningelement" altered.
2016-11-23 12:43:31.209 ===== TRACE =====  Index "planningelementOrganization" created.
2016-11-23 12:43:31.269 ===== TRACE =====  Table "resource" altered.
2016-11-23 12:43:31.270 ***** ERROR ***** Exception-[42804] SQLSTATE[42804]: Datatype mismatch: 7 ERREUR:  la colonne « mandatorydescription » est de type numeric mais l'expression est de type boolean
LINE 2: ('ProductVersion', 'Major Version', '10',0,false,'MAJ'),
                                                   ^
HINT:  Vous devez réécrire l'expression ou lui appliquer une transformation de type.
2016-11-23 12:43:31.270 ***** ERROR *****    For query : INSERT INTO type (scope, name, sortOrder, idle, mandatoryDescription, code) VALUES
('ProductVersion', 'Major Version', '10',0,false,'MAJ'),
('ProductVersion', 'Minor Version', '20',0,false,'MIN'),
('ProductVersion', 'Patch', '30',0,false,'PATCH'),
('ComponentVersion', 'Major Version', '10',0,false,'maj'),
('ComponentVersion', 'Minor Version', '20',0,false,'min'),
('ComponentVersion', 'Patch', '30',0,false,'patch');
2016-11-23 12:43:31.270 ***** ERROR *****    Strack trace :
2016-11-23 12:43:31.270 ***** ERROR *****    #0 Sql->query called at [/home/wwwroot/projeqtor/db/maintenanceFunctions.php:71]
2016-11-23 12:43:31.271 ***** ERROR *****    #1 runScript called at [/home/wwwroot/projeqtor/db/maintenance.php:101]
2016-11-23 12:43:31.271 ***** ERROR *****    #2 include called at [/home/wwwroot/projeqtor/tool/loginCheck.php:135]
2016-11-23 12:43:31.271 ===== TRACE ===== 
2016-11-23 12:43:31.271 ===== TRACE ===== Error # 3 => SQL error while executing maintenance query for version V6.0.0 (see above message)
2016-11-23 12:43:31.271 ===== TRACE ===== 
2016-11-23 12:43:31.271 ===== TRACE ===== *************************************************
2016-11-23 12:43:31.271 ===== TRACE ===== 
2016-11-23 12:43:31.298 ===== TRACE =====  Table "version" altered.
2016-11-23 12:43:31.320 ===== TRACE =====  Table "role" altered.
2016-11-23 12:43:31.324 ===== TRACE =====  3 lines inserted into table "list".
2016-11-23 12:43:31.326 ===== TRACE ===== 
2016-11-23 12:43:31.326 ===== TRACE ===== DATABASE UPDATED
2016-11-23 12:43:31.327 ===== TRACE =====  WITH 3 ERRORS
2016-11-23 12:43:31.327 ===== TRACE ===== 
2016-11-23 12:43:31.334 ===== TRACE =====    => Removing default .htpassword file in API to avoid security leak
2016-11-23 12:43:31.879 ===== TRACE ===== =====================================
2016-11-23 12:43:31.879 ===== TRACE ===== 
2016-11-23 12:43:31.879 ===== TRACE ===== 3 ERRORS DURING UPDATE TO VERSION V6.0.1
2016-11-23 12:43:31.879 ===== TRACE ===== 
2016-11-23 12:43:31.880 ===== TRACE ===== =====================================
2016-11-23 12:43:31.880 ===== TRACE =====