I got error message when I try to access Stats menu from my dashboard.
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 79 bytes) in /home/hosting/public_html/mydomain.net/wp-includes/wp-db.php on line 958
It seem I have memory limitation and need to reconfigure first some point in my wordpress.
Configure WordPress Memory Limit
Add this line in wp-config.php
Try again and I have no luck. Still same error.
Move the blog with sub domain in my vps account and set the limit to 384 give me great result.
The problem is 64M already place as highest memory value I can use as I stand in shared host.
Investigate WordPress database data
wp-db.php related to database and that clue give me hint to phpmyadmin and see the status :
in wp_postmeta I see 32,139 rows and click browse button give me to another suspect
meta_key with value ‘searchTerm’ take many space and since I’ve disable the plugin I decide to delete this data.
Click SQL in phpmyadmin and issue this command :
delete from wp_postmeta where meta_key=’searchTerm’;
New confirmation window appear, I choose OK.
The result is as follow :
31826 row(s) deleted. ( Query took 0.9189 sec )
Try access stats menu from wordpress dashboard and the picture tell me the result
Success, I can access the stats.
- wp-db.php is function related to database access.
- try to explore data in database with phpmyadmin
- use WP_MEMORY_LIMIT as 1st aid.
See you in other post and stay health!