Forum

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.

[SOLVED] Version 6....
 
Notifications
Clear all

[SOLVED] Version 6.1.1

3 Posts
2 Users
0 Reactions
4,722 Views
 DEV
(@lee)
Posts: 57
Active Member
Topic starter
 
[#4142]

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


 
Posted : 23 Feb 2017 16H39
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

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');

 
Posted : 28 Feb 2017 11H04
 DEV
(@lee)
Posts: 57
Active Member
Topic starter
 

Ok, and not reproduce with major version.


 
Posted : 10 Jan 2018 13H04
Share:

Scroll to Top