View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] error on 8.2.5 migration - ProjeQtOr
 

[SOLVED] error on 8.2.5 migration

More
03 Mar 2020 09:56 #1 by pipobru
error on 8.2.5 migration was created by pipobru
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.

Please Log in or Create an account to join the conversation.

More
03 Mar 2020 10:22 #2 by babynus
Replied by babynus on topic error on 8.2.5 migration
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);
Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
03 Mar 2020 10:26 - 03 Mar 2020 10:26 #3 by babynus
Replied by babynus on topic error on 8.2.5 migration
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.
Babynus
Administrator of ProjeQtOr web site
Last edit: 03 Mar 2020 10:26 by babynus.
The following user(s) said Thank You: pipobru

Please Log in or Create an account to join the conversation.

More
03 Mar 2020 10:29 #4 by pipobru
Replied by pipobru on topic error on 8.2.5 migration
Top Thanks ! it work fine

Please Log in or Create an account to join the conversation.

Moderators: babynus, protion
Time to create page: 0.033 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.

Login Form