Hi There,

I am trying a the current dockerized version of OpenXPKI. When I try to
revocate a cert. I get this "Database error: execution of SQL query failed"

>From Workflow history by
Action/Descrition=NICE_DISPATCH_REVOKE/global_nice_revoke_certificate

EXCEPTION: Database error: execution of SQL query failed; __dbi_error__ =>
You can't specify target table 'certificate' for update in FROM clause,
__dsn__ => dbi:mysql:host=db;database=openxpki;port=3306, __query__ =>
UPDATE certificate SET revocation_id = (SELECT
coalesce(max(revocation_id)+1, 1) FROM certificate) , status = ? WHERE ( (
identifier = ? AND revocation_id IS NULL ) ), __source__ =>
DBD::mysql::st::execute, __user__ => openxpki

System Version 3.4.0
Config Version config 3.4

Regards,
Jeff
_______________________________________________
OpenXPKI-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openxpki-users

Reply via email to