PayPal module errors 1.2.7

[estyles]

I run a Zen Cart installation for someone and they are having some issues with the PayPal module. When they view someone's order in the admin panel, it gives this error:

1054 Unknown column 'zen_order_id' in 'where clause'

And does not show any of the order. I did some searching and found a tool on this forum called curltest.php which I tried, and I get this when testing PayPal (with or without SSL):

ACK=Failure&L_ERRORCODE0=81002&L_SHORTMESSAGE0=Unspecified%20Method&L_LONGMESSAG E0=Method%20Specified%20is%20not%20Supported&L_SEVERITYCODE0=ErrorEOF

The PayPal website is useless and doesn't explain that error at all. Can someone please help me out here? What does it mean and how do I fix it?

The Zen Cart installation is v1.2.7 - yes I know, don't bother telling me to upgrade, it's not going to happen (well it is, but I need this fixed now). I just need a fix for this problem with this version!

Thanks :)

[DrByte]

Zen Cart v1.2.7 doesn't have Express Checkout support, but you're quoting what looks like an Express Checkout error.
So, it sounds like you've stuffed in some files from a newer version of Zen Cart. But, that won't work. Either upgrade fully, or remove the Express Checkout option altogether.

[estyles]

Thanks for the reply. Is there a working PayPal module for v1.2.7? If so, where can I download it?

[kobra]

Thanks for the reply. Is there a working PayPal module for v1.2.7?

As part of the distribution - included is PayPal IPN

There is no working PayPal Express option for 1.2.7

[estyles]

Zen Cart v1.2.7 doesn't have Express Checkout support, but you're quoting what looks like an Express Checkout error.
So, it sounds like you've stuffed in some files from a newer version of Zen Cart. But, that won't work. Either upgrade fully, or remove the Express Checkout option altogether.

Wait! Sorry, I just realised that the error you are talking about comes from the curltest.php file that I found on these forums, which I believe does it's tests independant of the ZenCart installation, so the installation of Zen Cart isn't necessarily trying to use PayPal Express (in fact I know it isn't as nothing has been touched with the installation in a long time, this problem started occuring when the installation was moved to a new server).

Is there any more debugging that I can do to my installation to attempt to find out what is wrong?

[kobra]

Is there any more debugging that I can do to my installation to attempt to find out what is wrong?

admin > modules > payment > PayPal IPN - Website Payments Standard > edit

At the bottom you can enable:

Debug Mode
Enable debug logging?
NOTE: This can REALLY clutter your email inbox!
Logging goes to the /includes/modules/payment/paypal/logs folder
Email goes to the store-owner address.

Then process a test order using another PP account different than the one the store uses and it will logg the details or lack there of

[estyles]

There's no debug option listed when I edit the PayPal module - perhaps it was added in a later version?

[kobra]

There's no debug option listed when I edit the PayPal module - perhaps it was added in a later version?

Completely possible as it hase been 3+ years since I have had a 1.2.7 installed and my memory is not that long

this problem started occuring when the installation was moved to a new server

On a off chance - remove/un-install PayPal IPN - Website Payments Standard and then re-install it

I forget the rerason that this sometimes needs to be done when the server has moved but it is a standard solution in many cases

[DrByte]

1054 Unknown column 'zen_order_id' in 'where clause'

This error could be a result of either:
a) the column was renamed
b) the column was deleted
c) the column doesn't exist yet

In v1.3.8 the column was renamed from zen_order_id to order_id. Many people reported that same error message after choosing to install the new files without upgrading their database properly, contrary to upgrade instructions. Whether you've done similarly, I can't tell.

I suppose in v1.2.7 the column "zen_order_id" might not even exist yet. Or maybe it's supposed to but yours was damaged for some reason. I don't remember exactly what it was using back then, and I haven't dug up a copy of the old code to check.

[estyles]

Thanks for your help guys, I got it all sorted eventually.

Someone had tried to update to a newer version and had applied some of the database updates. I removed them and everything is working fine now :)