invoice module produces an error.

[foneguy9]

I have an invoice module on my 4.5.1H and have the following error. Can anyone help repair it?

When I open up the Account, this shows up at the bottom of the account. I can open up and print the invoice.


Error retrieving Account list: Query Failed: SELECT jcrminvoices.id , jcrminvoices.invoice_number , jcrminvoices.date_invoice , CONCAT(IFNULL(jt0.first_name,''),' ',IFNULL(jt0.last_name,'')) contact_name, jcrminvoices.internal_ref , jcrminvoices.amount , jcrminvoices.currency_id , jcrminvoices.status , jt1.user_name assigned_user_name, jcrminvoices.assigned_user_id , 'jcrminvoices' panel_name FROM jcrminvoices AND jt0.deleted=0 AND jt1.deleted=0 where (jcrminvoices.account_id='bb8c8661-221e-b600-b96b-476048e53cfb') AND jcrminvoices.deleted=0 LIMIT 0,10::MySQL error 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 'AND jt0.deleted=0 AND jt1.deleted=0 where (jcrminvoices.account_id='bb8c8661-22' at line 1

Thanks!

[foneguy9]

re indexed the database and works now!

Thanks.