Hello, I have a problem with whmcs invoices.
First, I had these errors:
PDOException: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'status' in where clause is ambiguous in /var/www/clients/vendor/illuminate/database/Connection.php:333
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 = 1 and status = Unpaid and type != Invoice group by tblinvoices.id) in /var/www/clients/vendor/illuminate/database/Connection.php:713
Then I was advised to do, which now gives these errors:
PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'status' in 'where clause' in /var/www/clients/vendor/illuminate/database/Connection.php:333
Next Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'status' in 'where clause' (SQL: select IFNULL(total, 0) as total, IFNULL(SUM(amountin), 0) as amount_in, IFNULL(SUM(amountout), 0) as amount_out from tblinvoices left join tblaccounts on tblaccounts.invoiceid = tblinvoices.id where tblinvoices.userid = 1 and status = Unpaid and 1 = 1 group by tblinvoices.id) in /var/www/clients/vendor/illuminate/database/Connection.php:713
Does anyone have a solution?
Regards.
