Results 1 to 6 of 6
  1. #1
    Join Date
    May 2011
    Location
    NSW
    Posts
    169
    Plugin Contributions
    0

    Default can't delete customer

    I was testing the forms etc and set up an account then I deleted it from the database table but it was still showing in admin so I went ahead and deleted from within admin/customers and it won't delete- just wondering why not? curiosity..

  2. #2
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: can't delete customer

    I was testing the forms etc and set up an account then I deleted it from the database table but it was still showing in admin so I went ahead and deleted from within admin/customers and it won't delete- just wondering why not?
    There are a couple of indexed tables where an account is referenced

    You only hit/deleted ONE directly in the DB - - bad move

    Now the records are incomplete for a delete from the admin

    Did you backup BEFORE messing directly with the DB??

    Restore.
    And then delete via the admin only
    Zen-Venom Get Bitten

  3. #3
    Join Date
    Apr 2006
    Location
    London, UK
    Posts
    10,569
    Plugin Contributions
    25

    Default Re: can't delete customer

    To take it out cleanly you would have to remove the records associated with it from the customers, customers_info and address_book tables. Otherwise you leave bits behind and risk (and this sounds like what's happening) the equivalent Zen Cart queries being unable to link the tables together properly and failing.
    Kuroi Web Design and Development | Twitter

    (Questions answered in the forum only - so that any forum member can benefit - not by personal message)

  4. #4
    Join Date
    May 2011
    Location
    NSW
    Posts
    169
    Plugin Contributions
    0

    Default Re: can't delete customer

    I knew what I did might have implications.

    Thanks kobra and koroi!

  5. #5
    Join Date
    Mar 2008
    Posts
    8
    Plugin Contributions
    0

    Default Re: can't delete customer

    Quote Originally Posted by kuroi View Post
    To take it out cleanly you would have to remove the records associated with it from the customers, customers_info and address_book tables. Otherwise you leave bits behind and risk (and this sounds like what's happening) the equivalent Zen Cart queries being unable to link the tables together properly and failing.
    Where do I find these tables?

    I had a customer who was having trouble logging in, and as they hadn't purchased anything, I figured the easiest solution was to delete the account (from my admin panel). And they could create a new one. They say they have tried but it comes back that the email address is already in use.

    So I guess I need to do something with these tables to make sure nothing is left blocking them from creating their account again.

    Hayley
    Hayely's Creations

  6. #6
    Join Date
    Apr 2006
    Location
    London, UK
    Posts
    10,569
    Plugin Contributions
    25

    Default Re: can't delete customer

    From what you're saying, it sounds as though the customers may not be deleting cleanly. That could indicate data corruption, so needs top be investigated and resolved before you start deleting the evidence.

    To answer your question, the quote was referring to database tables, but it would be dangerous to mess with them unless you know what you're doing. And even then make sure you back up the database first.
    Kuroi Web Design and Development | Twitter

    (Questions answered in the forum only - so that any forum member can benefit - not by personal message)

 

 

Similar Threads

  1. Can't Delete customer review
    By kitcorsa in forum General Questions
    Replies: 7
    Last Post: 27 May 2012, 01:44 PM
  2. Can't delete customer
    By Rob905 in forum Templates, Stylesheets, Page Layout
    Replies: 2
    Last Post: 4 Jul 2009, 04:29 AM
  3. Customer country, can't delete it
    By esl25 in forum Templates, Stylesheets, Page Layout
    Replies: 0
    Last Post: 10 Sep 2008, 03:56 AM
  4. Can i delete Gender in Customer Details !
    By Hung_war3 in forum General Questions
    Replies: 7
    Last Post: 6 Mar 2008, 12:14 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR