Re: [Audacity-devel] Internal Error DBConnection

[Jack L. <xxj...@gm...>]

Actually the computer I used did not have DBPAGE turned on ( I have
too many computers....). Let me make a note about that in the port
since that is not the default for the system sqlite3.

On Sat, Mar 27, 2021 at 9:19 PM Jack L. <xxj...@gm...> wrote:
>
> It looks like it's using the system version which does have dbpage
> table support compiled in.
>
> -- ========== Configuring sqlite ==========
> -- Checking for module 'sqlite3 >= 3.32.0'
> --   Found sqlite3 , version 3.34.1
> -- Using 'sqlite' system library
>
> usr/ports/databases/sqlite3 # make showconfig
> ===> The following configuration options are available for sqlite3-3.34.1,1:
>     ARMOR=off: Detect misuse of the API
>     DBPAGE=on: Enable DBPAGE Virtual Table
>     DBSTAT=on: Enable DBSTAT Virtual Table
>     DIRECT_READ=on: File is read directly from disk
>     DQS=on: Double-quoted String Literals
>     EXTENSION=on: Allow loadable extensions
>     FTS3_TOKEN=on: Enable two-args version fts3_tokenizer
>     FTS4=on: Enable FTS3/4 (Full Text Search) module
>     FTS5=on: Enable version 5 full-text search engine
>     LIKENOTBLOB=off: LIKE does not match blobs
>     MEMMAN=off: Allow it to release unused memory
>     METADATA=on: Enable column metadata
>     NORMALIZE=off: Enable normalized sql function
>     NULL_TRIM=off: Omits NULL columns at the ends of rows
>     RBU=off: Enable the resumable bulk update
>     SECURE_DELETE=on: Overwrite deleted information with zeros
>     SORT_REF=off: To use references in the sorter
>     STMT=off: Prepared statement scan status
>     STSHELL=on: Statically link libsqlite3 into shell
>     TCL=off: Enable tcl extension and sqlite_analyzer
>     THREADS=on: Threading support
>     TRUSTED_SCHEMA=off: SQL functions & virtual tables are considered unsafe
>     UNKNOWN_SQL=off: Suppress unknown function errors
>     UNLOCK_NOTIFY=on: Enable notification on unlocking
>     URI=on: Enable use the URI filename
>     URI_AUTHORITY=off: Allow convert URL into a UNC
> ====> Optional extensions
>     JSON1=off: Enable the JSON1 extension
>     SESSION=off: Enable the session extension
> ====> Optional functions
>     OFFSET=off: Enable sqlite_offset() returning record's file offset
>     SER1=off: Enable the sqlite3_[de]serialize() interface
>     SOUNDEX=off: Enable the soundex() SQL function
> ====> Unicode support
>     ICU=off: Unicode support via ICU
>     UNICODE61=on: Unicode Version 6.1 tokenizer
> ====> Index type for range queries
>     RTREE=on: Enable R*Tree module
>     RTREE_INT=off: Store 32-bit sig int (no float) coordinates
>     GEOPOLY=off: Uses the GeoJSON notation (RFC-7946)
> ====> Where to store temporary file: you have to select exactly one of them
>     TS0=off: Always use temporary file
>     TS1=off: File by default, change allowed PRAGMA
>     TS2=off: Memory by default, change allowed PRAGMA
>     TS3=on: Always use memory
> ====> Which query planner to use, stability or ...: you can only
> select none or one of them
>     STAT3=off: Collect histogram data from leftmost column
>     STAT4=off: Collect histogram data from all columns
> ====> Command line editing library: you can only select none or one of them
>     READLINE=off: Command line editing via libreadline
>     LIBEDIT=off: Command line editing via libedit
>
> On Sat, Mar 27, 2021 at 9:11 PM Leland <ll...@ho...> wrote:
> >
> > Are you using FreeBSD's sqlite3 package or the one we supply?  We require the sqlite "dbpage table" support be compiled in.  This is controlled with the SQLITE_ENABLE_DBPAGE_VTAB sqlite3 compile define.
> >
> > > -----Original Message-----
> > > From: Jack L. <xxj...@gm...>
> > > Sent: Saturday, March 27, 2021 10:28 PM
> > > To: Audacity-Devel list <aud...@li...>
> > > Subject: [Audacity-devel] Internal Error DBConnection
> > >
> > > I was using the latest audacity 3.0.0 with all the patches on FreeBSD and just
> > > came across an "Internal Error". I ctrl+o and opened file1,
> > > ctrl+o another file 2, closed file 1, following message appears:
> > >
> > > 20:21:04: Debug: Cached a statement for 3
> > > 20:21:36: Debug: Cached a statement for 1
> > > 20:21:54: Debug: Cached a statement for 6
> > > 20:21:54: Debug: prepare error no such table: sqlite_dbpage
> > >
> > > and then internal error in screenshot. After closing all the dialogs, it was
> > > working normally again.
> >
> >
> >
> > _______________________________________________
> > audacity-devel mailing list
> > aud...@li...
> > https://lists.sourceforge.net/lists/listinfo/audacity-devel