Jump to content
Beko

Problem after update status Unpaid SQLSTATE[23000]

Recommended Posts

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}

Share this post


Link to post
Share on other sites

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.

 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated