You found a bug. Thanks! And thanks for adding the SQLite version. It is indeed relevant.
Darn it! — I thought I defeated that particular one. It’s something to do with SQLite 3.7, and how it handles unique keys in tables.
I’m near to releasing a new version, so your report is timely.
(Squeeeeeee …. the sound of the bug-zapper charging up … )
Thread Starter
Aharon
(@spaceling)
Thank you Ollie. It’s good to know I’m helping. I’m looking now through the other error logs and I’m finding similar “unable to execute” errors (either ‘column is not unique‘ or ‘database is locked‘). Copying these below just in case they offer any additional clues.
This one is from the root error log:
#0 /home/.../.../.../wp-content/object-cache.php(1296): SQLite3Stmt->execute()
#1 /home/.../.../.../wp-content/object-cache.php(1239): WP_Object_Cache->handle_put('get_page_by_pat...', 0, 'posts', 0)
#2 /home/.../.../.../wp-content/object-cache.php(1950): WP_Object_Cache->set('get_page_by_pat...', 0, 'posts', 0)
#3 /home/.../.../.../wp-includes/post.php(5747): wp_cache_set('get_page_by_pat...', 0, 'posts')
#4 /home/.../.../.../wp-includes/class-wp.php(239): get_page_by_path('compilations/li...')
#5 /home/.../.../.../wp-includes/class-wp.php(780): WP->parse_request('')
#6 /home/.../.../.../wp-includes/functions.php(1332): WP->main('')
#7 /home/.../.../.../wp-blog-header.php(16): wp()
#8 /home/. in /home/.../.../.../wp-content/object-cache.php on line 1296
[19-Jan-2023 03:29:43 UTC] PHP Fatal error: Uncaught Exception: Unable to execute statement: database is locked in /home/.../.../.../wp-content/object-cache.php:1178
Stack trace:
#0 /home/.../.../.../wp-content/object-cache.php(1178): SQLite3Stmt->execute()
#1 /home/.../.../.../wp-content/object-cache.php(1142): WP_Object_Cache->getone('get_page_by_pat...', 'posts')
#2 /home/.../.../.../wp-content/object-cache.php(1428): WP_Object_Cache->cache_item_exists('get_page_by_pat...', 'posts')
#3 /home/.../.../.../wp-content/object-cache.php(1994): WP_Object_Cache->get('get_page_by_pat...', 'posts', false, NULL)
#4 /home/.../.../.../wp-includes/post.php(5680): wp_cache_get('get_page_by_pat...', 'posts')
#5 /home/.../.../.../wp-includes/class-wp.php(239): get_page_by_path('prayers/lunisol...')
#6 /home/.../.../.../wp-includes/class-wp.php(780): WP->parse_request('')
#7 /home/.../.../... in /home/.../.../.../wp-content/object-cache.php on line 1178
This one is from the error log in wp_admin:
[19-Jan-2023 04:51:52 UTC] PHP Fatal error: Uncaught Exception: Unable to execute statement: column name is not unique in /home/.../.../.../wp-content/object-cache.php:1296
Stack trace:
#0 /home/.../.../.../wp-content/object-cache.php(1296): SQLite3Stmt->execute()
#1 /home/.../.../.../wp-content/object-cache.php(1239): WP_Object_Cache->handle_put('wp_query:8d3851...', Array, 'posts', 0)
#2 /home/.../.../.../wp-content/object-cache.php(1950): WP_Object_Cache->set('wp_query:8d3851...', Array, 'posts', 0)
#3 /home/.../.../.../wp-includes/class-wp-query.php(3292): wp_cache_set('wp_query:8d3851...', Array, 'posts')
#4 /home/.../.../.../wp-includes/class-wp-query.php(3749): WP_Query->get_posts()
#5 /home/.../.../.../wp-content/plugins/contact-form-7/includes/contact-form.php(89): WP_Query->query(Array)
#6 /home/.../.../.../wp-content/plugins/contact-form-7/includes/block-editor/block-editor.php(58): W in /home/.../.../.../wp-content/object-cache.php on line 1296