View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] Surbooking error in logs - ProjeQtOr

Prochaines sessions de formation

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

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)

Mardi 23 avril (10h30-12h)

Jeudi 16 mai (16h-17h30)

Jeudi 13 juin (10h30-12h)

  
 

Planifiez avec ProjeQtOr

3 et 4 avril (9h - 12h30)

  
 

Administrez avec ProjeQtOr

10 et 11 avril (9h - 12h30)

  

 

 
 

[SOLVED] Surbooking error in logs

More
07 Aoû 2019 10:10 #1 by Bena
Surbooking error in logs was created 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
Replied by babynus on topic Surbooking error in logs
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
Replied by Bena on topic Surbooking error in logs
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
Replied by babynus on topic Surbooking error in logs
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
Replied by Bena on topic Surbooking error in logs
Thanks, no more error :)
--
Bena

Please Connexion or Create an account to join the conversation.

Moderators: babynus, protion
Time to create page: 0.042 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.

Login Form