Credit card module problems

[autonomedia]

Hi,

I recently upgraded to 1.3.8a, and installed a new online cert running with a new host. Orders are coming in fine, but cannot manually process credit card orders (PayPal is working fine).

I get the following message in my order emails:

WARNING: You have enabled the CC payment module but have not properly configured it to send CC information to you by email. As a result, you will not be able to process the CC number for orders placed using this method. Go to Admin->Modules->Payment->CC->Edit and set the preferred email address for sending CC information.

But when I go to that spot, I see this:

Payment Modules 1054 Unknown column 'cc_expire' in 'linkpoint_api'
in:
[ALTER TABLE linkpoint_api ADD ordertype varchar(8) NOT NULL default '' after cc_expire]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

My credit card line is set for offline processing, but when I click that link, nothing happens.

Thanks for any help! Jim

[DrByte]

It's finding that your Linkpoint module is out-of-date and trying to update it.
If you're not really using the Linkpoint module, select it and click Remove to stop it from producing those errors.

[autonomedia]

There is no Linkpoint module available. This is my entire screen, below. I can't click on any of these and get any response. ( I had to eliminate some red dots and ...) Jim

1054 Unknown column 'cc_expire' in 'linkpoint_api'
in:
[ALTER TABLE linkpoint_api ADD ordertype varchar(8) NOT NULL default '' after cc_expire]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Modules Sort Order Orders Status Action
Authorize.net (SIM) authorizenet
Authorize.net (AIM) authorizenet_aim
Authorize.net - eCheck authorizenet_echeck
Credit Card - Offline Processing cc 0 default
Cash on Delivery cod
The Zen Cart FREE CHARGE CARD freecharger

[DrByte]

If you go to Admin->Tools->Server Information, can you copy and paste the "Zen Cart Version" information (and upgrade history details) from the center of that screen?

[autonomedia]

Database Patch Level: 1.3.8

v1.3.8 [2008-04-13 22:25:28] (Version Update 1.3.7->1.3.8)
v1.3.7 [2008-04-13 22:24:14] (Version Update 1.3.6->1.3.7)
v1.3.6 [2008-04-13 22:23:56] (Version Update 1.3.5->1.3.6)
v1.3.5 [2008-04-13 22:23:14] (Version Update 1.3.0.2->1.3.5)
v1.3.0.2 [2008-04-13 22:22:46] (Version Update 1.3.0.1->1.3.0.2)
v1.3.0.1 [2008-04-13 22:21:00] (Version Update 1.3.0->1.3.0.1)
v1.3.0 [2008-04-13 22:19:58] (Version Update 1.2.7->1.3.0)
v1.2.7 [2008-04-13 22:18:59] (Version Update 1.2.6->1.2.7)
v1.2.6 [2008-04-13 22:18:45] (Version Update 1.2.5->1.2.6)
v1.2.5 [2005-07-15 00:39:49] (Fresh Installation)

If you need more than this, please let me know. Thanks, Jim

[DrByte]

I recently upgraded to 1.3.8a,

Database Patch Level: 1.3.8

v1.3.8 [2008-04-13 22:25:28] (Version Update 1.3.7->1.3.8)
v1.3.7 [2008-04-13 22:24:14] (Version Update 1.3.6->1.3.7)
v1.3.6 [2008-04-13 22:23:56] (Version Update 1.3.5->1.3.6)
v1.3.5 [2008-04-13 22:23:14] (Version Update 1.3.0.2->1.3.5)
v1.3.0.2 [2008-04-13 22:22:46] (Version Update 1.3.0.1->1.3.0.2)
v1.3.0.1 [2008-04-13 22:21:00] (Version Update 1.3.0->1.3.0.1)
v1.3.0 [2008-04-13 22:19:58] (Version Update 1.2.7->1.3.0)
v1.2.7 [2008-04-13 22:18:59] (Version Update 1.2.6->1.2.7)
v1.2.6 [2008-04-13 22:18:45] (Version Update 1.2.5->1.2.6)
v1.2.5 [2005-07-15 00:39:49] (Fresh Installation)

I'm confused. In your first post you said "I recently upgraded to 1.3.8", but your upgrade history shows that you upgraded from 1.2.5 to 1.3.8 back on April 13 2008. Today is December 12 2008. If your definition of "recent" is "sometime in the last year, then I accept your statement. But ... one would think that you would have reported problems about payment modules a lot sooner than 8 months later ...

Or, am I missing something here?

[autonomedia]

Well, ok, not all that recent, but since we did not manage to get the SSL cert in place until late last month, it's only been a couple of weeks that we recognized this problem. Is it possible to simply deactivate the credit card line and ask all buyers to go through PayPal?

Otherwise, I just downloaded the .pem file from YourPay (now First Data), which might solve the credit card problem, if I can figure out how to put that up and in the right place.

Jim

[autonomedia]

Also, I just don't get any edit options in the right-hand column for any of the entries in my Payment modules. I checked under the Admin for the types of credit cards to be accepted. They are set correctly, and are all editable. Thanks, Jim

[autonomedia]

Furthermore, I have a new .pem file downloaded from YourPay (now called First Data). Should this be uploaded to our server? Jim

[DrByte]

So, you "are" wanting to use Linkpoint?

You'll need to do two things:
1) Go into phpMyAdmin and "drop" your linkpoint_api table. That will lose any data that's in it, but will prepare it for the payment module to set it up for you automatically.
2) Set up the module afresh following these instructions: https://www.zen-cart.com/tutorials/i...hp?article=298