Orders don't show up in Admin/User panel

Hey

So here's the problem, I've already done a clean install and didn't help. I hope somebody here would be able to help out.

No orders show up in admin or user panel after doing a successful purchase! No history of any orders whatsoever!
The odd thing is that they do appear in my databases and I can see them with phpmyadmin.

I did a lot googling and searching but found nothing that could help me, some people had similar issues and the suggestions was to check if I have "Order statuses" Which I do have (like pending, completed... blah blah).
I tried using other purchase methods, tried different usernames different products...
I even changed hosts to see if it'll help (Both linux and my current host was recommended for Opencart), nothing works.

So I'm basically stumped, dunno what to do.
Any ideas?

EDIT: Okay so I found my orders when I filtered Orders list by "Missing Orders" ! Why are they Missing orders and not pending? is this also why there are no order history in user's panel too?

up...

Is your payment method properly set up?

rph wrote:Is your payment method properly set up?

Double checked, doesn't seem to be anything wrong with the set up... what should I be looking for exactly?
I tried both payment by check and manual bank transfer.

Should be fine if you're just using default payment methods. Are you sure you're actually completing the order? You get a confirmation screen and email and your shopping cart empties out?

rph wrote:Should be fine if you're just using default payment methods. Are you sure you're actually completing the order? You get a confirmation screen and email and your shopping cart empties out?

Yes, the order is completed and I get the confirmation screen and the email. I'm pretty sure the order is completed because I can see it when I filter "Missing Orders" in admin panel and it shows up. then I click on view the order and go to the Order History tab and click on Add History, and then the order shows up in both admin and user panel (under Pending status)
I uploaded two screen shots.

And the order numbers match from the confirmation email?

rph wrote:And the order numbers match from the confirmation email?

Actually I don't get a confirmation email up until I add the Order History and tick the Notify Customer checkbox. after I get the email the order numbers do match, they were both 30.

Edit: I'm using version 1.5.2.1

Up...

It sounds like the orders aren't being completed. Did you try logging in with the account and seeing if the items are still in the cart?

rph wrote:It sounds like the orders aren't being completed. Did you try logging in with the account and seeing if the items are still in the cart?

Yep, I just tried that too, the cart is empty and I thought maybe the problem was with the users so I tried making a purchase as a guest and the same thing...
And then I thought maybe there's something wrong with the custom template that I'm using so I switched to the default template and didn't make any difference.

This is starting to get annoying, dead ends...!

Check what status new orders are being assigned in your store settings. Also check your database for what order_status_id is being assigned on a new order.

rph wrote:Check what status new orders are being assigned in your store settings. Also check your database for what order_status_id is being assigned on a new order.

I checked the store settings, New orders are being assigned as Pending.

and I checked the database, there isn't any table called Order_status_id ! That's weird... But I found a column named "Order_status_id" in a table called "order" (is this what you meant?) I had two orders there, one of them is 15 the other one is 0.

It's a column in the order_status table.

rph wrote:It's a column in the order_status table.

Well, all of the order status are there, including Pending, which is number 1:

The idea was to check that your order_status table was lining up correctly. It is so this is likely an issue with the confirmation function not being called. Check your error log, check your VQMod error log, disable any third-party extensions, and try placing an order with a different payment method like COD.

rph wrote:The idea was to check that your order_status table was lining up correctly. It is so this is likely an issue with the confirmation function not being called. Check your error log, check your VQMod error log, disable any third-party extensions, and try placing an order with a different payment method like COD.

You're right, the problem is definitely from the function not being called back. I checked the error logs, they were empty except for some old errors that has nothing to do with this problem. I disabled the modules and VQmods but it didn't make any difference!
What I did notice was that, this time I chose the products, entered names, addresses etc... but I didn't click on Confirm Order and closed the page. The unfinished order appeared as missing order. Which means that there's definitely something wrong with the call back function!

WhiteRenard wrote:The unfinished order appeared as missing order. Which means that there's definitely something wrong with the call back function!

No, that's the proper default behavior. If you don't finalize the order then it's not an order. That's why I asked you if you completed the order. It's entirely possible customers are going into the checkout to get info like shipping cost then choosing to abandon the order.

rph wrote:

WhiteRenard wrote:The unfinished order appeared as missing order. Which means that there's definitely something wrong with the call back function!

No, that's the proper default behavior. If you don't finalize the order then it's not an order. That's why I asked you if you completed the order. It's entirely possible customers are going into the checkout to get info like shipping cost then choosing to abandon the order.

Okay... then what should we do?

Up...