Hi everyone,

I have read through all the posts on 1054 errors that I felt were relevant and simply couldn't find help for this particular error.

I am currently using Zen Cart version 1.3.8a.

When I visit Admin>Customers>Paypal IPN I get the following error message:
"1054 Unknown column 'p.order_id' in 'on clause'
in:
[select count(*) as total from paypal as p left join orders as o on o.orders_id = p.order_id]"

I am pretty sure this error may be occuring because I use the Canada Post module which was made for an older version of Zen Cart (there seems to be no new release). I fixed a different error I was having (the 1054 error for zen.order_id) with success... but have run into this.

First, does anyone know if there is a newer version of the Canada Post Module? The one I have was made for Zen Cart 1.3.7

Second, does anyone know how I might fix this particular error? Is it simply a matter of renaming one of the columns in my paypal table?

Any help is appreciated! Let me know if I haven't included any pertinent information.
Laura