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