MS2.2 Delete Customers from Admin

[Overdog]

Hello all,

 

Yes I have searched the forums and sent email to a few folks about my issue and I still have not found a solution .

 

In simple terms I cannot delete customers from within the admin section of MS2.2

Yes I click delete the store asks are you sure and I hit delete agian and customer is still there . Yes I can delete from Myphpadmin no prob . Yes I have a few mods installed .

 

osCAffiliate v2.02.zip

allow_guest_reviews_v2.01-MS2.zip

Down for Maintenance v1.1b.zip

credit_voucher_5-06-01.zip

randomimages.rtf.zip

define_mainpage_v1.3.3_MS2.zip

Information Pages Unlimited v1.1g.zip

paypalipn_v0981_for_milestone_2.zip

 

 

I have a MS1 site runing in production and no problems with deleting cutomers in the admin section ... any help with the delete customers is VERY VERY WELCOME

[eMark]

I also have this same problem.

 

No errors or anything, just click "confirm" button and it returns to the main Customer screen and the customer is still there.

 

Any ideas?

[eMark]

I have narrowed it down to the cID value not get passed to the page where you confirm the deletion of the record.

 

It is present in the address bar when you get to the confirm delete page.

 

/admin/customers.php?selected_box=customers&page=1&cID=1&action=confirm

 

But when you do a view source on the confirm delete page, the cID value is missing.

 

<form name="customer" action="xxxxxx/admin/customers.php?page=1&cID=&action=deleteconfirm" method="post">

 

Any ideas?

[zudan]

Hi,

this is completely outdated, but your message put me on track -

Had exactly the same behavior, so realised that after having installed another Mod(Members Discount 2.2)

the c.customers_id field was not selected (anymore ?) - I've seen in other mods too that this field is not selected but if I just add it to the sql statement ... bingo - all works again

My understanding is too basic as to the validity of selecting this field or not, but in my understanding it should be there and was there originally - so this leaves me a bit puzzled versus the other mods installations i've seen , but anyway I don't think there's any problem with it.

 

 

So in the delete section (case 'deleteconfirm':)

 

so it now looks like:

 

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'] . "'");

 

 

Best wishes

 

 

 

I have narrowed it down to the cID value not get passed to the page where you confirm the deletion of the record.

 

It is present in the address bar when you get to the confirm delete page.

 

/admin/customers.php?selected_box=customers&page=1&cID=1&action=confirm

 

But when you do a view source on the confirm delete page, the cID value is missing.

 

<form name="customer" action="xxxxxx/admin/customers.php?page=1&cID=&action=deleteconfirm" method="post">

 

Any ideas?