HomeHome Product Discus... Product Discus...SmithCartSmithCartPortalID Incorrect in Smith_StoreOrdersPortalID Incorrect in Smith_StoreOrders
Previous
 
Next
New Post
7/29/2016 1:18 PM
 
Steve Halpern
9th Level Poster


Joined: 6/1/2010
Posts: 179
Hi,

We got a complaint about a missing order. It was not in our order list.

I discovered after the latest 7.26 update (we updated around May 18), PortalID was not getting written correctly to Smith_StoreOrders. Our PortalID is 1 (there is no 0 portal on our system). When I changed the PortalID to 1, the order showed in the orders list. On some orders it got written as 1, and on others it got written as 0.

I went ahead and made 1 the default value for the table. I guess that is a temporary fix, or it still may be overwritten with a 0. I manually updated all values to 1 also.

You can look at the picture to see how it is getting written.

We are still on the last version of DNN7. The 0 or 1 being written to PortalID is intermittent. Also, the TabModuleID is getting written as 0 sometimes too. Do I need to update that field?

In StoreOrderDetails the PortalID is getting successfully written as 1.

Thanks,

Steve
 
 Login to download attachment
New Post
7/31/2016 9:18 PM
 
Steve Halpern
9th Level Poster


Joined: 6/1/2010
Posts: 179
Hi,

We had 2 orders today that had Portal ID = 0. This is becoming quite an urgent issue. Is there any solution you know of? I can maybe try to schedule an "UPDATE Smith_StoreOrders SET PortalID = 1 WHERE PortalID = 0" query every 5 minutes through a scheduler as a temporary fix. I do not think this would hurt anything. Setting the default value to 1 in the table was still overwritten with a 0. Also TabID is not getting written.

Also, these odd things are happening, I am not sure they are related:

1. We are getting duplicate notification emails on some orders.
2. A customer can get 2 serial numbers on a purchased download product if the first one is declined. It will show up as 2 separate items in their confirmation mail, but they are charged once. It is like some array is refreshing with a new serial after the first decline.

Again, the portal issue definitely showed up on the latest version. Not sure if the other 2 points are related, but it is fairly recent that started to happen.

See the attached image for how it appears in the order admin area.

Thanks,

Steve
 
 Login to download attachment
New Post
8/1/2016 2:38 PM
 
No Ranking

Joined: 1/1/0001
Posts: 0
Hi Steve,

We haven't had any other reports of this issue but which version did you upgrade to v7.26 from?

Are you able to replicate the issue?

Is the Customer logged in or out when Portal ID 0 is saved with the Order. The TabModuleID should be saved with the Order but it's not really needed unless you have the "Admin Orders By Store" enabled in your Store Settings -> Multi Portal / Multi Store section.

I tried replicating the issue on one of our test sites using a child portal (portal Id: 1) but I have not been able to reproduce the behavior you are. I would like to have you login to our public test portal and try to replicate the issue. This will determine if the issue you are reporting is with the latest version of the cart or an issue that is isolated to your environment (DNN Portal, Cart, hosting setup, etc).

Please send a message to support@smith-consulting.com with a reference to this forum thread and I will provide you with access credentials.

Thanks!
 
New Post
8/2/2016 6:19 AM
 
Steve Halpern
9th Level Poster


Joined: 6/1/2010
Posts: 179
Hi Kevin,

The customer is logged in as that is a requirement to purchase.

We had updated from 7.22, which was a private build you all sent me to test out another bug fix.

One note is that there is no portal ID of 0 on our system, so this could be difficult to fully test. There is only a single portal, and it is portal 1. This had created issues with other modules over the years, as portal 0 was deleted long ago. Maybe this scenario is related to this issue. We are about to migrate to a fresh DNN install, and will do a fresh cart install. Maybe this will solve some of these issues. We will then keep the default Portal 0 (modifying the database of course to change the required fields).

I will send a mail shortly!

Thanks,

Steve
 
 Page 1 of 1
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartPortalID Incorrect in Smith_StoreOrdersPortalID Incorrect in Smith_StoreOrders




Questions? Contact us for answers!

Contact Us!