Can't repair database changing from older Sqlite DB to new driver

[ngocphamm]

I came across an issue with Scheduled actions on my test WP instance using SQLite database. After some digging, I realized it's likely because I am still using the older driver, which didn't get updated to support the query that is causing issue #241.

So I tried to get my SQLite plugin to use the new format, by following the migration instructions here https://make.wordpress.org/playground/2025/06/13/introducing-a-new-sqlite-driver-for-wordpress/

After adding define( 'WP_SQLITE_AST_DRIVER', true ); to wp-config.php, reloading any page leads to the page saying I need to repair the database

Clicking that button and another message

After adding define('WP_ALLOW_REPAIR', true); to wp-config.php, then I see

Clicking either option would result in an error screen saying it can't repair multiple tables.

The list of the tables is

wp_users: 
wp_usermeta: 
wp_posts: 
wp_comments: 
wp_links: 
wp_options: 
wp_postmeta: 
wp_terms: 
wp_term_taxonomy: 
wp_term_relationships: 
wp_termmeta: 
wp_commentmeta: 

My WordPress instance

• WordPress: 6.9
• PHP 8.3.28

Active plugins

Can someone point me to a direction where I can get this fixed? And please let me know if there's some debugging information I can provide to help.

[JanJakes]

@ngocphamm Without the actual database, I'm unfortunately not able to figure out what happened here. There have been some improvements to the migration logic. Is this still an issue? If so, we can reopen this.