https://domainname.com/clientarea.php?action=invoices
Oops!
Something went wrong and we couldn't process your request.
Please go back to the previous page and try again.
If the problem persists, please contact us.
« Back to Homepage
PDOException: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'status' in where clause is ambiguous in /home/supporth/public_html/vendor/illuminate/database/Connection.php:333
Stack trace:
#0 /home/supporth/public_html/vendor/illuminate/database/Connection.php(333): PDO->prepare('select IFNULL(t...')
#1 /home/supporth/public_html/vendor/illuminate/database/Connection.php(706): Illuminate\Database\Connection->Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'select IFNULL(t...', Array)
#2 /home/supporth/public_html/vendor/illuminate/database/Connection.php(669): Illuminate\Database\Connection->runQueryCallback('select IFNULL(t...', Array, Object(Closure))
#3 /home/supporth/public_html/vendor/illuminate/database/Connection.php(342): Illuminate\Database\Connection->run('select IFNULL(t...', Array, Object(Closure))
#4 /home/supporth/public_html/vendor/illuminate/database/Query/Builder.php(1583): Illuminate\Database\Connection->select('select IFNULL(t...', Array, true)
#5 /home/supporth/public_html/vendor/illuminate/database/Query/Builder.php(1569): Illuminate\Database\Query\Builder->runSelect()
#6 /home/supporth/public_html/vendor/whmcs/whmcs-foundation/lib/View/Client/Menu/PrimarySidebarFactory.php(0): Illuminate\Database\Query\Builder->get(Array)
#7 /home/supporth/public_html/vendor/whmcs/whmcs-foundation/lib/View/Client/Menu/MenuRepository.php(0): WHMCS\View\Client\Menu\PrimarySidebarFactory->invoiceList()
#8 /home/supporth/public_html/vendor/whmcs/whmcs-foundation/lib/View/Client/Menu/MenuRepository.php(0): WHMCS\View\Client\Menu\MenuRepository->buildSidebar('primarySidebar', 'invoiceList')
#9 /home/supporth/public_html/vendor/illuminate/support/Facades/Facade.php(217): WHMCS\View\Client\Menu\MenuRepository->primarySidebar('invoiceList')
#10 /home/supporth/public_html/clientarea.php(0): Illuminate\Support\Facades\Facade::__callStatic('primarySidebar', Array)
#11 {main}
Next Illuminate\Database\QueryException: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'status' in where clause is ambiguous (SQL: select IFNULL(total, 0) as total, IFNULL(SUM(amountin), 0) as amount_in, IFNULL(SUM(amountout), 0) as amount_out from `tblinvoices` inner join `tblinvoiceitems` on `tblinvoiceitems`.`invoiceid` = `tblinvoices`.`id` left join `tblaccounts` on `tblaccounts`.`invoiceid` = `tblinvoices`.`id` where `tblinvoices`.`userid` = 57 and `status` = Unpaid and `type` != Invoice group by `tblinvoices`.`id`) in /home/supporth/public_html/vendor/illuminate/database/Connection.php:713
Stack trace:
#0 /home/supporth/public_html/vendor/illuminate/database/Connection.php(669): Illuminate\Database\Connection->runQueryCallback('select IFNULL(t...', Array, Object(Closure))
#1 /home/supporth/public_html/vendor/illuminate/database/Connection.php(342): Illuminate\Database\Connection->run('select IFNULL(t...', Array, Object(Closure))
#2 /home/supporth/public_html/vendor/illuminate/database/Query/Builder.php(1583): Illuminate\Database\Connection->select('select IFNULL(t...', Array, true)
#3 /home/supporth/public_html/vendor/illuminate/database/Query/Builder.php(1569): Illuminate\Database\Query\Builder->runSelect()
#4 /home/supporth/public_html/vendor/whmcs/whmcs-foundation/lib/View/Client/Menu/PrimarySidebarFactory.php(0): Illuminate\Database\Query\Builder->get(Array)
#5 /home/supporth/public_html/vendor/whmcs/whmcs-foundation/lib/View/Client/Menu/MenuRepository.php(0): WHMCS\View\Client\Menu\PrimarySidebarFactory->invoiceList()
#6 /home/supporth/public_html/vendor/whmcs/whmcs-foundation/lib/View/Client/Menu/MenuRepository.php(0): WHMCS\View\Client\Menu\MenuRepository->buildSidebar('primarySidebar', 'invoiceList')
#7 /home/supporth/public_html/vendor/illuminate/support/Facades/Facade.php(217): WHMCS\View\Client\Menu\MenuRepository->primarySidebar('invoiceList')
#8 /home/supporth/public_html/clientarea.php(0): Illuminate\Support\Facades\Facade::__callStatic('primarySidebar', Array)
#9 {main}