Can't delete customers

[roughrider]

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?

[Guest]

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.

[Guest]

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.

[♥Monika in Germany]

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

[Guest]

Ok thank you!!

I did find the query in my customer.php file

but when I changed it it gave me a database error.

[Guest]

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'

[Guest]

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!

[shoppy]

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