[ljmac]

Hi,

A MySQL syntax error has started cropping up recently, even though I have made no changes that might be related to this (same MySQL version, same PHP version, same bbPress version, same WordPress version). Can anyone enlighten me on what might be causing this?

Once again, this only started happening recently despite the lack of any significant related changes – I have been doing forum repairs for years without any errors.

[09-Mar-2023 05:01:55 UTC] WordPress database error 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 ‘312810’)’ at line 2 for query INSERT INTO as_usermeta (user_id, meta_key, meta_value) VALUES
(‘4185’, ‘as__bbp_favorites, ‘312810’); made by require_once(‘wp-admin/admin.php’), do_action(‘load-tools_page_bbp-repair’), call_user_func_array, bbp_admin_repair_handler, call_user_func, bbp_admin_repair_user_favorites

[Robin W]

ok, not quite sure why this occurred, but the bit that says

('4185', 'as__bbp_favorites, '312810')

is lacking a closing ‘ on 'as__bbp_favorites so should read

('4185', 'as__bbp_favorites', '312810')

Is this a one off, or is it now doing this everytime?

[ljmac]

It has happened the last three times I’ve done repairs. How can I go about fixing this?

[Robin W]

it is always at the same point?

[ljmac]

TBH this is the first time I’ve recorded the error – the first couple of times I assumed it must just be some kind of random error, given that I’d never seen it before. So I can’t confirm if it has always had the missing apostrophe in that position, but I can confirm that the error always occurred in relation to the favorites.

[Robin W]

ok, if you get it again, can you record so we can see

[ljmac]

As it turns out, the last time I did repairs this error was gone. But I appreciate your help anyway – if it happens again I will know what to look for.

[Robin W]

thanks for updating us, let us know if it occurs again, and if it does, run a second time to see if that clears it