Missing order details.

[NCGrimbo]

Hi all. I've just got my first store up and running and everything seems to be working and orders get placed and paypal charges the user. The problem is that when I look at the orders page and then double click on an order, I don't get any details on what was ordered. I get the header in the report and then a line where the orders should be that shows "Products Models price" etc. The below that, where I would expect to see the products purchased, there is nothing but the discount and then then total cost of the order. I tried to search the forum but I counldn't find any help.

Can someone point me in the right direction? Here's what it looks like:

[Ajeh]

Could you look at your database tables in phpMyAdmin and see what you have for:
orders
orders_products

In the orders table, you should see 1 record for each order ...

In the orders_products table, you should see 1 record for each Product in the Order ...

[NCGrimbo]

I have 1 record in the orders table. It has the data for the order that was placed. There are no records in the orders_products table. I'm assuming that's why I get no details. Before the order was placed, there were 3 test orders in the system. I deleted the 3 test orders after the first real order was placed. I wonder if there's a bug that may have deleted all the data from orders_products. I'm going to put another test record in the system and see if I can recreate the problem. Looks like I will need to manually add the items that were ordered to the order to make it correct.

[NCGrimbo]

Update: I just added two new orders and both show the products in the invoices and there are records in the orders_products table for the orders. I deleted one order and the other one was OK. The only difference was between the test orders and the real order is that the real order used paypal to make the payment and I've been using "Check/Money Order" for the test orders. Would that make a difference?

[Ajeh]

It is an odd one, but as you cannot reproduce the problem it is difficult to say what might have caused the problem originally ...

You might try making a few test orders just to be sure it doesn't happen again ...

[NCGrimbo]

I was able to reproduce this problem and I found the answer. I was leaving off the PDT Token on the PayPal IPN configuration screen in the admin section of ZenCart. I must have missed that it is required when reading the information about IPN on the forums.

But that raised another error, "1292 Incorrect datetime value". I searched the forums and found the answer to that fix on this post of this thread: http://www.zen-cart.com/forum/showpo...25&postcount=3. I needed to add the code for the "datetime_to_sqlformat" function, but once I did that, it worked.

Thanks for the help guys and girls!

[Ajeh]

Thanks for posting the cause and solution that you found that fixed this issue for you ... it is a great help to others ...