Guest Posted August 11, 2010 Posted August 11, 2010 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
Guest Posted August 11, 2010 Posted August 11, 2010 John, Did you run the SQL included with the contribution? Chris
Guest Posted August 11, 2010 Posted August 11, 2010 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
vituskung Posted August 13, 2010 Posted August 13, 2010 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");
Recommended Posts
Archived
This topic is now archived and is closed to further replies.