Jump to content

Blanking out Credit Card Issue Number

Recommended Posts

Hi. I migrated over from WhoisCart to WHMCS and love it. When I migrated, I typed in all my customer's credit card numbers, but I missunderstood the meaning of 'card issue number' and used that field for the wrong purpose. I want to blank them all out now, since we don't use that with our processor. I was going to use a MySQL Query, but since that's a 'blob' field, I'm confused on what to do.


If someone (MATT??) or someone could help with the proper MySQL syntax to erase/blank out the tblclients.issuenumber field, I would really appreciate it. :)

Link to comment
Share on other sites

Hi JasonO, thanx but no, this doesn't do what I need. :) I'm not asking how to remove the display from the templates (I've already done that using the templates supplied in that thread). What I'm talking about is actually removing a Card Issue Numbers from client profiles - that is to say, blanking out all the issuenumber field from the tblclients table.

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.

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