Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.
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.
Insertion in table "importable" failed twice.
Possibly you added some data in this table to be able to import data that was not possible in standard.
The insertions are for Delivery and Tender, so you may not import these items.
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,
Check that corresponding lines don't exist in the table "importable" (possibly with different id).
If they don't try and insert : just copy SQL instruction that failed and change ID (with very high value to avoid new errors later)
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
It seems you already tried once to migrate from 6.0.4 to 7.0.0 and reverted code : but db was already updated.
So creation of tables failed as tables already exist
thks babynus,
coud you suggest it's safe to continue migration process, without to take into account theses errors, or is it better to start from a real 6.3.7 version.
CDLT.
If you can start from a real 6.3.7 it will be better, but possibly you used the application in the meantime.
It's not really dansgerous to have migration twice.
What you must take care of is somepossible dupplicates : duplicate lines in parameters or dupplicate parameters in reports.
Nothing blocking.