error: Uncaught mysqli_sql_exception:

Hey,

Sorry for the trouble, and thank you for reporting this. I’ve run a few tests at my end and haven’t been able to replicate it. I think it might relate to your server set up, whereby the revisions database table isn’t created for some reason. Could you let me know which version of PHP and MySQL you are using?

If you could provide access to a dummy site running on the same server that would be very helpful too. You can send access via our secure contact form. And you may wish to use this handy plugin for that. No worries at all if not.

Cheers,
Sebastian

P.S. it’s a bit late here in the UK now, but I can work on this first thing in the morning.

Hi,

I updated latest version: 5.8.3 with latest Php 8.1 on a cPanel WordPress install last week.. though the PhpMyadmin says different:

Server: Localhost via UNIX socket
Server type: MariaDB
Server connection: SSL is not being used Documentation
Server version: 10.3.32-MariaDB-log-cll-lve – MariaDB Server
Protocol version: 10
User: username@localhost
Server charset: cp1252 West European (latin1)

Web Server
cpsrvd 11.94.0.18
Database client version: libmysql – 5.6.43
PHP extension: mysqliDocumentation curlDocumentation mbstringDocumentation
PHP version: 7.3.32

.. thanks for your effort;)

———–
Fatal error: Uncaught mysqli_sql_exception: Table ‘Username_wp_001.wpg1_micro_revisions’ doesn’t exist in /home/Username/public_html/wp-includes/wp-db.php:2056 Stack trace: #0 /home/Username/public_html/wp-includes/wp-db.php(2056): mysqli_query() #1 /home/Username/public_html/wp-includes/wp-db.php(1945): wpdb->_do_query() #2 /home/Username/public_html/wp-includes/wp-db.php(2695): wpdb->query() #3 /home/Username/public_html/wp-admin/includes/upgrade.php(2749): wpdb->get_results() #4 /home/Username/public_html/wp-content/plugins/microthemer/tvr-microthemer.php(4382): dbDelta() #5 /home/Username/public_html/wp-content/plugins/microthemer/tvr-microthemer.php(4572): tvr_microthemer_admin->maybeCreateOrUpdateRevsTable() #6 /home/Username/public_html/wp-content/plugins/microthemer/includes/program-data.php(1317): tvr_microthemer_admin->getRevisions() #7 /home/Username/public_html/wp-content/plugins/microthemer/tvr-microthemer.php(688): include(‘/home/Username/…’) #8 /home/Username/public_html/wp-includes/class-wp-hook.php(303): tvr_microthemer_admin->microthemer_activated_or_updated() #9 /home/Username/public_html/wp-includes/class-wp-hook.php(327): WP_Hook->apply_filters() #10 /home/Username/public_html/wp-includes/plugin.php(470): WP_Hook->do_action() #11 /home/Username/public_html/wp-admin/plugins.php(193): do_action() #12 {main} thrown in /home/Username/public_html/wp-includes/wp-db.php on line 2056

• This reply was modified 2 years, 10 months ago by wshop.
• This reply was modified 2 years, 10 months ago by wshop.
• This reply was modified 2 years, 10 months ago by wshop.

Thanks for the info. Your PHP (8.1) and WP (5.8.3) version is all I need, you can delete the other information below that.

According to this Kinsta article, it seems the current WordPress core isn’t fully compatible with PHP 8.1. WordPress 5.9 should address this, which is scheduled for release on Jan 25th, 2022.

I suspect I will need to update Microthemer in various ways to ensure compatibility with version 8.1, and I’m going to start testing this. But as a temporary fix, you could try downgrading to PHP 8.0 or 7.4. The error you’re getting seems to be coming from the dbDelta function, which is a native WordPress function. Downgrading will also give other plugin authors time to catch up with PHP 8.1. I saw a few other posts about PHP 8.1 compatibility issues, e.g. Yoast SEO.

Cheers,
Sebastian

P.S. I’m on a train and haven’t been able to download 8.1 yet, so can’t confirm 100% if downgrading will resolve your Microthemer issue, but will check this ASAP.