I tried to update to 6.4.1, the issue still here. I don't understand, nothing changed on server side...
During update I got errors :
2017-09-29 09:34:58.328 ===== TRACE =====
2017-09-29 09:34:58.328 ===== TRACE ===== =====================================
2017-09-29 09:34:58.328 ===== TRACE =====
2017-09-29 09:34:58.328 ===== TRACE ===== DataBase actual Version = V6.3.6
2017-09-29 09:34:58.328 ===== TRACE ===== ProjeQtOr actual Version = V6.4.1
2017-09-29 09:34:58.328 ===== TRACE =====
2017-09-29 09:34:58.328 ===== TRACE ===== =====================================
2017-09-29 09:34:58.328 ===== TRACE =====
2017-09-29 09:34:58.328 ===== TRACE ===== VERSION V6.4.0
2017-09-29 09:34:58.329 ===== TRACE =====
2017-09-29 09:34:58.357 ***** ERROR ***** [V6.3.6] Exception-[23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '10' for key 'PRIMARY'
2017-09-29 09:34:58.357 ***** ERROR ***** [V6.3.6] For query : INSERT INTO `event` (`id`,`name`,`idle`, `sortOrder`) VALUES
(10,'affectationAdd',0,51),
(11,'affectationChange',0,52);
2017-09-29 09:34:58.358 ***** ERROR ***** [V6.3.6] Strack trace :
2017-09-29 09:34:58.358 ***** ERROR ***** [V6.3.6] #0 Sql->query called at [/var/www/projeqtor/db/maintenanceFunctions.php:71]
2017-09-29 09:34:58.358 ***** ERROR ***** [V6.3.6] #1 runScript called at [/var/www/projeqtor/db/maintenance.php:101]
2017-09-29 09:34:58.358 ***** ERROR ***** [V6.3.6] #2 include called at [/var/www/projeqtor/tool/loginCheck.php:135]
2017-09-29 09:34:58.364 ===== TRACE =====
2017-09-29 09:34:58.364 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V6.4.0 (see above message)
2017-09-29 09:34:58.364 ===== TRACE =====
2017-09-29 09:34:58.364 ===== TRACE ===== *************************************************
2017-09-29 09:34:58.364 ===== TRACE =====
2017-09-29 09:34:58.378 ===== TRACE ===== 2 lines inserted into table "parameter".
2017-09-29 09:34:58.379 ===== TRACE ===== 2 lines inserted into table "parameter".
2017-09-29 09:34:58.392 ***** ERROR ***** [V6.3.6] Exception-[42S21] SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'hasView'
2017-09-29 09:34:58.392 ***** ERROR ***** [V6.3.6] For query : ALTER TABLE `report` ADD `hasView` int(1) DEFAULT 1,
ADD `hasPrint` int(1) DEFAULT 1,
ADD `hasPdf` int(1) DEFAULT 1,
ADD `hasToday` int(1) DEFAULT 1,
ADD `hasFavorite` int(1) DEFAULT 1,
ADD `hasWord` int(1) DEFAULT 0,
ADD `hasExcel` int(1) DEFAULT 0;
2017-09-29 09:34:58.392 ***** ERROR ***** [V6.3.6] Strack trace :
2017-09-29 09:34:58.392 ***** ERROR ***** [V6.3.6] #0 Sql->query called at [/var/www/projeqtor/db/maintenanceFunctions.php:71]
2017-09-29 09:34:58.392 ***** ERROR ***** [V6.3.6] #1 runScript called at [/var/www/projeqtor/db/maintenance.php:101]
2017-09-29 09:34:58.392 ***** ERROR ***** [V6.3.6] #2 include called at [/var/www/projeqtor/tool/loginCheck.php:135]
2017-09-29 09:34:58.392 ===== TRACE =====
2017-09-29 09:34:58.392 ===== TRACE ===== Error # 2 => SQL error while executing maintenance query for version V6.4.0 (see above message)
2017-09-29 09:34:58.392 ===== TRACE =====
2017-09-29 09:34:58.392 ===== TRACE ===== *************************************************
2017-09-29 09:34:58.392 ===== TRACE =====
2017-09-29 09:34:58.394 ===== TRACE ===== 2 lines inserted into table "parameter".
2017-09-29 09:34:58.413 ===== TRACE ===== 1 lines inserted into table "reportparameter".
2017-09-29 09:34:58.414 ***** ERROR ***** [V6.3.6] Exception-[42S01] SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'versioncompatibility' already exists
2017-09-29 09:34:58.414 ***** ERROR ***** [V6.3.6] For query : CREATE TABLE `versioncompatibility` (
`id` int(12) unsigned NOT NULL AUTO_INCREMENT,
`idVersionA` int(12) NOT NULL,
`idVersionB` int(12) NOT NULL,
`creationDate` date NOT NULL,
`idUser` int(12) NOT NULL,
`idle` int(1) DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
2017-09-29 09:34:58.414 ***** ERROR ***** [V6.3.6] Strack trace :
2017-09-29 09:34:58.415 ***** ERROR ***** [V6.3.6] #0 Sql->query called at [/var/www/projeqtor/db/maintenanceFunctions.php:71]
2017-09-29 09:34:58.415 ***** ERROR ***** [V6.3.6] #1 runScript called at [/var/www/projeqtor/db/maintenance.php:101]
2017-09-29 09:34:58.415 ***** ERROR ***** [V6.3.6] #2 include called at [/var/www/projeqtor/tool/loginCheck.php:135]
2017-09-29 09:34:58.415 ===== TRACE =====
2017-09-29 09:34:58.415 ===== TRACE ===== Error # 3 => SQL error while executing maintenance query for version V6.4.0 (see above message)
2017-09-29 09:34:58.415 ===== TRACE =====
2017-09-29 09:34:58.415 ===== TRACE ===== *************************************************
2017-09-29 09:34:58.415 ===== TRACE =====
2017-09-29 09:34:58.415 ***** ERROR ***** [V6.3.6] Exception-[42S21] SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'isDynamic'
2017-09-29 09:34:58.415 ***** ERROR ***** [V6.3.6] For query : ALTER TABLE `filter` ADD COLUMN `isDynamic` int(1) DEFAULT '0';
2017-09-29 09:34:58.415 ***** ERROR ***** [V6.3.6] Strack trace :
2017-09-29 09:34:58.415 ***** ERROR ***** [V6.3.6] #0 Sql->query called at [/var/www/projeqtor/db/maintenanceFunctions.php:71]
2017-09-29 09:34:58.415 ***** ERROR ***** [V6.3.6] #1 runScript called at [/var/www/projeqtor/db/maintenance.php:101]
2017-09-29 09:34:58.415 ***** ERROR ***** [V6.3.6] #2 include called at [/var/www/projeqtor/tool/loginCheck.php:135]
2017-09-29 09:34:58.415 ===== TRACE =====
2017-09-29 09:34:58.415 ===== TRACE ===== Error # 4 => SQL error while executing maintenance query for version V6.4.0 (see above message)
2017-09-29 09:34:58.415 ===== TRACE =====
2017-09-29 09:34:58.415 ===== TRACE ===== *************************************************
2017-09-29 09:34:58.415 ===== TRACE =====
2017-09-29 09:34:58.417 ***** ERROR ***** [V6.3.6] Exception-[42S21] SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'isDynamic'
2017-09-29 09:34:58.417 ***** ERROR ***** [V6.3.6] For query : ALTER TABLE `filtercriteria` ADD COLUMN `isDynamic` int(1) DEFAULT '0';
2017-09-29 09:34:58.417 ***** ERROR ***** [V6.3.6] Strack trace :
2017-09-29 09:34:58.417 ***** ERROR ***** [V6.3.6] #0 Sql->query called at [/var/www/projeqtor/db/maintenanceFunctions.php:71]
2017-09-29 09:34:58.417 ***** ERROR ***** [V6.3.6] #1 runScript called at [/var/www/projeqtor/db/maintenance.php:101]
2017-09-29 09:34:58.417 ***** ERROR ***** [V6.3.6] #2 include called at [/var/www/projeqtor/tool/loginCheck.php:135]
2017-09-29 09:34:58.417 ===== TRACE =====
2017-09-29 09:34:58.417 ===== TRACE ===== Error # 5 => SQL error while executing maintenance query for version V6.4.0 (see above message)
2017-09-29 09:34:58.417 ===== TRACE =====
2017-09-29 09:34:58.417 ===== TRACE ===== *************************************************
2017-09-29 09:34:58.417 ===== TRACE =====
2017-09-29 09:34:58.417 ***** ERROR ***** [V6.3.6] Exception-[42S21] SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'orOperator'
2017-09-29 09:34:58.417 ***** ERROR ***** [V6.3.6] For query : ALTER TABLE `filtercriteria` ADD COLUMN `orOperator` int(1) DEFAULT '0';
2017-09-29 09:34:58.417 ***** ERROR ***** [V6.3.6] Strack trace :
2017-09-29 09:34:58.417 ***** ERROR ***** [V6.3.6] #0 Sql->query called at [/var/www/projeqtor/db/maintenanceFunctions.php:71]
2017-09-29 09:34:58.417 ***** ERROR ***** [V6.3.6] #1 runScript called at [/var/www/projeqtor/db/maintenance.php:101]
2017-09-29 09:34:58.417 ***** ERROR ***** [V6.3.6] #2 include called at [/var/www/projeqtor/tool/loginCheck.php:135]
2017-09-29 09:34:58.418 ===== TRACE =====
2017-09-29 09:34:58.418 ===== TRACE ===== Error # 6 => SQL error while executing maintenance query for version V6.4.0 (see above message)
2017-09-29 09:34:58.418 ===== TRACE =====
2017-09-29 09:34:58.418 ===== TRACE ===== *************************************************
2017-09-29 09:34:58.418 ===== TRACE =====
2017-09-29 09:34:58.418 ***** ERROR ***** [V6.3.6] Exception-[23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '12' for key 'PRIMARY'
2017-09-29 09:34:58.418 ***** ERROR ***** [V6.3.6] For query : INSERT INTO `event` (`id`,`name`,`idle`, `sortOrder`) VALUES
(12,'linkAdd',0,53),
(13,'linkDelete',0,54);
2017-09-29 09:34:58.418 ***** ERROR ***** [V6.3.6] Strack trace :
2017-09-29 09:34:58.418 ***** ERROR ***** [V6.3.6] #0 Sql->query called at [/var/www/projeqtor/db/maintenanceFunctions.php:71]
2017-09-29 09:34:58.418 ***** ERROR ***** [V6.3.6] #1 runScript called at [/var/www/projeqtor/db/maintenance.php:101]
2017-09-29 09:34:58.418 ***** ERROR ***** [V6.3.6] #2 include called at [/var/www/projeqtor/tool/loginCheck.php:135]
2017-09-29 09:34:58.418 ===== TRACE =====
2017-09-29 09:34:58.418 ===== TRACE ===== Error # 7 => SQL error while executing maintenance query for version V6.4.0 (see above message)
2017-09-29 09:34:58.418 ===== TRACE =====
2017-09-29 09:34:58.418 ===== TRACE ===== *************************************************
2017-09-29 09:34:58.418 ===== TRACE =====
2017-09-29 09:34:58.423 ***** ERROR ***** [V6.3.6] Exception-[23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '49' for key 'PRIMARY'
2017-09-29 09:34:58.423 ***** ERROR ***** [V6.3.6] For query : INSERT INTO `importable` (`id`,`name`,`idle`) VALUES
(49,'Delivery',0);
2017-09-29 09:34:58.423 ***** ERROR ***** [V6.3.6] Strack trace :
2017-09-29 09:34:58.423 ***** ERROR ***** [V6.3.6] #0 Sql->query called at [/var/www/projeqtor/db/maintenanceFunctions.php:71]
2017-09-29 09:34:58.423 ***** ERROR ***** [V6.3.6] #1 runScript called at [/var/www/projeqtor/db/maintenance.php:101]
2017-09-29 09:34:58.423 ***** ERROR ***** [V6.3.6] #2 include called at [/var/www/projeqtor/tool/loginCheck.php:135]
2017-09-29 09:34:58.423 ===== TRACE =====
2017-09-29 09:34:58.423 ===== TRACE ===== Error # 8 => SQL error while executing maintenance query for version V6.4.0 (see above message)