Hmmm, I am the host. You're right. The problem is that setting ROW_FORMAT=DYNAMIC is ineffective unless the innodb-file-per-table option is set and in effect.

But where is all this documented? I've looked at the Community Builder Technical Requirements page, and all it says about the database is "Joomla 3.x requires MYSQL version 5.1 or better". It refers to the Joomla documentation, but that says nothing more than that the minimum requirement is 5.1.

In fact, I'm running MariaDB 5.5 (which should be wholly compatible with MySQL 5.5) with InnoDB support. But that clearly isn't enough. Indeed, some of the options that you are saying are requirements for Community Builder are not supported in MySQL 5.1. (They are supported in the InnoDB plugin, but that is an advanced option, and is not the standard MySQL 5.1).

It's wasted quite a lot of my time (and some of yours) struggling through these issues. Shouldn't there be proper documentation somewhere describing just what the database requirements really are?

And, as I said, InnoDB is supported on my database server. None of what you say alters the fact that my database server exceeds the minimum requirements stated by both Community Builder and Joomla.

The database is utf8mb4 for no other reason than that Joomla seems to be pushing that way, for better or worse. See for example issues.joomla.org/tracker/joomla-cms/8472.

I could easily enough convert to utf8, but you didn't mention that until now. It was stated that the DB was utf8mb4 in my initial post.

Nobody can use "at least MySQL 5.7" because there is no GA release beyond 5.7. Your history is substantially adrift. MySQL 5.7 went GA in October 2015, which makes it a lot less than five years old. Looking at a few hosts, SIteground appears to have moved to MySQL 5.6 around eighteen months ago, SFAIK that's where they still are. Hostgator's web site says that their shared hosting uses MySQL 5.5. Both 5.5 and 5.6 remain supported releases. A number of web hosts are using MariaDB (now the default database option in a number of Linux distributions), probably on a variety of releases.

At present I do not wish to move beyond 5.5 for the simple reason that I run a shared database that supports a number of web sites at different stages of technology. There is also the consideration that a move beyond 5.5 requires a decision between MySQL and MariaDB since the two systems are no longer wholly compatible after 5.5. It is probable that my DB server will move to MariaDB 10.2 over the next few months as the client web sites catch up with technology.

But, I would emphasise that the point I am making is that where you have a page stating what the technical requirements are for Community Builder, it should contain an accurate statement that is complete enough to ensure that the system will work. That would save everyone time.