Hi @warezit thank you for sharing this. I happen to have the same exact problem. I used WPOptimize plugin to delete unused tables in my database. I may have deleted the tables dedicated to store Buddypress messages. Users can’t send private messages and admins can’t send site-wise notices.
I wanted to confirm the steps to did to solve this. First you deleted the plugin, then backup database, then search and delete bp_ in wp_options table.
Last, you re-installed plugin.
Did you lose any data in the process. I have working site with many users.
