Bug Fixed MySQL Error 'thread.xfa_fss_transaction_id' in 'on clause'

[Freelancer]

As I visited the Forum Sales Log just to check, the following happened.

Error Info
Mysqli prepare error: Unknown column 'thread.xfa_fss_transaction_id' in 'on clause' - library/Zend/Db/Statement/Mysqli.php:77

Stack Trace
#0 /var/www/clients/client180/web812/web/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('\n\t\t\t\tSELECT tra...')
#1 /var/www/clients/client180/web812/web/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '\n\t\t\t\tSELECT tra...')
#2 /var/www/clients/client180/web812/web/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('\n\t\t\t\tSELECT tra...')
#3 /var/www/clients/client180/web812/web/library/XenForo/Model.php(219): Zend_Db_Adapter_Abstract->query('\n\t\t\t\tSELECT tra...', Array, 2)
#4 /var/www/clients/client180/web812/web/library/XFA/ForumSales/Model/Transaction.php(71): XenForo_Model->fetchAllKeyed('\n\t\t\t\tSELECT tra...', 'transaction_id')
#5 /var/www/clients/client180/web812/web/library/XFA/ForumSales/Extends/ControllerAdmin/Log.php(20): XFA_ForumSales_Model_Transaction->getLogs(Array)
#6 /var/www/clients/client180/web812/web/library/XenForo/FrontController.php(351): XFA_ForumSales_Extends_ControllerAdmin_Log->actionForumSales()
#7 /var/www/clients/client180/web812/web/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#8 /var/www/clients/client180/web812/web/admin.php(13): XenForo_FrontController->run()
#9 {main}

Request State
Array
(
    [url] => https://www.mywebsite.com/admin.php?logs/forum-sales
    [_GET] => Array
        (
            [logs/forum-sales] => 
        )

    [_POST] => Array
        (
        )

)

 

[Clement]

Thanks, I did remove that column but forgot to update the forum sales log page.

 

[Freelancer]

I will find everything. You can not hide bugs from me...