OPNsense Forum

Archive => 23.1 Legacy Series => Topic started by: gatortech12 on February 23, 2023, 12:01:19 AM

Title: System Update failure: SQLiute error
Post by: gatortech12 on February 23, 2023, 12:01:19 AM
I went to update opnsense and this is what I was met with. Any guidance  would be appreciated

Number of packages to be upgraded: 15
pkg-static: sqlite error while executing SELECT lua_script, type  FROM lua_script    JOIN pkg_lua_script USING(lua_script_id)  WHERE package_id = 22 in file pkgdb_iterator.c:689: database disk image is malformed
Starting web GUI...done.
Generating RRD graphs...done.
Title: Re: System Update failure: SQLiute error
Post by: franco on February 23, 2023, 12:36:31 PM
use opnsense-bootstrap when the package data base is malformed:

# opnsense-bootstrap

(all your settings will be retained, plugins must be resynced to work again but no big deal)


Cheers,
Franco