I think this is same problem I have had and there is no indication here that the problem was resolved. Here is how it was resolved for me for a fews days but now having problem again: I moved to a cloud server with the innodb_page_size = 64K now. The PHP variable upload_max_filesize has been increased to 100m. It apparently worked. No more error messages when inputing multiple paragraphs into a Text Editor field.
This seemed to work for a few days and I was pretty excited but then started getting another error message. "Error, your profile could not be updated."
The tech people at my current host looked into it and ultimately came to same conclusion as my previous host, that this is caused by a limitation of CB and not a hosting issue. Since this is now the second host to say this, I guess this is the case. Here is what my host said this time:
"I have spent quite a bit of time attempting to resolve this. Increasing InnoDB page size did not help unfortunately. After researching this on the Internet I found many topics related to the exact same error, and the proposed solution was to increase the innodb_log_file_size setting. I increased that from 5 MB to 128 MB, yet the issue still remained. The problem itself appears to be due to way the Community Builder database records are structured.
Krileon, of Joomlapolis, had said a couple times to me and to kunarkintir that he thought the problem had to do with how much data we were trying to save in one field: "I believe this is due to you storing a very large amount of text (10+ paragraphs it would seam) into a single field." Apparently, this appears to be a limitation due to the way CB database is currently set up? Maybe that will change with future upgrades of CB. If anyone figures out an answer, I will be eager to hear it but otherwise, will try rebuilding yet once again and seeing if I can work around this CB database limitation.
krileon
