Update WordPress 6.7

I’m getting several errors while trying to do the database update of WordPress 6.7

[13-Nov-2024 07:25:09 UTC] WordPress database error

MySQL query:

ALTER TABLE wp_terms CHANGE COLUMN term_id term_id bigint(20) unsigned NOT NULL auto_increment

Queries made or created this session were:

1. Executing: BEGIN | (no parameters)
2. Executing: INSERT INTO _mysql_data_types_cache (table, column_or_index, mysql_type) VALUES (:table, :column, :datatype) ON CONFLICT(table, column_or_index) DO UPDATE SET mysql_type = :datatype | parameters: wp_terms, term_id, bigint(20) unsigned
3. Executing: DROP TRIGGER IF EXISTS “__wp_terms_term_id_on_update__” | (no parameters)
4. Executing: SELECT sql FROM sqlite_master WHERE type=”table” AND name=:table | (no parameters)
5. Executing: SELECT * FROM pragma_index_list(“wp_terms”) as l; | (no parameters)
6. Executing: SELECT * FROM pragma_index_info(“name”) as l; | (no parameters)
7. Executing: SELECT * FROM pragma_index_info(“slug”) as l; | (no parameters)
8. Executing: CREATE TABLE _tmp__wp_terms_43411102 as SELECT * FROM wp_terms | (no parameters)
9. Executing: DROP TABLE wp_terms | (no parameters)
10. Executing: CREATE TABLE “wp_terms” ( term_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL DEFAULT ”, slug TEXT NOT NULL DEFAULT ”, term_group integer NOT NULL default 0 ) | (no parameters)
11. Executing: INSERT INTO wp_terms SELECT * FROM _tmp__wp_terms_43411102 | (no parameters)
12. Executing: DROP TABLE _tmp__wp_terms_43411102 | (no parameters)
13. Executing: CREATE INDEX IF NOT EXISTS name ON wp_terms () | (no parameters)
14. Executing: ROLLBACK | (no parameters)

Error occurred at line 4117 in Function handle_error. Error message was: SQLSTATE[HY000]: General error: 1 near “)”: syntax error.

Backtrace: #0 /var/www/html/fa/wordpress/wp-content/plugins/sqlite-database-integration/wp-includes/sqlite/class-wp-sqlite-db.php(299): WP_SQLite_Translator->get_error_message() #1 /var/www/html/fa/wordpress/wp-admin/includes/upgrade.php(3271): WP_SQLite_DB->query(‘ALTER TABLE wp_…’) #2 /var/www/html/fa/wordpress/wp-admin/includes/upgrade.php(3312): dbDelta(Array) #3 /var/www/html/fa/wordpress/wp-admin/includes/upgrade.php(662): make_db_current_silent() #4 /var/www/html/fa/wordpress/wp-admin/upgrade.php(147): wp_upgrade() #5 {main}

for query ALTER TABLE wp_terms CHANGE COLUMN term_id term_id bigint(20) unsigned NOT NULL auto_increment made by wp_upgrade, make_db_current_silent, dbDelta, WP_SQLite_DB->query, WP_SQLite_DB->print_error
[13-Nov-2024 07:25:09 UTC] WordPress database error

MySQL query:

ALTER TABLE wp_terms CHANGE COLUMN name name varchar(200) NOT NULL default ”

Queries made or created this session were:

1. Executing: BEGIN | (no parameters)
2. Executing: INSERT INTO _mysql_data_types_cache (table, column_or_index, mysql_type) VALUES (:table, :column, :datatype) ON CONFLICT(table, column_or_index) DO UPDATE SET mysql_type = :datatype | parameters: wp_terms, name, varchar(200)
3. Executing: DROP TRIGGER IF EXISTS “__wp_terms_name_on_update__” | (no parameters)
4. Executing: SELECT sql FROM sqlite_master WHERE type=”table” AND name=:table | (no parameters)
5. Executing: SELECT * FROM pragma_index_list(“wp_terms”) as l; | (no parameters)
6. Executing: SELECT * FROM pragma_index_info(“name”) as l; | (no parameters)
7. Executing: SELECT * FROM pragma_index_info(“slug”) as l; | (no parameters)
8. Executing: CREATE TABLE _tmp__wp_terms_75042776 as SELECT * FROM wp_terms | (no parameters)
9. Executing: DROP TABLE wp_terms | (no parameters)
10. Executing: CREATE TABLE “wp_terms” ( term_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL DEFAULT ”, slug TEXT NOT NULL DEFAULT ”, term_group integer NOT NULL default 0 ) | (no parameters)
11. Executing: INSERT INTO wp_terms SELECT * FROM _tmp__wp_terms_75042776 | (no parameters)
12. Executing: DROP TABLE _tmp__wp_terms_75042776 | (no parameters)
13. Executing: CREATE INDEX IF NOT EXISTS name ON wp_terms () | (no parameters)
14. Executing: ROLLBACK | (no parameters)

Error occurred at line 4117 in Function handle_error. Error message was: SQLSTATE[HY000]: General error: 1 near “)”: syntax error.

Backtrace: #0 /var/www/html/fa/wordpress/wp-content/plugins/sqlite-database-integration/wp-includes/sqlite/class-wp-sqlite-db.php(299): WP_SQLite_Translator->get_error_message() #1 /var/www/html/fa/wordpress/wp-admin/includes/upgrade.php(3271): WP_SQLite_DB->query(‘ALTER TABLE wp_…’) #2 /var/www/html/fa/wordpress/wp-admin/includes/upgrade.php(3312): dbDelta(Array) #3 /var/www/html/fa/wordpress/wp-admin/includes/upgrade.php(662): make_db_current_silent() #4 /var/www/html/fa/wordpress/wp-admin/upgrade.php(147): wp_upgrade() #5 {main}

for query ALTER TABLE wp_terms CHANGE COLUMN name name varchar(200) NOT NULL default ” made by wp_upgrade, make_db_current_silent, dbDelta, WP_SQLite_DB->query, WP_SQLite_DB->print_error
[13-Nov-2024 07:25:09 UTC] WordPress database error

MySQL query:

ALTER TABLE wp_terms CHANGE COLUMN slug slug varchar(200) NOT NULL default ”

Queries made or created this session were:

1. Executing: BEGIN | (no parameters)
2. Executing: INSERT INTO _mysql_data_types_cache (table, column_or_index, mysql_type) VALUES (:table, :column, :datatype) ON CONFLICT(table, column_or_index) DO UPDATE SET mysql_type = :datatype | parameters: wp_terms, slug, varchar(200)
3. Executing: DROP TRIGGER IF EXISTS “__wp_terms_slug_on_update__” | (no parameters)
4. Executing: SELECT sql FROM sqlite_master WHERE type=”table” AND name=:table | (no parameters)
5. Executing: SELECT * FROM pragma_index_list(“wp_terms”) as l; | (no parameters)
6. Executing: SELECT * FROM pragma_index_info(“name”) as l; | (no parameters)
7. Executing: SELECT * FROM pragma_index_info(“slug”) as l; | (no parameters)
8. Executing: CREATE TABLE _tmp__wp_terms_50097820 as SELECT * FROM wp_terms | (no parameters)
9. Executing: DROP TABLE wp_terms | (no parameters)
10. Executing: CREATE TABLE “wp_terms” ( term_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL DEFAULT ”, slug TEXT NOT NULL DEFAULT ”, term_group integer NOT NULL default 0 ) | (no parameters)
11. Executing: INSERT INTO wp_terms SELECT * FROM _tmp__wp_terms_50097820 | (no parameters)
12. Executing: DROP TABLE _tmp__wp_terms_50097820 | (no parameters)
13. Executing: CREATE INDEX IF NOT EXISTS name ON wp_terms () | (no parameters)
14. Executing: ROLLBACK | (no parameters)

Error occurred at line 4117 in Function handle_error. Error message was: SQLSTATE[HY000]: General error: 1 near “)”: syntax error.

Backtrace: #0 /var/www/html/fa/wordpress/wp-content/plugins/sqlite-database-integration/wp-includes/sqlite/class-wp-sqlite-db.php(299): WP_SQLite_Translator->get_error_message() #1 /var/www/html/fa/wordpress/wp-admin/includes/upgrade.php(3271): WP_SQLite_DB->query(‘ALTER TABLE wp_…’) #2 /var/www/html/fa/wordpress/wp-admin/includes/upgrade.php(3312): dbDelta(Array) #3 /var/www/html/fa/wordpress/wp-admin/includes/upgrade.php(662): make_db_current_silent() #4 /var/www/html/fa/wordpress/wp-admin/upgrade.php(147): wp_upgrade() #5 {main}

for query ALTER TABLE wp_terms CHANGE COLUMN slug slug varchar(200) NOT NULL default ” made by wp_upgrade, make_db_current_silent, dbDelta, WP_SQLite_DB->query, WP_SQLite_DB->print_error
[13-Nov-2024 07:25:09 UTC] WordPress database error

MySQL query:

ALTER TABLE wp_terms CHANGE COLUMN term_group term_group bigint(10) NOT NULL default 0

Queries made or created this session were:

1. Executing: BEGIN | (no parameters)
2. Executing: INSERT INTO _mysql_data_types_cache (table, column_or_index, mysql_type) VALUES (:table, :column, :datatype) ON CONFLICT(table, column_or_index) DO UPDATE SET mysql_type = :datatype | parameters: wp_terms, term_group, bigint(10)
3. Executing: DROP TRIGGER IF EXISTS “__wp_terms_term_group_on_update__” | (no parameters)
4. Executing: SELECT sql FROM sqlite_master WHERE type=”table” AND name=:table | (no parameters)
5. Executing: SELECT * FROM pragma_index_list(“wp_terms”) as l; | (no parameters)
6. Executing: SELECT * FROM pragma_index_info(“name”) as l; | (no parameters)
7. Executing: SELECT * FROM pragma_index_info(“slug”) as l; | (no parameters)
8. Executing: CREATE TABLE _tmp__wp_terms_44619638 as SELECT * FROM wp_terms | (no parameters)
9. Executing: DROP TABLE wp_terms | (no parameters)
10. Executing: CREATE TABLE “wp_terms” ( term_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL DEFAULT ”, slug TEXT NOT NULL DEFAULT ”, term_group integer NOT NULL default 0 ) | (no parameters)
11. Executing: INSERT INTO wp_terms SELECT * FROM _tmp__wp_terms_44619638 | (no parameters)
12. Executing: DROP TABLE _tmp__wp_terms_44619638 | (no parameters)
13. Executing: CREATE INDEX IF NOT EXISTS name ON wp_terms () | (no parameters)
14. Executing: ROLLBACK | (no parameters)

Error occurred at line 4117 in Function handle_error. Error message was: SQLSTATE[HY000]: General error: 1 near “)”: syntax error.

Backtrace: #0 /var/www/html/fa/wordpress/wp-content/plugins/sqlite-database-integration/wp-includes/sqlite/class-wp-sqlite-db.php(299): WP_SQLite_Translator->get_error_message() #1 /var/www/html/fa/wordpress/wp-admin/includes/upgrade.php(3271): WP_SQLite_DB->query(‘ALTER TABLE wp_…’) #2 /var/www/html/fa/wordpress/wp-admin/includes/upgrade.php(3312): dbDelta(Array) #3 /var/www/html/fa/wordpress/wp-admin/includes/upgrade.php(662): make_db_current_silent() #4 /var/www/html/fa/wordpress/wp-admin/upgrade.php(147): wp_upgrade() #5 {main}

for query ALTER TABLE wp_terms CHANGE COLUMN term_group term_group bigint(10) NOT NULL default 0 made by wp_upgrade, make_db_current_silent, dbDelta, WP_SQLite_DB->query, WP_SQLite_DB->print_error
[13-Nov-2024 07:25:09 UTC] WordPress database error

MySQL query:

ALTER TABLE wp_term_relationships ADD PRIMARY KEY (object_id,term_taxonomy_id)

Queries made or created this session were:

1. Executing: BEGIN | (no parameters)
2. Executing: INSERT INTO _mysql_data_types_cache (table, column_or_index, mysql_type) VALUES (:table, :column, :datatype) ON CONFLICT(table, column_or_index) DO UPDATE SET mysql_type = :datatype | parameters: wp_term_relationships, wp_term_relationships__(, PRIMARY
3. Executing: CREATE PRIMARY KEY “wp_term_relationships__(” ON “wp_term_relationships” (,term_taxonomy_id) | (no parameters)
4. Executing: ROLLBACK | (no parameters)

Error occurred at line 4117 in Function handle_error. Error message was: SQLSTATE[HY000]: General error: 1 near “PRIMARY”: syntax error.

Backtrace: #0 /var/www/html/fa/wordpress/wp-content/plugins/sqlite-database-integration/wp-includes/sqlite/class-wp-sqlite-db.php(299): WP_SQLite_Translator->get_error_message() #1 /var/www/html/fa/wordpress/wp-admin/includes/upgrade.php(3271): WP_SQLite_DB->query(‘ALTER TABLE wp_…’) #2 /var/www/html/fa/wordpress/wp-admin/includes/upgrade.php(3312): dbDelta(Array) #3 /var/www/html/fa/wordpress/wp-admin/includes/upgrade.php(662): make_db_current_silent() #4 /var/www/html/fa/wordpress/wp-admin/upgrade.php(147): wp_upgrade() #5 {main}

for query ALTER TABLE wp_term_relationships ADD PRIMARY KEY (object_id,term_taxonomy_id) made by wp_upgrade, make_db_current_silent, dbDelta, WP_SQLite_DB->query, WP_SQLite_DB->print_error