Hello, friends.
First of all, congratulations for your awesome product.
My environment:
- Linux Form Scratch 9.1
- Apache 2.4.4
- PHP 7.4.13
- PostgreSQL 13.1
- ProjeQtOr 9.2.1
My problem:
When I pretend to delete a status, ProjeQtOr sends the following message:
SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block
and doesn't delete the status.
The PostgreSQL log says:
ERROR: column notification.idstatus does not exist at character 48
STATEMENT: select count(*) as cpt from notification where notification.idStatus= '25'
and , in fact, there isn't a column named idStatus in notification table. There is a idStatusNotification column.
Just delete or comment line 486 in projeqtor/model/persistence/SqlElement.php
// "Notification" => "controlStrict",
This fix will be included in V9.2.2
Done.
Works.
Thanks a lot.