Location custom field by AddonsLab [Paid] 2.1.4

[woody]

Discovered with a new install of Bob's CAS addon. Entered an ID, the field title and then hitting "save"...nothing more...have tried a dozen combinations and all result in an error.

[LIST]
[*]XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'location_options' in 'field list'
[*]src/XF/Db/AbstractStatement.php:225
[*]Generated by: [URL='https://forum.ih8mud.com/admin.php?users/woody.1720/edit']woody[/URL]
[*]May 14, 2026 at 1:16 PM
[/LIST]
[HEADING=2]Stack trace[/HEADING]
INSERT  INTO [ICODE]xf_xa_cas_ad_field[/ICODE] ([ICODE]display_group[/ICODE], [ICODE]display_order[/ICODE], [ICODE]field_type[/ICODE], [ICODE]field_choices[/ICODE], [ICODE]max_length[/ICODE], [ICODE]required[/ICODE], [ICODE]display_template[/ICODE], [ICODE]wrapper_template[/ICODE], [ICODE]field_id[/ICODE], [ICODE]match_type[/ICODE], [ICODE]editable_user_group_ids[/ICODE], [ICODE]match_params[/ICODE], [ICODE]hide_title[/ICODE], [ICODE]display_on_list[/ICODE], [ICODE]display_on_tab[/ICODE], [ICODE]display_on_tab_field_id[/ICODE], [ICODE]location_options[/ICODE]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(207): XF\Db\AbstractStatement->getException('MySQL statement...', 1054, '42S22')
#1 src/XF/Db/Mysqli/Statement.php(43): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1054, '42S22')
#2 src/XF/Db/Mysqli/Statement.php(61): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Db/AbstractAdapter.php(219): XF\Db\AbstractAdapter->query('INSERT  INTO `x...', Array)
#5 src/XF/Mvc/Entity/Entity.php(1578): XF\Db\AbstractAdapter->insert('xf_xa_cas_ad_fi...', Array, false)
#6 src/XF/Mvc/Entity/Entity.php(1306): XF\Mvc\Entity\Entity->_saveToSource()
#7 src/XF/Mvc/FormAction.php(72): XF\Mvc\Entity\Entity->save(true, false)
#8 src/XF/Mvc/FormAction.php(190): XF\Mvc\FormAction->{closure:XF\Mvc\FormAction::saveEntity():70}(Object(XF\Mvc\FormAction))
#9 src/XF/Admin/Controller/AbstractField.php(193): XF\Mvc\FormAction->run()
#10 src/XF/Mvc/Dispatcher.php(362): XF\Admin\Controller\AbstractField->actionSave(Object(XF\Mvc\ParameterBag))
#11 src/XF/Mvc/Dispatcher.php(264): XF\Mvc\Dispatcher->dispatchClass('XenAddons\\CAS:A...', 'Save', Object(XF\Mvc\RouteMatch), Object(AL\LocationField\XenAddons\CAS\Admin\Controller\AdField), NULL)
#12 src/XF/Mvc/Dispatcher.php(121): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(AL\LocationField\XenAddons\CAS\Admin\Controller\AdField), NULL)
#13 src/XF/Mvc/Dispatcher.php(63): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#14 src/XF/App.php(2824): XF\Mvc\Dispatcher->run()
#15 src/XF.php(814): XF\App->run()
#16 admin.php(15): XF::runApp('XF\\Admin\\App')
#17 {main}
[HEADING=2]Request state[/HEADING]
array(4) {
  ["url"] => string(32) "/admin.php?xa-cas/ad-fields/save"
  ["referrer"] => string(55) "https://forumname.com/admin.php?xa-cas/ad-fields/add"
  ["_GET"] => array(1) {
    ["xa-cas/ad-fields/save"] => string(0) ""
  }
  ["_POST"] => array(19) {
    ["_xfToken"] => string(8) "********"
    ["field_id"] => string(5) "color"
    ["title"] => string(5) "Color"
    ["description"] => string(0) ""
    ["display_group"] => string(6) "header"
    ["display_order"] => string(1) "1"
    ["category_ids"] => array(1) {
      [0] => string(0) ""
    }
    ["field_type"] => string(7) "textbox"
    ["match_type"] => string(4) "none"
    ["max_length"] => string(1) "0"
    ["field_choice"] => array(1) {
      [0] => string(0) ""
    }
    ["field_choice_text"] => array(1) {
      [0] => string(0) ""
    }
    ["location_options"] => array(8) {
      ["field_format"] => string(4) "form"
      ["country_field"] => array(4) {
        ["default"] => string(0) ""
        ["display_mode"] => string(6) "select"
        ["highlighted"] => string(0) ""
        ["custom_list"] => string(0) ""
      }
      ["full_address_format"] => string(52) "{streetAddress}, {zipCode} {city} {state}, {country}"
      ["filter_format"] => string(12) "range_search"
      ["state_field"] => array(1) {
        ["mode"] => string(4) "text"
      }
      ["city_field"] => array(1) {
        ["mode"] => string(4) "text"
      }
      ["zip_code_field"] => array(2) {
        ["mode"] => string(4) "text"
        ["regex"] => string(0) ""
      }
      ["street_address_field"] => array(2) {
        ["mode"] => string(4) "text"
        ["regex"] => string(0) ""
      }
    }
    ["editable_user_group"] => string(3) "all"
    ["display_template"] => string(0) ""
    ["wrapper_template"] => string(0) ""
    ["_xfResponseType"] => string(4) "json"
    ["_xfWithData"] => string(1) "1"
    ["_xfRequestUri"] => string(31) "/admin.php?xa-cas/ad-fields/add"
  }
}

[/code