HomeHome Product Discus... Product Discus...SmithCartSmithCartDisappearing Products when exporting BuyNow Disappearing Products when exporting BuyNow
Previous
 
Next
New Post
5/26/2010 8:02 AM
 

I exported my home page in order to move the content to a product page. I decided I wanted the Buynow module on a new Products Page instead of the home page. I Exported and imported successfully, but now the Buy Now module doesn't see any of the products I've set up. All of my settings on the Store Admin module are gone - The categories, the products, the manufacturers. The featured product module still shows the product. I look at the DNN_SmithCategory table and the data is there. I look at DNN_Smith_Products and the data is there. I receive the log error:

AssemblyVersion: 5.2.3
PortalID: -1
PortalName:
UserID: -1
UserName:
ActiveTabID: -1
ActiveTabName:
RawURL: /Home/tabid/40/ctl/ProductDetails/mid/ProductID/1/Default.aspx?SkinSrc=/Portals/_default/Skins/MinimalExtropy/index
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://www.spacemanagementproducts.com/Home.aspx
UserAgent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; GTB6.4; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 1.0.3705; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; InfoPath.1; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; OfficeLiveConnector.1.3; OfficeLivePatch.0.0)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: f888d2d0-335f-4734-8acf-75ea439d1b16
InnerException: Unhandled Error:
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Number.StringToNumber
StackTrace:
Message: System.Exception: Unhandled Error: ---> System.FormatException: Input string was not in a correct format. at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) at DotNetNuke.Common.Globals.IsAdminSkin() at DotNetNuke.Entities.Portals.PortalSettings.GetPortalSettings(Int32 tabID, PortalInfo portal) at DotNetNuke.Entities.Portals.PortalSettings..ctor(Int32 tabID, PortalAliasInfo objPortalAliasInfo) at DotNetNuke.HttpModules.UrlRewriteModule.OnBeginRequest(Object s, EventArgs e) at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) --- End of inner exception stack trace ---
Source:
Server Name: EDTWEB27

The list of Manufacturers shows up on the new page. Categories and Products do now.

I am running version 2.88.

Shouldn't I be able to move modules between pages? What happened? How do I reconnect the store admin menu with the Buy Now module so I can edit it within the system?

 
New Post
5/26/2010 8:33 AM
 

As you know you are able to add the buynow module to multiple pages in your portal. In order for the buynow module to keep settings, categories and products seperate the tabid (aka tabname or page name) is saved to the database. When you move the module i suspect dnn changes the tabid but the old tabid is still in the smith_products table and the settings is what is causing your error.

I suspect this is the problem but my past experience with moving other modules (non smith cart) around the way you described it has not always worked, I have lost the content of the module or it just flat out didnt work.



Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
5/26/2010 8:36 AM
 

What table to I update to add the correct Tabid? I have SQL Server management Studio open as we speak. Also, Why don't you reference your data tables by name so it is under your control. DNN_SMITH_CATEGORY will always be DNN_SMITH_CATEGORY even if DNN wants to refer to it as TABID 5 somewhere. I am looking at the column table for every table in DNN and I don't see any that have a Tabid/Name mapping. Can you guide me, please?

 
New Post
5/26/2010 8:44 AM
 

smith_categories and smith_products but its also in the the dnn module settings table. As an alternate solution can you keep the module on the same page and just change the name from the page settings. Seems easier


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
5/26/2010 9:12 AM
 

Hi Scott,

Thank you for the connection. The way I got the new number was to add a new category, called Test. Looking in Server management studio I opened the DNN_SMITH_Category table and looked at the new value of the Category "Test" for the field TabModuleId. The value was 80 while the previously entered values from the old page was 64. I edited the two other categories from 64 to 80 and committed the change. I then edited DNN_SMITH_Products, Field TabModuleId from it's original value of 64 to it's new value ot 80 and committed the change. All the settings are now completely correct. That was a tough bug.

Regards,

Art Hendela

www.hendela.com

 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartDisappearing Products when exporting BuyNow Disappearing Products when exporting BuyNow