I receive an error when following these steps:
1. Create new customer (via admin)
2. Click on "new order"
3. Error
It works fine when doing it the following way:
1. create new account (via storefront)
2. goto admin -> customers -> customers
3. select customer
4. click "new order"
5. works fine.
Here's the error that displays on screen:
WARNING: An Error occurred, please refresh the page and try again.
Here's the error that displays in the logs:
Code:
PHP Fatal error: 1054:Unknown column 'c.customers_firstname' in 'field list' :: SELECT c.customers_firstname, c.customers_lastname, a.entry_company AS billing_company, a.entry_street_address AS billing_street_address, a.entry_suburb AS billing_suburb, a.entry_postcode AS billing_postcode, a.entry_city AS billing_city, a.entry_state AS billing_state, a.entry_country_id FROM `customers_info` AS c LEFT JOIN `address_book` AS a ON c.customers_default_address_id != a.address_book_id WHERE a.customers_id = c.customers_id AND c.customers_id = '5' in /path/to/store/includes/classes/db/mysql/query_factory.php on line 120
My Server Specs:
MySQL Version: MySQL 5.1.62
PHP Version: 5.3.8
Zen-Cart Version: 1.5.1
Any idea as to why this is happening?
Bookmarks