Orders processing successfully but not showing up in Orders

[hawks67]

Apologies for being quick on the draw...

I posted this last night and then THOUGHT that addressing the IPN setting on PayPal resolved it...I did a test transaction and it did work...but today we're back to SNAFU.

On my site a customer can complete an order all the way through PayPal (my only payment option), and I receive email notification from PayPal of the received payment, but I have no orders showing up on the Admin-Customers-Orders page (and none on the Admin Home page, either). I've tried multiple times with multiple customers, and all the orders go through PayPal to completion, but nothing shows up in Orders. Inventory does appear to increment properly (each order of 1 item reduces the number of those items in stock by 1), but that's it.

I'm running v1.3.5, and have applied all the patches and anti-hacking fixes up to but NOT including v1.3.9h. This was working fine earlier this year (my site is seasonal)...

I noticed that a very similar question was just posted to this forum a couple days ago, but the suggested fixes don't apply to my situation.

Suggestions are very much requested! Thank you!

Gary

[Ajeh]

If you go to phpMyAdmin, and search the orders table, do you see the order in the database?

If you go to phpMyAdmin, and search the orders_total table, do you see the order in the database?

If so, what do you see for the field:
class

for this order?

[hawks67]

OK, now I feel completely stupid. Please know that I only mess with this Zen-Cart for a couple weeks a year, then shut it down...so there is SO much I don't know, starting with phpMyadmin. Where would I access that? I don't see it as an option anywhere on the Admin side...probably not looking in the right place...

Apologies, I know this sounds like a ridiculous question to the veterans and experts...of which I'm neither...

[Ajeh]

phpMyAdmin should be available through the Control Panel of your domain from your hosting provider ...

If you are not sure how to get into this or the Control Panel to reach it, then you will want to contact your hosting provider for you site and ask them for additional help ...

[hawks67]

OK, downloading and installing phpMyAdmin was wrought with problems, so I used MySQL...and found that the orders and orders_total tables are empty. Clearly there is a problem here...

[Ajeh]

If this worked last night ... how is it your orders and orders_total tables are empty now?

I would think you would at least have the records for the ones in the past and the one that worked for you last night ...

Are you sure you are looking at the correct database?

Can you also check the files:
/includes/configure.php
/admin/includes/configure.php

and make sure both are using the same URLs and database information ...

[hawks67]

>If this worked last night ... how is it your orders and orders_total tables are empty now?

I deleted last night's successful test order. Wanted to start fresh, I guess. I only have the one db, so it's not that.

Now here's the weird thing. In the /includes/configure.php file, the HTTPS server is www18.ssldomain, but on my hosting provider's admin page it says it should be www6.ssldomain. And that's what we put into the PayPal IPN field last night, thinking that would solve our problems. Aha, right? But while I was researching this, in just the last five minutes, an order came through...with those two non-matching settings intact...and it showed up on the Admin orders page, the orders table and the orders_total table. Plus, I got the usual email summarizing the order. Everything worked great, but those two ssldomain values are still currently not the same! I can understand how they would need to be the same in order for the process to work properly, and as soon as I saw that they weren't, I though, "yay, we found it!"...but then, within seconds, <ding>, I got an email telling me I had a successfully completed transaction that worked in every way. How can this be? And, moreover, if I've never once edited this HTTPS value in configure.php (never even understood it enough to mess with it) or on my hosting provider's page, how did it change? How did it go from www16 to www6?

My head is starting to explode...this used to work fine exactly the way it is now, with HTTPS values that don't match...apparently, anyways...

[Ajeh]

If your referring to the setting in PayPal ... it isn't "what" the setting is so much as there is a setting ...

The PayPal IPN is sending the setting to PayPal on what to use per transaction, and overrides whatever is actually set ...

[hawks67]

thanks for the input...I ended up trashing the old site and building a new on on a new domain. And THAT one didn't function at all, either. Turns out, in talking with my hosting provider, that it's critical that the server your site is on has current PHP on it.

[Ajeh]

Thanks for the update that the problem was with your server ...