Hi,
During installation, an error occured :
2017-02-23 10:02:41.471 ===== TRACE ===== VERSION V5.3.0
2017-02-23 10:02:41.471 ===== TRACE =====
2017-02-23 10:02:41.517 ===== TRACE ===== Table "restricttype" altered.
2017-02-23 10:02:41.533 ===== TRACE ===== Index "restricttypeProfile" created.
2017-02-23 10:02:41.533 ===== TRACE ===== 1 lines inserted into table "report".
2017-02-23 10:02:41.533 ===== TRACE ===== 2 lines inserted into table "reportparameter".
2017-02-23 10:02:41.533 ===== TRACE ===== 4 lines inserted into table "habilitationreport".
2017-02-23 10:02:41.533 ===== TRACE ===== 1 lines inserted into table "reportparameter".
2017-02-23 10:02:41.533 ===== TRACE ===== 1 lines inserted into table "reportparameter".
2017-02-23 10:02:41.533 ===== TRACE ===== 1 lines inserted into table "report".
2017-02-23 10:02:41.533 ** ERROR ** Exception-[21S01] SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 2
2017-02-23 10:02:41.533 ** ERROR ** For query : INSERT INTO `reportparameter` (`idReport`, `name`, `paramType`, `sortOrder`, `defaultValue`) VALUES
(58, 'month', 'month', 20, 'currentMonth'),
(175, 58, 'idResource', 'resourceList', 10, 'currentResource');
2017-02-23 10:02:41.533 ** ERROR ** Strack trace :
2017-02-23 10:02:41.533 ** ERROR ** #0 Sql->query called at [C:ProjeqtorAppV6dbmaintenanceFunctions.php:71]
2017-02-23 10:02:41.533 ** ERROR ** #1 runScript called at [C:ProjeqtorAppV6dbmaintenance.php:101]
2017-02-23 10:02:41.533 ** ERROR ** #2 include called at [C:ProjeqtorAppV6toolloginCheck.php:57]
2017-02-23 10:02:41.533 ===== TRACE =====
2017-02-23 10:02:41.533 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V5.3.0 (see above message)
What can I do ?
Thanks
Hi,
This is minor issue.
You can fix it with this query (to be executed for instance in MySqlAdmin)
INSERT INTO `reportparameter` (`idReport`, `name`, `paramType`, `sortOrder`, `defaultValue`) VALUES (58, 'month', 'month', 20, 'currentMonth'), (58, 'idResource', 'resourceList', 10, 'currentResource');
Ok, and not reproduce with major version.