BuddyBoss Home – Web › Support Forums › Plugins › BuddyBoss Media › Errors after updating to 3.1.7
- This topic has 2 replies, 2 contibutors, and was last updated 8 years, 7 months ago by Anonymous.
Question
February 11, 2016 at 12:06 am #58880@acroyesAfter 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
February 11, 2016 at 8:06 am #58920@
AnonymousHi @acroyes
Thanks for your input. Sorry for inconvenience.
I have notified about them to developers.
RegardsApril 7, 2016 at 11:07 pm #67325@
AnonymousHi @acroyes It is fixed in the latest release (3.1.9) available now.
Regards
Varun Dubey
- The question ‘Errors after updating to 3.1.7’ is closed to new replies.