forgot password?


   
 
SQL syntax error after update from 0.8.2 => 0.8.4
Posted: 13 May 2008 11:45 PM   [ Ignore ]  
Newbie
Rank
Total Posts:  3
Joined  2007-10-04

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_paidFROM invoice_payments

SELECT invoices
.*, clients.nameclients.address1clients.address2clients.cityclients.countryclients.provinceclients.websiteclients.postal_code, (SELECT SUM(invoice_payments.amount_paidFROM invoice_payments WHERE invoice_payments.invoice_id=20) AS amount_paidTO_DAYS(invoices.dateIssued) - TO_DAYS(curdate()) AS daysOverdue, (SELECT SUM(invoice_items.amount invoice_items.quantityFROM 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 `clientsON invoices.client_id clients.id JOIN `invoice_itemsON invoices.id invoice_items.invoice_id LEFT JOIN `invoice_paymentsON 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

Profile
 
 
Posted: 14 May 2008 06:51 AM   [ Ignore ]   [ # 1 ]  
Administrator
RankRankRankRank
Total Posts:  650
Joined  2007-09-16

maybe.  The new version of Bamboo uses CodeIgniter’s new UTF-8 capabilites so that should be a non-issue.

I’ll endeavour to get it out shortly.  Keep an eye on my blog.

Profile
 
 
   
 
 
‹‹ Few bugs for French User      SEND BY EMAIL ››