Hi,
Could you please post the entire error message ?

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]

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;

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.

You don't nedd to update the table.
The error is clear : "Column not found" the column is missing, not in unexpected format.
 

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;

 

Hi, Thank you, it works 🙂