How do I use phpMyAdmin to check a live database?

[milauskas]

This is a follow up to an eariler post about no cc info populating the order page (with the exception of the cc number).

 

I want to find some way to see if the type, owner and expiration date are stored in the database. I'm assuming I can do this with phpMyAdmin, but I've only used it on my local machine for local databases. Can anyone guide me in using it to view the database that's associated with a live site?

 

Forgive my inexperience, but I need to find some way, at least in the interim, to get this info. Thanks!

 

MM

[Jack_mcs]

You need to login to phpmyadmin. How you do that will vary with your hosts control panel. Once logged in, just click on the orders table and find the order you are wondering about.

 

Jack

[milauskas]

Thanks, Jack. Your reply did help. I was able to access phpMyAdmin through the host's control panel. I appreciate it. Now, hoever, it's confirmed that the info I'm looking for is not being stored in the database.

 

I need the credit card type, owner and expiration date to show up but they're not.

 

Would you (or anyone else who reads this) know what I can possibly do? Without this info my client can process credit card orders. I'm at a loss, that's why I'm here on the forums.

 

Any insight? Thanks!

[Jack_mcs]

Assuming you are using the cc module, you probably need to install the CVV contribution.

 

Jack

[milauskas]

Hi Jack,

 

Well, I've installed the CVV contrib, but that hasn't solved the problem. Although I've now got the CVV field showing up, that too is blank on the order form.

 

Still at a loss.

 

Mike