Re: pkgtools/pkgin-0.9.2 - sql errors (on Linux)

[Jonathan Perkin <jperkin%joyent.com@localhost>]

* On 2015-08-17 at 18:23 BST, Matthias Ferdinand wrote:

> since upgrading from pkgin-0.8.0 to 0.9.1 / 0.9.2, "pkgin av" only shows
>     Requested list is empty.
> and re-reading local and remote summary at each invocation.
> 
> In /opt/pkgsrc/var/db/pkgin/sql.log I see lots of entries like
>     SQL error: near ")": syntax error
>     SQL query: );
> 
> This not only happens on old Linux installs, but also on Ubuntu
> 12.04/14.04
> 
> Removing pkgin.db/sql.log and re-running "pkgin -f update" does not
> help.
> 
> On NetBSD6.1 it appears to work ok.

Thanks, could you put your ${VARBASE}/db/pkgin and the pkg_summary you
are using somewhere?  Ideally if your repository is available just
point me at it.  I'll try to reproduce and fix.

Cheers,

-- 
Jonathan Perkin  -  Joyent, Inc.  -  www.joyent.com