FreeBSD, bootstrapping pkg, "pkg-static: sqlite error while executing INSERT OR ROLLBACK INTO pkg_search"

I was trying to install bash on a FreeBSD 10.2 system, see https://unix.stackexchange.com/questions/43475/how-to-install-bash-on-freebsd But the install failed because pkg was trying to fetch from a too-new repository. I then tried following the recipe at https://glasz.org/sheeplog/2017/02/freebsd-usrlocalliblibpkgso3-undefined-symbol-utimensat.html , which several sources said was the right thing to do. However, part of the recipe involved uninstalling pkg and reinstalling it. That resulted in the following: # pkg install -y pkg The package management tool is not yet installed on your system. Do you want to fetch and install it now? [y/N]: y Bootstrapping pkg from pkg+http://pkg.FreeBSD.org/FreeBSD:10:amd64/release_2 , please wait... Verifying signature with trusted certificate pkg.freebsd.org.2013102301... done pkg-static: warning: database version 34 is newer than libpkg(3) version 31, but still compatible pkg-static: sqlite error while executing INSERT OR ROLLBACK INTO pkg_search(id, name, origin) VALUES (?1, ?2 || '-' || ?3, ?4); in file pkgdb.c:1542: no such table: pkg_search And so now I'm stuck. Can anybody tell me how I might recover from this state?