From owner-freebsd-ports@freebsd.org Sun Jan 22 12:51:25 2017 Return-Path: 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 83CACCB09A4 for ; Sun, 22 Jan 2017 12:51:25 +0000 (UTC) (envelope-from baptiste.daroussin@gmail.com) Received: from mailman.ysv.freebsd.org (mailman.ysv.freebsd.org [IPv6:2001:1900:2254:206a::50:5]) by mx1.freebsd.org (Postfix) with ESMTP id 5EBA28CF for ; Sun, 22 Jan 2017 12:51:25 +0000 (UTC) (envelope-from baptiste.daroussin@gmail.com) Received: by mailman.ysv.freebsd.org (Postfix) id 5E125CB09A2; Sun, 22 Jan 2017 12:51:25 +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 5DBADCB09A1 for ; Sun, 22 Jan 2017 12:51:25 +0000 (UTC) (envelope-from baptiste.daroussin@gmail.com) Received: from mail-wm0-x242.google.com (mail-wm0-x242.google.com [IPv6:2a00:1450:400c:c09::242]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client CN "smtp.gmail.com", Issuer "Google Internet Authority G2" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id E46378CD for ; Sun, 22 Jan 2017 12:51:24 +0000 (UTC) (envelope-from baptiste.daroussin@gmail.com) Received: by mail-wm0-x242.google.com with SMTP id r126so19142245wmr.3 for ; Sun, 22 Jan 2017 04:51:24 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=sender:date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=HxLybemS2d5hcI51KTwZZb85JYLfug+vtT7yoB3BdJ4=; b=lsbADcCm+boe9N66JmkyD/Rf24SteQFyetZfu7DkVxLQMWEBrTrby8NRnd3qMTzGGX JKlLK5bjPgemIPz3mEPcaf2vDF1SALL4GBvpGrcoRk8LElk+JKfFTj8RdNIb0jtpn8oP Aa2FF5/yAvHgjvE57OHEduTYAMuQ2TtX833ej73t2dP220qU0x+1kWtkaAH3yPHoyfN4 kXJ0bHcBqMH2TKC39yW2mMd44GeTMdKEoT2DlmIUUeNaSYGL8Gwc9pe3tKjtM1fXKfjV d/2k6Ail89f6dzn09oQmH4W1UxG+/rxkHyuQtCtkiocHBIUuKqcZCKkrSapAUujlR56K P5kQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:sender:date:from:to:cc:subject:message-id :references:mime-version:content-disposition:in-reply-to:user-agent; bh=HxLybemS2d5hcI51KTwZZb85JYLfug+vtT7yoB3BdJ4=; b=MQZdRagm/oJY1v5b66LrZYkyGHEWq3OvW8l8d5Qa2o+J1qHapLljvueLT7k6tVkOb2 3UXhA7y9kRa/Od78XuDION4mncgZH/PpVnxllK7j4XVebL/Gky+THawC3N9WBTMd7DGW ZpYTiFD21m6sKZCbQWX6l2oaA2bygml98c6WhgXqLKe2i2ScVICo7Q4gHCPWo4k+ESm/ C25cMV4V/yv4LhnVT3i3fPY9xQqkrTvLhlOWD9H6wWdRgpfg0WnVQT+DE75G668FhpHF mKinRoD1PCmmBFTwXS43/XhjC2GICmDpLTq2jbsNvcHsX33pZWvALKcuFoaEGxh1pvn0 igCg== X-Gm-Message-State: AIkVDXKGDKiEu75ThXAP5svk1b0RO9ilM042Sm7/UbDBl+Dx6Zks8GnxPeP6mWqlKkUUDg== X-Received: by 10.223.133.98 with SMTP id 89mr19305638wrh.200.1485089483361; Sun, 22 Jan 2017 04:51:23 -0800 (PST) Received: from ivaldir.etoilebsd.net ([2001:41d0:8:db4c::1]) by smtp.gmail.com with ESMTPSA id b51sm9372719wrd.39.2017.01.22.04.51.21 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Sun, 22 Jan 2017 04:51:22 -0800 (PST) Sender: Baptiste Daroussin Date: Sun, 22 Jan 2017 13:51:21 +0100 From: Baptiste Daroussin To: Kurt Jaeger Cc: ports@FreeBSD.org Subject: Re: pkg database issue: database version 34 is newer than libpkg(3) version 33 ? Message-ID: <20170122125121.umgvq5yodt7ul4r2@ivaldir.etoilebsd.net> References: <20170122093652.GM13006@home.opsec.eu> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="23ivl5tok2now7bf" Content-Disposition: inline In-Reply-To: <20170122093652.GM13006@home.opsec.eu> User-Agent: NeoMutt/20170113 (1.7.2) X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 22 Jan 2017 12:51:25 -0000 --23ivl5tok2now7bf Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Sun, Jan 22, 2017 at 10:36:52AM +0100, Kurt Jaeger wrote: > Hi! >=20 > # 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 su= ch table: pkg_search >=20 > I've tried to create the table pkg_search using sqlite3, but: >=20 > CREATE VIRTUAL TABLE pkg_search USING fts4(id, name, origin); > Error: vtable constructor failed: pkg_search >=20 > Any ideas on how to proceed ? pkg shell CREATE VIRTUAL TABLE pkg_search USING fts4(id, name, origin); pragma user_version=3D33; that should do it You downgraded from pkg-devel? Best regards, Bapt --23ivl5tok2now7bf Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCAAdFiEEgOTj3suS2urGXVU3Y4mL3PG3PloFAliEqsYACgkQY4mL3PG3 PloncQ/6Aodf9gQUfi0F6cyHF7bOFGEx318w1GZRGubATUhuq+EOUbaeK5jCyTGB v8oaxlhrJLoDORLf7CPHQ9GkuXHMm6WDv/tE7bR/5AojWfT2ObQNsbq9dWQ855u9 C2X5xkF+Bibk5R7FOxhotaI/VRl7vwXJIimhDm9qkKoxxgj/aXZNERA2DVt7xY5F Lbf5osRmNerKpOi5Q5X+vh402FwszBlehAFEFSJPORbfC2RaZWuIf3qMjNVUqoci tNZhYrRTG998UZsrt+Fbw/9AwEyx5KabjM3Ng06Kha81ZKJlZJxGWDDyoYZGPV+1 fptM4h8XwcgUQTavwpYEdV72Ysq385i/i1TDEIkLMsGOh0Q4PFgT2uD9F51cSJnh JjCkZzov1v02GN2aANTJkg54pZalx+OMk7CCV2N0GFEAqIazs8SRddJgcRBbG843 0I21zYr6T/OX2pc5QthWm6Z0/8e5/Dv61mBcXtIdJhN6GzKymwh/AwCUso27INiD JPP98OTPN2d3zrnBw+pnFBPVYOYlE+oC6RwVrZUwIwwldN7xHFJoQ/Q6Q4uaMEUJ jdu6U2vGAe9KOl0GWwtDzvAosUb7/zn1/jZT3GATi7fm7dTdC0x6pVLfffp+ajVs Efxo2SgXzfMqB/0zFvMsw+YzCprRHdSlnYFjzm2i+TLj5rmeHeI= =o7/L -----END PGP SIGNATURE----- --23ivl5tok2now7bf--