Forum

feedback after upgr...
 
Notifications
Retirer tout

feedback after upgrade to 6.0.1

3 Posts
2 Utilisateurs
0 Reactions
2,528 Vu
(@pipobru)
Posts: 180
Active Member
Début du sujet
 
[#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');


 
Posté : 22 Nov AM 10:1111
(@babynus)
Posts: 14952
Membre Admin
 

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


 
Posté : 23 Nov AM 11:1111
(@pipobru)
Posts: 180
Active Member
Début du sujet
 

Yes my database is postgresql.


 
Posté : 23 Nov AM 11:1111
Share:
Retour en haut