Hi Alex,
I use PostgreSQL database, and when I say:
/usr/local/bin/openxpkiadm certificate import --file cacert.pem
I get the error:
I18N_OPENXPKI_SERVER_DBI_DBH_EXECUTE_FAILED; __ERRNO__ => 7; __ERRVAL__ =>
ERROR: argument of WHERE
must be type boolean, not type integer
; __QUERY__ => delete from secret where 1
This is because of the lines you added:
> --- trunk/perl-modules/core/trunk/OpenXPKI/Server/DBI/SQL.pm 2007-01-29
> 09:38:46 UTC (rev 717)
> +++ trunk/perl-modules/core/trunk/OpenXPKI/Server/DBI/SQL.pm 2007-01-29
> 09:53:42 UTC (rev 718)
> @@ -312,9 +312,15 @@
>
> + if (!defined $hash && $all) {
> + $sql .= '1'; # delete everything
> + $hash = {}; # so that foreach below works
> + }
If I change
$sql .= '1';
to
$sql .= '\'1\'';
everything works fine for me. But I only tested PostgreSQL. Is it works in the
DB that you use?
Best regards,
Julia.
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
OpenXPKI-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openxpki-devel
