BuddyPress/BuddyBoss Activity Stream with DigitalOcean Managed Database (solved)

To assist other users who may also be attempting to use BuddyPress or BuddyBoss Platform with a DigitalOcean managed MySQL database I want to report an issue that arose for me with the stock managed database configuration.

The issue was with the BuddyPress Activity Stream. Activity posts would not load when the BuddyPress Groups component was active.

I traced the problem to a BuddyPress query that was throwing an “unknown column” error. This type of error occurs when MySQL cannot match a column in the query with a column in the database. It usually indicates a problem with the query syntax.

In this case, however, the problem appeared to be on the database side. BuddyBoss Platform worked fine in other environments. And so I began looking for things I could control on the managed database.

The solution turned out to be to delete one of the default Global SQL Modes in the settings tab of the database management console. By deleting the “ANSI_QUOTES” mode I was able to prevent the error and solve the problem.

At the time of this writing, BuddyBoss Platform is on version 2.5.90 and MySQL is version 8. It appears possible that there is a glitch in the code that generates this particular query. Everything else in BuddyBoss Platform works with the stock managed database. I have raised this question with the developers, but for now this solution is working for me.

Submit an answer

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

Sign In or Sign Up to Answer

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Bobby Iliev
Site Moderator
Site Moderator badge
April 17, 2024


Happy to hear that you’ve managed to get this working by deleting the ANSI_QUOTES mode!

Thank you for sharing that solution here with the community.

Good luck with your project and feel free to post new questions in case that anything else pops up!



Try DigitalOcean for free

Click below to sign up and get $200 of credit to try our products over 60 days!

Sign up

Featured on Community

Get our biweekly newsletter

Sign up for Infrastructure as a Newsletter.

Hollie's Hub for Good

Working on improving health and education, reducing inequality, and spurring economic growth? We'd like to help.

Become a contributor

Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.

Welcome to the developer cloud

DigitalOcean makes it simple to launch in the cloud and scale up as you grow — whether you're running one virtual machine or ten thousand.

Learn more
DigitalOcean Cloud Control Panel