Hello,
After upgrade i have three errors
2016-11-22 08:23:51.448 ***** ERROR ***** Exception-[42883] SQLSTATE[42883]: Undefined function: 7 ERROR: function wbssortable(integer) does not exist at character 77
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
2016-11-22 08:23:51.448 ***** ERROR ***** For query : CREATE INDEX planningelementbaselineWbsSortable ON planningelementbaseline (wbsSortable(255));
2016-11-22 08:23:51.448 ***** ERROR ***** Strack trace :
2016-11-22 08:23:51.448 ***** ERROR ***** #0 Sql->query called at [/var/www/html/db/maintenanceFunctions.php:71]
2016-11-22 08:23:51.448 ***** ERROR ***** #1 runScript called at [/var/www/html/db/maintenance.php:101]
2016-11-22 08:23:51.448 ***** ERROR ***** #2 include called at [/var/www/html/tool/loginCheck.php:135]
2016-11-22 08:23:51.449 ===== TRACE =====
2016-11-22 08:23:51.449 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V6.0.0 (see above message)
2016-11-22 08:23:51.449 ===== TRACE =====
2016-11-22 08:23:51.611 ***** ERROR ***** Exception-[42804] SQLSTATE[42804]: Datatype mismatch: 7 ERROR: column "mandatorydescription" is of type numeric but expression is of type boolean
LINE 2: ('Organization', 'Department', '10',0,false,'DEPT'),
^
HINT: You will need to rewrite or cast the expression.
2016-11-22 08:23:51.611 ***** ERROR ***** For query : INSERT INTO type (scope, name, sortOrder, idle, mandatoryDescription, code) VALUES
('Organization', 'Department', '10',0,false,'DEPT'),
('Organization', 'Unit', '20',0,false,'UNIT'),
('Organization', 'Location', '30',0,false,'LOC');
2016-11-22 08:23:51.611 ***** ERROR ***** Strack trace :
2016-11-22 08:23:51.611 ***** ERROR ***** #0 Sql->query called at [/var/www/html/db/maintenanceFunctions.php:71]
2016-11-22 08:23:51.611 ***** ERROR ***** #1 runScript called at [/var/www/html/db/maintenance.php:101]
2016-11-22 08:23:51.611 ***** ERROR ***** #2 include called at [/var/www/html/tool/loginCheck.php:135]
2016-11-22 08:23:51.611 ===== TRACE =====
2016-11-22 08:23:51.611 ===== TRACE ===== Error # 2 => SQL error while executing maintenance query for version V6.0.0 (see above message)
2016-11-22 08:23:51.611 ===== TRACE =====
2016-11-22 08:23:51.611 ===== TRACE ===== *************************************************
2016-11-22 08:23:51.857 ***** ERROR ***** Exception-[42804] SQLSTATE[42804]: Datatype mismatch: 7 ERROR: column "mandatorydescription" is of type numeric but expression is of type boolean
LINE 2: ('ProductVersion', 'Major Version', '10',0,false,'MAJ'),
^
HINT: You will need to rewrite or cast the expression.
2016-11-22 08:23:51.857 ***** ERROR ***** For query : INSERT INTO type (scope, name, sortOrder, idle, mandatoryDescription, code) VALUES
('ProductVersion', 'Major Version', '10',0,false,'MAJ'),
('ProductVersion', 'Minor Version', '20',0,false,'MIN'),
('ProductVersion', 'Patch', '30',0,false,'PATCH'),
('ComponentVersion', 'Major Version', '10',0,false,'maj'),
('ComponentVersion', 'Minor Version', '20',0,false,'min'),
('ComponentVersion', 'Patch', '30',0,false,'patch');
2016-11-22 08:23:51.857 ***** ERROR ***** Strack trace :
2016-11-22 08:23:51.857 ***** ERROR ***** #0 Sql->query called at [/var/www/html/db/maintenanceFunctions.php:71]
2016-11-22 08:23:51.857 ***** ERROR ***** #1 runScript called at [/var/www/html/db/maintenance.php:101]
2016-11-22 08:23:51.857 ***** ERROR ***** #2 include called at [/var/www/html/tool/loginCheck.php:135]
2016-11-22 08:23:51.857 ===== TRACE =====
2016-11-22 08:23:51.857 ===== TRACE ===== Error # 3 => SQL error while executing maintenance query for version V6.0.0 (see above message)
2016-11-22 08:23:51.857 ===== TRACE =====
2016-11-22 08:23:51.857 ===== TRACE ===== *************************************************
solved whith this sql :
CREATE INDEX planningelementbaselineWbsSortable ON planningelementbaseline (wbssortable);
INSERT INTO type (scope, name, sortOrder, idle, mandatoryDescription, code) VALUES
('Organization', 'Department', '10',0,0,'DEPT'),
('Organization', 'Unit', '20',0,0,'UNIT'),
('Organization', 'Location', '30',0,0,'LOC');
INSERT INTO type (scope, name, sortOrder, idle, mandatoryDescription, code) VALUES
('ProductVersion', 'Major Version', '10',0,0,'MAJ'),
('ProductVersion', 'Minor Version', '20',0,0,'MIN'),
('ProductVersion', 'Patch', '30',0,0,'PATCH'),
('ComponentVersion', 'Major Version', '10',0,0,'maj'),
('ComponentVersion', 'Minor Version', '20',0,0,'min'),
('ComponentVersion', 'Patch', '30',0,0,'patch');