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]