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.
Ok, uncomment line 12, but leave line 15.
Thread Starter
S
(@roode)
Now the about box not displayed.
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.%'
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
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
http://www.webiktisat.net/
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.
