jynxy

Hi, Updated a clients account from 7.3 to latest version when clicking on an invoice via admin we are getting the following error, i cant seem to track down why. does anyone have any ideas ? Thanks PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'invoice_id' in 'where clause' in /home/username/public_html/vendor/illuminate/database/Connection.php:331 Stack trace: #0 /home/username/public_html/vendor/illuminate/database/Connection.php(331): PDO->prepare('select count(*)...') #1 /home/username/public_html/vendor/illuminate/database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database\{closure}('select count(*)...', Array) #2 /home/username/public_html/vendor/illuminate/database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback('select count(*)...', Array, Object(Closure)) #3 /home/username/public_html/vendor/illuminate/database/Connection.php(339): Illuminate\Database\Connection->run('select count(*)...', Array, Object(Closure)) #4 /home/username/public_html/vendor/illuminate/database/Query/Builder.php(2202): Illuminate\Database\Connection->select('select count(*)...', Array, true) #5 /home/username/public_html/vendor/illuminate/database/Query/Builder.php(2190): Illuminate\Database\Query\Builder->runSelect() #6 /home/username/public_html/vendor/illuminate/database/Query/Builder.php(2685): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() #7 /home/username/public_html/vendor/illuminate/database/Query/Builder.php(2191): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure)) #8 /home/username/public_html/vendor/illuminate/database/Query/Builder.php(2612): Illuminate\Database\Query\Builder->get(Array) #9 /home/username/public_html/vendor/illuminate/database/Query/Builder.php(2540): Illuminate\Database\Query\Builder->aggregate('count', Array) #10 /home/username/public_html/vendor/illuminate/database/Eloquent/Builder.php(1403): Illuminate\Database\Query\Builder->count() #11 /home/username/public_html/adminhvr5/invoices.php(0): Illuminate\Database\Eloquent\Builder->__call('count', Array) #12 {main} Next Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'invoice_id' in 'where clause' (SQL: select count(*) as aggregate from `tblaffiliateshistory` where `invoice_id` = 102483) in /home/username/public_html/vendor/illuminate/database/Connection.php:671 Stack trace: #0 /home/username/public_html/vendor/illuminate/database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback('select count(*)...', Array, Object(Closure)) #1 /home/username/public_html/vendor/illuminate/database/Connection.php(339): Illuminate\Database\Connection->run('select count(*)...', Array, Object(Closure)) #2 /home/username/public_html/vendor/illuminate/database/Query/Builder.php(2202): Illuminate\Database\Connection->select('select count(*)...', Array, true) #3 /home/username/public_html/vendor/illuminate/database/Query/Builder.php(2190): Illuminate\Database\Query\Builder->runSelect() #4 /home/username/public_html/vendor/illuminate/database/Query/Builder.php(2685): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() #5 /home/username/public_html/vendor/illuminate/database/Query/Builder.php(2191): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure)) #6 /home/username/public_html/vendor/illuminate/database/Query/Builder.php(2612): Illuminate\Database\Query\Builder->get(Array) #7 /home/username/public_html/vendor/illuminate/database/Query/Builder.php(2540): Illuminate\Database\Query\Builder->aggregate('count', Array) #8 /home/username/public_html/vendor/illuminate/database/Eloquent/Builder.php(1403): Illuminate\Database\Query\Builder->count() #9 /home/username/public_html/adminhvr5/invoices.php(0): Illuminate\Database\Eloquent\Builder->__call('count', Array) #10 {main}