[d3vnu77]

When accessing an activity posts via the buddypress API…

Ok, it let me post that… I’ll try and continue here…

We are building an iOS/Andriod app for our social media platform based on buddypress/youzer.

When accessing the following link: https://n2aa.org/wp-json/buddypress/v1/activity/?component=activity&per_page=10

The activity posts that are displayed that are of the type “activity_photo” is not returning the image in the content.rendered field.

Trying to figure out if this is something on the youzer side of the code or the buddypress side of the code.

Here are couple images that explain the issue.

https://i.ibb.co/1JvTn7W/activity-photo-json-web-rendered.png

https://i.ibb.co/gdWSTRQ/activity-photo-json.png

[d3vnu77]

Nevermind, it looks like you may be right!

[d3vnu77]

@vapvarun I’ve tested and the same amount of rows exist in the new database

[d3vnu77]

@vapvarun Which rows would those be? This was the second time I’ve exported and then imported the database with the same result.

If I am logged in as admin, I can see all the activity fine.

[d3vnu77]

I should also mention that the migration was from a Maria15 database to a MySQL 8 Managed Database with Digital Ocean

[d3vnu77]

The above query fails on an unauthenticated user.

On an authenticated member the follow query fails:

SELECT DISTINCT a.id
FROM wp_bp_activity a
WHERE a.type IN ( ‘activity_status’,’activity_quote’,’activity_photo’,’activity_video’,’activity_audio’,’activity_giphy’,’activity_update’,’new_member’,’friends_register_activity_action’,’created_group’,’joined_group’,’activity_update’ )
AND a.is_spam = 0
AND a.hide_sitewide = 0
AND a.type NOT IN (‘activity_comment’, ‘last_activity’)
AND a.privacy NOT IN (‘onlyme’,’friends’)
OR a.user_id IN ( 360,244,1,274,262,172,128,46,263,270,264,261,105,168,148,155,154,145,146,144,116,133,107,135,137,115,114,118,117,111,82,37,78,93,90,79,75,31,38,41,39,35,15,21,12,10,29,33,28,26,11,2)
AND a.privacy = “friends”
OR a.user_id = 2
AND a.privacy = “onlyme”
AND a.user_id NOT IN(87,409)
ORDER BY a.date_recorded DESC, a.id DESC
LIMIT 0, 21

1054 – Unknown column ‘friends’ in ‘where clause’