The following tables are not present in the WordPress database: BLAH_stream, BLAH_stream_meta

[jeremybyingtonbrightonagency]

trafficstars

I just added your plugin to my local environment and then to a remote staging environment in Azure and I am only getting this error in the Azure setup. When I look at the tables, they were created successfully, but the MySQL configuration. To get past the error I tried manually creating the tables and I get this message:

The server is configured with lower_case_table_names=1, which only allows lowercase characters in schema and table names. The object will be created as blah_stream.

So, I am assuming this error is related to the PHP code looking for a table name using the prefix in the wp-config.php file without accounting for the possibility of a forced-lowercase scenario.

I feel like it is an edge-case caused by a misconfiguration rather than a plugin issue, but maybe someone will see this and know they need to correct their misconfiguration...BUT also, maybe the plugin could query for the lower_case_table_names value to determine if the table name needs to be lowercase. Just an idea...

[kidunot89]

@jeremybyingtonbrightonagency I did some investigating and add there is no logic for forcing the use of lowercase character in the table prefix in either the Stream or WordPress logic. I believe that your server configuration is forcing the case of you prefix.