1. REGISTRATION REQUIREMENTS:

    Register with your xenforo.com Username then start a conversation at xenforo.com w/Bob and provide the following:
    1. Your XenForo License Validation Token
    2. The Domain Name associated with the License
    NOTE: Your account will be validated once ALL requirements are verified/met. Thank you for your patience.

Unknown column 'allow_view_field_owner_in_user_group_ids' in 'field list'

Discussion in 'Showcase Bug Reports' started by phongvt, Oct 20, 2018.

  1. phongvt

    phongvt New Member Showcase EA

    I encounter this error while trying to create item field:

    Code:
         XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'allow_view_field_owner_in_user_group_ids' in 'field list' src/XF/Db/AbstractStatement.php:212
    
    Stack trace
    INSERT  INTO `xf_xa_sc_item_field` (`display_group`, `display_order`, `field_type`, `field_choices`, `max_length`, `required`, `display_template`, `field_id`, `match_type`, `match_params`, `hide_title`, `is_searchable`, `is_filter_link`, `fs_description`, `display_on_list`, `display_on_tab`, `display_on_tab_field_id`, `allow_use_field_user_group_ids`, `allow_view_field_user_group_ids`, `allow_view_field_owner_in_user_group_ids`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
    ------------
    
    #0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL statement...', 1054, '42S22')
    #1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1054, '42S22')
    #2 src/XF/Db/Mysqli/Statement.php(54): XF\Db\Mysqli\Statement->prepare()
    #3 src/XF/Db/AbstractAdapter.php(79): XF\Db\Mysqli\Statement->execute()
    #4 src/XF/Db/AbstractAdapter.php(160): XF\Db\AbstractAdapter->query('INSERT  INTO `x...', Array)
    #5 src/XF/Mvc/Entity/Entity.php(1403): XF\Db\AbstractAdapter->insert('xf_xa_sc_item_f...', Array, false)
    #6 src/XF/Mvc/Entity/Entity.php(1135): XF\Mvc\Entity\Entity->_saveToSource()
    #7 src/XF/Mvc/FormAction.php(69): XF\Mvc\Entity\Entity->save(true, false)
    #8 src/XF/Mvc/FormAction.php(159): XF\Mvc\FormAction->XF\Mvc\{closure}(Object(XF\Mvc\FormAction))
    #9 src/XF/Admin/Controller/AbstractField.php(188): XF\Mvc\FormAction->run()
    #10 src/XF/Mvc/Dispatcher.php(249): XF\Admin\Controller\AbstractField->actionSave(Object(XF\Mvc\ParameterBag))
    #11 src/XF/Mvc/Dispatcher.php(88): XF\Mvc\Dispatcher->dispatchClass('XenAddons\\Showc...', 'Save', 'json', Object(XF\Mvc\ParameterBag), 'xa_scItemFields', Object(XenAddons\Showcase\Admin\Controller\ItemField), NULL)
    #12 src/XF/Mvc/Dispatcher.php(41): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
    #13 src/XF/App.php(1931): XF\Mvc\Dispatcher->run()
    #14 src/XF.php(329): XF\App->run()
    #15 admin.php(13): XF::runApp('XF\\Admin\\App')
    #16 {main}
    
    Request state
    array(4) {
      ["url"] => string(33) "/admin.php?xa-sc/item-fields/save"
      ["referrer"] => string(50) "https://bmwclub.vn/admin.php?xa-sc/item-fields/add"
      ["_GET"] => array(1) {
       ["xa-sc/item-fields/save"] => string(0) ""
      }
      ["_POST"] => array(16) {
       ["field_id"] => string(7) "rr_bien"
       ["title"] => string(11) "Biển số"
       ["description"] => string(0) ""
       ["display_group"] => string(6) "header"
       ["display_order"] => string(1) "1"
       ["category_ids"] => array(1) {
         [0] => string(1) "1"
       }
       ["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) ""
       }
       ["display_template"] => string(0) ""
       ["_xfToken"] => string(8) "********"
       ["_xfRequestUri"] => string(32) "/admin.php?xa-sc/item-fields/add"
       ["_xfWithData"] => string(1) "1"
       ["_xfResponseType"] => string(4) "json"
      }
    }
    
    Please advice on how to solve it. Thanks!
     
  2. Bob

    Bob Developer Staff Member

    Unknown column: 'allow_view_field_owner_in_user_group_ids'

    That field is NEW to Showcase 3.0. Is this a NEW install or an Upgrade from a previous version of Showcase? Either way, its a field that is missing from the table that should be there.

    Can you inbox me with phpMyAdmin access so that I can check that table, add the field if neccessary and also make sure no other fields are missing in any of the other tables (showcase does have a fairly large scehema).
     
    phongvt likes this.
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.