[ BUG ] Disclosure sql OFFICIAL ON BRIVIUM.COM !!!!!!!!!!!!! Mysql Prepare Error !!!!!!!!!!!!!

  1. scru2

    scru2 - Aug 22, 2017 New Member

    Credit
    Point

    1st: Go here:
    https://brivium.com/search/?type=support_ticket_message

    2nd: This bug occurs when you insert ARABIC characters in the search text area for example: سؤال


    ^ copy and paste above arabic character into the search keywords textarea.

    3rd (IMPORTANT): CHOOSE minimum number of replies to be: 5

    click search you will get the error that will flood your admin panel log:

    The following error occurred:


    Mysqli prepare error: Unknown column 'support_ticket.reply_count' in 'where clause'



      • Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
      • Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
      • Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
      • Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 734
      • Zend_Db_Adapter_Abstract->fetchAll() in XenForo/Search/SourceHandler/MySqlFt.php at line 310
      • XenForo_Search_SourceHandler_MySqlFt->executeSearch() in XenForo/Search/SourceHandler/Abstract.php at line 152
      • XenForo_Search_SourceHandler_Abstract->searchType() in XenForo/Search/Searcher.php at line 111
      • XenForo_Search_Searcher->searchType() in XenForo/ControllerPublic/Search.php at line 249
      • XenForo_ControllerPublic_Search->actionSearch() in XenForo/FrontController.php at line 351
      • XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
      • XenForo_FrontController->run() in /home/brivium/public_html/index.php at line 13




     
    Last edited: Aug 22, 2017
    Loading...
  2. scru2

    scru2 - Aug 22, 2017 New Member

    Credit
    Point
  3. Lisa Nguyen

    Lisa Nguyen - Aug 22, 2017 Brivium Tester Staff Member

    Credit
    Point
    Thanks for your bug report. Our developer is trying to fix this issue. When it complete, I will notify you.

    Many thanks,
     
    #3