Title: NextGen Gallery has exploded SQL wp-options table
Last modified: August 21, 2016

---

# NextGen Gallery has exploded SQL wp-options table

 *  [gazouteast](https://wordpress.org/support/users/gazouteast/)
 * (@gazouteast)
 * [12 years, 9 months ago](https://wordpress.org/support/topic/nextgen-gallery-has-exploded-sql-wp-options-table/)
 * One of my clients sites just collapsed with a fatal error.
 * > Fatal error: Out of memory (allocated 67633152) (tried to allocate 8193 bytes)
   > in /homepages/37/xxxxxxxxxxx/htdocs/wp-treelocate/wp-includes/functions.php
   > on line 3568
 * Refreshing the error page reveals that the file name and line number at the end
   of the error will change … however /wp_includes/plugins.php turns up regularly
   an errant file, so does this adminimize plugin line 444 error
 * > Fatal error: Out of memory (allocated 67633152) (tried to allocate 6144 bytes)
   > in /homepages/37/xxxxxxxxxxx/htdocs/wp-treelocate/wp-content/plugins/adminimize/
   > adminimize.php on line 444
 * On a hunch I looked in the database and found the wp-options table had exploded.
   Instead of being about 50k it was **over 232MB** – 99% of that being transient
   data for nggallery gallery views.
 * I’m racking my brain for the SQL code to clean them out safely, but cannot remember
   how to structure it.
 * I had a similar issue several years ago when magpie caching was being used by
   another plugin – my entire hosting account got suspended that time around too–
   followed by a four month battle to get my site structures and data back from 
   the hosts.
 * Because of the NG Gallery sticky support thread about not deleting the plugin
   or you will lose all data, I’m loathe to just rename the plugins folder to regain
   access to wp-admin as I would normally do, so I hope the NextGen team answer 
   this topic quickly.
 * Please note; other people are posting threads here with identical issues, so 
   this is not an isolated incident (and they are all dated in the last few days)–
   I’ve posted a short version of this post on one of those other topics.
 * Issuing a plugin update will not work NextGen – we cannot get into wp-admin to
   run the updater – we need a hack to clear the bug, and a sql script to clear 
   the trash – and we need it urgently please, pretty please.

Viewing 3 replies - 1 through 3 (of 3 total)

 *  [WPyogi](https://wordpress.org/support/users/wpyogi/)
 * (@wpyogi)
 * [12 years, 9 months ago](https://wordpress.org/support/topic/nextgen-gallery-has-exploded-sql-wp-options-table/#post-4070666)
 * You need to post on the NGG sub-forum here:
 * [http://wordpress.org/support/plugin/nextgen-gallery](http://wordpress.org/support/plugin/nextgen-gallery)
 * >  I’ve posted a short version of this post on one of those other topics.
 * **
    However please do not post the same question in more than one place
    – it
   makes it harder for people to help you.
 *  Thread Starter [gazouteast](https://wordpress.org/support/users/gazouteast/)
 * (@gazouteast)
 * [12 years, 9 months ago](https://wordpress.org/support/topic/nextgen-gallery-has-exploded-sql-wp-options-table/#post-4070715)
 * Apologies – I thought I was posting to that sub-forum as I was logged into it
   and clicked “add new” at the top of the topics list.
 * Please could you move this topic to there?
 * Supporting what I said above – of the 330,000+ lines that had appeared in the
   wp-options table, 270,000 of them were transients created by ng-gallery. Once
   those were removed, the site came back up perfectly with no other changes.
 * Of the remaining 60,000-ish entries in the table, 57,000 were created by WordFence
   transients (another plugin).
 * I’ve seen this issue before – back when WP used Magpie caching, but this is the
   first time I’ve seen it since Magpie was replaced. Could something have been 
   re-introduced in WP3.6 that is causing this?
 *  [esmi](https://wordpress.org/support/users/esmi/)
 * (@esmi)
 * [12 years, 9 months ago](https://wordpress.org/support/topic/nextgen-gallery-has-exploded-sql-wp-options-table/#post-4070717)
 * You would be far better off posting a new topic in the correct sub-forum.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘NextGen Gallery has exploded SQL wp-options table’ is closed to new replies.

## Tags

 * [fatal error](https://wordpress.org/support/topic-tag/fatal-error/)

 * 3 replies
 * 3 participants
 * Last reply from: [esmi](https://wordpress.org/support/users/esmi/)
 * Last activity: [12 years, 9 months ago](https://wordpress.org/support/topic/nextgen-gallery-has-exploded-sql-wp-options-table/#post-4070717)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics