Solved Unknown column 'xs_seo_meta_robots' in 'field list' 2.3.0 fix 1

moshbit

Licensed
Licensed
SEO Optimization
Joined
Mar 2, 2020
Messages
2
Reaction score
1
xf 2.2.4 and seo 2.3.0 fix 1

im adding noindex/nofollow to the thread prefix 'library' and i get this error message:

Code:
    XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'xs_seo_meta_robots' in 'field list' src/XF/Db/AbstractStatement.php:228

    Generated by: Matt Derrick Mar 24, 2021 at 11:16 AM

Stack trace

UPDATE  `xf_thread_prefix` SET `allowed_user_group_ids` = ?, `xs_seo_meta_robots` = ? WHERE `prefix_id` = 29
------------

#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(94): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Db/AbstractAdapter.php(322): XF\Db\AbstractAdapter->query('UPDATE  `xf_thr...', Array)
#5 src/XF/Mvc/Entity/Entity.php(1515): XF\Db\AbstractAdapter->update('xf_thread_prefi...', Array, '`prefix_id` = 2...')
#6 src/XF/Mvc/Entity/Entity.php(1242): 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(187): XF\Mvc\FormAction->XF\Mvc\{closure}(Object(XF\Mvc\FormAction))
#9 src/XF/Admin/Controller/AbstractPrefix.php(148): XF\Mvc\FormAction->run()
#10 src/XF/Mvc/Dispatcher.php(350): XF\Admin\Controller\AbstractPrefix->actionSave(Object(XF\Mvc\ParameterBag))
#11 src/XF/Mvc/Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass('XF:ThreadPrefix', 'Save', Object(XF\Mvc\RouteMatch), Object(XenSoluce\SEOOptimization\XF\Admin\Controller\ThreadPrefix), NULL)
#12 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XenSoluce\SEOOptimization\XF\Admin\Controller\ThreadPrefix), NULL)
#13 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#14 src/XF/App.php(2326): XF\Mvc\Dispatcher->run()
#15 src/XF.php(488): XF\App->run()
#16 admin.php(13): XF::runApp('XF\\Admin\\App')
#17 {main}

Request state

array(4) {
  ["url"] => string(42) "/admin.php?thread-prefixes/library.29/save"
  ["referrer"] => string(68) "https://squattheplanet.com/admin.php?thread-prefixes/library.29/edit"
  ["_GET"] => array(1) {
    ["thread-prefixes/library_29/save"] => string(0) ""
  }
  ["_POST"] => array(14) {
    ["title"] => string(7) "Library"
    ["description"] => string(0) ""
    ["usage_help"] => string(0) ""
    ["css_class"] => string(20) "label label--library"
    ["prefix_group_id"] => string(2) "19"
    ["display_order"] => string(2) "40"
    ["usable_user_group"] => string(3) "sel"
    ["usable_user_group_ids"] => array(3) {
      [0] => string(1) "3"
      [1] => string(1) "4"
      [2] => string(1) "5"
    }
    ["node_ids"] => array(63) {
      [0] => string(1) "8"
      [1] => string(1) "4"
      [2] => string(3) "218"
      [3] => string(3) "222"
      [4] => string(3) "403"
      [5] => string(2) "81"
      [6] => string(2) "84"
      [7] => string(2) "83"
      [8] => string(1) "7"
      [9] => string(2) "52"
      [10] => string(3) "196"
      [11] => string(3) "190"
      [12] => string(3) "198"
      [13] => string(3) "199"
      [14] => string(3) "191"
      [15] => string(3) "192"
      [16] => string(3) "193"
      [17] => string(3) "194"
      [18] => string(3) "195"
      [19] => string(2) "33"
      [20] => string(2) "34"
      [21] => string(3) "324"
      [22] => string(3) "431"
      [23] => string(3) "430"
      [24] => string(3) "387"
      [25] => string(3) "354"
      [26] => string(2) "15"
      [27] => string(2) "11"
      [28] => string(2) "49"
      [29] => string(2) "60"
      [30] => string(2) "78"
      [31] => string(2) "12"
      [32] => string(3) "449"
      [33] => string(3) "216"
      [34] => string(2) "51"
      [35] => string(2) "54"
      [36] => string(2) "53"
      [37] => string(2) "56"
      [38] => string(2) "58"
      [39] => string(2) "59"
      [40] => string(2) "55"
      [41] => string(2) "57"
      [42] => string(2) "17"
      [43] => string(3) "438"
      [44] => string(3) "256"
      [45] => string(2) "20"
      [46] => string(3) "202"
      [47] => string(3) "439"
      [48] => string(2) "23"
      [49] => string(2) "25"
      [50] => string(3) "441"
      [51] => string(3) "440"
      [52] => string(3) "264"
      [53] => string(2) "26"
      [54] => string(2) "50"
      [55] => string(3) "261"
      [56] => string(2) "30"
      [57] => string(2) "19"
      [58] => string(2) "29"
      [59] => string(3) "225"
      [60] => string(3) "428"
      [61] => string(3) "385"
      [62] => string(3) "386"
    }
    ["xs_seo_meta_robots"] => string(16) "noindex,nofollow"
    ["_xfToken"] => string(8) "********"
    ["_xfRequestUri"] => string(42) "/admin.php?thread-prefixes/library.29/edit"
    ["_xfWithData"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
  }
}
 

SyTry

Administrator
Staff member
Administrator
Moderator
Licensed
Joined
Jul 8, 2019
Messages
384
Reaction score
195
Hello, thank you for your report. We'll share a fix tomorrow ! ;)

Regards, SyTry
 
Top Bottom