Guest Posted September 1, 2010 Posted September 1, 2010 Hi I have just installed the add on "Prices for Logged in users, and when I go to Delete or Edit a customer, in the customers window, the Orders and Email work fine. I get the following. Is someone able to tell me what I need to do to fix it.Ive tried 3 times installing this and keep getting the same result. 1054 - Unknown column 'a.entry_street_address_2' in 'field list' select c.customers_id, c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_dob, c.customers_email_address, a.entry_company, a.entry_street_address, a.entry_street_address_2, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id, a.entry_country_id, c.customers_telephone, c.customers_fax, c.customers_newsletter, c.customers_default_address_id, c.member_level from customers c left join address_book a on c.customers_default_address_id = a.address_book_id where a.customers_id = c.customers_id and c.customers_id = '2' [TEP STOP] Many thanks Grandpa Quote
Guest Posted September 2, 2010 Posted September 2, 2010 John, I don't believe this error is from the Prices for Logged in Users Contribution. Perhaps you installed another before that one ? I went over the installation instructions of Prices for Logged in Users and could not find any reference to 'a_entry_street_address_2' Chris Quote
Guest Posted September 2, 2010 Posted September 2, 2010 John, I don't believe this error is from the Prices for Logged in Users Contribution. Perhaps you installed another before that one ? I went over the installation instructions of Prices for Logged in Users and could not find any reference to 'a_entry_street_address_2' Chris Hi Chris Is there any way I can try and get rid of 'a_entry_street_address_2' at the moment, this is what has just appeared. I don't have any other addons etc, Just downloaded and added Prices for Logged in users. Many thanks John Quote
Guest Posted September 2, 2010 Posted September 2, 2010 Hi Chris Is there any way I can try and get rid of 'a_entry_street_address_2' at the moment, this is what has just appeared. I don't have any other addons etc, Just downloaded and added Prices for Logged in users. Many thanks John Hi Chris Think Ive found it in admin.includes.languages>English>customers on line 230 $customers_query = tep_db_query("select c.customers_id, c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_dob, c.customers_email_address, a.entry_company, a.entry_street_address,/* a.entry_street_address_2, */a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id, a.entry_country_id, c.customers_telephone, c.customers_fax, c.customers_newsletter, c.customers_default_address_id, c.member_level from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on c.customers_default_address_id = a.address_book_id where a.customers_id = c.customers_id and c.customers_id = '" . (int)$HTTP_GET_VARS['cID'] . "'"); So Ive commented it ou and all seems to work. Would value your comments on this please. Many thanks John Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.