HomeHome Product Discus... Product Discus...SmithCartSmithCartAny known IE 9 issues?Any known IE 9 issues?
Previous
 
Next
New Post
10/13/2011 5:39 PM
 
No Ranking

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

I tried to take a look at the URL you provide above but I do not think that it is available publicly. However since you have indicated that with a clean install without importing your data, the Cart doesn't have any issues indicates that this is a data import issue. How did you migrate the data over from the previous database?

Thanks,
 
New Post
10/13/2011 6:19 PM
 
Web Services
8th Level Poster


Joined: 2/22/2010
Posts: 276
I imported the data from a previous version of your cart. I used the import process in SQL server to move the data from another DB I exported it to. I enabled identity insert. Is always been in your shopping cart.
 
New Post
10/13/2011 7:56 PM
 
No Ranking

Joined: 1/1/0001
Posts: 0

Hi Michael,

The issue is most likely the TabModuleID assigned to the data being migrated from your previous store. The reason that TabModuleID is saved with product is so you can run multiple stores in your portal with unique categories and products. Also if you delete a BuyNow module and add it again to the page DNN will assign a different TabModuleID.

The easiest/fastest way to import your data after doing a fresh install would be to do the following:

Add your buynow module on your new page, where you want it.
Add a single item to the products, so that it shows up on your new BuyNow module.
Look in SQL Management studio, and jot down the TabModuleID for the new item.
Update the data so your old items (with the incorrect TabModuleID) match the new TabModuleID

For Example:
UPDATE Smith_Products SET TabModuleID=(NewNumber) WHERE TabModuleID=(OldNumber)
UPDATE Smith_Categories SET TabModuleID=(NewNumber) WHERE TabModuleID=(OldNumber)
UPDATE Smith_Product_Variants SET TabModuleID=(NewNumber) WHERE TabModuleID=(OldNumber)
UPDATE Smith_Manufacturers SET TabModuleID=(NewNumber) WHERE TabModuleID=(OldNumber)
UPDATE Smith_Orders SET TabModuleID=(NewNumber) WHERE TabModuleID=(OldNumber)
so on and so forth.

Thanks,
 
New Post
10/13/2011 8:40 PM
 
Web Services
8th Level Poster


Joined: 2/22/2010
Posts: 276
I understand how the tab module ids work. The products/categories/orders wouldn't have shown up unless I updated them. Please let me give you a little background on me. I have been doing web development, not just dnn installs, for 7 years. I'm fluent in php, .net, java, and c#. I know as much about app dev as any customer you are going to have. I have tested everything I can think of from JavaScript errors, to cookies, to AV programs. I understand that your time is about billable hours, just as mine is. However, I have a customer who does tons of business on this site and I need this fixed so I can upgrade Can you provide me with the source code and an install of this so I can debug this myself and send you the damn fix? I am a reseller so we have purchased multiple licenses from you.
 
New Post
10/13/2011 9:07 PM
 
Scott Kelly
1st Level Poster


Joined: 3/11/2010
Posts: 1979
Hi Michael,
The issue is not in the source code its in the data that you migrated and imported from an old database. If you are already covered on the tabmoduleid then check for nulls or other fields that dont have correct values. We add new fields in almost each release which are initialized properly when populated thru the sc ui. If you used ssms or some other tool to migrate your data chances are you have a field somewhere with an incorrect value or null. I would enter a product, category, etc thru the ui and compare the record against the ones you imported and you will find your data issue.

Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
10/14/2011 5:04 AM
 
Web Services
8th Level Poster


Joined: 2/22/2010
Posts: 276

You're right, this issue is with the data. The data that was entered into your system. If your application allows data to be entered that can break it, then that is a flaw in your system. I can't create a form and let customers put anything they want in it, and then when they put a null value in something and it breaks the site say, "oh, you need to not put in null data, that's your fault it's not working." Also, this isn't just one record, on the machines it doesn't work on, no products work at all. You cannot add a single one to your cart. I don't think it's fair if I have to sit and go through every single record in the db to find out what is breaking this, considering all of this data was entered into the database through your system.
 
New Post
10/14/2011 7:42 AM
 
Web Services
8th Level Poster


Joined: 2/22/2010
Posts: 276
By the way, that site chucks.intellicomweb.com should be back up. We had a DNS issue.
 
New Post
10/14/2011 5:05 PM
 
Scott Kelly
1st Level Poster


Joined: 3/11/2010
Posts: 1979

 

This thread is getting a bit long and I dont see all the relavant information needed to properly troubleshoot the issue so let me try summarize the sequence of steps your portal/cart has been thru and please fill in the blanks where requested below
 
1.  Originally your portal was running DNN 5 and SmithCart 3.? (please fill in the version of the cart you upgraded from I dont see it mentioned in the thread)
 
2.  You upgraded your DNN Portal from DNN 5 to DNN 6.  As we all know upgrading major versiosn of dnn is not a perfect process and can create errors in your dnn portal which might only be manifested in the cart since the cart is such a big module tapping a large portion of the dnn api.  So it is a possibility that the cause of the cart error you reported could be related you a bad dnn upgrade.  Keep in mind I am not saying this is the cause I am saying its a possibility.
 
3.  You backed up all the data in your smithcart  tables; products, categories, orders, etc to a backup database.  Did you use the SSMS export option to backup your cart data or did you use another tool?
 
4.  You deleted all the smithcart modules from the dnn host - module def screen
 
5.  You confirmed that all the tables and sprocs with the prefix of "smith" were completly removed.
 
6.  You installed the smithcart v4.58 and added the buynow module to your store page and configured the buynow settings
 
7.  You imported the cart data you backed up in step 3 above (please confirm what tool and procedure you used to import your cart data)
 
8.  You ran update statements on the cart tables to update the tabmoduleid with your new tabmoduleid
 
Please confirm.
 
Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
10/17/2011 10:18 AM
 
Web Services
8th Level Poster


Joined: 2/22/2010
Posts: 276
I agree this has gotten long. We were running dnn 5.4 with the shopping cart 4.36. I uninstalled the smith cart because I've upgraded this on a few other sites to dnn 6 and I've just found the best way to upgrade is to completely remove it, then upgrade, then reinstall. After I removed it, and got rid of all of the smith sps and tables, I upgraded to dnn 6. I then reinstalled and imported all of the data from a temporary db that I restored from a backup of the original site before I deleted the shopping cart. I then added one test product and change the tabmoduleid in the smith_products and smith_categories table to that id so the products show up. Then I get the issue.
 
 Page 2 of 2
Previous12 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartAny known IE 9 issues?Any known IE 9 issues?




Questions? Contact us for answers!

Contact Us!