Health Check gives database error

  • == Bug Report
    === Description
    If i go to: https://localhost/wordpress/wp-admin/site-health.php?tab=debug its logging in the debug file about WordPress database error.

    === Environment

    • WordPress: 6.7-beta1
    • PHP: 8.4.0RC1
    • Server: Apache/2.4.59 (Win64) PHP/8.4.0RC1 mod_fcgid/2.3.10-dev
    • Database: WP_SQLite_Translator (Server: 5.5 / Client: 3.46.0)
    • Browser: Edge 129.0.0.0 (Windows 10/11)
    • Theme: Twenty Twenty-Four 1.2
    • MU-Plugins: None activated
    • Plugins:
    • Plugin Check (PCP) 1.1.0
    • SQLite Database Integration 2.1.15
    • WordPress Beta Tester 3.5.6

      [03-Oct-2024 18:45:36 UTC] WordPress database error

      MySQL query:

      SHOW TABLE STATUS

      Queries made or created this session were:

      1. Executing: BEGIN | (no parameters)
      2. Executing: ROLLBACK | (no parameters)

      Error occurred at line 4117 in Function handle_error. Error message was: Syntax error: Unexpected token in query SHOW TABLE STATUS.

      Backtrace: #0 C:\wamp64\www\wordpress\wp-content\plugins\sqlite-database-integration\wp-includes\sqlite\class-wp-sqlite-db.php(287): WP_SQLite_Translator->get_error_message() #1 C:\wamp64\www\wordpress\wp-includes\class-wpdb.php(3142): WP_SQLite_DB->query(‘SHOW TABLE STAT…’) #2 C:\wamp64\www\wordpress\wp-admin\includes\class-wp-debug-data.php(1708): wpdb->get_results(‘SHOW TABLE STAT…’, ‘ARRAY_A’) #3 C:\wamp64\www\wordpress\wp-admin\includes\class-wp-debug-data.php(1728): WP_Debug_Data::get_database_size() #4 C:\wamp64\www\wordpress\wp-includes\rest-api\endpoints\class-wp-rest-site-health-controller.php(290): WP_Debug_Data::get_sizes() #5 C:\wamp64\www\wordpress\wp-includes\rest-api\class-wp-rest-server.php(1292): WP_REST_Site_Health_Controller->get_directory_sizes(Object(WP_REST_Request)) #6 C:\wamp64\www\wordpress\wp-includes\rest-api\class-wp-rest-server.php(1125): WP_REST_Server->respond_to_request(Object(WP_REST_Request), ‘/wp-site-health…’, Array, NULL) #7 C:\wamp64\www\wordpress\wp-includes\rest-api\class-wp-rest-server.php(439): WP_REST_Server->dispatch(Object(WP_REST_Request)) #8 C:\wamp64\www\wordpress\wp-includes\rest-api.php(449): WP_REST_Server->serve_request(‘/wp-site-health…’) #9 C:\wamp64\www\wordpress\wp-includes\class-wp-hook.php(324): rest_api_loaded(Object(WP)) #10 C:\wamp64\www\wordpress\wp-includes\class-wp-hook.php(348): WP_Hook->apply_filters(”, Array) #11 C:\wamp64\www\wordpress\wp-includes\plugin.php(565): WP_Hook->do_action(Array) #12 C:\wamp64\www\wordpress\wp-includes\class-wp.php(418): do_action_ref_array(‘parse_request’, Array) #13 C:\wamp64\www\wordpress\wp-includes\class-wp.php(813): WP->parse_request(”) #14 C:\wamp64\www\wordpress\wp-includes\functions.php(1336): WP->main(”) #15 C:\wamp64\www\wordpress\wp-blog-header.php(16): wp() #16 C:\wamp64\www\wordpress\index.php(17): require(‘C:\\wamp64\\www\\w…’) #17 {main}

      for query SHOW TABLE STATUS made by require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array(‘parse_request’), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, WP_REST_Site_Health_Controller->get_directory_sizes, WP_Debug_Data::get_sizes, WP_Debug_Data::get_database_size, WP_SQLite_DB->query, WP_SQLite_DB->print_error

      The page I need help with: [log in to see the link]

    Viewing 2 replies - 1 through 2 (of 2 total)

    • Hi @ipajen thanks for sharing the information. Could I just check with you first if this seems to be having any impact on your sites functionality or performance or is all working fine at this time?

      You may also wish to share with us?your Site Health information?which we can check to see if anything here about your setup stands out.

      Thread Starter Jarko Piironen

      (@ipajen)

      Hi @adamdunnage

      What I have tested so far its seems to work good except for not compatible plugins. Its local testing environment. Her is the health check report, hope it helps to find the issue.


      ### wp-core ###

      version: 6.7-beta1
      site_language: en_US
      user_language: en_US
      timezone: +00:00
      permalink: /%year%/%monthnum%/%day%/%postname%/
      https_status: false
      multisite: false
      user_registration: 0
      blog_public: 0
      default_comment_status: open
      environment_type: production
      user_count: 1
      dotorg_communication: true

      ### wp-paths-sizes ###

      wordpress_path: C:\wamp64\www\wordpress
      wordpress_size: loading...
      uploads_path: C:\wamp64\www\wordpress/wp-content/uploads
      uploads_size: loading...
      themes_path: C:\wamp64\www\wordpress/wp-content/themes
      themes_size: loading...
      plugins_path: C:\wamp64\www\wordpress/wp-content/plugins
      plugins_size: loading...
      fonts_path: C:\wamp64\www\wordpress/wp-content/uploads/fonts
      fonts_size: loading...
      database_size: loading...
      total_size: loading...

      ### wp-dropins (1) ###

      db.php: true

      ### wp-active-theme ###

      name: Twenty Twenty-Four (twentytwentyfour)
      version: 1.2
      author: the WordPress team
      author_website: https://www.ads-software.com
      parent_theme: none
      theme_features: core-block-patterns, post-thumbnails, responsive-embeds, editor-styles, html5, automatic-feed-links, widgets-block-editor, block-templates
      theme_path: C:\wamp64\www\wordpress/wp-content/themes/twentytwentyfour
      auto_update: Disabled

      ### wp-themes-inactive (3) ###

      Twenty Twenty-Five: version: 1.0, author: the WordPress team, Auto-updates disabled
      Twenty Twenty-Three: version: 1.5, author: the WordPress team, Auto-updates disabled
      Twenty Twenty-Two: version: 1.8, author: the WordPress team, Auto-updates disabled

      ### wp-plugins-active (1) ###

      SQLite Database Integration: version: 2.1.15, author: The WordPress Team, Auto-updates disabled

      ### wp-plugins-inactive (30) ###

      Accessibility Checker: version: 1.15.3, author: Equalize Digital, Auto-updates disabled
      Advanced Database Cleaner: version: 3.1.5, author: Younes JFR., Auto-updates disabled
      Akismet Anti-spam: Spam Protection: version: 5.3.3, author: Automattic - Anti-spam Team, Auto-updates disabled
      All-in-One WP Migration: version: 7.86, author: ServMask, Auto-updates disabled
      Code Snippets: version: 3.6.5.1, author: Code Snippets Pro, Auto-updates disabled
      Enable jQuery Migrate Helper: version: 1.4.0, author: The WordPress Team, Auto-updates disabled
      Events Manager: version: 6.6.1, author: Pixelite, Auto-updates disabled
      HD Quiz: version: 1.8.15, author: Harmonic Design, Auto-updates disabled
      HD Quiz - Save Results Light: version: 0.6, author: Harmonic Design, Auto-updates disabled
      Health Check & Troubleshooting: version: 1.7.1, author: The www.ads-software.com community, Auto-updates disabled
      Hello Dolly: version: 1.7.2, author: Matt Mullenweg, Auto-updates disabled
      Limit Login Attempts Reloaded: version: 2.26.13, author: Limit Login Attempts Reloaded, Auto-updates disabled
      LiteSpeed Cache: version: 6.5.1, author: LiteSpeed Technologies, Auto-updates disabled
      ManageWP - Worker: version: 4.9.20, author: GoDaddy, Auto-updates disabled
      MariaDB Health Checks: version: 1.1.0, author: Cloudfest Hackathon 2023 Team, Auto-updates disabled
      Ninja Forms: version: 3.8.17, author: Saturday Drive, Auto-updates disabled
      OMGF: version: 5.9.1, author: Daan from Daan.dev, Auto-updates disabled
      Patchstack Security: version: 2.2.13, author: Patchstack, Auto-updates disabled
      Performance Lab: version: 3.4.1, author: WordPress Performance Team, Auto-updates disabled
      PHP Compatibility Checker: version: 1.6.3, author: WP Engine, Auto-updates disabled
      Plugin Check (PCP): version: 1.1.0, author: WordPress Performance Team and Plugin Review Team, Auto-updates disabled
      Plugin Compatibility Checker: version: 4.0, author: Dinesh Pilani, Auto-updates disabled
      Query Monitor: version: 3.16.4, author: John Blackbourn, Auto-updates disabled
      Rank Math SEO: version: 1.0.229, author: Rank Math, Auto-updates disabled
      Restaurant Menu: version: 2.4.4, author: MotoPress, Auto-updates disabled
      Stop User Enumeration: version: 1.6.3, author: Fullworks, Auto-updates disabled
      Web Worker Offloading: version: 0.1.0, author: WordPress Performance Team, Auto-updates disabled
      WordPress Beta Tester: version: 3.5.6, author: WordPress Upgrade/Install Team, Auto-updates disabled
      WP SMS: version: 6.9.6, author: VeronaLabs, Auto-updates disabled
      WPVulnerability: version: 4.0.1, author: Javier Casares, Auto-updates disabled

      ### wp-media ###

      image_editor: WP_Image_Editor_GD
      imagick_module_version: Not available
      imagemagick_version: Not available
      imagick_version: Not available
      file_uploads: 1
      post_max_size: 8M
      upload_max_filesize: 2M
      max_effective_size: 2 MB
      max_file_uploads: 20
      gd_version: bundled (2.1.0 compatible)
      gd_formats: GIF, JPEG, PNG, WebP, BMP, AVIF, XPM
      ghostscript_version: not available

      ### wp-server ###

      server_architecture: Windows NT 10.0 AMD64
      httpd_software: Apache/2.4.59 (Win64) PHP/8.4.0RC1 mod_fcgid/2.3.10-dev
      php_version: 8.4.0RC1 64bit
      php_sapi: apache2handler
      max_input_variables: 1000
      time_limit: 30
      memory_limit: 128M
      admin_memory_limit: 256M
      max_input_time: 60
      upload_max_filesize: 2M
      php_post_max_size: 8M
      curl_version: 8.10.1 OpenSSL/3.1.5
      suhosin: false
      imagick_availability: false
      pretty_permalinks: true
      htaccess_extra_rules: true
      current: 2024-10-04T09:33:12+00:00
      utc-time: Friday, 04-Oct-24 09:33:12 UTC
      server-time: 2024-10-04T09:33:12+00:00

      ### wp-database ###

      db_engine: SQLite
      database_version: 3.46.0
      database_size: 2 MB

      ### wp-constants ###

      WP_HOME: undefined
      WP_SITEURL: undefined
      WP_CONTENT_DIR: C:\wamp64\www\wordpress/wp-content
      WP_PLUGIN_DIR: C:\wamp64\www\wordpress/wp-content/plugins
      WP_MEMORY_LIMIT: 40M
      WP_MAX_MEMORY_LIMIT: 256M
      WP_DEBUG: true
      WP_DEBUG_DISPLAY: true
      WP_DEBUG_LOG: true
      SCRIPT_DEBUG: false
      WP_CACHE: false
      CONCATENATE_SCRIPTS: undefined
      COMPRESS_SCRIPTS: undefined
      COMPRESS_CSS: undefined
      WP_ENVIRONMENT_TYPE: Undefined
      WP_DEVELOPMENT_MODE: undefined
      DB_CHARSET: utf8mb4
      DB_COLLATE: Defined, but empty
      DB_ENGINE: sqlite

      ### wp-filesystem ###

      wordpress: writable
      wp-content: writable
      uploads: writable
      plugins: writable
      themes: writable
      fonts: writable
      mu-plugins: writable
    Viewing 2 replies - 1 through 2 (of 2 total)
    • You must be logged in to reply to this topic.