Update to 1.18.x causes WordPress database error in backend

  • Resolved Ov3rfly

    (@ov3rfly)


    2 years ago

    Updated plugin to 1.18.1 yesterday, found empty/not loading statistics now in WordPress backend.

    Browser console shows Error 500 for this ajax call:

    https://example.com/wp-admin/admin-ajax.php?_fs_blog_admin=true

    Error Log of server shows WordPress database error The SELECT would examine more than MAX_JOIN_SIZE rows for different queries:

    WordPress database error The SELECT would examine more than MAX_JOIN_SIZE rows ... SELECT DATE(CONVERT_TZ(views.viewed_at ... made by do_action('toplevel_page_independent-analytics'), WP_Hook-]do_action, WP_Hook-]apply_filters, IAWP\\Independent_Analytics-]settings_page_markup, IAWP\\Views-]__construct, IAWP\\Views-]query

WordPress database error The SELECT would examine more than MAX_JOIN_SIZE rows ... SELECT COUNT(*) as views ... made by do_action('toplevel_page_independent-analytics'), WP_Hook-]do_action, WP_Hook-]apply_filters, IAWP\\Independent_Analytics-]settings_page_markup, IAWP\\Views-]__construct, IAWP\\Views-]query

    Rollback to 1.17.4 makes statistics in backend reappear and ajax call works fine again.

    WordPress 6.1.1, Independent Analytics, 1.18.1, PHP 8.0.28, mysqli 5.7.40-43

    wp_independent_analytics_referrers               60.879 rows
wp_independent_analytics_referrer_groups            302 rows
wp_independent_analytics_resources                4.644 rows
wp_independent_analytics_sessions               477.675 rows
wp_independent_analytics_views                  515.639 rows
wp_independent_analytics_visitors               235.076 rows
wp_independent_analytics_visitors_1_16_archive  182.629 rows
Viewing 13 replies - 1 through 13 (of 13 total)
  • Plugin Author Ben Sibley

    (@bensibley)

    I’m so sorry for the error. Thanks for letting us know about this.

    Could you tell me the current value of your site’s MAX_JOIN_SIZE? You can find this in phpMyAdmin by running the following SQL command:

    SHOW VARIABLES LIKE '%MAX_JOIN_SIZE%';
    Thread Starter Ov3rfly

    (@ov3rfly)

    max_join_size 	201326592
    Plugin Author Ben Sibley

    (@bensibley)

    Thank you!

    This value seems to be greatly reduced from the default value, which is 18446744073709551615.

    Are you able to edit this value yourself? If not, could you ask your web host to increase this limit?

    Thread Starter Ov3rfly

    (@ov3rfly)

    Not able to edit this value, sorry.

    It’s a client website with a typical higher-tier “WebHosting” plan ~20€/month at HostEurope.de which is owned by HEG/GoDaddy.

    Statistics in backend work fine with 1.17.4 with this value.

    Maybe you can add some legacy option to 1.18.x to keep the SQL requirements where they were before.

    Thanks for quick response.

    Plugin Author Ben Sibley

    (@bensibley)

    Could you let me know if the site is running WooCommerce and whether it’s using the free or pro version of Independent Analytics?

    We may be able to patch this soon based on this info. Otherwise, we can make some additional optimizations in a future update that should address this.

    Thread Starter Ov3rfly

    (@ov3rfly)

    WooCommerce 7.1.0, Independent Analytics free version, more info here:

    ### wp-core ###

version: 6.1.1
site_language: de_DE_formal
user_language: de_DE_formal
timezone: Europe/Berlin
permalink: /%postname%/
https_status: true
multisite: false
user_registration: 0
blog_public: 1
default_comment_status: open
environment_type: production
user_count: 952
dotorg_communication: true

### wp-paths-sizes ###

wordpress_path: /is/htdocs/xxx/www/xxx
wordpress_size: 146,92 MB (154054084 bytes)
uploads_path: /is/htdocs/xxx/www/xxx/wp-content/uploads
uploads_size: 20,84 GB (22381541199 bytes)
themes_path: /is/htdocs/xxx/www/xxx/wp-content/themes
themes_size: 11,55 MB (12106532 bytes)
plugins_path: /is/htdocs/xxx/www/xxx/wp-content/plugins
plugins_size: 139,53 MB (146306329 bytes)
database_size: 428,63 MB (449445939 bytes)
total_size: 21,55 GB (23143454083 bytes)

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

advanced-cache.php: true

### wp-active-theme ###

name: Oleander (oleander)
version: 1.4
author: Solo Pine Designs
author_website: https://solopine.com
parent_theme: none
theme_features: core-block-patterns, post-thumbnails, widgets, widgets-block-editor, wc-product-gallery-zoom, wc-product-gallery-lightbox, wc-product-gallery-slider, menus, post-formats, title-tag, automatic-feed-links, woocommerce, align-wide, editor-styles, editor-style
theme_path: /is/htdocs/xxx/www/xxx/wp-content/themes/oleander
auto_update: Deaktiviert

### wp-themes-inactive (4) ###

Twenty Twenty-Three: version: 1.0, author: Das WordPress-Team, Automatische Aktualisierungen deaktiviert

### wp-plugins-active (27) ###

All in One SEO: version: 4.3.2, author: All in One SEO Team, Automatische Aktualisierungen deaktiviert
Antispam Bee: version: 2.11.2, author: pluginkollektiv, Automatische Aktualisierungen deaktiviert
BackWPup: version: 4.0.0, author: Inpsyde GmbH, Automatische Aktualisierungen deaktiviert
Broken Link Checker: version: 1.11.21, author: WPMU DEV (latest version: 2.0.0), Automatische Aktualisierungen deaktiviert
Cache for WordPress Performance: version: 1.6.12, author: pigeonhut, Jody Nesbitt, Automatische Aktualisierungen deaktiviert
Classic Editor: version: 1.6.2, author: WordPress Contributors, Automatische Aktualisierungen deaktiviert
Classic Widgets: version: 0.3, author: WordPress Contributors, Automatische Aktualisierungen deaktiviert
Code Snippets: version: 3.2.2, author: Code Snippets Pro, Automatische Aktualisierungen deaktiviert
Contact Form 7: version: 5.7.4, author: Takayuki Miyoshi, Automatische Aktualisierungen deaktiviert
Content Views: version: 2.5.0.1, author: Content Views, Automatische Aktualisierungen deaktiviert
Content Views Pro: version: 5.4.1, author: CVSOFT LLC (latest version: 5.9.3.1), Automatische Aktualisierungen deaktiviert
Cookie Information | Free WP GDPR Consent Plugin: version: 2.0.22, author: Cookie Information, Automatische Aktualisierungen deaktiviert
Create by Mediavine: version: 1.9.3, author: Mediavine (latest version: 1.9.4), Automatische Aktualisierungen deaktiviert
Germanized for WooCommerce: version: 3.11.1, author: vendidero (latest version: 3.11.3), Automatische Aktualisierungen deaktiviert
Independent Analytics: version: 1.17.4, author: Independent Analytics (latest version: 1.18.1), Automatische Aktualisierungen deaktiviert
JPG, PNG Compression and Optimization: version: 1.7.35, author: pigeonhut, https://hosting.io, Jody Nesbitt, Automatische Aktualisierungen deaktiviert
Language Fallback: version: 1.0.5, author: Bernhard Kau (latest version: 2.0.0), Automatische Aktualisierungen deaktiviert
Loco Translate: version: 2.6.3, author: Tim Whitlock, Automatische Aktualisierungen deaktiviert
OMGF: version: 5.4.3, author: Daan from Daan.dev (latest version: 5.5.5.1), Automatische Aktualisierungen deaktiviert
PDF Invoices & Packing Slips for WooCommerce: version: 3.2.5, author: WP Overnight (latest version: 3.4.0), Automatische Aktualisierungen deaktiviert
Prosodia VGW OS: version: 3.25.3, author: Prosodia – Verlag für Musik und Literatur, Automatische Aktualisierungen deaktiviert
Remove IP: version: 0.1, author: guido, Automatische Aktualisierungen deaktiviert
Responsive Lightbox: version: 1.3.4, author: subhansanjaya, Automatische Aktualisierungen deaktiviert
Solo Pine Meta Fields: version: 1.3, author: Solo Pine, Automatische Aktualisierungen deaktiviert
WooCommerce: version: 7.1.0, author: Automattic (latest version: 7.4.1), Automatische Aktualisierungen deaktiviert
WordPress Ads Manager: version: 2.1, author: Crunchify, Automatische Aktualisierungen deaktiviert
WP Disable: version: 1.6.1, author: optimisation.io - jody nesbitt, Automatische Aktualisierungen deaktiviert

### wp-plugins-inactive (1) ###

Woo Store Vacation: version: 1.6.3, author: MyPreview (latest version: 1.7.0), Automatische Aktualisierungen deaktiviert

### code-snippets (2) ###

snippet-1: name: WooCommerce3, scope: global
snippet-3: name: Order snippets by date, scope: admin, modified: 2020-02-03 09:20:45, tags: [code-snippets-plugin]

### wp-media ###

image_editor: WP_Image_Editor_GD
imagick_module_version: 1690
imagemagick_version: ImageMagick 6.9.10-23 Q16 x86_64 20190101 https://imagemagick.org
imagick_version: @PACKAGE_VERSION@
file_uploads: File uploads is turned off
post_max_size: 32M
upload_max_filesize: 32M
max_effective_size: 32 MB
max_file_uploads: 50
gd_version: bundled (2.1.0 compatible)
gd_formats: GIF, JPEG, PNG, WebP, BMP, XPM
ghostscript_version: 9.27

### wp-server ###

server_architecture: Linux 4.14.132-xenu-he x86_64
httpd_software: Apache
php_version: 8.0.28-he.0 64bit
php_sapi: apache2handler
max_input_variables: 1000
time_limit: 30
memory_limit: 256M
max_input_time: 60
upload_max_filesize: 32M
php_post_max_size: 32M
curl_version: 7.64.0 OpenSSL/1.1.1n
suhosin: false
imagick_availability: true
pretty_permalinks: true
htaccess_extra_rules: true

### wp-database ###

extension: mysqli
server_version: 5.7.40-43-log
client_version: mysqlnd 8.0.28-he.0
max_allowed_packet: 100663296
max_connections: 1100

### wp-constants ###

WP_HOME: undefined
WP_SITEURL: undefined
WP_CONTENT_DIR: /is/htdocs/xxx/www/xxx/wp-content
WP_PLUGIN_DIR: /is/htdocs/xxx/www/xxx/wp-content/plugins
WP_MEMORY_LIMIT: 256M
WP_MAX_MEMORY_LIMIT: 256M
WP_DEBUG: false
WP_DEBUG_DISPLAY: true
WP_DEBUG_LOG: false
SCRIPT_DEBUG: false
WP_CACHE: false
CONCATENATE_SCRIPTS: undefined
COMPRESS_SCRIPTS: undefined
COMPRESS_CSS: undefined
WP_ENVIRONMENT_TYPE: Nicht definiert
DB_CHARSET: utf8mb4
DB_COLLATE: undefined

### wp-filesystem ###

wordpress: writable
wp-content: writable
uploads: writable
plugins: writable
themes: writable
    Plugin Author Ben Sibley

    (@bensibley)

    Thanks for letting me know.

    In this particular case, we should be able to create a patch soon that will get the site running again. We will make additional performance optimizations over the next few updates as well.

    Plugin Author Ben Sibley

    (@bensibley)

    This issue should be fixed for you now in version 1.19.

    While it’s fixed in the free version, this issue would return if you upgrade to PRO. We will be making further optimizations over time, but if you decide to upgrade in the future, please let me know so I can check if the underlying issue has been addressed at that time.

    Thread Starter Ov3rfly

    (@ov3rfly)

    Can confirm, issue is fixed with 1.19.0 free version.

    Thread Starter Ov3rfly

    (@ov3rfly)

    FYI, update caused another issue which obviously breaks ordering process in WooCommerce, will post new report later.

    Plugin Author Ben Sibley

    (@bensibley)

    We saw this issue already and released a patch for it. Please update to version 1.19.1 and it will be fixed.

    I’m very sorry for the continued errors.

    Thread Starter Ov3rfly

    (@ov3rfly)

    Changelog for 1.19.1 has no information about fixing a problem in ordering process in WooCommerce.

    PHP Fatal error: Uncaught Error: Class "Query" not found in .../wp-content/plugins/independent-analytics/iawp-bootstrap.php:163

    Please provide exact changelog, thanks.

    Plugin Author Ben Sibley

    (@bensibley)

    We rushed out the patch with the WooCommerce fix, so it looks like we forgot to include a note about it in the changelog.

    Here’s exactly what we changed to correct this error: https://plugins.trac.www.ads-software.com/changeset/2879403/independent-analytics/trunk/iawp-bootstrap.php

    As you can see, the Query and Visitor classes were not previously defined in this file, causing the PHP error.

Viewing 13 replies - 1 through 13 (of 13 total)
  • The topic ‘Update to 1.18.x causes WordPress database error in backend’ is closed to new replies.