Blanking out Credit Card Issue Number

[9DollarDomains]

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.

[JasonO]

http://forum.whmcs.com/showthread.php?t=8553

 

That any help?

[9DollarDomains]

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.

[Matt]

The following query would clear all issue numbers for all clients:

 

UPDATE tblclients SET issuenumber='';

 

Matt

[9DollarDomains]

OK, thanx. I thought that would work, but the 'blob' type threw me. I didn't want to try this and find out that it messed up the structure. Thanx again for the great support.

edited... I just ran this query and it did exactly what it was supposed to... thanx.