Title: Solution: Nextgen display types disappeared
Last modified: August 30, 2016

---

# Solution: Nextgen display types disappeared

 *  Resolved [markdeboer](https://wordpress.org/support/users/markdeboer/)
 * (@markdeboer)
 * [10 years, 12 months ago](https://wordpress.org/support/topic/solution-nextgen-display-types-disappeared/)
 * For some reason my NextGen 2.1.0 install broke: it did not show the display types
   anymore, causing every page to show ‘Invalid’ instead of a gallery. Probably 
   this was the result of using a database cleanup tool a bit too rigorously.
 * I found out there is no easy way to restore the database settings. Reinstalling
   the plugin will not change anything in the database. Even deleting it will not
   remove all the settings.
 * But after some investigation I found the following solution, which will work 
   for most database-related issues, I guess. This procedure resets some database
   options but keeps all the picture-, gallery- and albumdata. In my case, the Options
   page for the different display types was unusable so I did not have to go over
   those.
 * 0. Go to NextGen Gallery main page and note the number of pictures, galleries
   and albums. You also might want to check the Options pages for any specific settings.
   
   1. use MyPHPAdmin or another tool to export the 3 specific NGG tables wp_ngg_album,
   wp_ngg_galleries and wp_ngg_pictures (I simply chose a .sql export per table)
   2. Go to Gallery > Other options and choose Reset Options 3. Press ‘Reset all
   options to default settings’ 4. Go to Plugins and deactivate NextGen Gallery (
   optional, for safety) 5. use MyPHPAdmin or another tool to re-import the 3 .sql
   files into the respective tables 6. Activate NextGen Gallery (if you deactivated
   it in step 4) 7. Check the NextGen Gallery main page if it displays the same 
   number of pictures and galleries as there were in step 0. 8. Reconfigure NGG 
   on the Options page to your preference.
 * Hope this helps others with the same issues.
 * [https://wordpress.org/plugins/nextgen-gallery/](https://wordpress.org/plugins/nextgen-gallery/)

Viewing 1 replies (of 1 total)

 *  Plugin Contributor [photocrati](https://wordpress.org/support/users/photocrati/)
 * (@photocrati)
 * [10 years, 12 months ago](https://wordpress.org/support/topic/solution-nextgen-display-types-disappeared/#post-6263406)
 * [@markdeboer](https://wordpress.org/support/users/markdeboer/) – Thanks for sharing
   your experience with this … and you are most likely correct it was an over-zealous
   database optimizer that may have created the problem to begin with.
 * – Cais.

Viewing 1 replies (of 1 total)

The topic ‘Solution: Nextgen display types disappeared’ is closed to new replies.

 * ![](https://ps.w.org/nextgen-gallery/assets/icon-256x256.png?rev=2083961)
 * [Photo Gallery, Sliders, Proofing and Themes - NextGEN Gallery](https://wordpress.org/plugins/nextgen-gallery/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/nextgen-gallery/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/nextgen-gallery/)
 * [Active Topics](https://wordpress.org/support/plugin/nextgen-gallery/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/nextgen-gallery/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/nextgen-gallery/reviews/)

## Tags

 * [corrupt](https://wordpress.org/support/topic-tag/corrupt/)
 * [database](https://wordpress.org/support/topic-tag/database/)
 * [nextgen](https://wordpress.org/support/topic-tag/nextgen/)

 * 1 reply
 * 2 participants
 * Last reply from: [photocrati](https://wordpress.org/support/users/photocrati/)
 * Last activity: [10 years, 12 months ago](https://wordpress.org/support/topic/solution-nextgen-display-types-disappeared/#post-6263406)
 * Status: resolved