can’t seem to figure out the issue. everything works fine until i go to the invoices view. Then i get this error:
An Error Was Encountered
Error Number: 1064
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near SELECT SUM(invoice_payments.amount_paid) FROM invoice_payments
SELECT invoices.*, clients.name, clients.address1, clients.address2, clients.city, clients.country, clients.province, clients.website, clients.postal_code, (SELECT SUM(invoice_payments.amount_paid) FROM invoice_payments WHERE invoice_payments.invoice_id=20) AS amount_paid, TO_DAYS(invoices.dateIssued) - TO_DAYS(curdate()) AS daysOverdue, (SELECT SUM(invoice_items.amount * invoice_items.quantity) FROM invoice_items WHERE invoice_items.invoice_id=20) AS total_notax, (SELECT SUM(invoice_items.amount * invoice_items.quantity * (invoices.tax1_rate/100 * invoice_items.taxable)) FROM invoice_items WHERE invoice_items.invoice_id=20) AS total_tax1, (SELECT SUM(invoice_items.amount * invoice_items.quantity * (invoices.tax2_rate/100 * invoice_items.taxable)) FROM invoice_items WHERE invoice_items.invoice_id=20) AS total_tax2, (SELECT SUM(invoice_items.amount * invoice_items.quantity + (invoice_items.amount * invoice_items.quantity * (invoices.tax1_rate/100 + invoices.tax2_rate/100) * invoice_items.taxable)) FROM invoice_items WHERE invoice_items.invoice_id=20) AS total_with_tax FROM (`invoices`) JOIN `clients` ON invoices.client_id = clients.id JOIN `invoice_items` ON invoices.id = invoice_items.invoice_id LEFT JOIN `invoice_payments` ON invoices.id = invoice_payments.invoice_id WHERE invoices.id = 20 GROUP BY invoices.id
I did have to do this little hack to bypass utf8 http://codeigniter.com/wiki/MySQL_4.0/ . Maybe that is my problem?
im running:
Server version: 4.0.27-log
MySQL client version: 5.0.37
thx
