BuddyBoss Home – Web Support Forums Plugins BuddyBoss Media Errors after updating to 3.1.7

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

    #58880
    @acroyes

    After updating, bunch of errors on user albums and group album pages with wp_debug=true. They went away when I de-activated and reactivated the plugin, but thought you should know…

    on user albums:

    WordPress database error: [Unknown column 'a.group_id' in 'IN/ALL/ANY subquery']
    SELECT COUNT(*) FROM wp_buddyboss_media_albums a WHERE a.user_id=1 AND ( a.group_id NOT IN ( SELECT id FROM wp_bp_groups WHERE status != 'public' AND id NOT IN ( SELECT group_id FROM wp_bp_groups_members WHERE user_id = 1 ) ) OR a.group_id IS NULL)
    
    WordPress database error: [Unknown column 'a.group_id' in 'IN/ALL/ANY subquery']
    SELECT a.* FROM wp_buddyboss_media_albums a WHERE a.user_id=1 AND ( a.group_id NOT IN ( SELECT id FROM wp_bp_groups WHERE status != 'public' AND id NOT IN ( SELECT group_id FROM wp_bp_groups_members WHERE user_id = 1 ) ) OR a.group_id IS NULL) ORDER BY a.date_created DESC LIMIT 0, 20

    on group albums:

    WordPress database error: [Unknown column 'a.group_id' in 'where clause']
    SELECT COUNT(*) FROM wp_buddyboss_media_albums a WHERE a.group_id=7 AND ( a.privacy IN ( 'public','members','grouponly') OR a.user_id=1 )
    
    WordPress database error: [Unknown column 'a.group_id' in 'where clause']
    SELECT a.* FROM wp_buddyboss_media_albums a WHERE a.group_id=7 AND ( a.privacy IN ( 'public','members','grouponly') OR a.user_id=1 ) ORDER BY a.date_created DESC LIMIT 0, 20

    on creating a new album (this breaks if you don’t reactivate):
    WordPress database error: [Unknown column 'group_id' in 'field list'] INSERT INTO 'wp_buddyboss_media_albums' ('user_id', 'group_id', 'title', 'description', 'privacy', 'date_created', 'total_items') VALUES (1, 7, 'sdfdsf', '', 'public', '2016-02-11 05:43:10', 0)

    Answers

    #58920

    Anonymous
    @

    Hi @acroyes
    Thanks for your input. Sorry for inconvenience.
    I have notified about them to developers.
    Regards

    #67325

    Anonymous
    @

    Hi @acroyes It is fixed in the latest release (3.1.9) available now.

    Regards
    Varun Dubey

Viewing 3 posts - 1 through 3 (of 3 total)
  • The question ‘Errors after updating to 3.1.7’ is closed to new replies.