Missing web store

If you have questions about using mojoPortal, you can post them here.

You may want to first review our site administration documentation to see if your question is answered there.

This thread is closed to new posts. You must sign in to post in the forums.
12/3/2011 11:32:46 AM
Crispin
Gravatar
Total Posts 537
View Posts
feet planted firmly on the ground

Re: Missing web store

I've just been testing the "invalid ptd request" fix, with a test PayPal purchase... after completing the purchase I did arrive back at my site, to view the "Order Summary", and it appears in the order history, so it looks like the fix has worked. However the date on the order was incorrect:

Order Date 05/11/2011

Total £0.10

i.e. 5th November instead of 3rd December.

Other dates on the site are reporting correctly. If I go to my order history (under the purchasing user's account), the date shows correctly. This might be a bug, or perhaps be still a symptom of a config problem following my conversion of the site from SQLCE to SQL Server? Anyway I thought I'd better post it - any ideas? 

Later... I've just found that when I log in as site admin, and check the Store order history, the data is also wrong: 05/11/2011 14:29

But in the "PayPal Log" I think I've found the problem. There is a PDT entry for the correct date/time 03/12/2011 17:19:36, but there are also several entries from the date that was misreported above, when I was testing while originally setting up online entry. Table below. It looks like a couple of places are fetching the wrong record from the table for the completed purchase.

Request Type Payment Type Payment Status TransactionId Cart Total Tax Total Fee Settlement Created UTC
StandardCheckout                                          8.0000                                    0.0000                                    0.0000                                    0.0000                                    0.0000                                    05/11/2011 00:34:40
StandardCheckout                                          8.5000                                    0.0000                                    0.0000                                    0.0000                                    0.0000                                    05/11/2011 00:39:18
StandardCheckout                                          0.5000                                    0.0000                                    0.0000                                    0.0000                                    0.0000                                    05/11/2011 00:39:23
StandardCheckout                                          8.5000                                    0.0000                                    0.0000                                    0.0000                                    0.0000                                    05/11/2011 10:13:42
StandardCheckout                                          12.5000                                    0.0000                                    0.0000                                    0.0000                                    0.0000                                    05/11/2011 14:29:36
StandardCheckout                                          4.5000                                    0.0000                                    0.0000                                    0.0000                                    0.0000                                    05/11/2011 14:30:12
StandardCheckout                                          0.5000                                    0.0000                                    0.0000                                    0.0000                                    0.0000                                    05/11/2011 14:30:15
StandardCheckout                                          4.5000                                    0.0000                                    0.0000                                    0.0000                                    0.0000                                    05/11/2011 14:30:30
StandardCheckout                                          4.0000                                    0.0000                                    0.0000                                    0.0000                                    0.0000                                    05/11/2011 14:30:32
StandardCheckout                                          9.0000                                    0.0000                                    0.0000                                    0.0000                                    0.0000                                    05/11/2011 17:12:45
StandardCheckout                                          17.0000                                    0.0000                                    0.0000                                    0.0000                                    0.0000                                    06/11/2011 17:42:24
StandardCheckout                                          17.0000                                    0.0000                                    0.0000                                    0.0000                                    0.0000                                    22/11/2011 20:25:03
StandardCheckout                                          13.0000                                    0.0000                                    0.0000                                    0.0000                                    0.0000                                    22/11/2011 20:25:12
StandardCheckout                                          8.0000                                    0.0000                                    0.0000                                    0.0000                                    0.0000                                    22/11/2011 20:25:17
StandardCheckout                                          8.1000                                    0.0000                                    0.0000                                    0.0000                                    0.0000                                    03/12/2011 17:08:45
StandardCheckout                                          0.1000                                    0.0000                                    0.0000                                    0.0000                                    0.0000                                    03/12/2011 17:08:50
StandardCheckout                                          0.2000                                    0.0000                                    0.0000                                    0.0000                                    0.0000                                    03/12/2011 17:10:54
StandardCheckout                                          0.1000                                    0.0000                                    0.0000                                    0.0000                                    0.0000                                    03/12/2011 17:11:00
IPN                                    cart                                    Completed                                    31U94777PX1391202                                    0.1000                                    0.0000                                    0.1000                                    0.0000                                    0.0000                                    03/12/2011 17:19:19
PDT                                    cart                                    Completed                                    31U94777PX1391202                                    0.1000                                    0.0000                                    0.1000                                    0.1000                                    0.0000                                    03/12/2011 17:19:36

 

You must sign in to post in the forums. This thread is closed to new posts.