Delete Certificate leads to freezing of XCA

[AnonATXDO]

I installed the new version of XCA (2.5.0). Performing a delete action on Windows 10/Windows 2019 Server leads to a freeze and the software has to be closed forceabily. Before, even if the rights are not given within the table, the SQL error occured.

Now, with or without rights, the program crashes.

[AnonATXDO]

Sorry, it was a mistake by me. I implemented trigger to track changes - there was an issue.

However: Under XCA 2.4.0 I was instantly prompted with the SQL error... with XCA 2.5.0 it just crashes/freezes without any error shown. I thought it was very practicable to have the SQL errors shown in the software. Was there a change made to that behaviour?

[scasrl]

I have the same problem, and with version 2.4.0 it didn't happen

[dbuchhorn]

I run in this problem too. After I do some investigations I found the following reason.
It seams a new table "takeys" was added. In a sqlite database file the table is added automatically but in an postgresql database it isn't. Even I create this table manually the program freezes.

Logs (before adding the table)

  7902 Debug: .\lib\sql.cpp:208 XSqlQuery::exec "QUERY: .\\lib\\database_model.cpp:255 (SELECT MAX(stamp) from items) - Rows selected: -1"
  8007 Debug: .\lib\sql.cpp:208 XSqlQuery::exec "QUERY: .\\lib\\database_model.cpp:255 (SELECT MAX(stamp) from items) - Rows selected: -1"
  8202 Debug: .\lib\sql.cpp:208 XSqlQuery::exec "QUERY: .\\lib\\database_model.cpp:255 (SELECT MAX(stamp) from items) - Rows selected: -1"
  8203 Debug: .\lib\pki_base.cpp:101 pki_base::isVisible QRegularExpression("", QRegularExpression::PatternOptions("NoPatternOption")) QRegularExpression("", QRegularExpression::PatternOptions("NoPatternOption"))
  8203 Debug: .\lib\sql.cpp:25 DbTransaction::debug ".\\lib\\db_base.cpp(279) Transaction: Begin Level 2, E:0 "
  8203 Debug: .\lib\sql.cpp:208 XSqlQuery::exec "QUERY: .\\lib\\pki_x509super.cpp:83 (DELETE FROM x509super WHERE item=?[183]) - Rows affected: 1"
  8204 Debug: .\lib\sql.cpp:208 XSqlQuery::exec "QUERY: .\\lib\\pki_x509.cpp:151 (DELETE FROM certs WHERE item=?[183]) - Rows affected: 1"
  8205 Debug: .\lib\sql.cpp:208 XSqlQuery::exec "QUERY: .\\lib\\pki_x509.cpp:151 (DELETE FROM authority WHERE item=?[183]) - Rows affected: 0"
  8206 Debug: .\lib\sql.cpp:208 XSqlQuery::exec "QUERY: .\\lib\\pki_x509.cpp:151 (UPDATE crls SET issuer=NULL WHERE issuer=?[183]) - Rows affected: 0"
  8206 Debug: .\lib\sql.cpp:208 XSqlQuery::exec "QUERY: .\\lib\\pki_x509.cpp:151 (UPDATE certs SET issuer=NULL WHERE issuer=?[183]) - Rows affected: 0"
  8207 Debug: .\lib\sql.cpp:208 XSqlQuery::exec "QUERY: .\\lib\\pki_x509.cpp:151 (DELETE FROM revocations WHERE caId=?[183]) - Rows affected: 0"
  8208 Debug: .\lib\sql.cpp:208 XSqlQuery::exec "QUERY: .\\lib\\pki_x509.cpp:151 (DELETE FROM takeys WHERE item=?[183]) - Rows affected: -1"
  8208 Debug: .\lib\sql.cpp:25 DbTransaction::debug ".\\lib\\db_base.cpp(281) Transaction: Rollback Level 1, E:1 "
  8208 Critical: .\widgets\XcaWarning.cpp:65 xcaWarningGui::sqlerror SQL ERROR: "ERROR:  syntax error at or near \"(\"\nLINE 1: EXECUTE  (183)\n                 ^\n(42601) QPSQL: Es konnte keine Abfrage erzeugt werden - .\\lib\\pki_x509.cpp:151 (DELETE FROM takeys WHERE item=?[183])"

Hopefully this will help to fix the problem.

[mate1213]

I can confirm that this freezing happens with mysql database too.