Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

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


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?




Link to comment
Share on other sites


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

  • Create New...