Closed morganwdavis closed 3 weeks ago
I can replicate the issue, but so far I've been unable to find a reliable solution. As a workaround, installing the sqlite-object-cache plugin along with this one, fixes the issue - and also improves performance.
@OllieJones do you have any idea on how to address this? Can you see why installing the sqlite-object-cache plugin would fix the issue? đŸ¤”
installing the sqlite-object-cache plugin along with this one, fixes the issue
This made no difference for me. Errors persist still on every site interaction. In case it matters, this site is (unfortunately) still running PHP 7.4.33 due to legacy PHP apps. All other aspects of WordPress 6.5.3 are functional, however.
If you use a persistent object cache (presumably any of them, not just the SQLite one) transients are stored there, and not in the main database. That accounts for this problem being concealed when such a cache is active. This code path runs a cronjob, and so sets the "doing_cron" transient.
And, the offending query here is INSERT ... ON DUPLICATE KEY UPDATE... I can't see from the traceback whether that gets translated to SQLite's version of that syntax.
Is it possible the SQLite version on @morganwdavis 's server/php installation is prior to 3.24? If so, it will gack on SQLite's UPSERT (ON CONFLICT) syntax. https://www.plumislandmedia.net/reference/sqlite3-in-php-some-notes/#upsert Just a thought.
Is it possible the SQLite version on @morganwdavis 's server/php installation is prior to 3.24?
No. sqlite3 —version
reports 3.45.1
With the PHP base version being 7.4.33 (same for all the PHP extensions). I might try lifting the site over to a newer server with the latest of everything and see if the errors persist.
I found the fix for this. Closing this and creating a new issue.
Version 2.1.9
I'm continuing to see these entries (and similar) appear in the PHP error log many times per minute while accessing the site. The
no such column: wp_options
seems to happen when the ON DUPLICATE translator messes up quotation marks by using the wrong ones (at least in my experience with this in the past). I thought this was fixed in recent versions of the plugin but apparently not.Is this something the code needs to fix, or is there something in the database on my end that I need to fix/clear out?