Cc Numbers Not Stored In Orders Table

[jderoo]

The organization I am with has been handling CC orders manually for years and they do not want to switch to an automated gateway. When our OSCommerce was setup, some tests were run and it appeared that the CC information was stored in the database and reported when the office manager looked at the orders page. However, now the CC information does not appear in the report for new orders (it is still there for one of our early test orders). I have dumped the MySQL "orders" table and confirmed the data is not there, either. In one of the posts here I noticed someone mentioning that they had enabled the "send the middle digits of the CC number" feature and it seemed to work for him/her, so I tried it. Now it does seem to save the outer digits in the database and email the inner ones, but the expiration date is not stored or emailed.

 

Any Suggestions?

[jderoo]

I have been trying to figure this out for several days and my PHP/MySQL-fu isn't good enough. I would greatly appreciate it if someone could at least point me in the right general direction.

 

Thanks!

[Silverado05]

What payment module are you using to achieve this? Sounds like you might just need to remove it and install it again.

 

Also have you installed any new contributions like fancier invoice and packaging?

[jderoo]

What payment module are you using to achieve this? Sounds like you might just need to remove it and install it again.

 

Just the "Credit Card Module". I inherited the setup, so I'm not sure if it is plain vanilla or has been modified.

 

As a temporary fix, I am trying to add the expiration date to the email with the middle digits. It seems like it should work, but it seems like a hack.

 

Also have you installed any new contributions like fancier invoice and packaging?

 

The store is based in Florida, so we had to apply the FL County tax contribution modification, which is based on the NY County/City tax mod. I've tried backing that out, but then the whole thing hangs with php errors. I got past a couple of them by not removing the new table from the includes/database_tables.php when I revert, but then I get a blank screen later when I try to checkout.

 

Thanks!

[Silverado05]

So you are trying to add the entire cc number and expiration date in the email? If I am understanding that correctly that is a no no by the credit card companies.

 

You are running the base module and by design nothing should be able to be stored into the DB by default. You can try going into your admin>modules>payment and trying remove the credit card module and install it again.

[jderoo]

So you are trying to add the entire cc number and expiration date in the email? If I am understanding that correctly that is a no no by the credit card companies.

 

No - the module breaks up the CC number and stores some of the digits in the DB and sends the rest in an email. The problem we were having is that it didn't store the expiration date anywhere. And, I got some information from one of the other people who have been working on this site. He said that at first, all of the information was being stored in the db, but then he enable the send-the-middle-digits feature, at which point we lost storage of the expiration date, and, even when we turn the send-the-middle-digits-off now it still doesn't save the information.

 

So what I did was add the expiration date to the middle-digits email in cc.php, and that seems to be sufficient, at least for now.

 

You are running the base module and by design nothing should be able to be stored into the DB by default. You can try going into your admin>modules>payment and trying remove the credit card module and install it again.

 

I will do that if the change I made above does not work.

 

Thank you very much for taking the time to answer!

[Silverado05]

Oh ok gotcha. Well really the only thing I can suggest is try to uninstall the contribution or module and then reinstall it.