I'm setting up a new site with CBSubs and have CB all installed and everything working.
Now when I try to install CBSubs (using the cbplug_CBSubs_MAIN-4.1.0+build.2017.05.19.15.39.30.520d1fe23.zip file) in the CB plugin installer I get
Message
Upload Success
CB Package Installer1

However, in the 'detail' area it says "Package installation partially complete!"
And in the Failed column it lists:

002_cbplug_CBSubs_MAIN-4.1.0+build.2017.05.19.15.39.30.520d1fe23.zip
094_cbplug_int_cbsubspromotion-4.1.0+build.2017.05.19.15.39.30.520d1fe23.zip

having failed.

It looks like all the plugins install; however, whenever I try to do almost anything within Paid Subscriptions I get the error:
1146 Table 'kindred9.#__cbsubs_payments' doesn't exist
(The actual table - _payments etc - changes depending on what I'm trying to access)

If I run the CB Tools Check CB plugins database it tells me that a bunch of __cbsubs tables have 'structure differences'.

If I click the FIX button I get:
1709 Index column size too large. The maximum column size is 767 bytes.

If I do the 'dry run' it works without an issue.

I've reviewed the instructions here:
www.joomlapolis.com/forum/146-general/236108-solved-install-community-builder-cb

We have confirmed innodb_large_prefix is set ON

Also, all the tables (the ones that already did get installed) are set to:

Storage Engine: InnoDB
ROW FORMAT: was "Compact". All have been changed to "Dynamic"

I've tried to manually run one of the queries (the query that is listed in the dry run to create the #__cbsubs_promotions table (directly via mysqladmin) and I get the same error.

Is there another setting that I should be checking on the server other than that innodb_large_prefix = ON?

Or is there some other solution that wasn't provided in that other ticket (as the final solution was never indicated)?

I don't blieve this is a hosting issue as we have several other sites with the same host using CB and CBSubs without a problem.

Any other ideas where to check?

Also just received word from my hosting company that the server is set with the default size of 767 and they have not changed that.

Is CBSubs needing more than 767?

Has the install for CBSubs changed in the past 6-9 months? We've installed on other sites (same hosting company) without problem before this.

[We're using CoudAccess for hosting]

Not sure if it is the only one causing the problem, but I tested by manually running the query for "CREATE TABLE #__cbsubs_promotions..." and that one gives the error.

However, the details you provided related to the innodb settings should help. As it says that innodb_large_prefix is ON yet still getting this error seems to imply that there is a problem on the server.
Cloudaccess is monitoring this thread so hopefully they will be able to identify the issue now with these details.

I'll report back here as soon as they review those details.

Thanks.

Hosting company (CloudAccess) moved the site to a different piece of hardware (server) and everything worked fine. So it appears this is an issue with something on the hosting company hardware not working.

Thanks for all the help and detail getting to the bottom of this.
The hosting company is looking into the hardware to determine what got set wrong or where the error is.

This is now resolved.