Fixed Incorrect integer value: 'use_field_mapping8' for column 'user_id' at row

[Nirjonadda]

Affected version

2.3.2

Server error log:

XF\Db\Exception: MySQL query error [1366]: Incorrect integer value: 'use_field_mapping8' for column 'user_id' at row 1 src/XF/Db/AbstractStatement.php:230

Generated by: Unknown account Aug 13, 2024 at 1:19 PM

Stack trace

            INSERT INTO xf_search_index_temp
                (hit_position, content_type, content_id, user_id, item_date, discussion_id)
            VALUES
                (1, 'thread', 99869, 'use_field_mapping8', 'use_field_mapping1722770178', 'use_field_mapping99869'),(2, 'thread', 98762, 'use_field_mapping26875', 'use_field_mapping1712140706', 'use_field_mapping98762'),(3, 'thread', 98761, '
        
------------

#0 src/XF/Db/Mysqli/Statement.php(207): XF\Db\AbstractStatement->getException('MySQL query err...', 1366, 'HY000')
#1 src/XF/Db/Mysqli/Statement.php(83): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1366, 'HY000')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/addons/XFES/Search/Source/Elasticsearch.php(984): XF\Db\AbstractAdapter->query('
            INSERT INTO...')
#4 src/addons/XFES/Search/Source/Elasticsearch.php(889): XFES\Search\Source\Elasticsearch->getSqlResults(Array, Object(XF\Search\Query\KeywordQuery), '200')
#5 src/addons/XFES/Search/Source/Elasticsearch.php(157): XFES\Search\Source\Elasticsearch->executeSearch(Object(XF\Search\Query\KeywordQuery), Array, '200')
#6 src/XF/Search/Search.php(337): XFES\Search\Source\Elasticsearch->search(Object(XF\Search\Query\KeywordQuery), '200')
#7 src/XF/Search/Search.php(366): XF\Search\Search->XF\Search\{closure}(Object(XF\Search\Query\KeywordQuery), '200')
#8 src/XF/Search/Search.php(332): XF\Search\Search->executeSearch(Object(XF\Search\Query\KeywordQuery), '200', Object(Closure), true)
#9 src/XF/Repository/SearchRepository.php(37): XF\Search\Search->search(Object(XF\Search\Query\KeywordQuery))
#10 src/XF/Pub/Controller/SearchController.php(562): XF\Repository\SearchRepository->runSearch(Object(XF\Search\Query\KeywordQuery), Array, true)
#11 src/XF/Pub/Controller/SearchController.php(182): XF\Pub\Controller\SearchController->runSearch(Object(XF\Search\Query\KeywordQuery), Array)
#12 src/XF/Mvc/Dispatcher.php(362): XF\Pub\Controller\SearchController->actionSearch(Object(XF\Mvc\ParameterBag))
#13 src/XF/Mvc/Dispatcher.php(264): XF\Mvc\Dispatcher->dispatchClass('XF:Search', 'Search', Object(XF\Mvc\RouteMatch), Object(XFES\XF\Pub\Controller\Search), NULL)
#14 src/XF/Mvc/Dispatcher.php(121): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XFES\XF\Pub\Controller\Search), NULL)
#15 src/XF/Mvc/Dispatcher.php(63): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#16 src/XF/App.php(2813): XF\Mvc\Dispatcher->run()
#17 src/XF.php(802): XF\App->run()
#18 index.php(23): XF::runApp('XF\\Pub\\App')
#19 {main}

Request state

array(4) {
  ["url"] => string(14) "/search/search"
  ["referrer"] => string(36) "/search/search"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(8) {
    ["_xfToken"] => string(8) "********"
    ["keywords"] => string(6) "bhabhi"
    ["c"] => array(8) {
      ["title_only"] => string(1) "1"
      ["users"] => string(0) ""
      ["newer_than"] => string(0) ""
      ["older_than"] => string(0) ""
      ["min_reply_count"] => string(1) "0"
      ["prefixes"] => array(1) {
        [0] => string(0) ""
      }
      ["nodes"] => array(1) {
        [0] => string(2) "83"
      }
      ["child_nodes"] => string(1) "1"
    }
    ["order"] => string(7) "replies"
    ["search_type"] => string(4) "post"
    ["_xfResponseType"] => string(4) "json"
    ["_xfWithData"] => string(1) "1"
    ["_xfRequestUri"] => string(14) "/search/search"
  }
}

 

[XF Bug Bot]

Thank you for reporting this issue, it has now been resolved. We are aiming to include any changes that have been made in a future XFES release (2.3.3).

Change log:

Do not set format for `docvalue_fields` in XFES

There may be a delay before changes are rolled out to the XenForo Community.