From owner-freebsd-ports@freebsd.org  Sun Jan 22 09:36:53 2017
Return-Path: <owner-freebsd-ports@freebsd.org>
Delivered-To: freebsd-ports@mailman.ysv.freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org
 [IPv6:2001:1900:2254:206a::19:1])
 by mailman.ysv.freebsd.org (Postfix) with ESMTP id 0B961CBC74A
 for <freebsd-ports@mailman.ysv.freebsd.org>;
 Sun, 22 Jan 2017 09:36:53 +0000 (UTC) (envelope-from lists@opsec.eu)
Received: from mailman.ysv.freebsd.org (unknown [127.0.1.3])
 by mx1.freebsd.org (Postfix) with ESMTP id F0D83DB8
 for <freebsd-ports@freebsd.org>; Sun, 22 Jan 2017 09:36:52 +0000 (UTC)
 (envelope-from lists@opsec.eu)
Received: by mailman.ysv.freebsd.org (Postfix)
 id ED684CBC749; Sun, 22 Jan 2017 09:36:52 +0000 (UTC)
Delivered-To: ports@mailman.ysv.freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org
 [IPv6:2001:1900:2254:206a::19:1])
 by mailman.ysv.freebsd.org (Postfix) with ESMTP id EB61BCBC748
 for <ports@mailman.ysv.freebsd.org>; Sun, 22 Jan 2017 09:36:52 +0000 (UTC)
 (envelope-from lists@opsec.eu)
Received: from home.opsec.eu (home.opsec.eu [IPv6:2001:14f8:200::1])
 (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits))
 (Client did not present a certificate)
 by mx1.freebsd.org (Postfix) with ESMTPS id AC747DB7
 for <ports@FreeBSD.org>; Sun, 22 Jan 2017 09:36:52 +0000 (UTC)
 (envelope-from lists@opsec.eu)
Received: from pi by home.opsec.eu with local (Exim 4.87 (FreeBSD))
 (envelope-from <lists@opsec.eu>) id 1cVEZw-000NsG-4s
 for ports@FreeBSD.org; Sun, 22 Jan 2017 10:36:52 +0100
Date: Sun, 22 Jan 2017 10:36:52 +0100
From: Kurt Jaeger <lists@opsec.eu>
To: ports@FreeBSD.org
Subject: pkg database issue: database version 34 is newer than libpkg(3)
 version 33 ?
Message-ID: <20170122093652.GM13006@home.opsec.eu>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
X-BeenThere: freebsd-ports@freebsd.org
X-Mailman-Version: 2.1.23
Precedence: list
List-Id: Porting software to FreeBSD <freebsd-ports.freebsd.org>
List-Unsubscribe: <https://lists.freebsd.org/mailman/options/freebsd-ports>,
 <mailto:freebsd-ports-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-ports/>
List-Post: <mailto:freebsd-ports@freebsd.org>
List-Help: <mailto:freebsd-ports-request@freebsd.org?subject=help>
List-Subscribe: <https://lists.freebsd.org/mailman/listinfo/freebsd-ports>,
 <mailto:freebsd-ports-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Sun, 22 Jan 2017 09:36:53 -0000

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 ?

-- 
pi@opsec.eu            +49 171 3101372                         3 years to go !