|
YOKE
|
June 3, 2016 at 1:20 am
I am receiving the following error:
Warning: mysql_query(): Unable to save result set in /home/XXX/public_html/wp-includes/wp-db.php on line 1813
WordPress database error: [Out of memory (Needed 8388580 bytes)]
SELECT COUNT(DISTINCT (Datetime.DTT_ID )) FROM wp_esp_datetime AS Datetime WHERE Datetime.DTT_deleted = 0 AND Datetime.EVT_ID = 669 AND Datetime.DTT_EVT_start > ‘2016-06-03 07:08:21’
This error is appearing on all Event pages on the front end and in the admin pages I am getting: Unable to save result set in /home/yoke/public_html/wp-includes/wp-db.php on line 1813 repeatedly and do not have access to all events that have been created.
From my EE Maintenance page, system status:
[wp_max_upload_size] => 200 MB
[wp_memory] => <mark class=”yes”>256 MB</mark>
[memory_limit] => Array
(
[global_value] => 32M
[local_value] => 256M
[access] => 7
)
I have set the wp_memory_limit to 256M in my wp-config, htaccess and local php.ini and also ran a repair on all ee tables in my database
I am up to date with my version of EE and WP
If someone has some advice it would be greatly appreciated!
Thanks
Leanne
|
|
Tony
|
June 3, 2016 at 2:44 am
Hi Leanne,
I have set the wp_memory_limit to 256M in my wp-config, htaccess and local php.ini and also ran a repair on all ee tables in my database
That’s setting PHP memory which is different than your MySQL memory limit.
The query is pulling all of the datetimes from the database and then removing the duplicates before returning them to you so the temporary value storing the details may be too big, however unless you have a lot of datetimes you should not see that error.
What type of hosting is this? Can you restart MySQL yourself?
First I would restart MySQL and confirm if the issue remains, if so you may need to increase the memory available to MySQL. Depending on your hosting you may need to contact your host to have them do it for you.
|
