Jump to content

How to clear all credit card and token data within WHMCS database


Recommended Posts

I want to delete all credit card data and any remote token data stored in WHMCS.

So I tried using the 'delete bank' and 'delete credit card' buttons under settings, general, security. This didn't seem to do anything as I could still see some clients have data in the credit card fields within tblclients, i can also see entries in the deprecated table tblcreditcards, and there is also data in tblpaymentmethods

I used this on tblclients 

UPDATE tblclients
SET cardtype = '', cardlastfour= '', startdate = '', expdate = '', issuenumber = '', gatewayid = '';

and used phpymyadmin to empty tblpaymentmethods and tblcreditcards but in doing so, i noticed that a client had a payment, and that on the transaction list page, the 'payment method' field was showing as blank.

So I restored the DB from the backup I made beforehand, and thought I'd ask the question here rather than trying again and breaking things.

Thanks! 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated