Aalst Posted April 19, 2004 Share Posted April 19, 2004 since installing this contribution (which is great other than this problem) whenever i search for a customer name i get1064 - You have an error in your SQL syntax near 'where c.customers_lastname like '%NAME%' or c.customers_firstname like '%NAME%' at line 3 select count(*) as total from customers c, address_book a, sources s, customers_info i where s.sources_id = c.entry_source_id and i.customers_info_id = c.customers_id and c.customers_id = a.customers_id and c.customers_default_address_id = a. address_book_id where c.customers_lastname like '%NAME%' or c.customers_firstname like '%NAME%' or c.customers_email_address like '%NAME%' [TEP STOP] where NAME = the name searched for. That error shouldn't be related to RCS, because you can't search for a customer in it. Sounds like you are getting this error in another part of OSC like the Customer Admin. If so this can't be related to RCS unless during the install you mistakely changed something dealing with the customer admin. Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.