Support Forums

@tjchester I tried both your suggestions. No difference. See http://www.dewaaghalsjes.nl/fotoalbum/

regards

@tjchester I think I found the problem. I deleted about 100 of the last posted photo’s from activity (and from the media library ( 🙁 because deleting from activity does not delete the actual attachment…) and then the global media page was working again.

I do think it is a bug in the global media code though because in profile and in activity it did show all the photo’s and only on the global media page i got the “No photo’s found” message…

Anyway, busy now placing all my albums back online…

regards

error with debug set to true:

WordPress database error: [The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay] SELECT DISTINCT a.id FROM 0_bp_activity a INNER JOIN 0_bp_activity_meta ON ( a.id = 0_bp_activity_meta.activity_id ) INNER JOIN 0_bp_activity_meta AS mt1 ON ( a.id = mt1.activity_id ) INNER JOIN 0_bp_activity_meta AS mt2 ON ( a.id = mt2.activity_id ) LEFT JOIN 0_bp_activity_meta AS bbamt ON (a.id = bbamt.activity_id AND bbamt.meta_key = ‘buddyboss_media_album_id’) WHERE a.is_spam = 0 AND a.hide_sitewide = 0 AND ( 0_bp_activity_meta.meta_key = ‘buddyboss_media_aid’ OR mt1.meta_key = ‘buddyboss_pics_aid’ OR mt2.meta_key = ‘bboss_pics_aid’ ) AND a.type NOT IN (‘activity_comment’, ‘last_activity’) AND (bbamt.activity_id IS NULL OR bbamt.meta_value IN ( 1,2,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18)) ORDER BY a.date_recorded DESC LIMIT 0, 21

@tjchester if in the meanwhile they can guide me how to add SET OPTION SQL_BIG_SELECTS = 1 to the sql statements in /includes/media-functions.php as a quick temporary fix I would be eternally grateful 🙂

@tjchester unfortunately it did not work. This is what I did:

line 117 and further:

	$wpdb->query('SET OPTION SQL_BIG_SELECTS = 1');
	return "SELECT COUNT(*) FROM $activity_table a
                INNER JOIN $activity_meta_table am ON a.id = am.activity_id
                LEFT JOIN (SELECT id FROM $groups_table WHERE status != 'public' ) grp ON a.item_id = grp.id
                WHERE 1=1 
                AND (am.meta_key = 'buddyboss_media_aid' OR am.meta_key = 'buddyboss_pics_aid' OR am.meta_key = 'bboss_pics_aid')
                AND (a.component != 'groups' || a.item_id != grp.id)";

and line 142 and further:

	$wpdb->query('SET OPTION SQL_BIG_SELECTS = 1');
	return "SELECT a.*, am.meta_value FROM $activity_table a
          INNER JOIN $activity_meta_table am ON a.id = am.activity_id
          LEFT JOIN (SELECT id FROM $groups_table WHERE status != 'public' ) grp ON a.item_id = grp.id
          WHERE 1=1 
          AND (am.meta_key = 'buddyboss_media_aid' OR am.meta_key = 'buddyboss_pics_aid' OR am.meta_key = 'bboss_pics_aid')
          AND (a.component != 'groups' || a.item_id != grp.id)
          ORDER BY a.date_recorded DESC";

I’ll wait for the solution of the devs.

If I may suggest:

make an alternative All Albums page the default selected with album links to Album page similar to All Photo’s but then limited to album photo’s only?

regards 🙂