pkg database issue: database version 34 is newer than libpkg(3) version 33 ?

[Baptiste Daroussin]

On Sun, Jan 22, 2017 at 10:36:52AM +0100, Kurt Jaeger wrote:
> Hi!
> 
> # pkg delete pkg
> pkg: warning: database version 34 is newer than libpkg(3) version 33, but still compatible
> pkg: sqlite error while executing INSERT OR ROLLBACK INTO pkg_search(id, name, origin) VALUES (?1, ?2 || '-' || ?3, ?4); in file pkgdb.c:1544: no such table: pkg_search
> 
> I've tried to create the table pkg_search using sqlite3, but:
> 
> CREATE VIRTUAL TABLE pkg_search USING fts4(id, name, origin);
> Error: vtable constructor failed: pkg_search
> 
> Any ideas on how to proceed ?

pkg shell
CREATE VIRTUAL TABLE pkg_search USING fts4(id, name, origin);
pragma user_version=33;


that should do it

You downgraded from pkg-devel?

Best regards,
Bapt
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: not available
URL: <http://lists.freebsd.org/pipermail/freebsd-ports/attachments/20170122/b5dd7f48/attachment.sig>