Title: Settings not saving, WordPress database error: [Unknown column ‘hover_effect’ in
Last modified: December 14, 2017

---

# Settings not saving, WordPress database error: [Unknown column ‘hover_effect’ in

 *  Resolved [D1](https://wordpress.org/support/users/d1/)
 * (@d1)
 * [8 years, 5 months ago](https://wordpress.org/support/topic/settings-not-saving-wordpress-database-error-unknown-column-hover_effect-in/)
 * Hello,
 * The gallery setting are not saving. I enabled debug and received this message:
 * WordPress database error: [Unknown column ‘hover_effect’ in ‘field list’]
    UPDATE`
   wp_photo_gallery_wp_gallerys` SET `name` = ‘New gallery’, `sl_width` = ‘600’,`
   sl_height` = ‘375’, `pause_on_hover` = ‘on’, `gallery_list_effects_s` = ‘fade’,`
   description` = ‘4000’, `param` = ‘1000’, `sl_position` = ‘center’, `photo_gallery_wp_sl_effects`
   = ‘5’, `ordering` = ‘1’, `rating` = ‘off’, `autoslide` = ‘on’, `hover_effect`
   = ‘0’, `content_per_page` = ‘5’, `display_type` = ‘2’, `gallery_loader_type` 
   = ‘1’ WHERE `id` = 8
 * Thanks
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fsettings-not-saving-wordpress-database-error-unknown-column-hover_effect-in%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 1 replies (of 1 total)

 *  [huge-it-support-1](https://wordpress.org/support/users/huge-it-support-1/)
 * (@huge-it-support-1)
 * [8 years, 5 months ago](https://wordpress.org/support/topic/settings-not-saving-wordpress-database-error-unknown-column-hover_effect-in/#post-9784902)
 * Dear D1,
 * Thanks for your post.
 * Could you, please, try to deactivate/delete the plugin and install it agai?
    
   This will probably fix the issue.
 * Please, clear your browser cache after all
 * We will wait for your results
 * Thanks

Viewing 1 replies (of 1 total)

The topic ‘Settings not saving, WordPress database error: [Unknown column ‘hover_effect’
in’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/gallery-and-caption_fe7e4a.svg)
 * [Photo Gallery and Image Gallery](https://wordpress.org/plugins/gallery-and-caption/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/gallery-and-caption/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/gallery-and-caption/)
 * [Active Topics](https://wordpress.org/support/plugin/gallery-and-caption/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/gallery-and-caption/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/gallery-and-caption/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [huge-it-support-1](https://wordpress.org/support/users/huge-it-support-1/)
 * Last activity: [8 years, 5 months ago](https://wordpress.org/support/topic/settings-not-saving-wordpress-database-error-unknown-column-hover_effect-in/#post-9784902)
 * Status: resolved