Problem after update status Unpaid SQLSTATE[23000]

[Beko]

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}

[WHMCS John]

Hi there,

We've determined that similar errors to this have been caused by modifications to the MySQL database schema - presumably the result of an after-market module.

In the cases our technical support team have handled, one or more of the following additional columns had been added to the tblinvoiceitems table:

• status
• created_at
• updated_at

We also found evidence of some custom triggers added to tblinvoices and tblorders.

Please consult with the vendor of your after-market module vendor on the presence of these tables and suitability of removing them. At the time of writing, these fields are not used by a stock WHMCS installation.

The standard schema for these tables is described by the schema.sql files in the /resources/sql/install/ directory.

I recommend consulting with a qualified database administrator to restore the modified table schemas to their original state.