Hello,
when i migrate to 8.2.5 version i have this error:
2020-03-03 09:11:05.031 ===== TRACE ===== VERSION V8.3.5
2020-03-03 09:11:05.031 ===== TRACE =====
2020-03-03 09:11:05.048 ** ERROR ** [V8.3.2] Exception-[42601] SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "NULL"
LINE 1: ...E deliverable ALTER impactWork TYPE DECIMAL(12,5) NULL DEFAU...
^
2020-03-03 09:11:05.048 ** ERROR ** [V8.3.2] For query : ALTER TABLE deliverable ALTER impactWork TYPE DECIMAL(12,5) NULL DEFAULT NULL;
2020-03-03 09:11:05.048 ** ERROR ** [V8.3.2] Strack trace :
2020-03-03 09:11:05.048 ** ERROR ** [V8.3.2] #0 Sql->query called at [/var/www/html/db/maintenanceFunctions.php:71]
2020-03-03 09:11:05.048 ** ERROR ** [V8.3.2] #1 runScript called at [/var/www/html/db/maintenance.php:111]
2020-03-03 09:11:05.048 ** ERROR ** [V8.3.2] #2 include called at [/var/www/html/tool/loginCheck.php:143]
2020-03-03 09:11:05.048 ===== TRACE =====
2020-03-03 09:11:05.048 ===== TRACE ===== Error # 1 => SQL error while executing maintenance query for version V8.3.5 (see above message)
2020-03-03 09:11:05.048 ===== TRACE =====
2020-03-03 09:11:05.048 ===== TRACE ===== *************************************************
2020-03-03 09:11:05.048 ===== TRACE =====
2020-03-03 09:11:05.048 ===== TRACE =====
2020-03-03 09:11:05.048 ===== TRACE ===== DATABASE UPDATED
2020-03-03 09:11:05.048 ===== TRACE ===== WITH 1 ERROR
This error is very important ?
Thanks for you answer.
Bruno.
Hi,
This ios an issue that may occur oinly on PostgreSql.
To finalize migration, just execute following query :
ALTER TABLE deliverable ALTER impactWork TYPE DECIMAL(12,5);
NB : the issue is very minor, even if you don't fix it 😉
In fact it is just to avoid bad rounding when entering estimated workload on deliverable, when admin selected work format as hours.
Top Thanks ! it work fine