WPIntell

Source evidence

Health Check gives database error

SQLite Database Integration · support · 2024-10-03T18:58:00+00:00

complaintsentiment
highseverity
1.0relevance
2replies
Evidence linked to opportunitycommercial context

Proof Health

Open evidence

Commercial opportunities need traceable source links before they are treated as build-worthy.

4 / 31 rows with source links

12.9% of this page's analysis has direct source links.

0 build-decision rows missing links

0 rows here require auditable proof before promotion.

27 rows with no attached evidence

0 rows have source counts but still need direct links.

Conversation

support
Jarko Piironen unresolved
== Bug Report === Description If i go to: http://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: Executing: BEGIN | (no parameters) 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] 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. 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://wordpress.org 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 WordPress.org 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 This reply was modified 1 year, 8 months ago by Jarko Piironen .

Comments

2 shown
Adam Dunnage 2024-10-04T09:24:00+00:00

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.

Jarko Piironen 2024-10-04T09:39:00+00:00

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://wordpress.org 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 WordPress.org 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 Technolo...