Haime Croeze

@tjchester I updated Buddypress to version 2.3.1 (from 2.2.3.1) and problem was solved 🙁 Anyhow, thread can be closed 🙂

Hi @tjchester I have disabled all plugins except for Buddypress, BBWall and BBMedia and the issue still exists. So it could be something of BBMedia itself?

regards

@tjchester the load more works in main activity screen and also in the member photo tab. The only place it does not work is in the global page.

@admin @tjchester Thanks for the update!

I do notice one bug still…

after the db update still it does not have the correct count. See attached of one of my users. Count says 4 photo’s but she has five. The first four where uploaded in a batch (4 photo’s at once) and the last one (the dog) was uploaded as a single photo.

So after the update…[Read more]

@daniel_amigos muchas gracias

@tjchester no, the count shown is the count op uploads, not the count of actual photo’s. Thus if I upload 4 photo’s at once it will increase with +1 instead of +4. I have more then a thousand photo’s which I uploaded in 4-photo-upload actions.

@tjchester see below a screenshot of my wall with the not-translated dropdown items and also a screenshot of my LocoTranslate screen where I have translated what appears to be those items.

All other fields did translate correctly btw.

@tjchester I solved it! 🙂

I added a new function at the top on media-functions.php (and deleted the lines you suggested)

function bbmedia_allow_large_joins()
{
global $wpdb;
$wpdb->query('SET SQL_BIG_SELECTS=1');
}
add_action('init', 'bbmedia_allow_large_joins');

anyway, if devs can implement something like what I suggested above…[Read more]

@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…[Read more]

@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 🙂

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…[Read more]

@tjchester I found the bug and it is a nasty one 🙁

I have exactly 1000 photo’s uploaded on my site (990 visible and 10 deleted from activity by users but still in attachment table). As soon as I add photo number 1001 (I tried with several photo’s to be sure that it was not because the photo itself was corrupted) my global media page will not…[Read more]

@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…[Read more]

@tjchester

I downgraded to 3.0.1 now because on my test site (http://test3.croeze.net/fotoalbum/) that one works. Unfortunately on live the downgrade does not help either…

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

regards

@style960 I managed to replicate most of the member page with the following code in a normal wordpress page (inserted in text mode!), maybe something you can do also

<div id="buddypress">
<div id="item-nav">
<div id="object-nav" class="item-list-tabs no-ajax">
<ul>
<li id="clubinfo-algemeen-li"><a id="clubinfo-activity"…[Read more]