Error in site error_log (cPanel File Manager)
-
Hi,
In the last few days I have started getting the below error appearing in my site’s error log;WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'where media_type IN ('photo','video','music') ...' at line 3 for query SELECT activity_id, media_type from where media_type IN ('photo','video','music') and context = 'group' and context_id = 1 and blog_id = 1 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/blocksy/page.php'), get_template_part, locate_template, load_template, require('/themes/blocksy/single.php'), get_template_part, locate_template, load_template, require('/themes/blocksy/template-parts/single.php'), the_content, apply_filters('the_content'), WP_Hook->apply_filters, bp_replace_the_content, apply_filters('bp_replace_the_content'), WP_Hook->apply_filters, BP_Groups_Theme_Compat->single_content, bp_buffer_template_part, bp_get_template_part, bp_locate_template, load_template, require('/themes/blocksy-child/buddypress/groups/single/home.php'), bp_get_template_part, bp_locate_template, load_template, require('/themes/blocksy-child/buddypress/groups/single/cover-image-header.php'), do_action('bp_after_group_header'), WP_Hook->do_action, WP_Hook->apply_filters, bp_ap_rtmedia_update_group_medias_countThe query SELECT and the very last part makes me think that this is to do with your plugin, but if it is not I apologise and would appreciate any suggestions as to what might be causing it. I should add that there are 3 slightly different versions of this error, with the only difference being the number in context_id = 1 ( 2 or 3 being the others) which I think might relate to the id number of the Buddypress Groups. I am using the most up to date versions of WordPress and your plugin, and all other plugins are also up to date, and at present the site is on PHP 7.4, if that is in any way relevant. I am trying to work out if anything occurred on the date the errors started (first one was on 27-Sep-2022 21:42:27 UTC) but as things are being tested it is difficult to know.The only new plugin added that day was Buddypress Global Search but as these errors are not frequent (4 in total), if I deactivate that plugin I’m not going to know one way or another if it is the cause, but given the little I understand about such errors I think it is unlikely to be.
As far as I can tell, so far these errors are not affecting anything to do with how the site is operating, but we are still in a test phase, so it could be that something will be affected under certain conditions. As mentioned they are not very frequent, so are probably only triggered by either a visit to a certain page or carrying out a certain action, which I have not yet been able to work out. Any help that is forthcoming would be most appreciated.
P.S.
I think I have just discovered what triggers the error – when I visit the home page of a group a new error appears and (as I suspected) the context_id changes to the group’s id.
-
Turning off group messaging made no difference, the errors still occur. And things are more serious than I thought – no media is being uploaded. The process of posting works but the post only has text, no media when published, and nothing in the Media tab for the user Profile or Group > Media tab. I don’t know if the error is connected to this, but obviously this is a big problem as it is the core function of your plugin. I am going to see if another plugin is conflicting but would appreciate your assistance, especially if there are any known plugins that conflict, or other things that can cause your plugin to fail.
UPDATE: the error in the error log has been eliminated by deactivating a plugin – BuddyPress Activity Privacy – BUT it is still not possible to upload any media
- The topic ‘Error in site error_log (cPanel File Manager)’ is closed to new replies.
