Weird database error

[wannabe]

Hi,

I have a weird error in my apache error log;

Is this related to KLEO or some other plugin?

COPY CODE

[Thu Jul 30 11:42:01.395028 2015] [fcgid:warn] [pid 3124] [client 1.1.1.1:62403] mod_fcgid: stderr: WordPress databasefout 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 'where media_type IN ('photo','video','music') , referer: http://somewebsite.nl/groups/altenatief-nieuws/members/
[Thu Jul 30 11:42:01.395130 2015] [fcgid:warn] [pid 3124] [client 1.1.1.1:62403] mod_fcgid: stderr: \t    \t                        an' at line 3 bij query SELECT activity_id, media_type , referer: http://somewebsite.nl/groups/altenatief-nieuws/members/
[Thu Jul 30 11:42:01.395141 2015] [fcgid:warn] [pid 3124] [client 1.1.1.1:62403] mod_fcgid: stderr: \t    \t                       from  , referer: http://somewebsite.nl/groups/altenatief-nieuws/members/
[Thu Jul 30 11:42:01.395148 2015] [fcgid:warn] [pid 3124] [client 1.1.1.1:62403] mod_fcgid: stderr: \t    \t                      where media_type IN ('photo','video','music') , referer: http://somewebsite.nl/groups/altenatief-nieuws/members/
[Thu Jul 30 11:42:01.395155 2015] [fcgid:warn] [pid 3124] [client 1.1.1.1:62403] mod_fcgid: stderr: \t    \t                        and context = 'group' , referer: http://somewebsite.nl/groups/altenatief-nieuws/members/
[Thu Jul 30 11:42:01.395185 2015] [fcgid:warn] [pid 3124] [client 1.1.1.1:62403] mod_fcgid: stderr: \t    \t                        and context_id = 1  , referer: http://somewebsite.nl/groups/altenatief-nieuws/members/
[Thu Jul 30 11:42:01.395196 2015] [fcgid:warn] [pid 3124] [client 1.1.1.1:62403] mod_fcgid: stderr: \t    \t                        and blog_id = 1 created by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/kleo/buddypress.php'), the_content, apply_filters('the_content'), call_user_func_array, bp_replace_the_content, apply_filters('bp_replace_the_content'), call_user_func_array, BP_Groups_Theme_Compat->single_content, bp_buffer_template_part, bp_get_template_part, bp_locate_template, load_template, require('/themes/kleo/buddypress/groups/single/home.php'), bp_get_template_part, bp_locate_template, load_template, require('/themes/kleo/buddypress/groups/single/group-header.php'), do_action('bp_after_group_header'), call_user_func_array, bp_ap_rtmedia_update_group_medias_count, referer: http://somewebsite.nl/groups/altenatief-nieuws/members/

[sharmstr]

Looks like rtMedia.

Hi there!!! Help others from the community and mark any reply as solution if it solved your question. Mark as a solution

This support site is not about custom work. If you need custom development please contact cornel@seventhqueen.com

[sharmstr]

are you using bp activity privacy? https://wordpress.org/support/topic/integration-with-rtmedia

perhaps not running a supported version of mysql?

Hi there!!! Help others from the community and mark any reply as solution if it solved your question. Mark as a solution

This support site is not about custom work. If you need custom development please contact cornel@seventhqueen.com

[wannabe]

Yes confirmed, it is activity privacy. Thanks 🙂

[sharmstr]

Great.

Hi there!!! Help others from the community and mark any reply as solution if it solved your question. Mark as a solution

This support site is not about custom work. If you need custom development please contact cornel@seventhqueen.com

[wannabe]

For those who are experiencing the same here is a fix;

You see, the table_name is not set in query.

I use the latest release of rtMedia with the latest release of BuddyPress Activity Privacy on WordPress 4.0.

I changed the lines 330, 472 in your code in file /includes/bp-activity-privacy-integrations.php

from
$table_name = $rtmedia_query->model->table_name;
to
$table_name = $wpdb->base_prefix.”rt_rtm_media”;

Now the error is going away and it works fine for me.

Please fix this for next updates, so my changes are not lost.

Thanks

Original poster

[sharmstr]

Just to be clear, /includes/bp-activity-privacy-integrations.php is NOT part of Kleo. Its part of the buddypress activity privacy plugin. Kleo will not be making any changes to make it upgrade safe.

Thank you for the info @wannabe

Hi there!!! Help others from the community and mark any reply as solution if it solved your question. Mark as a solution

This support site is not about custom work. If you need custom development please contact cornel@seventhqueen.com

[Author]

Posts