Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

osCommerce addon


  • Please log in to reply

#1
grandpa

grandpa

    Member

  • Member
  • PipPipPip
  • 265 posts
Hi

I have treid to get an answer to the following problem at the osCommerce forums but with no luck, perhaps someone may be able to offer help.

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
  • 0

Advertisements


#2
Neil Jones

Neil Jones

    Member 5k

  • Member
  • PipPipPipPipPipPipPipPip
  • 8,476 posts
I'm not familiar with the application in question but that message says there's an issue with the database that it uses.

Edited by Neil Jones, 02 September 2010 - 02:30 PM.

  • 0

#3
grandpa

grandpa

    Member

  • Topic Starter
  • Member
  • PipPipPip
  • 265 posts
Hi

Thanks for that. Will try and locate.

Cheers

Grandpa
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP