Error Unknown column wp_bp_activity_meta.meta_key

[karlos]

Hello,

I am having the following error in error_log file of worpress which is apparently slowing the website down.
How can we fix?

Thank you!

[14-Dec-2015 22:54:09 Europe/Madrid] Error Unknown column ‘boeS7Iug_bp_activity_meta.meta_key’ in ‘where clause’ de la base de datos de WordPress para la consulta SELECT DISTINCT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name FROM boeS7Iug_bp_activity a LEFT JOIN boeS7Iug_users u ON a.user_id = u.ID LEFT JOIN boeS7Iug_rt_rtm_media m ON ( a.id = m.activity_id AND m.blog_id = ‘1’ ) LEFT JOIN boeS7Iug_rt_rtm_activity ra ON ( a.id = ra.activity_id and ra.blog_id = ‘1’ ) WHERE a.is_spam = 0 AND a.hide_sitewide = 0 AND (
boeS7Iug_bp_activity_meta.meta_key = ‘favorite_count’
) AND a.type NOT IN (‘activity_comment’, ‘last_activity’) AND (NOT EXISTS (SELECT m.activity_id FROM boeS7Iug_bp_activity_meta m WHERE m.meta_key=’rtmedia_privacy’ AND m.activity_id=a.id) OR ( (ra.privacy is NULL OR ra.privacy <= 0) OR ((ra.privacy=20) OR (a.user_id=73 AND ra.privacy >= 40) OR (ra.privacy=40 AND a.user_id IN (‘1446′,’144′,’1149′,’750′,’1410′,’674′,’142′,’1074′,’1100′,’896′,’535′,’400′,’1103′,’78’,’94’,’650′,’342′,’230′,’967′,’1162′,’90’,’1326′,’234′,’862′,’240′,’131′,’939′,’496′,’1000′,’1154′))) ) ) ORDER BY CAST(boeS7Iug_bp_activity_meta.meta_value AS SIGNED) DESC LIMIT 0, 5 realizada por require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/buddyboss/buddypress.php’), get_sidebar, locate_template, load_template, require_once(‘/themes/buddyboss/sidebar-buddypress.php’), dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, BuddyBoss_Most_Liked_Activity_Widget->widget, bp_has_activities, BP_Activity_Template->__construct, bp_activity_get, BP_Activity_Activity::get

[karlos]

This is the error_log file. Thank you!

[Varun Dubey]

Hi @karlos it have some rt__media related errors I have notified to developer they will check it shortly
Please send the error log at [email protected] , Please include this forum url for reference
Error log will help to identify the exact issue
Regards

[karlos]

I just did.

Thank you!

[Matt]

I have been getting this on my-site too and am interested on any resolution or direction.

[karlos]

Hi Matt. Did you find it to be slowing down your site in some way?

[Matt]

No, I have not noticed it affect the speed of our site.

And it only happens for me on certain pages… And not all the time just quite frequently.

I have hired 2 developers that have been unable to fix it – but they were never able to recreate the issue.

[karlos]

It looks like it happens when the main wall or feed is visited.

[Varun Dubey]

Hi @karlos @mdaniel98
Wall plugin have privacy option and Rtmedia also have privacy option
Try to disable RT media privacy
These errors belong to RTmedia queries for meta_key=’rtmedia_privacy’
Regards
Varun Dubey

[Matt]

actually, I noticed my error is slightly different.

WordPress database error Unknown column ‘wp_bp_activity_meta.meta_value’ in ‘order clause’ for query SELECT DISTINCT a.id FROM wp_bp_activity a WHERE a.is_spam = 0 AND a.id IN (140) AND a.type NOT IN (”, ‘last_activity’) ORDER BY CAST(wp_bp_activity_meta.meta_value AS SIGNED) DESC made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/boss/front-page.php’), get_sidebar, locate_template, load_template, require_once(‘/themes/boss/sidebar-home-right.php’), dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, BuddyBoss_Most_Liked_Activity_Widget->widget, bp_has_activities, BP_Activity_Template->__construct, bp_activity_get_specific, BP_Activity_Activity::get, referer:

I can create a new topic if needed.

[Varun Dubey]

Hi @mdaniel98
We have modified queries and following query is removed in our new updated version
Please check your error logs once again , hopefully no new more after plugin update

/*
		 SELECT DISTINCT a.id  FROM wp_bp_activity a  INNER JOIN wp_bp_activity_meta ON (a.id = wp_bp_activity_meta.activity_id)
		 WHERE a.is_spam = 0 AND a.hide_sitewide = 0 AND
		 (wp_bp_activity_meta.meta_key = 'favorite_count' ) AND a.type != 'activity_comment' AND a.type != 'last_activity'
		 ORDER BY a.date_recorded DESC LIMIT 0, 5
		 */

Regards
Varun Dubey

[karlos]

Hello,

For me, as you suggested, disabling rtMedia privacy settings fix the slowness we were suffering for about 2 weeks. Apparently somehow it conflicts with something else, probably with the theme’s owns privacy settings. Now the website is running flashing light again.

I have confirmed it: as soon as I enable rtMedia privacy, site goes horribly slow. I disable and goes back fast.

And no more error messages.

Thank you!

[Matt]

@vapvarun – thank you! I have not seen error yet today – and would have normally seen it quite a few times by now!

[Varun Dubey]

🙂 great