• Resolved smarti9

    (@smarti9)


    Hi, page data for multiple selections is not loading and live view is throwing critical error

    Error Details
    =============
    An error of type E_ERROR was caused in line 589 of the file /var/www/webroot/ROOT/wp-content/plugins/independent-analytics-pro/vendor/illuminate/database/Connection.php. Error message: Uncaught PDOException: SQLSTATE[HY001]: Memory allocation error: 1038 Out of sort memory, consider increasing server sort buffer size in /var/www/webroot/ROOT/wp-content/plugins/independent-analytics-pro/vendor/illuminate/database/Connection.php:321
    Stack trace:
    #0 /var/www/webroot/ROOT/wp-content/plugins/independent-analytics-pro/vendor/illuminate/database/Connection.php(321): PDOStatement->execute()
    #1 /var/www/webroot/ROOT/wp-content/plugins/independent-analytics-pro/vendor/illuminate/database/Connection.php(587): IAWPSCOPED\Illuminate\Database\Connection->IAWPSCOPED\Illuminate\Database\{closure}()
    #2 /var/www/webroot/ROOT/wp-content/plugins/independent-analytics-pro/vendor/illuminate/database/Connection.php(561): IAWPSCOPED\Illuminate\Database\Connection->runQueryCallback()
    #3 /var/www/webroot/ROOT/wp-content/plugins/independent-analytics-pro/vendor/illuminate/database/Connection.php(312): IAWPSCOPED\Illuminate\Database\Connection->run()
    #4 /var/www/webroot/ROOT/wp-content/plugins/independent-analytics-pro/vendor/illuminate/database/Query/Builder.php(1995): IAWPSCOPED\Illuminate\Database\Connection->select()
    #5 /var/www/webroot/ROOT/wp-content/plugins/independent-analytics-pro/vendor/illuminate/database/Query/Builder.php(1985): IAWPSCOPED\Illuminate\Database\Query\Builder->runSelect()
    #6 /var/www/webroot/ROOT/wp-content/plugins/independent-analytics-pro/vendor/illuminate/database/Query/Builder.php(2419): IAWPSCOPED\Illuminate\Database\Query\Builder->IAWPSCOPED\Illuminate\Database\Query\{closure}()
    #7 /var/www/webroot/ROOT/wp-content/plugins/independent-analytics-pro/vendor/illuminate/database/Query/Builder.php(1984): IAWPSCOPED\Illuminate\Database\Query\Builder->onceWithColumns()
    #8 /var/www/webroot/ROOT/wp-content/plugins/independent-analytics-pro/IAWP/Rows/Pages.php(26): IAWPSCOPED\Illuminate\Database\Query\Builder->get()
    #9 /var/www/webroot/ROOT/wp-content/plugins/independent-analytics-pro/IAWP/Rows/Rows.php(58): IAWP\Rows\Pages->fetch_rows()
    #10 /var/www/webroot/ROOT/wp-content/plugins/independent-analytics-pro/IAWP/Real_Time.php(44): IAWP\Rows\Rows->rows()
    #11 /var/www/webroot/ROOT/wp-content/plugins/independent-analytics-pro/IAWP/Real_Time.php(69): IAWP\Real_Time->get_real_time_analytics()
    #12 /var/www/webroot/ROOT/wp-content/plugins/independent-analytics-pro/IAWP/Admin_Page/Analytics_Page.php(37): IAWP\Real_Time->render_real_time_analytics()
    #13 /var/www/webroot/ROOT/wp-content/plugins/independent-analytics-pro/IAWP/Admin_Page/Admin_Page.php(50): IAWP\Admin_Page\Analytics_Page->render_page()
    #14 /var/www/webroot/ROOT/wp-content/plugins/independent-analytics-pro/IAWP/Independent_Analytics.php(225): IAWP\Admin_Page\Admin_Page->render()
    #15 /var/www/webroot/ROOT/wp-includes/class-wp-hook.php(324): IAWP\Independent_Analytics->IAWP\{closure}()
    #16 /var/www/webroot/ROOT/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters()
    #17 /var/www/webroot/ROOT/wp-includes/plugin.php(517): WP_Hook->do_action()
    #18 /var/www/webroot/ROOT/wp-admin/admin.php(260): do_action()
    #19 {main}

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

    (@bensibley)

    Hi there,

    Thanks for getting in touch. I’m sorry to hear about this error.

    It sounds like the server is running out of memory when fetching the analytics data. Can you ask your host if they can increase the sort buffer size? Here is a code snippet you can pass along to them:

    sort_buffer_size = 4M 
    read_rnd_buffer_size = 4M

    Let me know if they can make this change or not.

    Thread Starter smarti9

    (@smarti9)

    That worked thanks!

    Plugin Author Ben Sibley

    (@bensibley)

    Great, glad to hear that!

    Stay in touch if you need anything else.

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

The topic ‘Fatal Error with latest update’ is closed to new replies.