Viewing 12 replies - 31 through 42 (of 42 total)
  • Plugin Contributor Greg Ross

    (@gregross)

    Ok, in log3, line 12 should be:

    $search_result['All'] = wp_statistics_searchengine('all','total');

    comment it out (by placing two forward (/) slashing at the beginning of the line like:

    //$search_result['All'] = wp_statistics_searchengine('all','total');

    Do the same for line 15 (inside the for loop).

    Thread Starter S

    (@roode)

    Yeah, now log3 works too.

    Plugin Contributor Greg Ross

    (@gregross)

    Ok, uncomment line 12, but leave line 15.

    Thread Starter S

    (@roode)

    Now the about box not displayed.

    Plugin Contributor Greg Ross

    (@gregross)

    Ok, I’m sending you an updated functions.php with some debugging code in it. Replace the one in wp-statistics\includes\functions.

    There should be at most 5 debug messages displayed:

    DEBUG: Before searchengine_query
    DEBUG: After searchengine_query
    DEBUG: Before query
    DEBUG: Query string: SELECT * FROM …
    DEBUG: After searchengine_query

    Let me know which ones are displayed and what the query string is if it is displayed.

    Thread Starter S

    (@roode)

    These codes displayed:

    DEBUG: Before searchengine_query
    DEBUG: After searchengine_query
    DEBUG: Before query
    DEBUG: Query string: SELECT * FROM <code>wp_statistics_visitor</code> WHERE <code>referred</code> LIKE '%baidu.com%'
    DEBUG: After searchengine_query
    DEBUG: Before searchengine_query
    DEBUG: After searchengine_query
    DEBUG: Before query
    DEBUG: Query string: SELECT * FROM <code>wp_statistics_visitor</code> WHERE <code>referred</code> LIKE '%bing.com%'
    DEBUG: After searchengine_query
    DEBUG: Before searchengine_query
    DEBUG: After searchengine_query
    DEBUG: Before query
    DEBUG: Query string: SELECT * FROM <code>wp_statistics_visitor</code> WHERE <code>referred</code> LIKE '%duckduckgo.com%' OR <code>referred</code> LIKE '%ddg.gg%'
    DEBUG: After searchengine_query
    DEBUG: Before searchengine_query
    DEBUG: After searchengine_query
    DEBUG: Before query
    DEBUG: Query string: SELECT * FROM <code>wp_statistics_visitor</code> WHERE <code>referred</code> LIKE '%google.%'
    Plugin Contributor Greg Ross

    (@gregross)

    Do you have access to phpMyAdmin?

    If so run the following SQL query and see what happens:

    SELECT * FROM wp_statistics_visitor WHERE referred LIKE '%google.%'
    Thread Starter S

    (@roode)

    I see a list of data,

    “Showing rows 0 – 49 (123404 total, Query took 0.0004 seconds.)”

    123404 row

    Plugin Contributor Greg Ross

    (@gregross)

    So it looks like you’ve run out of memory during the database query, you have two choices:

    1. increase the php memory limit
    2. remove some of the data from the database

    Thread Starter S

    (@roode)

    Removing mass of data didn’t solved the problem but increasing the php memory limit worked.
    I hope the overview page work henceforth.

    Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 71 bytes) in /home/webiktisat.net/httpdocs/wp-content/plugins/wp-statistics/includes/log/widgets/referring.php on line 41

    Hi, How can I fix this error

    https://www.webiktisat.net/

    Plugin Contributor Greg Ross

    (@gregross)

    mustafa dertli: please open a new ticket instead of adding on to an old one. Having said that, the above two recommendations (in post 40 of this thread) probably hold true for you as well.

Viewing 12 replies - 31 through 42 (of 42 total)
  • The topic ‘Statistics not displayed’ is closed to new replies.