Support » Plugin: Microthemer Lite - Visual Editor to Customize CSS » error: Uncaught mysqli_sql_exception:

  • Hi, thanks for the likely best free CSS editor according to reviews,
    though the last update 8 hours ago is broken.. fresh and first install, removed all other CSS editors already..

    Error message:
    ________________
    Plugin could not be activated because it triggered a fatal error.

    Fatal error: Uncaught mysqli_sql_exception: Table ‘mydb_name.wpg1_micro_revisions’ doesn’t exist in /home/myusername/public_html/wp-includes/wp-db.php:2056 Stack trace: #0
    _________________

    Thanks advance for support

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Themeover

    (@bastywebb)

    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.

    Thread Starter wshop

    (@wshop)

    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 5 months, 2 weeks ago by wshop.
    • This reply was modified 5 months, 2 weeks ago by wshop.
    • This reply was modified 5 months, 2 weeks ago by wshop.
    Plugin Author Themeover

    (@bastywebb)

    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.

Viewing 3 replies - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.