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.