Date: Sun, 22 Jan 2017 13:51:21 +0100 From: Baptiste Daroussin <bapt@FreeBSD.org> To: Kurt Jaeger <lists@opsec.eu> 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> In-Reply-To: <20170122093652.GM13006@home.opsec.eu> References: <20170122093652.GM13006@home.opsec.eu>
next in thread | previous in thread | raw e-mail | index | archive | help
--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--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20170122125121.umgvq5yodt7ul4r2>