View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Database error deleting status. - ProjeQtOr
 

Database error deleting status.

More
09 Jul 2021 09:42 #1 by ppmichirones
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.

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

More
09 Jul 2021 16:39 #2 by babynus
Just delete or comment line 486 in projeqtor/model/persistence/SqlElement.php

//          "Notification" => "controlStrict",

This fix will be included in V9.2.2

Babynus
Administrator of ProjeQtOr web site

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

More
09 Jul 2021 19:26 #3 by ppmichirones
Done.
Works.
Thanks a lot.

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

Moderators: babynusprotion
Time to create page: 0.050 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.