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
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`);
Perfect it works perfectly