2014-11-10 13:28:40 ===== TRACE ===== ===================================== 2014-11-10 13:28:40 ===== TRACE ===== 2014-11-10 13:28:40 ===== TRACE ===== DataBase actual Version = V4.3.2 2014-11-10 13:28:40 ===== TRACE ===== ProjeQtOr actual Version = V4.4.2 2014-11-10 13:28:40 ===== TRACE ===== 2014-11-10 13:28:40 ===== TRACE ===== ===================================== 2014-11-10 13:28:40 ===== TRACE ===== 2014-11-10 13:28:40 ===== TRACE ===== VERSION V4.4.0 2014-11-10 13:28:40 ===== TRACE ===== 2014-11-10 13:28:40 ***** ERROR ***** Exception-[42S21] SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'apiKey' 2014-11-10 13:28:40 ***** ERROR ***** For query : ALTER TABLE `resource` ADD COLUMN `apiKey` varchar(400) DEFAULT NULL; 2014-11-10 13:28:40 ***** ERROR ***** Strack trace : 2014-11-10 13:28:40 ***** ERROR ***** #0 Sql->query called at [/var/www/localhost/htdocs/projeqtor/db/maintenance.php:386] 2014-11-10 13:28:40 ***** ERROR ***** #1 runScript called at [/var/www/localhost/htdocs/projeqtor/db/maintenance.php:107] 2014-11-10 13:28:40 ***** ERROR ***** #2 include called at [/var/www/localhost/htdocs/projeqtor/tool/loginCheck.php:92] 2014-11-10 13:28:40 ===== TRACE ===== 2014-11-10 13:28:40 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V4.4.0 (see above message) 2014-11-10 13:28:40 ===== TRACE ===== 2014-11-10 13:28:40 ===== TRACE ===== ************************************************* 2014-11-10 13:28:40 ===== TRACE ===== 2014-11-10 13:28:40 ***** ERROR ***** Exception-[23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '53' for key 'PRIMARY' 2014-11-10 13:28:40 ***** ERROR ***** For query : INSERT INTO `report` (`id`, `name`, `idReportCategory`, `file`, `sortOrder`, `idle`) VALUES (53,'reportProductTestDetail',8,'productTestDetail.php',825,0); 2014-11-10 13:28:40 ***** ERROR ***** Strack trace : 2014-11-10 13:28:40 ***** ERROR ***** #0 Sql->query called at [/var/www/localhost/htdocs/projeqtor/db/maintenance.php:386] 2014-11-10 13:28:40 ***** ERROR ***** #1 runScript called at [/var/www/localhost/htdocs/projeqtor/db/maintenance.php:107] 2014-11-10 13:28:40 ***** ERROR ***** #2 include called at [/var/www/localhost/htdocs/projeqtor/tool/loginCheck.php:92] 2014-11-10 13:28:40 ===== TRACE ===== 2014-11-10 13:28:40 ===== TRACE ===== Error # 2 => SQL error while executing maintenance query for version V4.4.0 (see above message) 2014-11-10 13:28:40 ===== TRACE ===== 2014-11-10 13:28:40 ===== TRACE ===== ************************************************* 2014-11-10 13:28:40 ===== TRACE ===== 2014-11-10 13:28:41 ===== TRACE ===== 3 lines inserted into table "reportparameter". 2014-11-10 13:28:41 ===== TRACE ===== 7 lines inserted into table "habilitationreport". 2014-11-10 13:28:41 ***** ERROR ***** Exception-[23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '23' for key 'PRIMARY' 2014-11-10 13:28:41 ***** ERROR ***** For query : INSERT INTO `mailable` (`id`,`name`, `idle`) VALUES (23,'Product', '0'), (24,'Version', '0'); 2014-11-10 13:28:41 ***** ERROR ***** Strack trace : 2014-11-10 13:28:41 ***** ERROR ***** #0 Sql->query called at [/var/www/localhost/htdocs/projeqtor/db/maintenance.php:386] 2014-11-10 13:28:41 ***** ERROR ***** #1 runScript called at [/var/www/localhost/htdocs/projeqtor/db/maintenance.php:107] 2014-11-10 13:28:41 ***** ERROR ***** #2 include called at [/var/www/localhost/htdocs/projeqtor/tool/loginCheck.php:92] 2014-11-10 13:28:41 ===== TRACE ===== 2014-11-10 13:28:41 ===== TRACE ===== Error # 3 => SQL error while executing maintenance query for version V4.4.0 (see above message) 2014-11-10 13:28:41 ===== TRACE ===== 2014-11-10 13:28:41 ===== TRACE ===== ************************************************* 2014-11-10 13:28:41 ===== TRACE ===== 2014-11-10 13:28:41 ***** ERROR ***** Exception-[42S21] SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'validatedCalculated' 2014-11-10 13:28:41 ***** ERROR ***** For query : ALTER TABLE `planningelement` ADD COLUMN `validatedCalculated` int(1) unsigned DEFAULT 0; 2014-11-10 13:28:41 ***** ERROR ***** Strack trace : 2014-11-10 13:28:41 ***** ERROR ***** #0 Sql->query called at [/var/www/localhost/htdocs/projeqtor/db/maintenance.php:386] 2014-11-10 13:28:41 ***** ERROR ***** #1 runScript called at [/var/www/localhost/htdocs/projeqtor/db/maintenance.php:107] 2014-11-10 13:28:41 ***** ERROR ***** #2 include called at [/var/www/localhost/htdocs/projeqtor/tool/loginCheck.php:92] 2014-11-10 13:28:41 ===== TRACE ===== 2014-11-10 13:28:41 ===== TRACE ===== Error # 4 => SQL error while executing maintenance query for version V4.4.0 (see above message) 2014-11-10 13:28:41 ===== TRACE ===== 2014-11-10 13:28:41 ===== TRACE ===== ************************************************* 2014-11-10 13:28:41 ===== TRACE ===== 2014-11-10 13:28:41 ***** ERROR ***** Exception-[42S21] SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'workElementEstimatedWork' 2014-11-10 13:28:41 ***** ERROR ***** For query : ALTER TABLE `planningelement` ADD COLUMN `workElementEstimatedWork` DECIMAL(9,5) UNSIGNED; 2014-11-10 13:28:41 ***** ERROR ***** Strack trace : 2014-11-10 13:28:41 ***** ERROR ***** #0 Sql->query called at [/var/www/localhost/htdocs/projeqtor/db/maintenance.php:386] 2014-11-10 13:28:41 ***** ERROR ***** #1 runScript called at [/var/www/localhost/htdocs/projeqtor/db/maintenance.php:107] 2014-11-10 13:28:41 ***** ERROR ***** #2 include called at [/var/www/localhost/htdocs/projeqtor/tool/loginCheck.php:92] 2014-11-10 13:28:41 ===== TRACE ===== 2014-11-10 13:28:41 ===== TRACE ===== Error # 5 => SQL error while executing maintenance query for version V4.4.0 (see above message) 2014-11-10 13:28:41 ===== TRACE ===== 2014-11-10 13:28:41 ===== TRACE ===== ************************************************* 2014-11-10 13:28:41 ===== TRACE ===== 2014-11-10 13:28:41 ***** ERROR ***** Exception-[42S21] SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'workElementRealWork' 2014-11-10 13:28:41 ***** ERROR ***** For query : ALTER TABLE `planningelement` ADD COLUMN `workElementRealWork` DECIMAL(9,5) UNSIGNED; 2014-11-10 13:28:41 ***** ERROR ***** Strack trace : 2014-11-10 13:28:41 ***** ERROR ***** #0 Sql->query called at [/var/www/localhost/htdocs/projeqtor/db/maintenance.php:386] 2014-11-10 13:28:41 ***** ERROR ***** #1 runScript called at [/var/www/localhost/htdocs/projeqtor/db/maintenance.php:107] 2014-11-10 13:28:41 ***** ERROR ***** #2 include called at [/var/www/localhost/htdocs/projeqtor/tool/loginCheck.php:92] 2014-11-10 13:28:41 ===== TRACE ===== 2014-11-10 13:28:41 ===== TRACE ===== Error # 6 => SQL error while executing maintenance query for version V4.4.0 (see above message) 2014-11-10 13:28:41 ===== TRACE ===== 2014-11-10 13:28:41 ===== TRACE ===== ************************************************* 2014-11-10 13:28:41 ===== TRACE ===== 2014-11-10 13:28:41 ***** ERROR ***** Exception-[42S21] SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'workElementLeftWork' 2014-11-10 13:28:41 ***** ERROR ***** For query : ALTER TABLE `planningelement` ADD COLUMN `workElementLeftWork` DECIMAL(9,5) UNSIGNED; 2014-11-10 13:28:41 ***** ERROR ***** Strack trace : 2014-11-10 13:28:41 ***** ERROR ***** #0 Sql->query called at [/var/www/localhost/htdocs/projeqtor/db/maintenance.php:386] 2014-11-10 13:28:41 ***** ERROR ***** #1 runScript called at [/var/www/localhost/htdocs/projeqtor/db/maintenance.php:107] 2014-11-10 13:28:41 ***** ERROR ***** #2 include called at [/var/www/localhost/htdocs/projeqtor/tool/loginCheck.php:92] 2014-11-10 13:28:41 ===== TRACE ===== 2014-11-10 13:28:41 ===== TRACE ===== Error # 7 => SQL error while executing maintenance query for version V4.4.0 (see above message) 2014-11-10 13:28:41 ===== TRACE ===== 2014-11-10 13:28:41 ===== TRACE ===== ************************************************* 2014-11-10 13:28:41 ===== TRACE ===== 2014-11-10 13:28:41 ***** ERROR ***** Exception-[42S21] SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'workElementCount' 2014-11-10 13:28:41 ***** ERROR ***** For query : ALTER TABLE `planningelement` ADD COLUMN `workElementCount` DECIMAL(5) UNSIGNED; 2014-11-10 13:28:41 ***** ERROR ***** Strack trace : 2014-11-10 13:28:41 ***** ERROR ***** #0 Sql->query called at [/var/www/localhost/htdocs/projeqtor/db/maintenance.php:386] 2014-11-10 13:28:41 ***** ERROR ***** #1 runScript called at [/var/www/localhost/htdocs/projeqtor/db/maintenance.php:107] 2014-11-10 13:28:41 ***** ERROR ***** #2 include called at [/var/www/localhost/htdocs/projeqtor/tool/loginCheck.php:92] 2014-11-10 13:28:41 ===== TRACE ===== 2014-11-10 13:28:41 ===== TRACE ===== Error # 8 => SQL error while executing maintenance query for version V4.4.0 (see above message) 2014-11-10 13:28:41 ===== TRACE ===== 2014-11-10 13:28:41 ===== TRACE ===== ************************************************* 2014-11-10 13:28:41 ===== TRACE ===== 2014-11-10 13:28:44 ===== TRACE ===== DISCONNECTED USER 'wbasalaj' 2014-11-10 13:28:52 ===== TRACE ===== 14 lines updated into table "planningelement". 2014-11-10 13:28:52 ***** ERROR ***** Exception-[42S21] SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'expenseAssignedAmount' 2014-11-10 13:28:52 ***** ERROR ***** For query : ALTER TABLE `planningelement` ADD COLUMN `expenseAssignedAmount` DECIMAL(11,2) UNSIGNED; 2014-11-10 13:28:52 ***** ERROR ***** Strack trace : 2014-11-10 13:28:52 ***** ERROR ***** #0 Sql->query called at [/var/www/localhost/htdocs/projeqtor/db/maintenance.php:386] 2014-11-10 13:28:52 ***** ERROR ***** #1 runScript called at [/var/www/localhost/htdocs/projeqtor/db/maintenance.php:107] 2014-11-10 13:28:52 ***** ERROR ***** #2 include called at [/var/www/localhost/htdocs/projeqtor/tool/loginCheck.php:92] 2014-11-10 13:28:52 ===== TRACE ===== 2014-11-10 13:28:52 ===== TRACE ===== Error # 9 => SQL error while executing maintenance query for version V4.4.0 (see above message) 2014-11-10 13:28:52 ===== TRACE ===== 2014-11-10 13:28:52 ===== TRACE ===== ************************************************* 2014-11-10 13:28:52 ===== TRACE ===== 2014-11-10 13:28:52 ***** ERROR ***** Exception-[42S21] SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'expensePlannedAmount' 2014-11-10 13:28:52 ***** ERROR ***** For query : ALTER TABLE `planningelement` ADD COLUMN `expensePlannedAmount` DECIMAL(11,2) UNSIGNED; 2014-11-10 13:28:52 ***** ERROR ***** Strack trace : 2014-11-10 13:28:52 ***** ERROR ***** #0 Sql->query called at [/var/www/localhost/htdocs/projeqtor/db/maintenance.php:386] 2014-11-10 13:28:52 ***** ERROR ***** #1 runScript called at [/var/www/localhost/htdocs/projeqtor/db/maintenance.php:107] 2014-11-10 13:28:52 ***** ERROR ***** #2 include called at [/var/www/localhost/htdocs/projeqtor/tool/loginCheck.php:92] 2014-11-10 13:28:52 ===== TRACE ===== 2014-11-10 13:28:52 ===== TRACE ===== Error # 10 => SQL error while executing maintenance query for version V4.4.0 (see above message) 2014-11-10 13:28:52 ===== TRACE ===== 2014-11-10 13:28:52 ===== TRACE ===== ************************************************* 2014-11-10 13:28:52 ===== TRACE ===== 2014-11-10 13:28:52 ***** ERROR ***** Exception-[42S21] SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'expenseRealAmount' 2014-11-10 13:28:52 ***** ERROR ***** For query : ALTER TABLE `planningelement` ADD COLUMN `expenseRealAmount` DECIMAL(11,2) UNSIGNED; 2014-11-10 13:28:52 ***** ERROR ***** Strack trace : 2014-11-10 13:28:52 ***** ERROR ***** #0 Sql->query called at [/var/www/localhost/htdocs/projeqtor/db/maintenance.php:386] 2014-11-10 13:28:52 ***** ERROR ***** #1 runScript called at [/var/www/localhost/htdocs/projeqtor/db/maintenance.php:107] 2014-11-10 13:28:52 ***** ERROR ***** #2 include called at [/var/www/localhost/htdocs/projeqtor/tool/loginCheck.php:92] 2014-11-10 13:28:52 ===== TRACE ===== 2014-11-10 13:28:52 ===== TRACE ===== Error # 11 => SQL error while executing maintenance query for version V4.4.0 (see above message) 2014-11-10 13:28:52 ===== TRACE ===== 2014-11-10 13:28:52 ===== TRACE ===== ************************************************* 2014-11-10 13:28:52 ===== TRACE ===== 2014-11-10 13:28:52 ***** ERROR ***** Exception-[42S21] SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'expenseLeftAmount' 2014-11-10 13:28:52 ***** ERROR ***** For query : ALTER TABLE `planningelement` ADD COLUMN `expenseLeftAmount` DECIMAL(11,2) UNSIGNED; 2014-11-10 13:28:52 ***** ERROR ***** Strack trace : 2014-11-10 13:28:52 ***** ERROR ***** #0 Sql->query called at [/var/www/localhost/htdocs/projeqtor/db/maintenance.php:386] 2014-11-10 13:28:52 ***** ERROR ***** #1 runScript called at [/var/www/localhost/htdocs/projeqtor/db/maintenance.php:107] 2014-11-10 13:28:52 ***** ERROR ***** #2 include called at [/var/www/localhost/htdocs/projeqtor/tool/loginCheck.php:92] 2014-11-10 13:28:52 ===== TRACE ===== 2014-11-10 13:28:52 ===== TRACE ===== Error # 12 => SQL error while executing maintenance query for version V4.4.0 (see above message) 2014-11-10 13:28:52 ===== TRACE ===== 2014-11-10 13:28:52 ===== TRACE ===== ************************************************* 2014-11-10 13:28:52 ===== TRACE ===== 2014-11-10 13:28:52 ***** ERROR ***** Exception-[42S21] SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'expenseValidatedAmount' 2014-11-10 13:28:52 ***** ERROR ***** For query : ALTER TABLE `planningelement` ADD COLUMN `expenseValidatedAmount` DECIMAL(11,2) UNSIGNED; 2014-11-10 13:28:52 ***** ERROR ***** Strack trace : 2014-11-10 13:28:52 ***** ERROR ***** #0 Sql->query called at [/var/www/localhost/htdocs/projeqtor/db/maintenance.php:386] 2014-11-10 13:28:52 ***** ERROR ***** #1 runScript called at [/var/www/localhost/htdocs/projeqtor/db/maintenance.php:107] 2014-11-10 13:28:52 ***** ERROR ***** #2 include called at [/var/www/localhost/htdocs/projeqtor/tool/loginCheck.php:92] 2014-11-10 13:28:52 ===== TRACE ===== 2014-11-10 13:28:52 ===== TRACE ===== Error # 13 => SQL error while executing maintenance query for version V4.4.0 (see above message) 2014-11-10 13:28:52 ===== TRACE ===== 2014-11-10 13:28:52 ===== TRACE ===== ************************************************* 2014-11-10 13:28:52 ===== TRACE ===== 2014-11-10 13:28:56 ===== TRACE ===== Table "planningelement" altered. 2014-11-10 13:29:00 ===== TRACE ===== Table "planningelement" altered. 2014-11-10 13:29:04 ===== TRACE ===== Table "planningelement" altered. 2014-11-10 13:29:08 ===== TRACE ===== Table "planningelement" altered. 2014-11-10 13:29:12 ===== TRACE ===== Table "planningelement" altered. 2014-11-10 13:29:12 ===== TRACE ===== 0 lines updated into table "planningelement". 2014-11-10 13:29:12 ===== TRACE ===== 0 lines updated into table "planningelement". 2014-11-10 13:29:12 ***** ERROR ***** Exception-[42S21] SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'dontReceiveTeamMails' 2014-11-10 13:29:12 ***** ERROR ***** For query : ALTER TABLE `resource` ADD COLUMN `dontReceiveTeamMails` int(1) unsigned DEFAULT 0; 2014-11-10 13:29:12 ***** ERROR ***** Strack trace : 2014-11-10 13:29:12 ***** ERROR ***** #0 Sql->query called at [/var/www/localhost/htdocs/projeqtor/db/maintenance.php:386] 2014-11-10 13:29:12 ***** ERROR ***** #1 runScript called at [/var/www/localhost/htdocs/projeqtor/db/maintenance.php:107] 2014-11-10 13:29:12 ***** ERROR ***** #2 include called at [/var/www/localhost/htdocs/projeqtor/tool/loginCheck.php:92] 2014-11-10 13:29:12 ===== TRACE ===== 2014-11-10 13:29:12 ===== TRACE ===== Error # 14 => SQL error while executing maintenance query for version V4.4.0 (see above message) 2014-11-10 13:29:12 ===== TRACE ===== 2014-11-10 13:29:12 ===== TRACE ===== ************************************************* 2014-11-10 13:29:12 ===== TRACE ===== 2014-11-10 13:29:12 ===== TRACE ===== 2014-11-10 13:29:12 ===== TRACE ===== DATABASE UPDATED 2014-11-10 13:29:12 ===== TRACE ===== WITH 14 ERRORS 2014-11-10 13:29:12 ===== TRACE ===== 2014-11-10 13:29:13 ===== TRACE ===== ===================================== 2014-11-10 13:29:13 ===== TRACE ===== 2014-11-10 13:29:13 ===== TRACE ===== 14 ERRORS DURING UPDATE TO VERSION V4.4.2 2014-11-10 13:29:13 ===== TRACE ===== 2014-11-10 13:29:13 ===== TRACE ===== =====================================