Strange error message re. PayPal Notifications

[cpaulson]

That is what I thought and checked many stylesheets, but there are probably more I missed. I'll keep searching for stylesheets to compare.
Thanks.

[RJChief]

I am getting a similar error as the first post of this thread... My problem is slightly different. When ordered through paypal, the order comes into ZC and I can view it as a new order (able to see what was purchased and all) but thats all. I am getting the 1054 error in the "where clause" and removed the ZEN_ORDER_ID and replaced it with ORDER_ID.

To the best of my knowledge, this should have been the only upgrade necessary... any advice?

[RJChief]

I take my problem back... I found my corrupt coding

[paperthreads]

I know this is an old thread, but I"m getting the same error, I can see the new order just fine, but when I click on it, to see the detail of the order, I get this error:

1054 Unknown column 'zen_order_id' in 'where clause'
in:
[select * from paypal where zen_order_id = 21856 AND parent_txn_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.

If I go to the Customers>Paypal IPN i get the following error:

1054 Unknown column 'p.zen_order_id' in 'on clause'
in:
[select count(*) as total from paypal as p left join orders 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 haven't done ANYTHING to my database, no upgrades, NOTHING since November 2010. Everything has been working just fine until today, when this suddenly cropped up.

My version is listed as:
Zen Cart 1.3.7.1Patch: 1::

Database Patch Level: 1.3.7

I'm not sure how to resolve this, as this has just randomly happened.....

[DrByte]

I know this is an old thread, but I"m getting the same error, I can see the new order just fine, but when I click on it, to see the detail of the order, I get this error:

1054 Unknown column 'zen_order_id' in 'where clause'
in:
[select * from paypal where zen_order_id = 21856 AND parent_txn_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.

If I go to the Customers>Paypal IPN i get the following error:

1054 Unknown column 'p.zen_order_id' in 'on clause'
in:
[select count(*) as total from paypal as p left join orders 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 haven't done ANYTHING to my database, no upgrades, NOTHING since November 2010. Everything has been working just fine until today, when this suddenly cropped up.

My version is listed as:
Zen Cart 1.3.7.1Patch: 1::

Database Patch Level: 1.3.7

I'm not sure how to resolve this, as this has just randomly happened.....

Very odd.
There are only a few ways that would happen:
a) you're using a screen that you don't normally use (ie: maybe you normally use the Super Orders addon but this time you're using a different one, and only now seeing the error)
b) someone has changed files on your server
c) someone has changed the database structure on your server, perhaps via an attempted database upgrade gone bad

http://www.zen-cart.com/wiki/index.p...ing_From_Hacks
http://www.zen-cart.com/wiki/index.p...Obscure_Issues

I hope you keep regular reliable backups.

[paperthreads]

Dr Byte, thanks for the reply,

In answer to your reply,

1. I'm not using a different screen than what I normally use. I'm on order number 21862, that is starting with order #1 back in 2006. I would think that after processing 21000+ orders in the past 5 years, I would definitely know what screens I use! I'm the only one that processes orders, as it's a sole proprietorship, and i haven't gone to any new screens!

2. I haven't updated ANYTHING since November 2010. That includes making any changes on my server. I have a dedicated server, that ONLY I can access. I had problems with someone hacking my site on a shared dedicated server about 2 years ago, which is when I moved to a dedicated server. I am the only one with server access, and I made no updates, changes, etc on this server since I did my upgrades back in November 2010.

3. Again, I'm the only user on my server, and I haven't done ANY changes to the database either. I haven't even logged into the database since November 2010. Haven't had a need, because I do everything through the admin screen, and my database has auto back ups set for daily, so no need to even go in and do backups.

This is why i'm puzzled that this has happened just out of the blue. I am going to have to pay for someone to do an upgrade and fix this problem, because I don't have the time to do it myself right now. We have a huge sales event coming up this weekend that I'm preparing for, and when we do these events, I expect to have more than 750 orders over the weekend...and I can't access or do ANYTHING to orders that were paid with paypal at this time because of this error.

[DrByte]

I believe that *you* are the only person that YOU know has access to your server.
But, you're using an old version of ZC that has widely-published vulnerabilities that hackers like to exploit. So, it might be that someone else *does* have access to your site because you've been hacked.
http://www.zen-cart.com/wiki/index.p...ing_From_Hacks

I hope you have copies on your home computer of your database backups, as well as all the PHP/CSS/JS/etc files from your store (via FTP).