Error in Admin - PayPal IPN page - zen_orders_id

I'm recieving an error in the admin customers module for PayPal IPN and Orders

Here's what PayPal says at the top of the page:

1054 Unknown column 'p.zen_order_id' in 'on clause'
in:
[select count(*) as total from zen_paypal as p left join zen_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.

It looks like a database issue but I'm not sure.

Here's what the Orders page says:

LEGEND: Billing and Shipping does not match Billing and Shipping does not match

I haven't a clue on either issue.

Any help would be appreciated.

Mike

jestcoun:

I'm recieving an error in the admin customers module for PayPal IPN and Orders

Here's what PayPal says at the top of the page:

1054 Unknown column 'p.zen_order_id' in 'on clause'
in:
[select count(*) as total from zen_paypal as p left join zen_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.

It looks like a database issue but I'm not sure.
What version of Zen Cart?
What version(s) have you upgraded from?
What addons/contributions do you have installed?

jestcoun:

Here's what the Orders page says:

LEGEND: Billing and Shipping does not match Billing and Shipping does not match

I haven't a clue on either issue.A Legend is something explaining what symbols mean. Isn't there a red dot next to that?
I'm not sure why you're calling that an "issue".

I'm running v1.3.7 with Hostmonster and I'm currently testing it in Linux/Ubuntu/Firefox and Windows XP.

I have the same problem as http://www.zen-cart.com/forum/showthread.php?t=84469 ...with a few more details.

I ran test orders using gift certificates and the order process works okay through giving me the download option for my mp3.

However, if I chose not to download and go to my account area to try and download, Zencart is not showing a download option.

In addition, my Admin/Customers Orders shows no orders as processed and the legend displays a red dot with a message at the top of the page that says:

LEGEND: Billing and Shipping does not match Billing and Shipping does not match

I checked my database for order records and none exist.

Admin/Customers/my test profile (me)/Orders icon takes me back to the same page with the same results...no orders.

Admin/Reports/Customers Order Total/my test profile/Orders icon takes me back to the same page with the same results...no orders.

Admin/Customers/Paypal IPN has an error at the top of the page that says:

1054 Unknown column 'p.zen_order_id' in 'on clause'
in:
[select count(*) as total from zen_paypal as p left join zen_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 don't have a clue where to start to fix this one....help appreciated!

Mike

Okay...I'll take a DUH on that one. All I saw was the red dot and warning bells were going off. I didn't comprehend LEGEND...

I've been steady at work on this site, in every spare minute away from my job, for 4 weeks....give me a break.

Bottom line...my orders are not showing up and I do have the error messages on the admin paypal link.

Still need help...

Thanks for setting me straight on that one.

More info.

Add-ons: phpbb, calendar, and guestbook are all linked from my ezpage menu bar but not in the directory of zencart.

Upgrades.: 1.3.7 was the original version installed. I backed it up (along with DB) and tried upgrading to 1.3.8. That didn't work out because hostmonster doesn't have php5 on the servers for me to use. So I deleted 1.3.8 and db then restored my original backed up version to the servers. I've just finished setting up my cutstom template in 1.3.7 in order to smooth the transition in to 1.3.8 but I want to make sure there are no issues in 1.3.7 before converting over to 1.3.8 or 8a.

Thanks

Mike

jestcoun:

That didn't work out because hostmonster doesn't have php5 on the servers for me to use.Zen Cart 1.3.8 doesn't "require" PHP 5.
But v1.4.0 will ...

jestcoun:

I'm recieving an error in the admin customers module for PayPal IPN and Orders

Here's what PayPal says at the top of the page:

1054 Unknown column 'p.zen_order_id' in 'on clause'

jestcoun:

So I deleted 1.3.8 and db then restored my original backed up version to the servers.
When you ran v1.3.8 with any PayPal module enabled, it renamed the "zen_orders_id" field in the "paypal" table to "orders_id".
Thus, once the change was made, that database was no longer compatible with v1.3.7.1 or earlier code.

So, if you're getting that error, you're using a database that has been touched by the v1.3.8 PayPal modules.

Thus, that either means you've not properly restored your old database when reverting to the prior version, or you've got your configure.php files pointed to the wrong database.

If you must keep the current database, alter the paypal table and rename the orders_id field to zen_orders_id.

However, downgrading is not a recommended procedure.

It's also sending duplicate gift certificates out...

The touched thing could have happened...give a few days to try and upgrade to 1.3.8 to see what happens.

Thanks.

Okay...upgrade is complete but I have more problems now than I started with.

The PayPal IPN error in admin is gone but orders still are not showing up in admin or user area of zencart. The only way to get to an order to download it after purchase is if you go to my email and click the link provided to view the order.

Also, when I click on My Accont and show orders as a user, all I get is 4-3-2-1 on the orders page an no info about orders show up???

Thanks for your help!

Mike

I've had enough...remove my site from the showcase and delete all my threads.

I have too many problems with your software...I'll stick to staight html.