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

Prochaines sessions de formation

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)

Mardi 23 avril (10h30-12h)

Jeudi 16 mai (16h-17h30)

Jeudi 13 juin (10h30-12h)

  
 

Planifiez avec ProjeQtOr

3 et 4 avril (9h - 12h30)

  
 

Administrez avec ProjeQtOr

10 et 11 avril (9h - 12h30)

  

 

 
 

[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 Connexion 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 Connexion or Create an account to join the conversation.

More
01 Fév 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 Connexion or Create an account to join the conversation.

More
01 Fév 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 Connexion or Create an account to join the conversation.

More
02 Fév 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 Connexion or Create an account to join the conversation.

More
02 Fév 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 Connexion or Create an account to join the conversation.

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

Paramétrages de cookies

×

Cookies fonctionnels

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

Veuillez vous connecter pour voir vos activités!

Autres cookies

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

Login Form