Undefined index: gallery_options_override issue

[Optic]

Hello @Bob B, just upgraded to Showcase 2.2.0 stable and Xenforo 1.4.1. Regenerated Showcase thumbnails and everything appears to be fine, but I seem to be getting flooded with these server errors everytime a user browses the Showcase:

Any help would greatly be appreciated, thanks.

ErrorException: Undefined index: gallery_options_override - library/NFLJ/Showcase/Model/Item.php:680
Generated By: Unknown Account, 6 minutes ago
Stack Trace

#0 /home/ancommun/public_html/forums/library/NFLJ/Showcase/Model/Item.php(680): XenForo_Application::handlePhpError(8, 'Undefined index...', '/home/ancommun/...', 680, Array)
#1 /home/ancommun/public_html/forums/library/NFLJ/Showcase/Model/Item.php(947): NFLJ_Showcase_Model_Item->prepareItem(Array, Array, Array, false, false)
#2 /home/ancommun/public_html/forums/library/NFLJ/Showcase/ControllerPublic/Showcase.php(151): NFLJ_Showcase_Model_Item->prepareItems(Array, true)
#3 /home/ancommun/public_html/forums/library/XenForo/FrontController.php(347): NFLJ_Showcase_ControllerPublic_Showcase->actionIndex()
#4 /home/ancommun/public_html/forums/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#5 /home/ancommun/public_html/forums/index.php(13): XenForo_FrontController->run()
#6 {main}

Request State

array(3) {
  ["url"] => string(39) "http://forums.ancommunity.net/showcase/"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}

 

[Bob]

Appears like the SQL steps for the 2.1.1 upgrade didn't take effect for you since that field was added in SC 2.1.1

Run this query and then check to make sure the 3 new fields have been properly added to the xf_nflj_showcase_category.

                    ALTER TABLE xf_nflj_showcase_category
                        ADD gallery_options_override tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
                        ADD gallery_type varchar(25) NOT NULL default '',
                        ADD gallery_tab1 tinyint(3) UNSIGNED NOT NULL DEFAULT '0'

 

[Optic]

Thanks @Bob B, you're a legend.

That fixed it!