Strange error message re. PayPal Notifications

[cpaulson]

Prior to upgrading from 1.3.7 to 1.3.8a, I had an error on my site where order confirmations would not be sent to me or to the customer. I did get a payment receipt from Pay Pal, but I had no idea what the customer had bought. I had to write each person to ask.

Now I have upgraded and have not had done any test orders yet, but, while checking things out, I found the following error message. It appears in the admin area, via the pulldown for Customers>PayPal IPN.

1054 Unknown column 'p.zen_order_id' in 'on clause'
in:
[select count(*) as total from strpaypal as p left join strorders as o on o.orders_id = p.zen_order_id]
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.

I don't know where it originated. Can anyone please help me to find and correct it?

Thanks,
Catherine

[DrByte]

Sounds like you missed upgrading the /admin/paypal.php file, since it's looking for a "zen_order_id" field which was removed as part of the upgrade to v1.3.8. Looks like you're still using the older version of that file.

[cpaulson]

I did that upgrade before upgrading the site. I just now removed and reinstalled both Pay Pal modules again in case I missed one before. The message is still there, though.

Do I need to go to the actual file, /admin/paypal.php and change some code manually?

Catherine

[cpaulson]

Hmm, I just did a search/find for that string of code, using Text Wrangler, but it says it was not found in the document admin/paypal.php

[DrByte]

[B]1054 Unknown column 'p.zen_order_id' in 'on clause'

Getting that error message in conjunction with upgrading to v1.3.8 and with Paypal, is a result of mismatched PHP files, typically resolved by properly upgrading the missed files.

[cpaulson]

Do you know how I can find which file is missed and how to fix them?

[DrByte]

http://winmerge.sf.net
https://www.zen-cart.com/tutorials/i...hp?article=108
http://www.zen-cart.com/wiki/index.p...Obscure_Issues

[cpaulson]

I have Text Wrangler, which is the Mac equivalent of Winmerg. I have read the tutorial, article 108 on upgrading and it got me in all sorts of trouble trying to change files. In the end, I had to start all over.

I don't see how I can compare the files from my old backup to the newly upgraded files since the Pay Pal ones from the old site won't be right for 1.3.8.

I have removed the Pay Pal modules from the admin area and reinstalled them. I thought that would upgrade them.

I will try the debugging utility linked in the other article but I'm always afraid I'll change something I shouldn't. I don't understand php code. Guess I'll have to leave it till morning since it's midnight here and I get up early.

[DrByte]

I don't see how I can compare the files from my old backup to the newly upgraded files since the Pay Pal ones from the old site won't be right for 1.3.8.

You don't need to.

Your problem is that you've supposedly upgraded to v1.3.8, but some of your files aren't properly containing v1.3.8 code.
So, compare your files against clean v1.3.8 files, and reconcile any differences.

[cpaulson]

Thank you, Dr.Byte,
That has gotten rid of the error message.

Your problem is that you've supposedly upgraded to v1.3.8, but some of your files aren't properly containing v1.3.8 code.
So, compare your files against clean v1.3.8 files, and reconcile any differences.

Does that mean I need to compare all the files in my store? I thought the upgrade would have applied any needed changs.

One more question...
Now that I've gone through the upgrade process, I know I am supposed to delete the install folder. But, do I leave the 1.3.8 uploaded folder in my store site or do I delete that, also?

The setup is:
store.stitchinthyme
/_all the folders that make up the site
/zen_cart 1.3.8

Catherine