Activity

  • Brian started the question Errors after updating to 3.1.7 in the forum BuddyBoss Media 8 years, 3 months ago

    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)