Today I suddenly have the following error when I click “Invoice summary”
A Database Error Occurred
Error Number: 1030
Got error 28 from storage engine
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
