Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Customer List Improved....HELP PLZ!


Tsuri Japan

Recommended Posts

I thought I'd try to istall this easy contrib but things have went for the worse.......

 

I installed this one:

http://www.oscommerce.com/community/contributions,3463

version 1.4.2 with the bug fix.

 

I made a back up and proceded to install the two simple files along with the images but after I did it I got this error message:

1054 - Unknown column 'c.customers_notes' in 'field list'

 

select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_notes as notes, c.customers_email_address, c.customers_telephone, c.customers_dob, ci.customers_info_date_of_last_logon as last_logon, ci.customers_info_number_of_logons as num_logons, ci.customers_info_date_account_created as date_account_created, a.entry_city as city, a.entry_state as state_alt, z.zone_name as state, ctry.countries_iso_code_2 as country,c.customers_newsletter, a.entry_country_id 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 left join customers_info ci on c.customers_id = ci.customers_info_id left join countries ctry on a.entry_country_id = ctry.countries_id left join zones z on a.entry_zone_id = z.zone_id order by c.customers_lastname ASC, c.customers_firstname ASC limit 0, 9

 

[TEP STOP]

 

I tried to overwrite my back up over the new files but it isn't even working now!!!!! What the hell is going on????

 

Help plz!

 

Nigelman :thumbsup:

Edited by Tsuri Japan
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

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...