SQLite Forum

Problem with search feature in doc
Login

Problem with search feature in doc

(1) By anonymous on 2021-01-02 17:18:50 [link] [source]

I use a bookmark at https://www.sqlite.org/lang_corefunc.html, then use the Search "button" to get where I need to go. For the last couple of days it gives this message:

Wapp Application Error

attempt to write a readonly database
    while executing
"db2 eval {
    PRAGMA synchronous=OFF;
    PRAGMA journal_mode=OFF;
    BEGIN;
      CREATE TABLE IF NOT EXISTS log(
        ip,                  -- I..."
    (procedure "search_add_log_entry" line 7)
    invoked from within
"search_add_log_entry $nRes"
    (procedure "searchresults" line 49)
    invoked from within
"$cmd"
    ("uplevel" body line 1)
    invoked from within
"uplevel {$cmd}"
    invoked from within
"time [list uplevel $script]"
    (procedure "ttime" line 2)
    invoked from within
"ttime {$cmd}"
    invoked from within
"db transaction {
    set t [ttime {$cmd}]
  }"
    (procedure "wapp-default" line 46)
    invoked from within
"wapp-default"

Does this need to be fixed or do I need to change my habits?

Happy New Year!

(2) By Richard Hipp (drh) on 2021-01-02 19:05:10 in reply to 1 [source]

The database was owned by "root" instead of "www-data" and the website runs as user www-data, hence it couldn't write. Fixed now. Not sure how that happened. Thanks for the report!

(3) By anonymous on 2021-01-02 19:42:30 in reply to 2 [link] [source]

Thank you for the likety-split fix and response.

Cheers.