Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

How do I fix this


Guest

Recommended Posts

Posted

Hi

 

I have just added Member Approval addon. Alls working ok except for the following.

/store/admin/customers.php

 

Can anyone throw any light on how I correct this.

 

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 = '1'

 

[TEP STOP]

 

Many thanks

 

Grandpa

Posted

John,

 

Did you run the SQL included with the contribution?

 

 

Chris

Posted

John,

 

Did you run the SQL included with the contribution?

 

 

Chris

Hi Chris

 

Yes I did. Tried again in SQL, customers and was "told" it was duplicate.

 

ALTER TABLE `customers` ADD `member_level` INT(5) DEFAULT '0' NOT NULL;

 

Cheers

 

John

Posted

I got a problem with this addon too. In the installation instruction, I'm not sure which file it refers to as there is no

admin/includes/modules/index/customers.php:

 

#### [ OPEN ] ##################################################################

 

admin/includes/modules/index/customers.php

 

##################################################################

 

 

## Find [line 20] ################################

 

$customers_query = tep_db_query("select c.customers_id, c.customers_lastname, c.customers_firstname,

 

ci.customers_info_date_account_created from " . TABLE_CUSTOMERS . " c, " . TABLE_CUSTOMERS_INFO . "

 

ci where c.customers_id = ci.customers_info_id order by ci.customers_info_date_account_created desc limit 6");

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...