ProjeQtOr free project management software - [SOLVED] Surbooking error in logs - ProjeQtOr
 

[SOLVED] Surbooking error in logs

More
07 Aoû 2019 10:10 #1 by Bena
Hello,

I have the following error in the log file :
2019-08-07 07:00:04.041 ***** ERROR ***** [V8.1.3] Error on SqlElement to get 'surbooked' for Class 'PlanningElement'  : field 'surbooked' not found in Database.
2019-08-07 07:00:04.041 ***** ERROR ***** [V8.1.3] Error on SqlElement to get 'surbooked' for Class 'PlanningElement'  : field 'surbooked' not found in Database.
2019-08-07 07:00:04.041 ***** ERROR ***** [V8.1.3] Error on SqlElement to get 'surbooked' for Class 'PlanningElement'  : field 'surbooked' not found in Database.
2019-08-07 07:00:04.041 ===== TRACE ===== Calcul automatique du planning : calcul différentiel - début - Projets : 78,87,89
2019-08-07 07:00:04.048 ***** ERROR ***** [V8.1.3] Error on SqlElement to get 'surbooked' for Class 'PlanningElement'  : field 'surbooked' not found in Database.
2019-08-07 07:00:04.048 ***** ERROR ***** [V8.1.3] Error on SqlElement to get 'surbooked' for Class 'PlanningElement'  : field 'surbooked' not found in Database.
2019-08-07 07:00:04.048 ***** ERROR ***** [V8.1.3] Error on SqlElement to get 'surbooked' for Class 'PlanningElement'  : field 'surbooked' not found in Database.
2019-08-07 07:00:04.049 ***** ERROR ***** [V8.1.3] Error on SqlElement to get 'surbooked' for Class 'PlanningElement'  : field 'surbooked' not found in Database.
2019-08-07 07:00:04.053 ***** ERROR ***** [V8.1.3] Error on SqlElement to get 'surbooked' for Class 'PlanningElement'  : field 'surbooked' not found in Database.
2019-08-07 07:00:04.054 ***** ERROR ***** [V8.1.3] Error on SqlElement to get 'surbooked' for Class 'PlanningElement'  : field 'surbooked' not found in Database.
2019-08-07 07:00:04.056 ***** ERROR ***** [V8.1.3] Error on SqlElement to get 'surbooked' for Class 'PlanningElement'  : field 'surbooked' not found in Database.
2019-08-07 07:00:04.061 ***** ERROR ***** [V8.1.3] Error on SqlElement to get 'surbooked' for Class 'PlanningElement'  : field 'surbooked' not found in Database.
2019-08-07 07:00:04.062 ***** ERROR ***** [V8.1.3] Error on SqlElement to get 'surbooked' for Class 'ProjectPlanningElement'  : field 'surbooked' not found in Database.
2019-08-07 07:00:04.067 ===== TRACE ===== Calcul automatique du planning : calcul différentiel - fin - résultat = Planning correctement mis à jour

Regards.

--
Bena

Please Connexion or Create an account to join the conversation.

More
07 Aoû 2019 20:40 #2 by babynus
it seems some scripts of migration to v8.1 failed
ALTER TABLE `${prefix}planningelement` ADD surbooked int(1) DEFAULT 0;
Can you retreive logs of migration and post here errors reportec ?

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
08 Aoû 2019 15:01 - 08 Aoû 2019 15:03 #3 by Bena
Here the log when the error forst appear :

# cat projeqtor_20190722.log
2019-07-22 15:45:03.512
DEBUG
loginCheck : current db version = 'V8.1.0'
2019-07-22 15:45:03.523
DEBUG
User->authenticate('xxxx', 'xxxxxxx'')
2019-07-22 15:45:03.523
DEBUG
User->authenticate : LDAP authenticate
2019-07-22 15:45:03.752 ===== TRACE ===== NEW CONNECTED USER 'xxxx'
2019-07-22 15:45:09.638 ===== TRACE ===== Cron started at 22/07/2019 15:45:09
2019-07-22 15:45:09.653 ===== TRACE ===== Calcul automatique du planning : calcul différentiel - début - Projets : aucun
2019-07-22 15:45:09.662 ===== TRACE ===== Calcul automatique du planning : calcul complet - début - Projets : tous
2019-07-22 15:45:09.701 ===== TRACE ===== Calcul automatique du planning : calcul complet - fin - résultat = Aucun projet à recalculer
2019-07-22 15:45:30.665 ===== TRACE ===== New installation found : projeqtorV8.1.2.zip
2019-07-22 15:45:36.254 ===== TRACE ===== Installation unzipped succefully
2019-07-22 15:45:36.392 ***** ERROR ***** [V8.1.0] HACK ================================================================
2019-07-22 15:45:36.392 ***** ERROR ***** [V8.1.0] Try to hack detected
2019-07-22 15:45:36.392 ***** ERROR ***** [V8.1.0] Source Code = securityCheckPage() - not .php or URL wrapper or not actual file
2019-07-22 15:45:36.392 ***** ERROR ***** [V8.1.0] QUERY_STRING =
2019-07-22 15:45:36.392 ***** ERROR ***** [V8.1.0] REMOTE_ADDR = 172.16.8.6
2019-07-22 15:45:36.392 ***** ERROR ***** [V8.1.0] SCRIPT_FILENAME = /projets/www/view/main.php
2019-07-22 15:45:36.392
DEBUG
=> /projets/projeqtor/tool/projeqtor.php at line 1506 called from debugPrintTraceStack
2019-07-22 15:45:36.392
DEBUG
=> /projets/projeqtor/tool/projeqtor.php at line 1529 called from traceHack
2019-07-22 15:45:36.392
DEBUG
=> /projets/projeqtor/tool/projeqtor.php at line 3950 called from securityCheckPage
2019-07-22 15:45:36.393
DEBUG
=> /projets/projeqtor/tool/projeqtor.php at line 127 called from securityCheckRequest
2019-07-22 15:45:36.393
DEBUG
=> /projets/projeqtor/view/main.php at line 37 called from require_once
2019-07-22 15:45:36.393 ***** ERROR ***** [V8.1.0] REQUEST_URI = /view/main.php
2019-07-22 15:45:36.004 ***** ERROR ***** [V8.1.0] Error on SqlElement to get 'surbooked' for Class 'ProjectPlanningElement' : field 'surbooked' not found in Database.
2019-07-22 15:45:37.010 ===== TRACE ===== NEW CONNECTED USER 'xxxx' (using remember me feature)
2019-07-22 15:45:37.043 ===== TRACE ===== DISCONNECTED USER 'xxxx'
2019-07-22 15:45:39.718 ===== TRACE ===== Cron normally stopped at 22/07/2019 15:45:39
2019-07-22 15:45:39.719 ===== TRACE ===== Cron stopped for deployment. Will be restarted
2019-07-22 15:45:55.368
DEBUG
loginCheck : current db version = 'V8.1.0'
2019-07-22 15:45:55.369
DEBUG
User->authenticate('xxxx', 'xxxx==')
2019-07-22 15:45:55.373
DEBUG
User->authenticate : LDAP authenticate
2019-07-22 15:45:55.409 ===== TRACE =====
2019-07-22 15:45:55.409 ===== TRACE ===== =====================================
2019-07-22 15:45:55.409 ===== TRACE =====
2019-07-22 15:45:55.409 ===== TRACE ===== DataBase actual Version = V8.1.0
2019-07-22 15:45:55.409 ===== TRACE ===== ProjeQtOr actual Version = V8.1.2
2019-07-22 15:45:55.409 ===== TRACE =====
2019-07-22 15:45:55.610 ===== TRACE ===== =====================================
2019-07-22 15:45:55.610 ===== TRACE =====
2019-07-22 15:45:55.610 ===== TRACE ===== DATABASE UPDATE COMPLETED TO VERSION V8.1.2
2019-07-22 15:45:55.610 ===== TRACE =====
2019-07-22 15:45:55.610 ===== TRACE ===== =====================================
2019-07-22 15:45:55.610 ===== TRACE =====
2019-07-22 15:45:55.652 ===== TRACE ===== === PLUGIN COMPATIBILITY ISSUE =====================================
2019-07-22 15:45:55.653 ===== TRACE ===== Plugin kanban version 3.5 is not compatible with ProjeQtOr V8.1.2.
2019-07-22 15:45:55.653 ===== TRACE ===== It has been desactivated. Please install version 4.1 or over.
2019-07-22 15:46:20.613
DEBUG
loginCheck : current db version = 'V8.1.2'
2019-07-22 15:46:20.614
DEBUG
User->authenticate('xxxx', 'xxxx==')
2019-07-22 15:46:20.618
DEBUG
User->authenticate : LDAP authenticate
2019-07-22 15:46:20.657 ***** ERROR ***** [V8.1.2] Error on SqlElement to get 'surbooked' for Class 'ProjectPlanningElement' : field 'surbooked' not found in Database.
2019-07-22 15:46:20.663 ===== TRACE ===== NEW CONNECTED USER 'xxxx'
2019-07-22 15:46:21.710 ***** ERROR ***** [V8.1.2] Error on SqlElement to get 'surbooked' for Class 'ProjectPlanningElement' : field 'surbooked' not found in Database.
2019-07-22 15:46:21.746 ***** ERROR ***** [V8.1.2] Error on SqlElement to get 'surbooked' for Class 'ProjectPlanningElement' : field 'surbooked' not found in Database.
2019-07-22 15:46:25.947 ===== TRACE ===== Cron started at 22/07/2019 15:46:25
2019-07-22 16:00:06.146 ===== TRACE ===== Calcul automatique du planning : calcul différentiel - début - Projets : aucun
2019-07-22 17:00:07.067 ===== TRACE ===== Calcul automatique du planning : calcul différentiel - début - Projets : aucun
2019-07-22 18:00:07.878 ===== TRACE ===== Calcul automatique du planning : calcul différentiel - début - Projets : aucun
2019-07-22 19:00:08.732 ===== TRACE ===== Calcul automatique du planning : calcul différentiel - début - Projets : aucun
2019-07-22 20:00:09.794 ===== TRACE ===== Calcul automatique du planning : calcul différentiel - début - Projets : aucun
2019-07-22 21:00:00.646 ===== TRACE ===== Calcul automatique du planning : calcul différentiel - début - Projets : aucun
2019-07-22 22:00:01.439 ===== TRACE ===== Calcul automatique du planning : calcul différentiel - début - Projets : aucun
2019-07-22 23:00:02.222 ===== TRACE ===== Calcul automatique du planning : calcul différentiel - début - Projets : aucun

And the migration log from 8.0.4 to 8.1.0

2019-07-03 15:44:43.016 ***** ERROR ***** [V8.0.4] Error on SqlElement to get 'startDate' for Class 'User' : field 'startDate' not found in Database.
2019-07-03 15:44:43.017 ***** ERROR ***** [V8.0.4] Error on SqlElement to get 'startDate' for Class 'User' : field 'startDate' not found in Database.
2019-07-03 15:44:43.017 ***** ERROR ***** [V8.0.4] Error on SqlElement to get 'startDate' for Class 'User' : field 'startDate' not found in Database.
2019-07-03 15:44:43.022 ***** ERROR ***** [V8.0.4] Error on SqlElement to get 'startDate' for Class 'User' : field 'startDate' not found in Database.
2019-07-03 15:44:43.023 ***** ERROR ***** [V8.0.4] Error on SqlElement to get 'startDate' for Class 'User' : field 'startDate' not found in Database.
2019-07-03 15:44:43.024 ***** ERROR ***** [V8.0.4] Error on SqlElement to get 'startDate' for Class 'User' : field 'startDate' not found in Database.
2019-07-03 15:44:43.054 ===== TRACE =====
2019-07-03 15:44:43.055 ===== TRACE ===== =====================================
2019-07-03 15:44:43.055 ===== TRACE =====
2019-07-03 15:44:43.055 ===== TRACE ===== DataBase actual Version = V8.0.4
2019-07-03 15:44:43.055 ===== TRACE ===== ProjeQtOr actual Version = V8.1.0
2019-07-03 15:44:43.055 ===== TRACE =====
2019-07-03 15:44:43.055 ===== TRACE ===== =====================================
2019-07-03 15:44:43.055 ===== TRACE =====
2019-07-03 15:44:43.055 ===== TRACE ===== VERSION V8.1.0
2019-07-03 15:44:43.055 ===== TRACE =====
2019-07-03 15:44:43.065 ===== TRACE ===== Table "statusmail" altered.
2019-07-03 15:44:43.118 ===== TRACE ===== Table "event" renamed to "eventformail`"
2019-07-03 15:44:43.119 ===== TRACE ===== 0 lines updated into table "columnselector".
2019-07-03 15:44:43.125 ===== TRACE ===== 0 lines updated into table "history".
2019-07-03 15:44:43.167 ===== TRACE ===== Table "resourcesurbooking" created.
2019-07-03 15:44:43.174 ===== TRACE ===== Index "resourcevariablesurbooking" created.
2019-07-03 15:44:43.175 ===== TRACE ===== 1 lines inserted into table "originable`(".
2019-07-03 15:44:43.220 ===== TRACE ===== Table "message" altered.
2019-07-03 15:44:43.230 ===== TRACE ===== Table "resource" altered.
2019-07-03 15:44:43.231 ===== TRACE ===== 0 lines deleted from table "t".
2019-07-03 15:44:43.235 ===== TRACE ===== 1 lines inserted into table "tempupdate".
2019-07-03 15:44:43.240 ===== TRACE ===== 1 lines deleted from table "workflowstatus".
2019-07-03 15:44:43.245 ===== TRACE ===== 1 lines deleted from table "t".
2019-07-03 15:44:43.247 ===== TRACE ===== 0 lines inserted into table "tempupdate".
2019-07-03 15:44:43.250 ===== TRACE ===== 0 lines deleted from table "workflowstatus".
2019-07-03 15:44:43.250 ===== TRACE ===== 0 lines deleted from table "t".
2019-07-03 15:44:43.252 ===== TRACE ===== 0 lines inserted into table "tempupdate".
2019-07-03 15:44:43.255 ===== TRACE ===== 0 lines deleted from table "workflowstatus".
2019-07-03 15:44:43.256 ===== TRACE ===== 0 lines deleted from table "t".
2019-07-03 15:44:43.272 ===== TRACE ===== Index "workflowstatusReference" created.
2019-07-03 15:44:43.273 ===== TRACE ===== 1 lines inserted into table "reportcategory".
2019-07-03 15:44:43.282 ===== TRACE ===== 3 lines inserted into table "report".
2019-07-03 15:44:43.292 ===== TRACE ===== 13 lines inserted into table "reportparameter".
2019-07-03 15:44:43.294 ===== TRACE ===== 3 lines inserted into table "habilitationreport".
2019-07-03 15:44:43.343 ===== TRACE ===== Table "resource" altered.
2019-07-03 15:44:43.374 ===== TRACE ===== Table "filter" altered.
2019-07-03 15:44:43.375 ===== TRACE ===== 0 lines updated into table "filter".
2019-07-03 15:44:43.379 ===== TRACE ===== Table "resource" altered.
2019-07-03 15:44:43.381 ===== TRACE ===== 4 lines inserted into table "parameter".
2019-07-03 15:44:43.381 ===== TRACE =====
2019-07-03 15:44:43.381 ===== TRACE ===== DATABASE UPDATED
2019-07-03 15:44:43.381 ===== TRACE ===== WITH NO ERROR
2019-07-03 15:44:43.381 ===== TRACE =====
2019-07-03 15:44:43.550 ===== TRACE ===== =====================================
2019-07-03 15:44:43.550 ===== TRACE =====
2019-07-03 15:44:43.550 ===== TRACE ===== DATABASE UPDATE COMPLETED TO VERSION V8.1.0
2019-07-03 15:44:43.550 ===== TRACE =====
2019-07-03 15:44:43.550 ===== TRACE ===== =====================================
2019-07-03 15:44:43.550 ===== TRACE =====

--
Bena
Last edit: 08 Aoû 2019 15:03 by Bena.

Please Connexion or Create an account to join the conversation.

More
08 Aoû 2019 17:09 #4 by babynus
I dont' understand why, but following queries where not executed.
Please execute them manually to fix the issue.
ALTER TABLE `planningelement` ADD surbooked int(1) DEFAULT 0;
ALTER TABLE `planningelementbaseline` ADD surbooked int(1) DEFAULT 0;
ALTER TABLE `plannedwork` ADD surbooked int(1) DEFAULT 0;
ALTER TABLE `plannedwork` ADD surbookedWork decimal(8,5) unsigned DEFAULT NULL;
ALTER TABLE `plannedworkbaseline` ADD surbooked int(1) DEFAULT 0;
ALTER TABLE `plannedworkbaseline` ADD surbookedWork decimal(8,5) unsigned DEFAULT NULL;
ALTER TABLE `assignment` ADD surbooked int(1) DEFAULT 0;

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
08 Aoû 2019 17:56 #5 by Bena
Thanks, no more error :)

--
Bena

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.044 seconds