BuddyPress.org

This is related to the strict mode of mysql. https://buddypress.org/forums/topic/there-was-a-problem-posting-your-update-please-try-again

BP 1.2.2 works provided you run a script to fix an existing table.

Here is the link that helped me solve this problem:

https://trac.buddypress.org/ticket/1999#comment:9