Before anybody says, I already know the other threads about this issue!
I have a newly built site that doesn’t have that many plugins. I installed MainWP and then Child Reports and get the message:
The following table is not present in the WordPress database: wp_mainwp_stream
In my database, I did have the other table “mainwp_stream_meta”, but not this one. At first I tried to make sure the MySQL user has all permissions, and they do.
Note that the latest version from the WP plugin store area was 2.0.8.
I found another thread on this issue, and the fix was provided by downloading an alternate version of Child Reports, see here: The following table is not present in the WordPress database: wp_mainwp_stream - #4 by bogdan
So then, for my issue, I removed the plugin I had (2.0.8) and installed that one. That plugin also reported itself as 2.0.8, I don’t know why. I did a folder compare between the two and there are a lot of differences.
Anyway, after installing the “fix” plugin, and then running the reset database function, the DB tables were both created. When I ran the DB reset feature on the normal plugin, it didn’t work.
My question is, that other “fixed” plugin was from three months ago, is there something in there that is going to be released in the next version? Is the latest plugin from the WP store buggy, does it fail for everyone? If not, what is making it not create tables for some users and not others?
Also, when I search the code of the plugin, I see many references to the table “mainwp_streammeta”, such as class-admin.php, class-db-driver-wpdb.php, class-query.php, class-uninstall.php. Why is it using this name when it seems like the actual table uses “mainwp_stream_meta” with the extra underscore? Is that a backward compatible thing, or is there a bunch of code trying to use a table that doesn’t exist? Could that be causing bugs?
Ultimately I just want to know what’s wrong with 2.0.8, is it safe to use on other sites or does it have bugs? What about this other version from 3 months ago, will that be updated to a new version number and be released? Why aren’t the DB tables being created? Why does the code reference the meta table with the wrong spelling?
I’m looking for an update when all this will be sorted out and when a new version will be released.