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.

feedback after upgr...
 
Notifications
Clear all

feedback after upgrade to 6.0.1

3 Posts
2 Users
0 Reactions
2,552 Views
(@pipobru)
Posts: 180
Active Member
Topic starter
 
[#3842]

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


 
Posted : 22 Nov 2016 10H46
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Thanks for reporting and for the fix.
Can yoju confirm that this occurs with PostgreSql Database ?


 
Posted : 23 Nov 2016 11H44
(@pipobru)
Posts: 180
Active Member
Topic starter
 

Yes my database is postgresql.


 
Posted : 23 Nov 2016 11H48
Share:

Scroll to Top