Illuminate\Database\QueryException in GET /nova-api/dues-transactions

Error in Apiary

Illuminate\Database\QueryException in GET /nova-api/dues-transactions
SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'id' (SQL: select count() as aggregate from (select dues_transactions., dues_transactions.*, dues_transaction_merchandise.merchandise_id as pivot_merchandise_id, dues_transaction_merchandise.dues_transaction_id as pivot_dues_transaction_id, dues_transaction_merchandise.provided_at as pivot_provided_at, dues_transaction_merchandise.provided_by as pivot_provided_by, dues_transaction_merchandise.created_at as pivot_created_at, dues_transaction_merchandise.updated_at as pivot_updated_at from dues_transactions inner join dues_transaction_merchandise on dues_transactions.id = dues_transaction_merchandise.dues_transaction_id left join payments on payments.payable_id = dues_transactions.id and payments.payable_type = dues-transaction and payments.deleted_at is null inner join dues_packages on dues_packages.id = dues_transactions.dues_package_id...

View on Bugsnag

Stacktrace

app/Http/Middleware/CASAuthenticate.php:100 - App\Http\Middleware\CASAuthenticate::handle

View full stacktrace

Created by RoboJackets Admin via Bugsnag

Start with the GET /nova-api/dues-transactions request and the duplicate id SQL shown in the report, then inspect the query path associated with app/Http/Middleware/CASAuthenticate.php:100. Reproduce the request if possible and trace where dues_transactions is selected twice; done means the endpoint no longer raises the duplicate-column error.