Forum

Database error dele...
 
Notifications
Retirer tout

Database error deleting status.

3 Posts
2 Utilisateurs
0 Reactions
1,490 Vu
(@ppmichirones)
Posts: 7
Active Member
Début du sujet
 
[#7621]

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.


 
Posté : 09/07/2021 11:42 am
(@babynus)
Posts: 14952
Membre Admin
 

Just delete or comment line 486 in projeqtor/model/persistence/SqlElement.php

//          "Notification" => "controlStrict",

This fix will be included in V9.2.2


 
Posté : 09/07/2021 6:39 pm
(@ppmichirones)
Posts: 7
Active Member
Début du sujet
 

Done.
Works.
Thanks a lot.


 
Posté : 09/07/2021 9:26 pm
Share:
Retour en haut