Forum

Migration with 2 ER...
 
Notifications
Retirer tout

Migration with 2 ERROR from 5.0.8 to 6.1.0 on empty and clean install

3 Posts
2 Utilisateurs
0 Reactions
5,596 Vu
(@pipobru)
Posts: 180
Reputable Member
Début du sujet
 
[#4077]

Hello,
I have a clean and empty install for first update test. When apply the last version 6.1.0 on 5.08 with postgresql, i have this trace (2 Error):
2017-02-07 10:28:52.368 ** ERROR ** Exception-[42P07] SQLSTATE[42P07]: Duplicate table: 7 ERROR: relation "deliverablestatus" already exists
2017-02-07 10:28:52.368 ** ERROR ** For query : CREATE TABLE deliverablestatus (
id serial,
scope varchar(100) DEFAULT NULL,
name varchar(100) DEFAULT NULL,
value numeric(3) DEFAULT 0,
color varchar(7) DEFAULT '#FFFFFF',
sortOrder numeric(3) DEFAULT 0,
idle numeric(1) DEFAULT '0',
PRIMARY KEY (id)
) ;
2017-02-07 10:28:52.368 ** ERROR ** Strack trace :
2017-02-07 10:28:52.368 ** ERROR ** #0 Sql->query called at [/var/www/html/testvide/db/maintenanceFunctions.php:71]
2017-02-07 10:28:52.368 ** ERROR ** #1 runScript called at [/var/www/html/testvide/db/maintenance.php:101]
2017-02-07 10:28:52.368 ** ERROR ** #2 include called at [/var/www/html/testvide/tool/loginCheck.php:135]
2017-02-07 10:28:52.368 ===== TRACE =====
2017-02-07 10:28:52.368 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V6.1.0 (see above message)
2017-02-07 10:28:52.368 ===== TRACE =====
2017-02-07 10:28:52.368 ===== TRACE ===== **********************************************
2017-02-07 10:28:52.368 ===== TRACE =====
2017-02-07 10:28:52.368
** ERROR ** Exception-[42809] SQLSTATE[42809]: Wrong object type: 7 ERROR: "deliverablestatus" is an index
LINE 1: INSERT INTO deliverablestatus (id, scope, name, value, sortO...
^
2017-02-07 10:28:52.368
** ERROR ** For query : INSERT INTO deliverablestatus (id, scope, name, value, sortOrder, color, idle) VALUES
(1, 'Deliverable', 'not done', 0, 10, '#ff0000', '0'),
(2, 'Deliverable', 'delivery refused (major reservations)', 1, 20, '#ff8c00', '0'),
(3, 'Deliverable', 'accepted with minor reservations', 2, 30, '#ffff00', '0'),
(4, 'Deliverable', 'accepted without reservations', 3, 40, '#7fff00', '0'),
(5, 'Incoming', 'not provided', 0, 10, '#ff0000', '0'),
(6, 'Incoming', 'not conform', 1, 20, '#ff8c00', '0'),
(7, 'Incoming', 'accepted with minor reservations', 2, 30, '#ffff00', '0'),
(8, 'Incoming', 'accepted without reservations', 3, 40, '#7fff00', '0');
2017-02-07 10:28:52.368
** ERROR ** Strack trace :
2017-02-07 10:28:52.369
** ERROR ** #0 Sql->query called at [/var/www/html/testvide/db/maintenanceFunctions.php:71]
2017-02-07 10:28:52.369
** ERROR ** #1 runScript called at [/var/www/html/testvide/db/maintenance.php:101]
2017-02-07 10:28:52.369
** ERROR ***** #2 include called at [/var/www/html/testvide/tool/loginCheck.php:135]

Can you help ? or this errors are not important ?

Thanks


 
Posté : 07/02/2017 12:39 pm
(@babynus)
Posts: 14952
Membre Admin
 

This is specific PostgreSql issue as index names are shared with table names (both are relations in postgres)
Fix is to change line 239 /db/projeqtor_V6.1.0.sql from

CREATE INDEX `deliverableStatus` ON `${prefix}deliverable` (`idDeliverableStatus`);

to

CREATE INDEX `deliverableStatusIdx` ON `${prefix}deliverable` (`idDeliverableStatus`);

 
Posté : 07/02/2017 11:56 pm
(@pipobru)
Posts: 180
Reputable Member
Début du sujet
 

Perfect it works perfectly


 
Posté : 08/02/2017 12:23 pm
Share:
Retour en haut