search

WordPress / sqlite-database-integration

Feature Plugin to add SQLite support to WordPress. Under Development.
GNU General Public License v2.0
223 stars 37 forks source link

Wordpress sqlite driver throw constraint exception when updating options #59

Open flymonkey00 opened 10 months ago

flymonkey00 commented 10 months ago

WordPress version: 6.4.1 sqlite-database-integration version: 2.1.2

After using the sqlite db driver, when I try to update Default post settings (Settings-Discussion) it always failed. And I can see the error log like this:

MySQL query: UPDATE wp_options SET option_value = NULL WHERE option_name = 'comment_registration' Queries made or created this session were: Executing: BEGIN | (no parameters) Executing: UPDATE wp_options SET option_value = NULL WHERE option_name = :param0 | parameters: comment_registration Executing: ROLLBACK | (no parameters)

and

Error occurred at line 3373 in Function handle_error. Error message was: SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: wp_options.option_value.

This issue appears to be caused by a misalignment of metadata for certain database tables.

mati75 commented 9 months ago

Confirm, I have the same error. It look like on missing param1 instead of NULL.