Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Recommended Posts

Posted

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

Posted

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

Posted

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

Posted

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

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.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...