Hi Derek,
I have been using BI for quite a while and after adding my 128th invoice (started at 1001) am receiving the following error:-
A Database Error Occurred
Error Number: 1104
The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
SELECT bamboo_invoices.*, bamboo_clients.name, (SELECT SUM(amount_paid) FROM bamboo_invoice_payments WHERE invoice_id=bamboo_invoices.id) AS amount_paid, TO_DAYS(bamboo_invoices.dateIssued) - TO_DAYS(curdate()) AS daysOverdue, ROUND((SELECT SUM(bamboo_invoice_items.amount * bamboo_invoice_items.quantity + (bamboo_invoice_items.amount * bamboo_invoice_items.quantity * (bamboo_invoices.tax1_rate/100 + bamboo_invoices.tax2_rate/100) * bamboo_invoice_items.taxable)) FROM bamboo_invoice_items WHERE bamboo_invoice_items.invoice_id=bamboo_invoices.id), 2) AS subtotal FROM (bamboo_invoices) JOIN bamboo_clients ON bamboo_invoices.client_id = bamboo_clients.id LEFT JOIN bamboo_invoice_items ON bamboo_invoices.id = bamboo_invoice_items.invoice_id LEFT JOIN bamboo_invoice_payments ON bamboo_invoices.id = bamboo_invoice_payments.invoice_id WHERE `client_id` IS NOT NULL GROUP BY bamboo_invoices.id HAVING (ROUND(amount_paid, 2) < ROUND(subtotal, 2) or amount_paid is null) ORDER BY dateIssued desc, invoice_number desc LIMIT 5000
I notice reading on the forum another user has experienced this and wondered if there is a solution. As far as I am aware, nothing has changed. Everything OK one minute and on addingthe 128th invoice this error occured.
Am OK to view Clients, Settings and Accounts, everything else generates this error.
Reading the comments from another post it seems they too are using Heart Internet (like I am )to host my Bamboo Invoice.
If you are able to shed any light on this be most appreciated, as I have more!!! invoices to add.
Also, can BI be hosted on my own PC setup using ‘WAMP’
Many thanks and hope to here from you soon.
Regards
David
Blend Coffee Shop.
