Jump to content

Beko

Member
  • Posts

    1
  • Joined

  • Last visited

About Beko

Beko's Achievements

Junior Member

Junior Member (1/3)

0

Reputation

  1. 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}
  2. Welcome to WHMCS.Community Beko! We're glad you're here please take some time to familiarise yourself with the Community Rules & Guidelines and take a moment to introduce yourself to other WHMCS.Community members in the Introduce Yourself Board.

×
×
  • 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