View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] SQLSTATE ERROR ON MILESTONE CREATION V9.0.2 - ProjeQtOr
 
 

[SOLVED] SQLSTATE ERROR ON MILESTONE CREATION V9.0.2

More
21 Jan 2021 18:41 #1 by Freesly
SQLSTATE ERROR ON MILESTONE CREATION V9.0.2 was created by Freesly
Hi,
When I try to create a milestone, I have a popup with the following error :

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lastUpdateDateTime' in 'field list'

Version 9.0.2

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

More
23 Jan 2021 18:11 #2 by babynus
Replied by babynus on topic SQLSTATE ERROR ON MILESTONE CREATION V9.0.2
Hi,
Could you please post the entire error message ?
Babynus
Administrator of ProjeQtOr web site

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

More
01 Feb 2021 15:37 #3 by Freesly
Replied by Freesly on topic SQLSTATE ERROR ON MILESTONE CREATION V9.0.2
Hi, sorry for the late reply

Here is a copy of logs :
2021-02-01 15:27:25.539 => 0.004 ***** ERROR ***** [V9.0.2] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lastUpdateDateTime' in 'field list'
2021-02-01 15:27:25.539 => 0.000 ***** ERROR ***** [V9.0.2]    For query : insert into milestone ( reference , name , idMilestoneType , idProject , creationDate , lastUpdateDateTime , idUser , idStatus , handled , done , idle , cancelled ) values ('-DEL-1', 'TestJalon', '23', '18', '2021-02-01', '2021-02-01 15:27:25', '7', '1', '0', '0', '0', '0')
2021-02-01 15:27:25.539 => 0.000 ***** ERROR ***** [V9.0.2]    Strack trace :
2021-02-01 15:27:25.539 => 0.000 ***** ERROR ***** [V9.0.2]    #0 Sql->query called at [/opt/projeqtor/model/persistence/SqlElement.php:1358]
2021-02-01 15:27:25.539 => 0.000 ***** ERROR ***** [V9.0.2]    #1 SqlElement->insertSqlElement called at [/opt/projeqtor/model/persistence/SqlElement.php:1132]
2021-02-01 15:27:25.539 => 0.000 ***** ERROR ***** [V9.0.2]    #2 SqlElement->saveSqlElement called at [/opt/projeqtor/model/persistence/SqlElement.php:790]
2021-02-01 15:27:25.539 => 0.000 ***** ERROR ***** [V9.0.2]    #3 SqlElement->save called at [/opt/projeqtor/model/MilestoneMain.php:214]
2021-02-01 15:27:25.539 => 0.000 ***** ERROR ***** [V9.0.2]    #4 MilestoneMain->save called at [/opt/projeqtor/tool/saveObject.php:110]

 
Attachments:

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

More
01 Feb 2021 16:01 #4 by babynus
Replied by babynus on topic SQLSTATE ERROR ON MILESTONE CREATION V9.0.2
It seems something went wrong during update.
Please check for errors in log file to chack for migration errors.

To fix your current issue, you have to execute this on your DB:
ALTER TABLE milestone ADD lastUpdateDateTime datetime DEFAULT NULL;
Babynus
Administrator of ProjeQtOr web site

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

More
02 Feb 2021 07:17 #5 by divyesh
Replied by divyesh on topic SQLSTATE ERROR ON MILESTONE CREATION V9.0.2
Said column is already there.Currently it is lastupdatedatetime timestamp without time zone,
Please update me so that I can alter alter it to datetime as suggested.

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

More
02 Feb 2021 20:08 #6 by babynus
Replied by babynus on topic SQLSTATE ERROR ON MILESTONE CREATION V9.0.2
You don't nedd to update the table.
The error is clear : "Column not found" the column is missing, not in unexpected format.
 
Babynus
Administrator of ProjeQtOr web site

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

Moderators: babynus, protion
Time to create page: 0.049 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