View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - SQL Error when deleting an asset - ProjeQtOr
 

SQL Error when deleting an asset

More
08 Jan 2025 07:11 #1 by GhaziTriki
Hello,

When I try to delete an asset I always get this error.2025-01-08 07:10:27.310 ***** ERROR ***** [V12.0.0] [1] Exception-[42703] SQLSTATE[42703]: Undefined column: 7 ERROR: column location.idasset does not exist
LINE 1: select count(*) as cpt from location where location.idAsset=...
^
2025-01-08 07:10:27.311 ***** ERROR ***** [V12.0.0] [1] For query : select count(*) as cpt from location where location.idAsset= '678'
2025-01-08 07:10:27.311 ***** ERROR ***** [V12.0.0] [1] Strack trace :
2025-01-08 07:10:27.311 ***** ERROR ***** [V12.0.0] [1] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:3239]
2025-01-08 07:10:27.311 ***** ERROR ***** [V12.0.0] [1] #1 SqlElement->countSqlElementsFromCriteria called at [/var/www/projeqtor/model/persistence/SqlElement.php:5846]
2025-01-08 07:10:27.311 ***** ERROR ***** [V12.0.0] [1] #2 SqlElement->deleteControl called at [/var/www/projeqtor/model/persistence/SqlElement.php:2123]
2025-01-08 07:10:27.311 ***** ERROR ***** [V12.0.0] [1] #3 SqlElement->deleteSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:1220]
2025-01-08 07:10:27.311 ***** ERROR ***** [V12.0.0] [1] #4 SqlElement->delete called at [/var/www/projeqtor/model/AssetMain.php:141]
2025-01-08 07:10:27.311 ***** ERROR ***** [V12.0.0] [1] #5 AssetMain->delete called at [/var/www/projeqtor/tool/deleteObject.php:77]
2025-01-08 07:10:27.311 ***** ERROR ***** [V12.0.0] [1] ERROR *****
2025-01-08 07:10:27.311 ***** ERROR ***** [V12.0.0] [1] on file '/var/www/projeqtor/model/persistence/SqlElement.php' at line (3242)
2025-01-08 07:10:27.311 ***** ERROR ***** [V12.0.0] [1] cause = Trying to access array offset on value of type bool
2025-01-08 07:10:27.311 ***** ERROR ***** [V12.0.0] [1] Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block
2025-01-08 07:10:27.311 ***** ERROR ***** [V12.0.0] [1] For query : select * from productasset where productasset.idAsset=678
2025-01-08 07:10:27.312 ***** ERROR ***** [V12.0.0] [1] Strack trace :
2025-01-08 07:10:27.312 ***** ERROR ***** [V12.0.0] [1] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:3143]
2025-01-08 07:10:27.312 ***** ERROR ***** [V12.0.0] [1] #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/projeqtor/model/persistence/SqlElement.php:2245]
2025-01-08 07:10:27.312 ***** ERROR ***** [V12.0.0] [1] #2 SqlElement->deleteSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:1220]
2025-01-08 07:10:27.312 ***** ERROR ***** [V12.0.0] [1] #3 SqlElement->delete called at [/var/www/projeqtor/model/AssetMain.php:141]
2025-01-08 07:10:27.312 ***** ERROR ***** [V12.0.0] [1] #4 AssetMain->delete called at [/var/www/projeqtor/tool/deleteObject.php:77]
2025-01-08 07:10:27.312 ***** ERROR ***** [V12.0.0] [1] Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block
2025-01-08 07:10:27.312 ***** ERROR ***** [V12.0.0] [1] For query : select * from alert where alert.refType='Asset' and alert.refId=678
2025-01-08 07:10:27.312 ***** ERROR ***** [V12.0.0] [1] Strack trace :
2025-01-08 07:10:27.312 ***** ERROR ***** [V12.0.0] [1] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:3143]
2025-01-08 07:10:27.312 ***** ERROR ***** [V12.0.0] [1] #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/projeqtor/model/persistence/SqlElement.php:2245]
2025-01-08 07:10:27.312 ***** ERROR ***** [V12.0.0] [1] #2 SqlElement->deleteSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:1220]
2025-01-08 07:10:27.312 ***** ERROR ***** [V12.0.0] [1] #3 SqlElement->delete called at [/var/www/projeqtor/model/AssetMain.php:141]
2025-01-08 07:10:27.312 ***** ERROR ***** [V12.0.0] [1] #4 AssetMain->delete called at [/var/www/projeqtor/tool/deleteObject.php:77]
2025-01-08 07:10:27.312 ***** ERROR ***** [V12.0.0] [1] Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block
2025-01-08 07:10:27.313 ***** ERROR ***** [V12.0.0] [1] For query : select * from indicatorvalue where indicatorvalue.refType='Asset' and indicatorvalue.refId='678'
2025-01-08 07:10:27.313 ***** ERROR ***** [V12.0.0] [1] Strack trace :
2025-01-08 07:10:27.313 ***** ERROR ***** [V12.0.0] [1] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:3143]
2025-01-08 07:10:27.313 ***** ERROR ***** [V12.0.0] [1] #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/projeqtor/model/persistence/SqlElement.php:2245]
2025-01-08 07:10:27.313 ***** ERROR ***** [V12.0.0] [1] #2 SqlElement->deleteSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:1220]
2025-01-08 07:10:27.313 ***** ERROR ***** [V12.0.0] [1] #3 SqlElement->delete called at [/var/www/projeqtor/model/AssetMain.php:141]
2025-01-08 07:10:27.313 ***** ERROR ***** [V12.0.0] [1] #4 AssetMain->delete called at [/var/www/projeqtor/tool/deleteObject.php:77]
2025-01-08 07:10:27.313 ***** ERROR ***** [V12.0.0] [1] Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block
2025-01-08 07:10:27.313 ***** ERROR ***** [V12.0.0] [1] For query : delete from asset where id=678
2025-01-08 07:10:27.313 ***** ERROR ***** [V12.0.0] [1] Strack trace :
2025-01-08 07:10:27.313 ***** ERROR ***** [V12.0.0] [1] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:2263]
2025-01-08 07:10:27.313 ***** ERROR ***** [V12.0.0] [1] #1 SqlElement->deleteSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:1220]
2025-01-08 07:10:27.313 ***** ERROR ***** [V12.0.0] [1] #2 SqlElement->delete called at [/var/www/projeqtor/model/AssetMain.php:141]
2025-01-08 07:10:27.313 ***** ERROR ***** [V12.0.0] [1] #3 AssetMain->delete called at [/var/www/projeqtor/tool/deleteObject.php:77]

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

More
09 Jan 2025 14:22 #2 by maxca
Hello,

It's bug, ticket recorded #9396
Have a nice day,
Maxca
The following user(s) said Thank You: GhaziTriki

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.