Database update #7 fails

I am unable to successfully run database update #7 (Delete give_logs and give_logmeta). I followed the recommended steps including enabling advanced database updates. All the update statuses are successful except #7. Here are my environment versions (WP version 6.0, PHP version 7.4.28, GiveWP version 2.20.2).

Note: I checked the database and the give_log table exists with 21 entries and the give_logmeta table does not exist.

Here are the first few lines of the error file:

Migration Failed
Migration ID:
delete_old_log_tables
Last run:
2022-06-14 14:58:47
Error details:
Give\Framework\Database\Exceptions\DatabaseQueryException Object
(
[queryErrors:Give\Framework\Database\Exceptions\DatabaseQueryException:private] => Array
(
[0] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 1
)

[message:protected] => Query failed in database
[string:Exception:private] =>
[code:protected] => 0
[file:protected] => /home3/hristmp9/public_html/wp-content/plugins/give/src/Framework/Database/Exceptions/DatabaseQueryException.php
[line:protected] => 34
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => /home3/hristmp9/public_html/wp-content/plugins/give/src/Framework/Database/DB.php
[line] => 242
[function] => create
[class] => Give\Framework\Database\Exceptions\DatabaseQueryException
[type] => ::
[args] => Array
(
[0] => Array
(
[0] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 1
)`
Any suggestions?

Thanks in advance,
Doug

• This topic was modified 3 years, 11 months ago by dheatherly.