BuddyBoss Home – Web Support Forums Themes BuddyBoss theme Error Unknown column wp_bp_activity_meta.meta_key

Viewing 14 posts - 1 through 14 (of 14 total)
  • Question

    #54436
    @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

    Answers

    #54438
    @karlos

    This is the error_log file. Thank you!

    #54572
    @vapvarun

    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 @buddyboss.com">support@buddyboss.com , Please include this forum url for reference
    Error log will help to identify the exact issue
    Regards

    #54578
    @karlos

    I just did.

    Thank you!

    #54735
    @mdaniel98

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

    #54741
    @karlos

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

    #54743
    @mdaniel98

    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.

    #54754
    @karlos

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

    #54755
    @vapvarun

    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

    #54771
    @mdaniel98

    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.

    #54866
    @vapvarun

    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

    #54886
    @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!

    #54887
    @mdaniel98

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

    #54896
    @vapvarun

    🙂 great

Viewing 14 posts - 1 through 14 (of 14 total)
  • The question ‘Error Unknown column wp_bp_activity_meta.meta_key’ is closed to new replies.