002_cbplug_CBSubs_MAIN failed to install??

Possibly a false positive mod_security rule is flagging it. Try contacting your host and see if there's anything in mod_security logs. If nothing is found please PM backend super user login credentials and will take a look.

Hi Krileon,

Thanks for your continued support on this... OK I have had a fairly lengthy discussion with my hosting company here in the UK (20i) and the tech guys there are pretty good (IMHO)

I gave all the details for the failed installs including dates and file description as well as the error messages reported so I am reasonably sure they have done as requested. They have confirmed - "I have checked our mod security logs and I cannot see anything related to this 500 internal server when trying to install this zip file."

I will set up Super User access for you on this domain and PM you the details as requested.

TIA

Have reviewed your install. It's failing to install due to "Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.". You're hitting database row size limits for some reason when it tries to create the CBSubs database tables.

I believe it's the _cbsubs_plans table doing this. It has quite a few columns, but the majority are using text types or low byte types so it shouldn't be doing this unless the table already exists, but has wrong column types.

Your database is currently 5.5.5-10.2.33-MariaDB-log. Joomla and CB do not officially support MariaDB. They officially only support MySQL. See the below topic regarding necessary MariaDB version and settings. Your host should be able to help you with updating MariaDB and adjusting the settings.

www.joomlapolis.com/forum/153-professional-member-support/242484-installation-cb-connect-failed?start=12#318734

We have to design around default database settings. Appears your server is using lower than default settings causing row size limit to be hit prematurely. There's nothing more I can suggest unfortunately. The only other option would be to PM phpmyadmin login and I can try forcing it to install by adjusting columns heavily, but that'd only be a temporary solution.

Thank you for your response... I will do as you say and let you know the outcome...

Hi Krileon, Is it possible for us to manually import this SQL database so that the rest of the installation can be done? Is there a .sql file for the above, I am told we can change the engine used for this specific table so it can fully import and then go from there as needed.

If this is possible could you provide a link to the required file(s)...

TIA

We do not provide SQL files. Our database configuration is entirely done through XML configuration using a custom database XML parsing engine. We'll be switching to raw SQL files for Joomla 4 rewrite of CB 3.x.

Changing the database engine won't fix your issue. The database engine should already be set to Innodb. Your issue is MariaDB configuration is likely incorrect and likely due to innodb_page_size default value being halved. The default innodb_page_size for MariaDB is 16k (same as MySQL), yours is likely set to 8k. The above topic covers in detail the default values your database should have for InnoDB.