Migration Error From 6.3.7 to 7.09

hi babynus, and all others,

we prepare the migration from the 6.3.7 to the last V7 (V7.0.9 today).

we met two database errors :

The first :

2018-05-24 14:11:45.039 ===== TRACE ===== =====================================
2018-05-24 14:11:45.039 ===== TRACE =====
2018-05-24 14:11:45.039 ===== TRACE ===== DataBase actual Version = V6.3.7
2018-05-24 14:11:45.039 ===== TRACE ===== ProjeQtOr actual Version = V7.0.9
2018-05-24 14:11:45.039 ===== TRACE =====
2018-05-24 14:11:45.039 ===== TRACE ===== =====================================
2018-05-24 14:11:45.039 ===== TRACE =====
2018-05-24 14:11:45.039 ===== TRACE ===== VERSION V6.4.0
2018-05-24 14:11:45.039 ===== TRACE =====
2018-05-24 14:11:45.042 ===== TRACE ===== 2 lines inserted into table "event".
2018-05-24 14:11:45.043 ===== TRACE ===== 2 lines inserted into table "parameter".
2018-05-24 14:11:45.044 ===== TRACE ===== 2 lines inserted into table "parameter".
2018-05-24 14:11:45.075 ===== TRACE ===== Table "report" altered.
2018-05-24 14:11:45.077 ===== TRACE ===== 2 lines inserted into table "parameter".
2018-05-24 14:11:45.079 ===== TRACE ===== 1 lines inserted into table "reportparameter".
2018-05-24 14:11:45.082 ===== TRACE ===== Table "versioncompatibility" created.
2018-05-24 14:11:45.093 ===== TRACE ===== Table "filter" altered.
2018-05-24 14:11:45.112 ===== TRACE ===== Table "filtercriteria" altered.
2018-05-24 14:11:45.131 ===== TRACE ===== Table "filtercriteria" altered.
2018-05-24 14:11:45.133 ===== TRACE ===== 2 lines inserted into table "event".
2018-05-24 14:11:45.134 ***** ERROR ***** [V6.3.7] Exception-[23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '49' for key 'PRIMARY'
2018-05-24 14:11:45.134 ***** ERROR ***** [V6.3.7] For query : INSERT INTO `importable` (`id`,`name`,`idle`) VALUES
(49,'Delivery',0);
2018-05-24 14:11:45.134 ***** ERROR ***** [V6.3.7] Strack trace :
2018-05-24 14:11:45.134 ***** ERROR ***** [V6.3.7] #0 Sql->query called at [/produits/www/projeqtor/db/maintenanceFunctions.php:71]
2018-05-24 14:11:45.134 ***** ERROR ***** [V6.3.7] #1 runScript called at [/produits/www/projeqtor/db/maintenance.php:110]
2018-05-24 14:11:45.134 ***** ERROR ***** [V6.3.7] #2 include called at [/produits/www/projeqtor/tool/loginCheck.php:143]
2018-05-24 14:11:45.134 ===== TRACE =====
2018-05-24 14:11:45.134 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V6.4.0 (see above message)
2018-05-24 14:11:45.135 ===== TRACE =====
2018-05-24 14:11:45.135 ===== TRACE ===== *************************************************
2018-05-24 14:11:45.135 ===== TRACE =====
2018-05-24 14:11:45.135 ===== TRACE =====
2018-05-24 14:11:45.135 ===== TRACE ===== DATABASE UPDATED
2018-05-24 14:11:45.135 ===== TRACE ===== WITH 1 ERROR
2018-05-24 14:11:45.135 ===== TRACE =====
2018-05-24 14:11:45.135 ===== TRACE ===== =====================================

and the second :

2018-05-24 14:11:45.240 ===== TRACE ===== =====================================
2018-05-24 14:11:45.240 ===== TRACE =====
2018-05-24 14:11:45.240 ===== TRACE ===== VERSION V6.4.3
2018-05-24 14:11:45.240 ===== TRACE =====
2018-05-24 14:11:45.241 ***** ERROR ***** [V6.3.7] Exception-[23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '50' for key 'PRIMARY'
2018-05-24 14:11:45.241 ***** ERROR ***** [V6.3.7] For query : INSERT INTO `importable` (`id`,`name`,`idle`) VALUES
(50,'Tender',0),
(51,'CallForTender',0);
2018-05-24 14:11:45.241 ***** ERROR ***** [V6.3.7] Strack trace :
2018-05-24 14:11:45.241 ***** ERROR ***** [V6.3.7] #0 Sql->query called at [/produits/www/projeqtor/db/maintenanceFunctions.php:71]
2018-05-24 14:11:45.241 ***** ERROR ***** [V6.3.7] #1 runScript called at [/produits/www/projeqtor/db/maintenance.php:110]
2018-05-24 14:11:45.241 ***** ERROR ***** [V6.3.7] #2 include called at [/produits/www/projeqtor/tool/loginCheck.php:143]
2018-05-24 14:11:45.241 ===== TRACE =====
2018-05-24 14:11:45.241 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V6.4.3 (see above message)
2018-05-24 14:11:45.241 ===== TRACE =====
2018-05-24 14:11:45.241 ===== TRACE ===== *************************************************
2018-05-24 14:11:45.242 ===== TRACE =====
2018-05-24 14:11:45.242 ===== TRACE =====
2018-05-24 14:11:45.242 ===== TRACE ===== DATABASE UPDATED
2018-05-24 14:11:45.242 ===== TRACE ===== WITH 1 ERROR
2018-05-24 14:11:45.242 ===== TRACE =====
2018-05-24 14:11:45.242 ===== TRACE ===== =====================================

All others DB update from 6.5.0 to 7.0.9 are OK.

could you help us on these errors .

thank's a lot.

Best regards.

Hi babynus,
sorry, but i dont understand your reply.

I've just perform the migration process. I never modify the database directly.
so How i could put these wrong data, and how i can repair this issue now.

Thank's for your reply.

Hi, babynus and all other,

we experiencing another issue during migration process :

lot of database error see below, could you help us on these errors :

2018-07-24 13:28:59.265 ===== TRACE ===== NEW CONNECTED USER 'admin'
2018-07-24 15:29:50.215 ===== TRACE ===== DISCONNECTED USER 'admin'
2018-07-24 15:31:17.891 ===== TRACE =====
2018-07-24 15:31:17.891 ===== TRACE ===== =====================================
2018-07-24 15:31:17.891 ===== TRACE =====
2018-07-24 15:31:17.891 ===== TRACE ===== DataBase actual Version = V6.3.7
2018-07-24 15:31:17.891 ===== TRACE ===== ProjeQtOr actual Version = V7.0.9
2018-07-24 15:31:17.891 ===== TRACE =====
2018-07-24 15:31:17.891 ===== TRACE ===== =====================================
2018-07-24 15:31:17.891 ===== TRACE =====
2018-07-24 15:31:17.891 ===== TRACE ===== VERSION V6.4.0
2018-07-24 15:31:17.891 ===== TRACE =====
2018-07-24 15:31:17.892 ===== TRACE ===== 2 lines inserted into table "event".
2018-07-24 15:31:17.893 ===== TRACE ===== 2 lines inserted into table "parameter".
2018-07-24 15:31:17.894 ===== TRACE ===== 2 lines inserted into table "parameter".
2018-07-24 15:31:17.903 ===== TRACE ===== Table "report" altered.
2018-07-24 15:31:17.904 ===== TRACE ===== 2 lines inserted into table "parameter".
2018-07-24 15:31:17.905 ===== TRACE ===== 1 lines inserted into table "reportparameter".
2018-07-24 15:31:17.906 ***** ERROR ***** [V6.3.7] Exception-[42S01] SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'versioncompatibility' already exists
2018-07-24 15:31:17.906 ***** ERROR ***** [V6.3.7] For query : CREATE TABLE `versioncompatibility` (
`id` int(12) unsigned NOT NULL AUTO_INCREMENT,
`idVersionA` int(12) unsigned DEFAULT NULL,
`idVersionB` int(12) unsigned DEFAULT NULL,
`creationDate` date,
`idUser` int(12) unsigned DEFAULT NULL,
`idle` int(1) DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
2018-07-24 15:31:17.906 ***** ERROR ***** [V6.3.7] Strack trace :
2018-07-24 15:31:17.906 ***** ERROR ***** [V6.3.7] #0 Sql->query called at [/produits/www/projeqtor/db/maintenanceFunctions.php:71]
2018-07-24 15:31:17.906 ***** ERROR ***** [V6.3.7] #1 runScript called at [/produits/www/projeqtor/db/maintenance.php:110]
2018-07-24 15:31:17.906 ***** ERROR ***** [V6.3.7] #2 include called at [/produits/www/projeqtor/tool/loginCheck.php:143]
2018-07-24 15:31:17.906 ===== TRACE =====
2018-07-24 15:31:17.906 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V6.4.0 (see above message)
2018-07-24 15:31:17.906 ===== TRACE =====
2018-07-24 15:31:17.906 ===== TRACE ===== *************************************************
2018-07-24 15:31:17.906 ===== TRACE =====
2018-07-24 15:31:17.911 ===== TRACE ===== Table "filter" altered.
2018-07-24 15:31:17.918 ===== TRACE ===== Table "filtercriteria" altered.
2018-07-24 15:31:17.932 ===== TRACE ===== Table "filtercriteria" altered.
2018-07-24 15:31:17.932 ===== TRACE ===== 2 lines inserted into table "event".
2018-07-24 15:31:17.933 ===== TRACE ===== 1 lines inserted into table "importable".
2018-07-24 15:31:17.933 ===== TRACE =====
2018-07-24 15:31:17.933 ===== TRACE ===== DATABASE UPDATED
2018-07-24 15:31:17.933 ===== TRACE ===== WITH 1 ERROR
2018-07-24 15:31:17.933 ===== TRACE =====
2018-07-24 15:31:17.933 ===== TRACE ===== =====================================
2018-07-24 15:31:17.933 ===== TRACE =====
2018-07-24 15:31:17.933 ===== TRACE ===== VERSION V6.4.1
2018-07-24 15:31:17.933 ===== TRACE =====
2018-07-24 15:31:17.936 ===== TRACE ===== Table "dependency" altered.
2018-07-24 15:31:17.964 ===== TRACE ===== Table "dependency" altered.
2018-07-24 15:31:17.967 ===== TRACE ===== Table "dependency" altered.
2018-07-24 15:31:17.967 ===== TRACE =====
2018-07-24 15:31:17.967 ===== TRACE ===== DATABASE UPDATED
2018-07-24 15:31:17.967 ===== TRACE ===== WITH NO ERROR
2018-07-24 15:31:17.967 ===== TRACE =====
2018-07-24 15:31:17.967 ===== TRACE ===== =====================================
2018-07-24 15:31:17.967 ===== TRACE =====
2018-07-24 15:31:17.967 ===== TRACE ===== VERSION V6.4.2
2018-07-24 15:31:17.968 ===== TRACE =====
2018-07-24 15:31:17.969 ===== TRACE ===== 8 lines inserted into table "habilitationother".
2018-07-24 15:31:17.969 ===== TRACE =====
2018-07-24 15:31:17.969 ===== TRACE ===== DATABASE UPDATED
2018-07-24 15:31:17.969 ===== TRACE ===== WITH NO ERROR
2018-07-24 15:31:17.969 ===== TRACE =====
2018-07-24 15:31:17.969 ===== TRACE ===== =====================================
2018-07-24 15:31:17.969 ===== TRACE =====
2018-07-24 15:31:17.969 ===== TRACE ===== VERSION V6.4.3
2018-07-24 15:31:17.969 ===== TRACE =====
2018-07-24 15:31:17.970 ===== TRACE ===== 2 lines inserted into table "importable".
2018-07-24 15:31:17.970 ===== TRACE =====
2018-07-24 15:31:17.970 ===== TRACE ===== DATABASE UPDATED
2018-07-24 15:31:17.970 ===== TRACE ===== WITH NO ERROR
2018-07-24 15:31:17.970 ===== TRACE =====
2018-07-24 15:31:17.970 ===== TRACE ===== =====================================
2018-07-24 15:31:17.970 ===== TRACE =====
2018-07-24 15:31:17.970 ===== TRACE ===== VERSION V6.5.0
2018-07-24 15:31:17.970 ===== TRACE =====
2018-07-24 15:31:17.971 ===== TRACE ===== 1 lines inserted into table "checklistable".
2018-07-24 15:31:17.977 ===== TRACE ===== Table "ticket" altered.
2018-07-24 15:31:17.983 ===== TRACE ===== Table "delay" altered.
2018-07-24 15:31:17.984 ===== TRACE ===== 1 lines inserted into table "reportparameter".
2018-07-24 15:31:17.985 ===== TRACE ===== 1 lines inserted into table "report".
2018-07-24 15:31:17.986 ===== TRACE ===== 1 lines inserted into table "habilitationreport".
2018-07-24 15:31:17.987 ===== TRACE ===== 7 lines inserted into table "reportparameter".
2018-07-24 15:31:17.993 ===== TRACE ===== 2 lines inserted into table "report".
2018-07-24 15:31:17.996 ===== TRACE ===== 4 lines inserted into table "habilitationreport".
2018-07-24 15:31:17.997 ===== TRACE ===== 4 lines inserted into table "habilitationreport".
2018-07-24 15:31:17.998 ===== TRACE ===== 3 lines inserted into table "reportparameter".
2018-07-24 15:31:17.998 ===== TRACE ===== 3 lines inserted into table "reportparameter".
2018-07-24 15:31:18.005 ===== TRACE ===== Table "billline" altered.
2018-07-24 15:31:18.012 ===== TRACE ===== Table "ticket" altered.
2018-07-24 15:31:18.013 ===== TRACE ===== 1 lines inserted into table "report".
2018-07-24 15:31:18.014 ===== TRACE ===== 4 lines inserted into table "habilitationreport".
2018-07-24 15:31:18.015 ===== TRACE ===== 2 lines inserted into table "reportparameter".
2018-07-24 15:31:18.021 ===== TRACE ===== Table "statusmail" altered.
2018-07-24 15:31:18.023 ===== TRACE ===== 65 lines inserted into table "today".
2018-07-24 15:31:18.028 ===== TRACE ===== Table "indicatordefinition" altered.
2018-07-24 15:31:18.034 ===== TRACE ===== Table "statusmail" altered.
2018-07-24 15:31:18.035 ===== TRACE ===== 3 lines inserted into table "menu".
2018-07-24 15:31:18.037 ===== TRACE ===== 24 lines inserted into table "habilitation".
2018-07-24 15:31:18.042 ===== TRACE ===== Table "testcase" altered.
2018-07-24 15:31:18.048 ===== TRACE ===== Table "testcase" altered.
2018-07-24 15:31:18.053 ===== TRACE ===== Table "statusmail" altered.
2018-07-24 15:31:18.058 ===== TRACE ===== Table "delay" altered.
2018-07-24 15:31:18.063 ===== TRACE ===== Table "indicatordefinition" altered.
2018-07-24 15:31:18.064 ===== TRACE ===== 1 lines inserted into table "parameter".
2018-07-24 15:31:18.167 ===== TRACE ===== Table "projecthistory" altered.
2018-07-24 15:31:18.239 ===== TRACE ===== Table "projecthistory" altered.
2018-07-24 15:31:18.240 ===== TRACE ===== 1 lines updated into table "report".
2018-07-24 15:31:18.241 ===== TRACE ===== 1 lines updated into table "report".
2018-07-24 15:31:18.241 ===== TRACE ===== 1 lines updated into table "reportparameter".
2018-07-24 15:31:18.247 ===== TRACE ===== Table "indicatordefinition" altered.
2018-07-24 15:31:18.253 ===== TRACE ===== Table "indicatordefinition" altered.
2018-07-24 15:31:18.257 ===== TRACE ===== Table "delivery" altered.
2018-07-24 15:31:18.267 ===== TRACE ===== Table "delivery" altered.
2018-07-24 15:31:18.272 ===== TRACE ===== Table "delivery" altered.
2018-07-24 15:31:18.277 ===== TRACE ===== Table "delivery" altered.
2018-07-24 15:31:18.281 ===== TRACE ===== Table "delivery" altered.
2018-07-24 15:31:18.285 ===== TRACE ===== Table "delivery" altered.
2018-07-24 15:31:18.290 ===== TRACE ===== Table "delivery" altered.
2018-07-24 15:31:18.294 ===== TRACE ===== Table "delivery" altered.
2018-07-24 15:31:18.305 ===== TRACE ===== Table "delivery" altered.
2018-07-24 15:31:18.306 ===== TRACE ===== 1 lines inserted into table "menu".
2018-07-24 15:31:18.313 ===== TRACE ===== 1 lines inserted into table "habilitation".
2018-07-24 15:31:18.321 ===== TRACE ===== Table "ticket" altered.
2018-07-24 15:31:18.322 ===== TRACE ===== 16 lines updated into table "ticket".
2018-07-24 15:31:18.330 ===== TRACE ===== Table "statusmail" altered.
2018-07-24 15:31:18.335 ===== TRACE ===== Table "indicatordefinition" altered.
2018-07-24 15:31:18.340 ===== TRACE ===== Table "indicatordefinition" altered.
2018-07-24 15:31:18.346 ===== TRACE ===== Table "requirement" altered.
2018-07-24 15:31:18.363 ===== TRACE ===== Index "requirementPriority" created.
2018-07-24 15:31:18.363 ===== TRACE ===== 1 lines inserted into table "report".
2018-07-24 15:31:18.364 ===== TRACE ===== 1 lines inserted into table "habilitationreport".
2018-07-24 15:31:18.365 ===== TRACE ===== 5 lines inserted into table "reportparameter".
2018-07-24 15:31:18.366 ===== TRACE ===== 1 lines inserted into table "report".
2018-07-24 15:31:18.367 ===== TRACE ===== 1 lines inserted into table "habilitationreport".
2018-07-24 15:31:18.367 ===== TRACE ===== 4 lines inserted into table "reportparameter".
2018-07-24 15:31:18.368 ===== TRACE ===== 1 lines inserted into table "report".
2018-07-24 15:31:18.369 ===== TRACE ===== 1 lines inserted into table "habilitationreport".
2018-07-24 15:31:18.369 ===== TRACE ===== 5 lines inserted into table "reportparameter".
2018-07-24 15:31:18.370 ===== TRACE ===== 1 lines inserted into table "report".
2018-07-24 15:31:18.371 ===== TRACE ===== 1 lines inserted into table "habilitationreport".
2018-07-24 15:31:18.372 ===== TRACE ===== 5 lines inserted into table "reportparameter".
2018-07-24 15:31:18.377 ===== TRACE ===== Table "testcase" altered.
2018-07-24 15:31:18.383 ===== TRACE ===== Table "testsession" altered.
2018-07-24 15:31:18.383 ***** ERROR ***** [V6.3.7] Exception-[42S01] SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'versionlanguage' already exists
2018-07-24 15:31:18.383 ***** ERROR ***** [V6.3.7] For query : CREATE TABLE `versionlanguage` (
`id` int(12) unsigned NOT NULL AUTO_INCREMENT,
`idVersion` int(12) unsigned DEFAULT NULL,
`scope` varchar(100) DEFAULT NULL,
`idLanguage` int(12) unsigned NOT NULL,
`creationDate` date NOT NULL,
`idUser` int(12) unsigned NOT NULL,
`idle` int(1) unsigned NOT NULL DEFAULT 0,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2018-07-24 15:31:18.384 ***** ERROR ***** [V6.3.7] Strack trace :
2018-07-24 15:31:18.384 ***** ERROR ***** [V6.3.7] #0 Sql->query called at [/produits/www/projeqtor/db/maintenanceFunctions.php:71]
2018-07-24 15:31:18.384 ***** ERROR ***** [V6.3.7] #1 runScript called at [/produits/www/projeqtor/db/maintenance.php:110]
2018-07-24 15:31:18.384 ***** ERROR ***** [V6.3.7] #2 include called at [/produits/www/projeqtor/tool/loginCheck.php:143]
2018-07-24 15:31:18.384 ===== TRACE =====
2018-07-24 15:31:18.384 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V6.5.0 (see above message)
2018-07-24 15:31:18.384 ===== TRACE =====
2018-07-24 15:31:18.384 ===== TRACE ===== *************************************************
2018-07-24 15:31:18.384 ===== TRACE =====
2018-07-24 15:31:18.390 ===== TRACE ===== Table "productlanguage" altered.
2018-07-24 15:31:18.390 ***** ERROR ***** [V6.3.7] Exception-[42S01] SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'versioncontext' already exists
2018-07-24 15:31:18.390 ***** ERROR ***** [V6.3.7] For query : CREATE TABLE `versioncontext` (
`id` int(12) unsigned NOT NULL AUTO_INCREMENT,
`idVersion` int(12) unsigned DEFAULT NULL,
`scope` varchar(100) DEFAULT NULL,
`idContext` int(12) unsigned NOT NULL,
`creationDate` date NOT NULL,
`idUser` int(12) unsigned NOT NULL,
`idle` int(1) unsigned NOT NULL DEFAULT 0,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2018-07-24 15:31:18.390 ***** ERROR ***** [V6.3.7] Strack trace :
2018-07-24 15:31:18.390 ***** ERROR ***** [V6.3.7] #0 Sql->query called at [/produits/www/projeqtor/db/maintenanceFunctions.php:71]
2018-07-24 15:31:18.390 ***** ERROR ***** [V6.3.7] #1 runScript called at [/produits/www/projeqtor/db/maintenance.php:110]
2018-07-24 15:31:18.390 ***** ERROR ***** [V6.3.7] #2 include called at [/produits/www/projeqtor/tool/loginCheck.php:143]
2018-07-24 15:31:18.390 ===== TRACE =====
2018-07-24 15:31:18.390 ===== TRACE ===== Error # 2 => SQL error while executing maintenance query for version V6.5.0 (see above message)
2018-07-24 15:31:18.390 ===== TRACE =====
2018-07-24 15:31:18.390 ===== TRACE ===== *************************************************
2018-07-24 15:31:18.391 ===== TRACE =====
2018-07-24 15:31:18.395 ===== TRACE ===== Table "productcontext" altered.
2018-07-24 15:31:18.395 ===== TRACE ===== 0 lines updated into table "productlanguage".
2018-07-24 15:31:18.395 ===== TRACE ===== 0 lines updated into table "productlanguage".
2018-07-24 15:31:18.396 ===== TRACE ===== 0 lines deleted from table "tempupdate".
2018-07-24 15:31:18.396 ===== TRACE ===== 0 lines inserted into table "tempupdate".
2018-07-24 15:31:18.396 ===== TRACE ===== 0 lines updated into table "productlanguage".
2018-07-24 15:31:18.396 ===== TRACE ===== 0 lines deleted from table "tempupdate".
2018-07-24 15:31:18.397 ===== TRACE ===== 0 lines inserted into table "versionlanguage".
2018-07-24 15:31:18.397 ===== TRACE ===== 0 lines deleted from table "productlanguage".
2018-07-24 15:31:18.397 ===== TRACE ===== 0 lines updated into table "productlanguage".
2018-07-24 15:31:18.398 ===== TRACE ===== 0 lines updated into table "versionlanguage".
2018-07-24 15:31:18.398 ===== TRACE ===== 0 lines updated into table "productcontext".
2018-07-24 15:31:18.398 ===== TRACE ===== 0 lines updated into table "productcontext".
2018-07-24 15:31:18.398 ===== TRACE ===== 0 lines deleted from table "tempupdate".
2018-07-24 15:31:18.399 ===== TRACE ===== 0 lines inserted into table "tempupdate".
2018-07-24 15:31:18.399 ===== TRACE ===== 0 lines updated into table "productcontext".
2018-07-24 15:31:18.399 ===== TRACE ===== 0 lines deleted from table "tempupdate".
2018-07-24 15:31:18.399 ===== TRACE ===== 0 lines inserted into table "versioncontext".
2018-07-24 15:31:18.400 ===== TRACE ===== 0 lines deleted from table "productcontext".
2018-07-24 15:31:18.400 ===== TRACE ===== 0 lines updated into table "productcontext".
2018-07-24 15:31:18.400 ===== TRACE ===== 0 lines updated into table "versioncontext".
2018-07-24 15:31:18.400 ===== TRACE =====
2018-07-24 15:31:18.400 ===== TRACE ===== DATABASE UPDATED
2018-07-24 15:31:18.400 ===== TRACE ===== WITH 2 ERRORS
2018-07-24 15:31:18.400 ===== TRACE =====
2018-07-24 15:31:18.400 ===== TRACE ===== =====================================
2018-07-24 15:31:18.400 ===== TRACE =====
2018-07-24 15:31:18.401 ===== TRACE ===== VERSION V6.5.1
2018-07-24 15:31:18.401 ===== TRACE =====
2018-07-24 15:31:18.402 ===== TRACE ===== 1 lines updated into table "report".
2018-07-24 15:31:18.403 ===== TRACE ===== 1 lines updated into table "report".
2018-07-24 15:31:18.403 ===== TRACE ===== 2 lines updated into table "menu".
2018-07-24 15:31:18.406 ===== TRACE ===== 2 lines updated into table "reportparameter".
2018-07-24 15:31:18.406 ===== TRACE =====
2018-07-24 15:31:18.406 ===== TRACE ===== DATABASE UPDATED
2018-07-24 15:31:18.406 ===== TRACE ===== WITH NO ERROR
2018-07-24 15:31:18.406 ===== TRACE =====
2018-07-24 15:31:18.406 ===== TRACE ===== =====================================
2018-07-24 15:31:18.406 ===== TRACE =====
2018-07-24 15:31:18.406 ===== TRACE ===== VERSION V6.5.5
2018-07-24 15:31:18.406 ===== TRACE =====
2018-07-24 15:31:18.412 ===== TRACE ===== Table "menu" altered.
2018-07-24 15:31:18.413 ===== TRACE ===== 13 lines updated into table "menu".
2018-07-24 15:31:18.413 ===== TRACE =====
2018-07-24 15:31:18.413 ===== TRACE ===== DATABASE UPDATED
2018-07-24 15:31:18.413 ===== TRACE ===== WITH NO ERROR
2018-07-24 15:31:18.413 ===== TRACE =====
2018-07-24 15:31:18.413 ===== TRACE ===== =====================================
2018-07-24 15:31:18.413 ===== TRACE =====
2018-07-24 15:31:18.413 ===== TRACE ===== VERSION V6.6.0
2018-07-24 15:31:18.413 ===== TRACE =====
2018-07-24 15:31:18.414 ***** ERROR ***** [V6.3.7] Exception-[42S01] SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'emailtemplate' already exists
2018-07-24 15:31:18.414 ***** ERROR ***** [V6.3.7] For query : CREATE TABLE `emailtemplate` (
`id` int(12) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`title` varchar(500) DEFAULT NULL,
`template` mediumtext DEFAULT NULL,
`idMailable` int(12) DEFAULT NULL,
`idType` int(12) UNSIGNED DEFAULT NULL,
`idle` int(1) UNSIGNED DEFAULT 0,
PRIMARY KEY (`id`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
2018-07-24 15:31:18.414 ***** ERROR ***** [V6.3.7] Strack trace :
2018-07-24 15:31:18.414 ***** ERROR ***** [V6.3.7] #0 Sql->query called at [/produits/www/projeqtor/db/maintenanceFunctions.php:71]
2018-07-24 15:31:18.414 ***** ERROR ***** [V6.3.7] #1 runScript called at [/produits/www/projeqtor/db/maintenance.php:110]
2018-07-24 15:31:18.414 ***** ERROR ***** [V6.3.7] #2 include called at [/produits/www/projeqtor/tool/loginCheck.php:143]
2018-07-24 15:31:18.414 ===== TRACE =====
2018-07-24 15:31:18.414 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V6.6.0 (see above message)
2018-07-24 15:31:18.414 ===== TRACE =====
2018-07-24 15:31:18.414 ===== TRACE ===== *************************************************
2018-07-24 15:31:18.414 ===== TRACE =====
2018-07-24 15:31:18.414 ***** ERROR ***** [V6.3.7] Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'emailtemplateMailable'
2018-07-24 15:31:18.414 ***** ERROR ***** [V6.3.7] For query : CREATE INDEX `emailtemplateMailable` ON `emailtemplate` (`idMailable`);
2018-07-24 15:31:18.414 ***** ERROR ***** [V6.3.7] Strack trace :
2018-07-24 15:31:18.415 ***** ERROR ***** [V6.3.7] #0 Sql->query called at [/produits/www/projeqtor/db/maintenanceFunctions.php:71]
2018-07-24 15:31:18.415 ***** ERROR ***** [V6.3.7] #1 runScript called at [/produits/www/projeqtor/db/maintenance.php:110]
2018-07-24 15:31:18.415 ***** ERROR ***** [V6.3.7] #2 include called at [/produits/www/projeqtor/tool/loginCheck.php:143]
2018-07-24 15:31:18.415 ===== TRACE =====
2018-07-24 15:31:18.415 ===== TRACE ===== Error # 2 => SQL error while executing maintenance query for version V6.6.0 (see above message)
2018-07-24 15:31:18.415 ===== TRACE =====
2018-07-24 15:31:18.415 ===== TRACE ===== *************************************************
2018-07-24 15:31:18.415 ===== TRACE =====
2018-07-24 15:31:18.415 ===== TRACE ===== 1 lines inserted into table "menu".
2018-07-24 15:31:18.417 ===== TRACE ===== 1 lines inserted into table "habilitation".
2018-07-24 15:31:18.423 ===== TRACE ===== Table "statusmail" altered.
2018-07-24 15:31:18.424 ===== TRACE ===== 1 lines inserted into table "parameter".
2018-07-24 15:31:18.424 ===== TRACE ===== 1 lines inserted into table "parameter".
2018-07-24 15:31:18.425 ***** ERROR ***** [V6.3.7] Exception-[42S01] SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'statusnotification' already exists
2018-07-24 15:31:18.425 ***** ERROR ***** [V6.3.7] For query : CREATE TABLE `statusnotification` (
`id` INT(12) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(100) DEFAULT NULL,
`color` VARCHAR(7) DEFAULT NULL,
PRIMARY KEY (`id`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
2018-07-24 15:31:18.425 ***** ERROR ***** [V6.3.7] Strack trace :
2018-07-24 15:31:18.425 ***** ERROR ***** [V6.3.7] #0 Sql->query called at [/produits/www/projeqtor/db/maintenanceFunctions.php:71]
2018-07-24 15:31:18.425 ***** ERROR ***** [V6.3.7] #1 runScript called at [/produits/www/projeqtor/db/maintenance.php:110]
2018-07-24 15:31:18.425 ***** ERROR ***** [V6.3.7] #2 include called at [/produits/www/projeqtor/tool/loginCheck.php:143]
2018-07-24 15:31:18.425 ===== TRACE =====
2018-07-24 15:31:18.425 ===== TRACE ===== Error # 3 => SQL error while executing maintenance query for version V6.6.0 (see above message)
2018-07-24 15:31:18.425 ===== TRACE =====
2018-07-24 15:31:18.425 ===== TRACE ===== *************************************************
2018-07-24 15:31:18.425 ===== TRACE =====
2018-07-24 15:31:18.425 ***** ERROR ***** [V6.3.7] Exception-[23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'PRIMARY'
2018-07-24 15:31:18.425 ***** ERROR ***** [V6.3.7] For query : INSERT INTO `statusnotification` (`id`, `name`, `color`) VALUES(1, 'unread', '#ff7f50');
2018-07-24 15:31:18.425 ***** ERROR ***** [V6.3.7] Strack trace :
2018-07-24 15:31:18.426 ***** ERROR ***** [V6.3.7] #0 Sql->query called at [/produits/www/projeqtor/db/maintenanceFunctions.php:71]
2018-07-24 15:31:18.426 ***** ERROR ***** [V6.3.7] #1 runScript called at [/produits/www/projeqtor/db/maintenance.php:110]
2018-07-24 15:31:18.426 ***** ERROR ***** [V6.3.7] #2 include called at [/produits/www/projeqtor/tool/loginCheck.php:143]
2018-07-24 15:31:18.426 ===== TRACE =====
2018-07-24 15:31:18.426 ===== TRACE ===== Error # 4 => SQL error while executing maintenance query for version V6.6.0 (see above message)
2018-07-24 15:31:18.426 ===== TRACE =====
2018-07-24 15:31:18.426 ===== TRACE ===== *************************************************
2018-07-24 15:31:18.426 ===== TRACE =====
2018-07-24 15:31:18.426 ***** ERROR ***** [V6.3.7] Exception-[23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2' for key 'PRIMARY'
2018-07-24 15:31:18.426 ***** ERROR ***** [V6.3.7] For query : INSERT INTO `statusnotification` (`id`, `name`, `color`) VALUES(2, 'read', '#32CD32');
2018-07-24 15:31:18.426 ***** ERROR ***** [V6.3.7] Strack trace :
2018-07-24 15:31:18.426 ***** ERROR ***** [V6.3.7] #0 Sql->query called at [/produits/www/projeqtor/db/maintenanceFunctions.php:71]
2018-07-24 15:31:18.426 ***** ERROR ***** [V6.3.7] #1 runScript called at [/produits/www/projeqtor/db/maintenance.php:110]
2018-07-24 15:31:18.426 ***** ERROR ***** [V6.3.7] #2 include called at [/produits/www/projeqtor/tool/loginCheck.php:143]
2018-07-24 15:31:18.426 ===== TRACE =====
2018-07-24 15:31:18.426 ===== TRACE ===== Error # 5 => SQL error while executing maintenance query for version V6.6.0 (see above message)
2018-07-24 15:31:18.426 ===== TRACE =====
2018-07-24 15:31:18.426 ===== TRACE ===== *************************************************
2018-07-24 15:31:18.426 ===== TRACE =====
2018-07-24 15:31:18.427 ***** ERROR ***** [V6.3.7] Exception-[42S01] SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'notification' already exists
2018-07-24 15:31:18.427 ***** ERROR ***** [V6.3.7] For query : CREATE TABLE `notification` (
`id` INT(12) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(100) DEFAULT NULL,
`idNotificationDefinition` INT(12) UNSIGNED DEFAULT NULL,
`idNotifiable` INT(12) UNSIGNED DEFAULT NULL,
`idMenu` INT(12) UNSIGNED DEFAULT NULL,
`idNotificationType` INT(12) UNSIGNED DEFAULT NULL,
`idUser` INT(12) UNSIGNED DEFAULT NULL,
`idResource` INT(12) UNSIGNED DEFAULT NULL,
`idStatusNotification` INT(12) UNSIGNED DEFAULT NULL,
`title` VARCHAR(4000) DEFAULT NULL,
`content` MEDIUMTEXT DEFAULT NULL,
`creationDateTime` DATETIME DEFAULT NULL,
`notificationDate` DATE DEFAULT NULL,
`notificationTime` TIME DEFAULT NULL,
`notifiedObjectId` INT(12) UNSIGNED DEFAULT NULL,
`sendEmail` INT(1) NOT NULL DEFAULT 0,
`emailSent` INT(1) NOT NULL DEFAULT 0,
`idle` INT(1) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
2018-07-24 15:31:18.427 ***** ERROR ***** [V6.3.7] Strack trace :
2018-07-24 15:31:18.427 ***** ERROR ***** [V6.3.7] #0 Sql->query called at [/produits/www/projeqtor/db/maintenanceFunctions.php:71]
2018-07-24 15:31:18.427 ***** ERROR ***** [V6.3.7] #1 runScript called at [/produits/www/projeqtor/db/maintenance.php:110]
2018-07-24 15:31:18.427 ***** ERROR ***** [V6.3.7] #2 include called at [/produits/www/projeqtor/tool/loginCheck.php:143]
2018-07-24 15:31:18.427 ===== TRACE =====
2018-07-24 15:31:18.427 ===== TRACE ===== Error # 6 => SQL error while executing maintenance query for version V6.6.0 (see above message)
2018-07-24 15:31:18.427 ===== TRACE =====
2018-07-24 15:31:18.427 ===== TRACE ===== *************************************************
2018-07-24 15:31:18.427 ===== TRACE =====
2018-07-24 15:31:18.427 ***** ERROR ***** [V6.3.7] Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'notificationHasNotificationDefinition_idx'
2018-07-24 15:31:18.427 ***** ERROR ***** [V6.3.7] For query : CREATE INDEX `notificationHasNotificationDefinition_idx` ON `notification` (`idNotificationDefinition`);
2018-07-24 15:31:18.427 ***** ERROR ***** [V6.3.7] Strack trace :
2018-07-24 15:31:18.427 ***** ERROR ***** [V6.3.7] #0 Sql->query called at [/produits/www/projeqtor/db/maintenanceFunctions.php:71]
2018-07-24 15:31:18.428 ***** ERROR ***** [V6.3.7] #1 runScript called at [/produits/www/projeqtor/db/maintenance.php:110]
2018-07-24 15:31:18.428 ***** ERROR ***** [V6.3.7] #2 include called at [/produits/www/projeqtor/tool/loginCheck.php:143]
2018-07-24 15:31:18.428 ===== TRACE =====
2018-07-24 15:31:18.428 ===== TRACE ===== Error # 7 => SQL error while executing maintenance query for version V6.6.0 (see above message)
2018-07-24 15:31:18.428 ===== TRACE =====
2018-07-24 15:31:18.428 ===== TRACE ===== *************************************************
2018-07-24 15:31:18.428 ===== TRACE =====
2018-07-24 15:31:18.428 ***** ERROR ***** [V6.3.7] Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'notificationNotifiable_idx'
2018-07-24 15:31:18.428 ***** ERROR ***** [V6.3.7] For query : CREATE INDEX `notificationNotifiable_idx` ON `notification` (`idNotifiable`);
2018-07-24 15:31:18.428 ***** ERROR ***** [V6.3.7] Strack trace :
2018-07-24 15:31:18.428 ***** ERROR ***** [V6.3.7] #0 Sql->query called at [/produits/www/projeqtor/db/maintenanceFunctions.php:71]
2018-07-24 15:31:18.428 ***** ERROR ***** [V6.3.7] #1 runScript called at [/produits/www/projeqtor/db/maintenance.php:110]
2018-07-24 15:31:18.428 ***** ERROR ***** [V6.3.7] #2 include called at [/produits/www/projeqtor/tool/loginCheck.php:143]
2018-07-24 15:31:18.428 ===== TRACE =====
2018-07-24 15:31:18.428 ===== TRACE ===== Error # 8 => SQL error while executing maintenance query for version V6.6.0 (see above message)
2018-07-24 15:31:18.428 ===== TRACE =====
2018-07-24 15:31:18.428 ===== TRACE ===== *************************************************
2018-07-24 15:31:18.428 ===== TRACE =====
2018-07-24 15:31:18.429 ***** ERROR ***** [V6.3.7] Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'notificationStatusNotification_idx'
2018-07-24 15:31:18.429 ***** ERROR ***** [V6.3.7] For query : CREATE INDEX `notificationStatusNotification_idx` ON `notification` (`idStatusNotification`);
2018-07-24 15:31:18.429 ***** ERROR ***** [V6.3.7] Strack trace :
2018-07-24 15:31:18.429 ***** ERROR ***** [V6.3.7] #0 Sql->query called at [/produits/www/projeqtor/db/maintenanceFunctions.php:71]
2018-07-24 15:31:18.429 ***** ERROR ***** [V6.3.7] #1 runScript called at [/produits/www/projeqtor/db/maintenance.php:110]
2018-07-24 15:31:18.429 ***** ERROR ***** [V6.3.7] #2 include called at [/produits/www/projeqtor/tool/loginCheck.php:143]
2018-07-24 15:31:18.429 ===== TRACE =====
2018-07-24 15:31:18.429 ===== TRACE ===== Error # 9 => SQL error while executing maintenance query for version V6.6.0 (see above message)
2018-07-24 15:31:18.429 ===== TRACE =====
2018-07-24 15:31:18.429 ===== TRACE ===== *************************************************
2018-07-24 15:31:18.429 ===== TRACE =====
2018-07-24 15:31:18.429 ***** ERROR ***** [V6.3.7] Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'notificationNotificationType_idx'
2018-07-24 15:31:18.429 ***** ERROR ***** [V6.3.7] For query : CREATE INDEX `notificationNotificationType_idx` ON `notification` (`idNotificationType`);
2018-07-24 15:31:18.429 ***** ERROR ***** [V6.3.7] Strack trace :
2018-07-24 15:31:18.429 ***** ERROR ***** [V6.3.7] #0 Sql->query called at [/produits/www/projeqtor/db/maintenanceFunctions.php:71]
2018-07-24 15:31:18.429 ***** ERROR ***** [V6.3.7] #1 runScript called at [/produits/www/projeqtor/db/maintenance.php:110]
2018-07-24 15:31:18.429 ***** ERROR ***** [V6.3.7] #2 include called at [/produits/www/projeqtor/tool/loginCheck.php:143]
2018-07-24 15:31:18.429 ===== TRACE =====
2018-07-24 15:31:18.429 ===== TRACE ===== Error # 10 => SQL error while executing maintenance query for version V6.6.0 (see above message)
2018-07-24 15:31:18.429 ===== TRACE =====
2018-07-24 15:31:18.429 ===== TRACE ===== *************************************************
2018-07-24 15:31:18.429 ===== TRACE =====
2018-07-24 15:31:18.430 ***** ERROR ***** [V6.3.7] Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'notificationMenu_idx'
2018-07-24 15:31:18.430 ***** ERROR ***** [V6.3.7] For query : CREATE INDEX `notificationMenu_idx` ON `notification` (`idMenu`);
2018-07-24 15:31:18.430 ***** ERROR ***** [V6.3.7] Strack trace :
2018-07-24 15:31:18.430 ***** ERROR ***** [V6.3.7] #0 Sql->query called at [/produits/www/projeqtor/db/maintenanceFunctions.php:71]
2018-07-24 15:31:18.430 ***** ERROR ***** [V6.3.7] #1 runScript called at [/produits/www/projeqtor/db/maintenance.php:110]
2018-07-24 15:31:18.430 ***** ERROR ***** [V6.3.7] #2 include called at [/produits/www/projeqtor/tool/loginCheck.php:143]
2018-07-24 15:31:18.430 ===== TRACE =====
2018-07-24 15:31:18.430 ===== TRACE ===== Error # 11 => SQL error while executing maintenance query for version V6.6.0 (see above message)
2018-07-24 15:31:18.430 ===== TRACE =====
2018-07-24 15:31:18.430 ===== TRACE ===== *************************************************
2018-07-24 15:31:18.430 ===== TRACE =====
2018-07-24 15:31:18.430 ***** ERROR ***** [V6.3.7] Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'notificationResource_idx'
2018-07-24 15:31:18.430 ***** ERROR ***** [V6.3.7] For query : CREATE INDEX `notificationResource_idx` ON `notification` (`idResource`);
2018-07-24 15:31:18.430 ***** ERROR ***** [V6.3.7] Strack trace :
2018-07-24 15:31:18.430 ***** ERROR ***** [V6.3.7] #0 Sql->query called at [/produits/www/projeqtor/db/maintenanceFunctions.php:71]
2018-07-24 15:31:18.430 ***** ERROR ***** [V6.3.7] #1 runScript called at [/produits/www/projeqtor/db/maintenance.php:110]
2018-07-24 15:31:18.430 ***** ERROR ***** [V6.3.7] #2 include called at [/produits/www/projeqtor/tool/loginCheck.php:143]
2018-07-24 15:31:18.431 ===== TRACE =====
2018-07-24 15:31:18.431 ===== TRACE ===== Error # 12 => SQL error while executing maintenance query for version V6.6.0 (see above message)
2018-07-24 15:31:18.431 ===== TRACE =====
2018-07-24 15:31:18.431 ===== TRACE ===== *************************************************
2018-07-24 15:31:18.431 ===== TRACE =====
2018-07-24 15:31:18.431 ***** ERROR ***** [V6.3.7] Exception-[42S01] SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'notificationdefinition' already exists
2018-07-24 15:31:18.431 ***** ERROR ***** [V6.3.7] For query : CREATE TABLE `notificationdefinition` (
`id` INT(12) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(100) DEFAULT NULL,
`idNotifiable` INT(12) UNSIGNED DEFAULT NULL,
`idMenu` INT(12) UNSIGNED DEFAULT NULL,
`idNotificationType` INT(12) UNSIGNED DEFAULT NULL,
`title` VARCHAR(100) DEFAULT NULL,
`content` MEDIUMTEXT DEFAULT NULL,
`notificationRule` VARCHAR(400) DEFAULT NULL,
`notificationReceivers` VARCHAR(400) DEFAULT NULL,
`sendEmail` INT(1) NOT NULL DEFAULT 0,
`targetDateNotifiableField` VARCHAR(100) DEFAULT NULL,
`everyDay` INT(1) NOT NULL DEFAULT 0,
`everyWeek` INT(1) NOT NULL DEFAULT 0,
`everyMonth` INT(1) NOT NULL DEFAULT 0,
`everyYear` INT(1) NOT NULL DEFAULT 0,
`fixedDay` INT(5) DEFAULT NULL,
`fixedMonth` INT(5) DEFAULT NULL,
`notificationNbRepeatsBefore` INT(5) DEFAULT NULL,
`notificationGenerateBefore` INT(5) DEFAULT NULL,
`notificationGenerateBeforeInMin` INT(5) DEFAULT NULL,
`idle` INT(1) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
2018-07-24 15:31:18.431 ***** ERROR ***** [V6.3.7] Strack trace :
2018-07-24 15:31:18.431 ***** ERROR ***** [V6.3.7] #0 Sql->query called at [/produits/www/projeqtor/db/maintenanceFunctions.php:71]
2018-07-24 15:31:18.431 ***** ERROR ***** [V6.3.7] #1 runScript called at [/produits/www/projeqtor/db/maintenance.php:110]
2018-07-24 15:31:18.431 ***** ERROR ***** [V6.3.7] #2 include called at [/produits/www/projeqtor/tool/loginCheck.php:143]
2018-07-24 15:31:18.431 ===== TRACE =====
2018-07-24 15:31:18.431 ===== TRACE ===== Error # 13 => SQL error while executing maintenance query for version V6.6.0 (see above message)
2018-07-24 15:31:18.431 ===== TRACE =====
2018-07-24 15:31:18.431 ===== TRACE ===== *************************************************
2018-07-24 15:31:18.431 ===== TRACE =====
2018-07-24 15:31:18.432 ***** ERROR ***** [V6.3.7] Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'notificationdefinitionNotifiable_idx'
2018-07-24 15:31:18.432 ***** ERROR ***** [V6.3.7] For query : CREATE INDEX `notificationdefinitionNotifiable_idx` ON `notificationdefinition` (`idNotifiable`);
2018-07-24 15:31:18.432 ***** ERROR ***** [V6.3.7] Strack trace :
2018-07-24 15:31:18.432 ***** ERROR ***** [V6.3.7] #0 Sql->query called at [/produits/www/projeqtor/db/maintenanceFunctions.php:71]
2018-07-24 15:31:18.432 ***** ERROR ***** [V6.3.7] #1 runScript called at [/produits/www/projeqtor/db/maintenance.php:110]
2018-07-24 15:31:18.432 ***** ERROR ***** [V6.3.7] #2 include called at [/produits/www/projeqtor/tool/loginCheck.php:143]
2018-07-24 15:31:18.432 ===== TRACE =====
2018-07-24 15:31:18.432 ===== TRACE ===== Error # 14 => SQL error while executing maintenance query for version V6.6.0 (see above message)
2018-07-24 15:31:18.432 ===== TRACE =====
2018-07-24 15:31:18.432 ===== TRACE ===== *************************************************
2018-07-24 15:31:18.432 ===== TRACE =====
2018-07-24 15:31:18.432 ***** ERROR ***** [V6.3.7] Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'notificationdefinitionNotificationType_idx'
2018-07-24 15:31:18.432 ***** ERROR ***** [V6.3.7] For query : CREATE INDEX `notificationdefinitionNotificationType_idx` ON `notificationdefinition` (`idNotificationType`);
2018-07-24 15:31:18.432 ***** ERROR ***** [V6.3.7] Strack trace :
2018-07-24 15:31:18.432 ***** ERROR ***** [V6.3.7] #0 Sql->query called at [/produits/www/projeqtor/db/maintenanceFunctions.php:71]
2018-07-24 15:31:18.432 ***** ERROR ***** [V6.3.7] #1 runScript called at [/produits/www/projeqtor/db/maintenance.php:110]
2018-07-24 15:31:18.432 ***** ERROR ***** [V6.3.7] #2 include called at [/produits/www/projeqtor/tool/loginCheck.php:143]
2018-07-24 15:31:18.432 ===== TRACE =====
2018-07-24 15:31:18.432 ===== TRACE ===== Error # 15 => SQL error while executing maintenance query for version V6.6.0 (see above message)
2018-07-24 15:31:18.433 ===== TRACE =====
2018-07-24 15:31:18.433 ===== TRACE ===== *************************************************
2018-07-24 15:31:18.433 ===== TRACE =====
2018-07-24 15:31:18.433 ***** ERROR ***** [V6.3.7] Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'notificationdefinitionMenu_idx'
2018-07-24 15:31:18.433 ***** ERROR ***** [V6.3.7] For query : CREATE INDEX `notificationdefinitionMenu_idx` ON `notificationdefinition` (`idMenu`);
2018-07-24 15:31:18.433 ***** ERROR ***** [V6.3.7] Strack trace :
2018-07-24 15:31:18.433 ***** ERROR ***** [V6.3.7] #0 Sql->query called at [/produits/www/projeqtor/db/maintenanceFunctions.php:71]
2018-07-24 15:31:18.433 ***** ERROR ***** [V6.3.7] #1 runScript called at [/produits/www/projeqtor/db/maintenance.php:110]
2018-07-24 15:31:18.433 ***** ERROR ***** [V6.3.7] #2 include called at [/produits/www/projeqtor/tool/loginCheck.php:143]
2018-07-24 15:31:18.433 ===== TRACE =====
2018-07-24 15:31:18.433 ===== TRACE ===== Error # 16 => SQL error while executing maintenance query for version V6.6.0 (see above message)
2018-07-24 15:31:18.433 ===== TRACE =====
2018-07-24 15:31:18.433 ===== TRACE ===== *************************************************
2018-07-24 15:31:18.433 ===== TRACE =====
2018-07-24 15:31:18.433 ***** ERROR ***** [V6.3.7] Exception-[42S01] SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'notifiable' already exists
2018-07-24 15:31:18.433 ***** ERROR ***** [V6.3.7] For query : CREATE TABLE `notifiable` (
`id` INT(12) UNSIGNED NOT NULL AUTO_INCREMENT,
`notifiableItem` VARCHAR(100) DEFAULT NULL,
`name` VARCHAR(100) DEFAULT NULL,
`idle` INT(1) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
2018-07-24 15:31:18.433 ***** ERROR ***** [V6.3.7] Strack trace :
2018-07-24 15:31:18.433 ***** ERROR ***** [V6.3.7] #0 Sql->query called at [/produits/www/projeqtor/db/maintenanceFunctions.php:71]
2018-07-24 15:31:18.434 ***** ERROR ***** [V6.3.7] #1 runScript called at [/produits/www/projeqtor/db/maintenance.php:110]
2018-07-24 15:31:18.434 ***** ERROR ***** [V6.3.7] #2 include called at [/produits/www/projeqtor/tool/loginCheck.php:143]
2018-07-24 15:31:18.434 ===== TRACE =====
2018-07-24 15:31:18.434 ===== TRACE ===== Error # 17 => SQL error while executing maintenance query for version V6.6.0 (see above message)
2018-07-24 15:31:18.434 ===== TRACE =====
2018-07-24 15:31:18.434 ===== TRACE ===== *************************************************
2018-07-24 15:31:18.434 ===== TRACE =====
2018-07-24 15:31:18.435 ===== TRACE ===== 17 lines inserted into table "notifiable".
2018-07-24 15:31:18.436 ===== TRACE ===== 1 lines inserted into table "menu".
2018-07-24 15:31:18.437 ===== TRACE ===== 1 lines inserted into table "menu".
2018-07-24 15:31:18.439 ===== TRACE ===== 1 lines inserted into table "habilitation".
2018-07-24 15:31:18.439 ===== TRACE ===== 1 lines inserted into table "habilitation".
2018-07-24 15:31:18.440 ===== TRACE ===== 1 lines inserted into table "habilitation".
2018-07-24 15:31:18.441 ===== TRACE ===== 1 lines inserted into table "habilitation".
2018-07-24 15:31:18.441 ===== TRACE ===== 1 lines inserted into table "habilitation".
2018-07-24 15:31:18.442 ===== TRACE ===== 1 lines inserted into table "habilitation".
2018-07-24 15:31:18.443 ===== TRACE ===== 1 lines inserted into table "habilitation".
2018-07-24 15:31:18.443 ===== TRACE ===== 1 lines inserted into table "habilitation".
2018-07-24 15:31:18.444 ===== TRACE ===== 1 lines inserted into table "accessright".
2018-07-24 15:31:18.445 ===== TRACE ===== 1 lines inserted into table "accessright".
2018-07-24 15:31:18.445 ===== TRACE ===== 1 lines inserted into table "accessright".
2018-07-24 15:31:18.446 ===== TRACE ===== 1 lines inserted into table "accessright".
2018-07-24 15:31:18.447 ===== TRACE ===== 1 lines inserted into table "accessright".
2018-07-24 15:31:18.447 ===== TRACE ===== 1 lines inserted into table "accessright".
2018-07-24 15:31:18.448 ===== TRACE ===== 1 lines inserted into table "accessright".
2018-07-24 15:31:18.449 ===== TRACE ===== 1 lines inserted into table "accessright".
2018-07-24 15:31:18.449 ===== TRACE ===== 1 lines inserted into table "accessright".
2018-07-24 15:31:18.450 ===== TRACE ===== 1 lines inserted into table "accessright".
2018-07-24 15:31:18.452 ===== TRACE ===== 1 lines inserted into table "accessright".
2018-07-24 15:31:18.452 ===== TRACE ===== 1 lines inserted into table "accessright".
2018-07-24 15:31:18.454 ===== TRACE ===== 1 lines inserted into table "accessright".
2018-07-24 15:31:18.455 ===== TRACE ===== 1 lines inserted into table "accessright".
2018-07-24 15:31:18.490 ===== TRACE ===== Table "meeting" altered.
2018-07-24 15:31:18.504 ===== TRACE ===== 252 lines updated into table "meeting".
2018-07-24 15:31:18.505 ===== TRACE ===== 3 lines inserted into table "type".
2018-07-24 15:31:18.511 ===== TRACE ===== Table "product" altered.
2018-07-24 15:31:18.516 ===== TRACE ===== Table "version" altered.
2018-07-24 15:31:18.522 ===== TRACE ===== Table "status" altered.
2018-07-24 15:31:18.529 ===== TRACE ===== Table "type" altered.
2018-07-24 15:31:18.531 ===== TRACE ===== 6 lines updated into table "type".
2018-07-24 15:31:18.532 ===== TRACE ===== 5 lines updated into table "product".
2018-07-24 15:31:18.533 ===== TRACE ===== 6 lines updated into table "version".
2018-07-24 15:31:18.534 ===== TRACE ===== 2 lines updated into table "product".
2018-07-24 15:31:18.535 ===== TRACE ===== 3 lines updated into table "product".
2018-07-24 15:31:18.536 ===== TRACE ===== 6 lines updated into table "version".
2018-07-24 15:31:18.536 ===== TRACE ===== 0 lines updated into table "version".
2018-07-24 15:31:18.543 ===== TRACE ===== Table "requirement" altered.
2018-07-24 15:31:18.549 ===== TRACE ===== Table "requirement" altered.
2018-07-24 15:31:18.556 ===== TRACE ===== Table "requirement" altered.
2018-07-24 15:31:18.563 ===== TRACE ===== Table "requirement" altered.
2018-07-24 15:31:18.569 ===== TRACE ===== Table "ticket" altered.
2018-07-24 15:31:18.574 ===== TRACE ===== Table "version" altered.
2018-07-24 15:31:18.578 ===== TRACE ===== Table "deliverable" altered.
2018-07-24 15:31:18.586 ===== TRACE ===== Table "delivery" altered.
2018-07-24 15:31:18.590 ===== TRACE ===== Table "delivery" altered.
2018-07-24 15:31:18.591 ===== TRACE ===== 10 lines inserted into table "checklistable".
2018-07-24 15:31:18.593 ===== TRACE ===== 3 lines inserted into table "copyable".
2018-07-24 15:31:18.593 ===== TRACE ===== 2 lines inserted into table "importable".
2018-07-24 15:31:18.594 ===== TRACE ===== 2 lines inserted into table "linkable".
2018-07-24 15:31:18.594 ===== TRACE ===== 6 lines inserted into table "mailable".
2018-07-24 15:31:18.595 ===== TRACE ===== 6 lines inserted into table "referencable".
2018-07-24 15:31:18.596 ===== TRACE ===== 6 lines inserted into table "originable".
2018-07-24 15:31:18.597 ===== TRACE ===== 19 lines inserted into table "textable".
2018-07-24 15:31:18.598 ===== TRACE ===== 1 lines deleted from table "linkable".
2018-07-24 15:31:18.598 ===== TRACE ===== 1 lines deleted from table "textable".
2018-07-24 15:31:18.598 ===== TRACE =====
2018-07-24 15:31:18.598 ===== TRACE ===== DATABASE UPDATED
2018-07-24 15:31:18.598 ===== TRACE ===== WITH 17 ERRORS
2018-07-24 15:31:18.598 ===== TRACE =====
2018-07-24 15:31:18.599 ===== TRACE ===== =====================================
2018-07-24 15:31:18.599 ===== TRACE =====
2018-07-24 15:31:18.599 ===== TRACE ===== VERSION V7.0.0
2018-07-24 15:31:18.599 ===== TRACE =====
2018-07-24 15:31:18.599 ===== TRACE ===== 3 lines inserted into table "parameter".
2018-07-24 15:31:18.600 ***** ERROR ***** [V6.3.7] Exception-[42S01] SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'mailtosend' already exists
2018-07-24 15:31:18.600 ***** ERROR ***** [V6.3.7] For query : CREATE TABLE `mailtosend` (
`id` int(12) unsigned NOT NULL AUTO_INCREMENT,
`idUser` int(12) unsigned DEFAULT NULL,
`refType` varchar(100) DEFAULT NULL,
`refId` int(12) unsigned DEFAULT NULL,
`idEmailTemplate` int(12) unsigned DEFAULT NULL,
`template` varchar(100) DEFAULT NULL,
`title` varchar(4000) DEFAULT NULL,
`dest` varchar(4000) DEFAULT NULL,
`recordDateTime` datetime DEFAULT NULL,
`idle` int(1) unsigned DEFAULT 0,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
2018-07-24 15:31:18.600 ***** ERROR ***** [V6.3.7] Strack trace :
2018-07-24 15:31:18.600 ***** ERROR ***** [V6.3.7] #0 Sql->query called at [/produits/www/projeqtor/db/maintenanceFunctions.php:71]
2018-07-24 15:31:18.600 ***** ERROR ***** [V6.3.7] #1 runScript called at [/produits/www/projeqtor/db/maintenance.php:110]
2018-07-24 15:31:18.600 ***** ERROR ***** [V6.3.7] #2 include called at [/produits/www/projeqtor/tool/loginCheck.php:143]
2018-07-24 15:31:18.600 ===== TRACE =====
2018-07-24 15:31:18.600 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V7.0.0 (see above message)
2018-07-24 15:31:18.600 ===== TRACE =====
2018-07-24 15:31:18.600 ===== TRACE ===== *************************************************
2018-07-24 15:31:18.600 ===== TRACE =====
2018-07-24 15:31:18.600 ***** ERROR ***** [V6.3.7] Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'mailtosendReference'
2018-07-24 15:31:18.600 ***** ERROR ***** [V6.3.7] For query : CREATE INDEX `mailtosendReference` ON `mailtosend` (`refType`,`refId`);
2018-07-24 15:31:18.600 ***** ERROR ***** [V6.3.7] Strack trace :
2018-07-24 15:31:18.600 ***** ERROR ***** [V6.3.7] #0 Sql->query called at [/produits/www/projeqtor/db/maintenanceFunctions.php:71]
2018-07-24 15:31:18.600 ***** ERROR ***** [V6.3.7] #1 runScript called at [/produits/www/projeqtor/db/maintenance.php:110]
2018-07-24 15:31:18.601 ***** ERROR ***** [V6.3.7] #2 include called at [/produits/www/projeqtor/tool/loginCheck.php:143]
2018-07-24 15:31:18.601 ===== TRACE =====
2018-07-24 15:31:18.601 ===== TRACE ===== Error # 2 => SQL error while executing maintenance query for version V7.0.0 (see above message)
2018-07-24 15:31:18.601 ===== TRACE =====
2018-07-24 15:31:18.601 ===== TRACE ===== *************************************************
2018-07-24 15:31:18.601 ===== TRACE =====
2018-07-24 15:31:18.601 ===== TRACE ===== 1 lines inserted into table "menu".
2018-07-24 15:31:18.602 ===== TRACE ===== 1 lines inserted into table "habilitation".
2018-07-24 15:31:18.988 ===== TRACE ===== Table "planningelement" altered.
2018-07-24 15:31:19.021 ===== TRACE ===== Table "planningelementbaseline" altered.
2018-07-24 15:31:19.022 ===== TRACE ===== 2 lines inserted into table "cronexecution".
2018-07-24 15:31:19.022 ***** ERROR ***** [V6.3.7] Exception-[42S01] SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'assignmentrecurring' already exists
2018-07-24 15:31:19.022 ***** ERROR ***** [V6.3.7] For query : CREATE TABLE `assignmentrecurring` (
`id` int(12) unsigned NOT NULL AUTO_INCREMENT,
`idAssignment` int(12) unsigned DEFAULT NULL,
`refType` varchar(100) DEFAULT NULL,
`refId` int(12) unsigned DEFAULT NULL,
`idResource` int(12) unsigned DEFAULT NULL,
`type` varchar(10) DEFAULT NULL,
`day` int(3) DEFAULT NULL,
`value` decimal(12,5) unsigned DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
2018-07-24 15:31:19.022 ***** ERROR ***** [V6.3.7] Strack trace :
2018-07-24 15:31:19.022 ***** ERROR ***** [V6.3.7] #0 Sql->query called at [/produits/www/projeqtor/db/maintenanceFunctions.php:71]
2018-07-24 15:31:19.022 ***** ERROR ***** [V6.3.7] #1 runScript called at [/produits/www/projeqtor/db/maintenance.php:110]
2018-07-24 15:31:19.022 ***** ERROR ***** [V6.3.7] #2 include called at [/produits/www/projeqtor/tool/loginCheck.php:143]
2018-07-24 15:31:19.022 ===== TRACE =====
2018-07-24 15:31:19.022 ===== TRACE ===== Error # 3 => SQL error while executing maintenance query for version V7.0.0 (see above message)
2018-07-24 15:31:19.023 ===== TRACE =====
2018-07-24 15:31:19.023 ===== TRACE ===== *************************************************
2018-07-24 15:31:19.023 ===== TRACE =====
2018-07-24 15:31:19.023 ***** ERROR ***** [V6.3.7] Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'idAssignmentAssignmentRecurring'
2018-07-24 15:31:19.023 ***** ERROR ***** [V6.3.7] For query : CREATE INDEX `idAssignmentAssignmentRecurring` ON `assignmentrecurring` (`idAssignment`);
2018-07-24 15:31:19.023 ***** ERROR ***** [V6.3.7] Strack trace :
2018-07-24 15:31:19.023 ***** ERROR ***** [V6.3.7] #0 Sql->query called at [/produits/www/projeqtor/db/maintenanceFunctions.php:71]
2018-07-24 15:31:19.023 ***** ERROR ***** [V6.3.7] #1 runScript called at [/produits/www/projeqtor/db/maintenance.php:110]
2018-07-24 15:31:19.023 ***** ERROR ***** [V6.3.7] #2 include called at [/produits/www/projeqtor/tool/loginCheck.php:143]
2018-07-24 15:31:19.023 ===== TRACE =====
2018-07-24 15:31:19.023 ===== TRACE ===== Error # 4 => SQL error while executing maintenance query for version V7.0.0 (see above message)
2018-07-24 15:31:19.023 ===== TRACE =====
2018-07-24 15:31:19.023 ===== TRACE ===== *************************************************
2018-07-24 15:31:19.023 ===== TRACE =====
2018-07-24 15:31:19.023 ***** ERROR ***** [V6.3.7] Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'referenceAssignmentRecurring'
2018-07-24 15:31:19.023 ***** ERROR ***** [V6.3.7] For query : CREATE INDEX `referenceAssignmentRecurring` ON `assignmentrecurring` (`refTYpe`, `refId`);
2018-07-24 15:31:19.023 ***** ERROR ***** [V6.3.7] Strack trace :
2018-07-24 15:31:19.023 ***** ERROR ***** [V6.3.7] #0 Sql->query called at [/produits/www/projeqtor/db/maintenanceFunctions.php:71]
2018-07-24 15:31:19.023 ***** ERROR ***** [V6.3.7] #1 runScript called at [/produits/www/projeqtor/db/maintenance.php:110]
2018-07-24 15:31:19.024 ***** ERROR ***** [V6.3.7] #2 include called at [/produits/www/projeqtor/tool/loginCheck.php:143]
2018-07-24 15:31:19.024 ===== TRACE =====
2018-07-24 15:31:19.024 ===== TRACE ===== Error # 5 => SQL error while executing maintenance query for version V7.0.0 (see above message)
2018-07-24 15:31:19.024 ===== TRACE =====
2018-07-24 15:31:19.024 ===== TRACE ===== *************************************************
2018-07-24 15:31:19.024 ===== TRACE =====
2018-07-24 15:31:19.024 ===== TRACE ===== 0 lines updated into table "planningmode".
2018-07-24 15:31:19.025 ===== TRACE ===== 2 lines updated into table "planningmode".
2018-07-24 15:31:19.026 ===== TRACE ===== 2 lines updated into table "planningmode".
2018-07-24 15:31:19.027 ===== TRACE ===== 2 lines updated into table "planningmode".
2018-07-24 15:31:19.028 ===== TRACE ===== 2 lines updated into table "planningmode".
2018-07-24 15:31:19.028 ===== TRACE ===== 2 lines updated into table "planningmode".
2018-07-24 15:31:19.029 ===== TRACE ===== 2 lines updated into table "planningmode".
2018-07-24 15:31:19.030 ===== TRACE ===== 2 lines updated into table "planningmode".
2018-07-24 15:31:19.030 ===== TRACE ===== 1 lines updated into table "planningmode".
2018-07-24 15:31:19.031 ===== TRACE ===== 1 lines inserted into table "planningmode".
2018-07-24 15:31:19.031 ===== TRACE =====
2018-07-24 15:31:19.031 ===== TRACE ===== DATABASE UPDATED
2018-07-24 15:31:19.031 ===== TRACE ===== WITH 5 ERRORS
2018-07-24 15:31:19.031 ===== TRACE =====
2018-07-24 15:31:19.031 ===== TRACE ===== =====================================
2018-07-24 15:31:19.031 ===== TRACE =====
2018-07-24 15:31:19.031 ===== TRACE ===== VERSION V7.0.2
2018-07-24 15:31:19.031 ===== TRACE =====
2018-07-24 15:31:19.031 ***** ERROR ***** [V6.3.7] Exception-[42S21] SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'comment'
2018-07-24 15:31:19.031 ***** ERROR ***** [V6.3.7] For query : ALTER TABLE `versioncompatibility`
ADD `comment` varchar(400) DEFAULT NULL;
2018-07-24 15:31:19.031 ***** ERROR ***** [V6.3.7] Strack trace :
2018-07-24 15:31:19.031 ***** ERROR ***** [V6.3.7] #0 Sql->query called at [/produits/www/projeqtor/db/maintenanceFunctions.php:71]
2018-07-24 15:31:19.032 ***** ERROR ***** [V6.3.7] #1 runScript called at [/produits/www/projeqtor/db/maintenance.php:110]
2018-07-24 15:31:19.032 ***** ERROR ***** [V6.3.7] #2 include called at [/produits/www/projeqtor/tool/loginCheck.php:143]
2018-07-24 15:31:19.032 ===== TRACE =====
2018-07-24 15:31:19.032 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V7.0.2 (see above message)
2018-07-24 15:31:19.032 ===== TRACE =====
2018-07-24 15:31:19.032 ===== TRACE ===== *************************************************
2018-07-24 15:31:19.032 ===== TRACE =====
2018-07-24 15:31:19.032 ===== TRACE =====
2018-07-24 15:31:19.032 ===== TRACE ===== DATABASE UPDATED
2018-07-24 15:31:19.032 ===== TRACE ===== WITH 1 ERROR
2018-07-24 15:31:19.032 ===== TRACE =====
2018-07-24 15:31:19.034 ===== TRACE ===== Create delivery types from deliverable types
2018-07-24 15:31:19.909 ===== TRACE ===== =====================================
2018-07-24 15:31:19.909 ===== TRACE =====
2018-07-24 15:31:19.909 ===== TRACE ===== 26 ERRORS DURING UPDATE TO VERSION V7.0.9
2018-07-24 15:31:19.909 ===== TRACE =====
2018-07-24 15:31:19.909 ===== TRACE ===== =====================================
2018-07-24 15:31:19.909 ===== TRACE =====
2018-07-24 15:31:19.961 ===== TRACE ===== === SCREEN CUSTOMIZATION ISSUE =====================================
2018-07-24 15:31:19.962 ===== TRACE ===== Certaines customisations d'écran ne sont pas cohérentes :
2018-07-24 15:31:19.963 ===== TRACE ===== - Action
2018-07-24 15:31:19.963 ===== TRACE ===== - Ticket
2018-07-24 15:31:19.964 ===== TRACE ===== Veuillez accéder à chacun de ces écrans sur le plugin de customisation (la version 5.0 ou supérieure est requise)

thank's for reply