roughrider Posted May 17, 2006 Share Posted May 17, 2006 Go to customers in admin cp, click on customer, click delete, confirm message.. Are you sure you want to delete this customer? Yes, but customer still shows. Any ideas? Ride It Like You Stole It Link to comment Share on other sites More sharing options...
Guest Posted September 9, 2006 Share Posted September 9, 2006 This is an old thread, but I'm having the exact same problem. Could it be coding somewhere I've flubbed up somehow? Everything else works great! Any help would be appreciated, in the meantime I'll keep searching the forum. Link to comment Share on other sites More sharing options...
Guest Posted September 9, 2006 Share Posted September 9, 2006 OK looking through the forums in this thread http://www.oscommerce.com/forums/index.php?showtopic=69563 They mentioned having installed the Members Discounts Contribution. I did that two days ago, but I don't understand the rest of what was said about how to fix it. Link to comment Share on other sites More sharing options...
♥Monika in Germany Posted September 9, 2006 Share Posted September 9, 2006 you need to change the customers query, as outlined in that other post ... open your file, look for the query that is very similar, and make the change :-) Monika addicted to writing code ... can't get enough of databases either, LOL! my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum Interactive Media Award July 2007 ~ category E-Commerce my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ... Link to comment Share on other sites More sharing options...
Guest Posted September 9, 2006 Share Posted September 9, 2006 Ok thank you!! I did find the query in my customer.php file but when I changed it it gave me a database error. Link to comment Share on other sites More sharing options...
Guest Posted September 9, 2006 Share Posted September 9, 2006 OK in admin/customers.php When I changed the code from this: default: $customers_query = tep_db_query("select 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_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.member_flag, c.customers_default_address_id 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 = '" . $HTTP_GET_VARS['cID'] . "'"); To this: default: $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_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_notes, c.customers_newsletter, c.member_flag, c.customers_default_address_id 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 = '" . $HTTP_GET_VARS['cID'] . "'"); I get this database error when I try to delete a customer 1054 - Unknown column 'c.customers_notes' 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_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_notes, c.customers_newsletter, c.member_flag, c.customers_default_address_id 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 = '10' Link to comment Share on other sites More sharing options...
Guest Posted September 9, 2006 Share Posted September 9, 2006 OH OH OH I fixed it!! YEAH!!! LOL I just removed the part that said c.customers_notes from the code and it works now!! Thanks so much for brainstorming with me! Link to comment Share on other sites More sharing options...
shoppy Posted June 7, 2010 Share Posted June 7, 2010 OH OH OH I fixed it!! YEAH!!! LOL I just removed the part that said c.customers_notes from the code and it works now!! Thanks so much for brainstorming with me! It has been a while but this mod realy helped me! Thanks. John Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.