Title: Fatal error: Allowed memory in Wp-db.php Last modified: August 22, 2016 --- # Fatal error: Allowed memory in Wp-db.php * Resolved [Donald](https://wordpress.org/support/users/donald-p/) * (@donald-p) * [11 years, 9 months ago](https://wordpress.org/support/topic/fatal-error-allowed-memory-in-wp-dbphp-1/) * I have been running my personal website since 2008 and recently I come across with this error which I thought was related to the memory limit but it didn’t worked so I am trying to understand what the issue is about and also how to solve. * **Issue shown as:** **Fatal error: Allowed memory size of 134217728 bytes exhausted( tried to allocate 35 bytes) in [path of my website]/wp-includes/wp-db.php on line 1938** and a white screen. * **When it happens?** There is no a regular replica of the reason why it triggers into this error. For example, sometimes when I create a new post and save as draft, it shows up the above error message. Sometimes happens when clicking to Dashboard , other time when I click on publish. * **When this issue came up** More or less since a month ago at max. * **Plugins installed and running** * AddThis Social Bookmarking Widget Askimet Booking.com affiliate plugin Easy contact forms FV Top Level Categories iThemes Security Newsletter nrelate Related Content Pretty Link Lite W3 Total Cache Widget Logic Wordpress SEO * Last plugin I installed was ithemes security probably 6 months ago * **PHP info** Currently the server memory Limit max is 128MB (before was 64) * **What code is in the line 1938?** `$new_array[] = array_values( get_object_vars( $row ) );` * I am getting the same line associated to this error. * **More coding** * ``` return $new_array; } elseif ( $output == ARRAY_A || $output == ARRAY_N ) { // Return an integer-keyed array of... if ( $this->last_result ) { foreach( (array) $this->last_result as $row ) { if ( $output == ARRAY_N ) { // ...integer-keyed row arrays $new_array[] = array_values( get_object_vars( $row ) ); } else { // ...column name-keyed row arrays $new_array[] = get_object_vars( $row ); } } } return $new_array; } elseif ( strtoupper( $output ) === OBJECT ) { // Back compat for OBJECT being previously case insensitive. return $this->last_result; } return null; ``` * I have also added the command Define memory limit of 128MB into wp-config.php, just in case was this the issue. * I have also did some research on this forum but didn’t found the exact error so I opened a new tread. * Thank in advance Donald Viewing 8 replies - 1 through 8 (of 8 total) * [Mark Ratledge](https://wordpress.org/support/users/songdogtech/) * (@songdogtech) * [11 years, 9 months ago](https://wordpress.org/support/topic/fatal-error-allowed-memory-in-wp-dbphp-1/#post-5206531) * If you’ve been adding posts since 2008, your database is probably fairly large and WordPress is running out of memory accessing it. Defining a memory limit of 128MB in wp-config.php usually works, but your webhost may be limiting overall memory, and that will make the database server crash with a large database. Try cleaning your post revisions: [http://wordpress.org/plugins/better-delete-revision/](http://wordpress.org/plugins/better-delete-revision/) * And, if you have a php.ini file, check the `memory_limit =` line and change it to 128M, which is a better way to allocate memory to WordPress. * You can run phpinfo to see what kind of memory allocation you already have. Make a plain text file and call it `phpinfo.php` and put just this line in it: * `` * then put the file in the root of your server, and then go to that file with your web browser. You’l see all the php info you need; scroll down for memory settings. If you get an error, that means your web hosting company won’t allow phpinfo to run for security reasons. * Thread Starter [Donald](https://wordpress.org/support/users/donald-p/) * (@donald-p) * [11 years, 9 months ago](https://wordpress.org/support/topic/fatal-error-allowed-memory-in-wp-dbphp-1/#post-5206566) * Dear songdogtech, * thanks for your promptly reply. * My database is around 19 Mb with 250 posts. Probably I write too much 🙂 About the hosting, I am with Godaddy and I got a Deluxe version so in the middle between basic and professional. I double checked into **phpinfo** and still have 128 Mb so they allowed me to keep it increased. * I cleaned the database and removed: * – 863 Posts revisions – 7 Unlinked tags – 1 auto draft * now I have to wait if the issue still persist. * In the meantime: * -yes I did create before a **phpinfo.php** file in order to check the memory and understand the path of php.ini that was set by default by my hosting service but not present into my root directory. * -I increased the memory creating a **php5.ini** file adding the memory limit setting. I read that now it is suffice to use php5.ini instead of php.ini as a way of new version. * I will do some test now and see if I still get errors. * Keep you updated Donald * ============Updates==================== Unfortunately I am still getting the same error 🙁 * [Mark Ratledge](https://wordpress.org/support/users/songdogtech/) * (@songdogtech) * [11 years, 9 months ago](https://wordpress.org/support/topic/fatal-error-allowed-memory-in-wp-dbphp-1/#post-5206635) * It’s GoDaddy; they’re a terrible host. * Try getting rid of W3TC; it can conflict with memory settings and server caching. * Thread Starter [Donald](https://wordpress.org/support/users/donald-p/) * (@donald-p) * [11 years, 9 months ago](https://wordpress.org/support/topic/fatal-error-allowed-memory-in-wp-dbphp-1/#post-5206673) * Hi songdogtech, * thanks for reply. * in my honest opinion, you get what you pay for. In the end it is a shared hosting and I pay enough to have a website and in the end of the month on the overall it is probably something more good than bad. I am not sure that moving all the stuff to another server will beneficiate so much to worth all the hassle. I have also a shared hosting with Register365 the medium one and my client has the professional one and again, not happy with bot of them. The only way it is probably to have a personalized server to see something suffice to not get stressed from this hosting toys for bloggers. * I have never had problems with W3TC ever. I did also speed testing and was doing great. Probably needs to be tweaked a bit to perform better. I am suspicious about iThemes Security. I will go a try to deactivate some plugins and see if I get something better. * Thanks again, if I have any update I will post here. Donald * Thread Starter [Donald](https://wordpress.org/support/users/donald-p/) * (@donald-p) * [11 years, 9 months ago](https://wordpress.org/support/topic/fatal-error-allowed-memory-in-wp-dbphp-1/#post-5206695) * updates and still testing. * I deactivated W3TC for the moment and : * 1. set memory limit to 256MB into the php5.ini 2. set `define('WP_MEMORY_LIMIT',' 256M');` in wp-config.php * php info confirms 256mb available. * In the meantime I pinged my website and found some data lost now and then. I did a trace route and I found a time out in the middle of the route. They are probably making some changes over there. I will re-test tomorrow. Donald * Thread Starter [Donald](https://wordpress.org/support/users/donald-p/) * (@donald-p) * [11 years, 9 months ago](https://wordpress.org/support/topic/fatal-error-allowed-memory-in-wp-dbphp-1/#post-5206742) * After my last post I haven’t gotten any error messages so I suppose the issue is solved. It will be my intention to provide an update in the case the issue is presenting in the future. * Thanks songdogtech for your support * Donald * Thread Starter [Donald](https://wordpress.org/support/users/donald-p/) * (@donald-p) * [11 years, 9 months ago](https://wordpress.org/support/topic/fatal-error-allowed-memory-in-wp-dbphp-1/#post-5206776) * Just to confirm the issue it is not present at this time and give an update about plugins who might influence memory resources between the ones I have installed. I run the P3 scan plugin and WordPress SEO is at 53% in the Runtime by Plugin section. While W3Total Cache just 5% The rest of plugins are less the 6% each. * I ran memory Viewer and the whole loading doesn’t reach the 40Mb * Donald * [CoreyTisdale](https://wordpress.org/support/users/coreytisdale/) * (@coreytisdale) * [10 years, 11 months ago](https://wordpress.org/support/topic/fatal-error-allowed-memory-in-wp-dbphp-1/#post-5206930) * The issue is not your memory limit, the issue is iThemes security. * It does two things regularly that will eat up all of your memory – file checks and backups. * Disable backups altogether in iThemes Security. It tries to load your entire database into memory, and it does this multiple times a day (even if your backup is scheduled for every few days or once a week or whatever). It makes no sense, but this is happening, and it is the most likely culprit since the wp-db is throwing the memory error. Use something else for backups, maybe even backup your full account through cpanel if using shared hosting instead of just backing up wordpress. I’m not advocating the idea of ditching backups, I’m advocating not using the backup feature of iThemes Security. * If you still have issues after this, turn off file change checking. This is an expensive process as well, but is less likely to be your issue. * Both of these options are easily accessible through the iThemesSecurity dashboard, you just have to turn them off completely. Viewing 8 replies - 1 through 8 (of 8 total) The topic ‘Fatal error: Allowed memory in Wp-db.php’ is closed to new replies. ## Tags * [fatal error](https://wordpress.org/support/topic-tag/fatal-error/) * [wp-db.php](https://wordpress.org/support/topic-tag/wp-db-php/) * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) * 8 replies * 3 participants * Last reply from: [CoreyTisdale](https://wordpress.org/support/users/coreytisdale/) * Last activity: [10 years, 11 months ago](https://wordpress.org/support/topic/fatal-error-allowed-memory-in-wp-dbphp-1/#post-5206930) * Status: resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics