Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1054 - Unknown column 'c.customers_company' in 'where clause'


robcn

Recommended Posts

When I try to search a customer at admin/customers.php I get the following error

 

1054 - Unknown column 'c.customers_company' in 'where clause'

 

select count(*) as total from customers c left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id where c.customers_lastname like '%John%' or c.customers_firstname like '%John%' or c.customers_company like '%John%'

 

I use MySQL 5.

Rest is working great.

 

Also is there any contrib on adding a search box at admin/orders.php (search by customer's name or company)?

 

I have gone thru hundreds of topics in this forum, but nothing on the customers' search problems, most of them are related with product bugs.

Can anyone help?

 

Thanks

-Rob

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...