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
    Posts
    26,425
    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
    Get Your Business Found

  3. #3
    Join Date
    Apr 2006
    Location
    London, UK
    Posts
    10,655
    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.
    See and test drive Zen Cart's free templates at zencarttemplates.info

    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
    9
    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,655
    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.
    See and test drive Zen Cart's free templates at zencarttemplates.info

    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
    By Rob905 in forum Templates, Stylesheets, Page Layout
    Replies: 2
    Last Post: 4 Jul 2009, 04:29 AM
  2. Customer orders - Delete
    By jmknash in forum General Questions
    Replies: 2
    Last Post: 8 May 2008, 05:16 PM
  3. how do I delete a customer????
    By keylesslocks in forum Managing Customers and Orders
    Replies: 3
    Last Post: 20 Dec 2007, 10:44 PM
  4. [Done 2.0.0] Delete Customer Bug
    By Alex Clarke in forum Bug Reports
    Replies: 2
    Last Post: 30 Oct 2007, 11:16 PM
  5. How to delete a customer? 1.3.1
    By marcelox8 in forum Basic Configuration
    Replies: 2
    Last Post: 1 Jun 2006, 05:17 PM

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
  •