|
|
 |
 |
Joined: 12/29/2010
Posts: 109
|
|
|
Hi there,
I am trying to fix our corrupted Smith Cart installation with a clean install.
I am following the pdf guide on running a clean install, however I am a bit of a database noob. I cannot get past step 1b) because I don't know how to connect to my website database via SQL Management Studio 2008. Any help would be appreciated.
Cheers,
Ricky
|
|
|
|
 | |
|
|
 |
 |
Joined: 3/11/2010
Posts: 1979
|
|
|
Normally your hosting company provides instructions on how to connect to your SQL Server. Who is your hosting provider?
Scott Kelly
Project Manager
|
|
|
|
| |
|
|
|
|
Joined: 12/29/2010
Posts: 109
|
|
|
Hi Scott,
We use 3essentials.
|
|
|
|
| |
|
|
|
|
Joined: 3/11/2010
Posts: 1979
|
|
|
Please contact 3essentials for instructions on how to connect to your sql database hosted with 3essentials.
Scott Kelly
Project Manager
|
|
|
|
| |
|
|
|
|
Joined: 12/29/2010
Posts: 109
|
|
|
Thanks Scott, I did and they helped me get it started.
I would like to know if there is any possible downsides to exporting more tables than the ones suggested in the PDF for a clean install?
For instance, i would like to keep my shipping tables, but I know that my shipping files have some corruption in them. If I import the old shipping tables, could that potentially corrupt my store after i've done the clean install?
|
|
|
|
| |
|
|
|
|
Joined: 3/11/2010
Posts: 1979
|
|
|
You can export any tables you like but after you complete the clean install I would recommend just importing the tables listed in the clean install instructions and testing first to verify the cart is working before you import any additional tables not listed in the clean install instructions. The only thing you need to worry about when importing the data back after doing a clean install is the "tabmoduleid" field. Look in the table before you import to see if it has the "tabmoduleid" in the table. If it does then you will need to update the tabmoduleid column as outlined in the clean install instructions.
Scott Kelly
Project Manager
|
|
|
|
| |
|
|
|
|
Joined: 12/29/2010
Posts: 109
|
|
|
Okay - then I will export all of the tables, and then pick/choose when I import.
|
|
|
|
| |
|
|
|
|
Joined: 12/29/2010
Posts: 109
|
|
|
I've completed the clean install(wow - that was hard!).
However, although everything seems like it should be working fine and I've checked the tables - the products are not showing up on my shopping cart.
|
|
|
|
| |
|
|
|
|
Joined: 12/29/2010
Posts: 109
|
|
|
Also, when I click on a category in the Categories menu, I get a redirect loop error in Chrome.
http://www.nu-tea.com/OnlineStore.aspx
When I add new products now, it gives me a critical error about "Products2". After doing my table import, I created Smith_Products as part of that process. When I added the BuyNow module to my Online store page, I noticed that it created a new table called Smith_Products2 (which was empty) and I deleted it.
Perhaps the products are being pointed to the wrong location, and cannot be found which is why they show up in the Cart Admin Menu/Products but not on the BuyNow or ProductDetails modules...
|
|
|
|
| |
|
|
|
|
Joined: 12/29/2010
Posts: 109
|
|
|
Here are the Errors from the Event viewer:
AssemblyVersion: 6.1.3
PortalID: 0
PortalName: Nu-Tea Company
UserID: 1
UserName: host
ActiveTabID: 36
ActiveTabName: Extensions
RawURL: /Host/Extensions/tabid/36/portalid/0/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://www.nu-tea.com/Host/Extensions/tabid/36/portalid/0/Default.aspx
UserAgent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.83 Safari/537.1
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 190e428b-da96-4aad-b488-1dd56f831c2f
InnerException: Could not load type 'Smith.DNN.Modules.BuyNow.ProductsController'.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Web.Compilation.BuildManager.GetType
StackTrace:
Message: System.Web.HttpException: Could not load type 'Smith.DNN.Modules.BuyNow.ProductsController'. at System.Web.Compilation.BuildManager.GetType(String typeName, Boolean throwOnError, Boolean ignoreCase) at DotNetNuke.Framework.Reflection.CreateType(String TypeName, String CacheKey, Boolean UseCache, Boolean IgnoreErrors)
Source:
Server Name: WEB26
AssemblyVersion: 6.1.3
PortalID: 0
PortalName: Nu-Tea Company
UserID: 4
UserName: rbandelin
ActiveTabID: 63
ActiveTabName: Online Store
RawURL: /OnlineStore.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://www.nu-tea.com/OnlineStore/tabid/63/ctl/Module/ModuleId/551/Default.aspx?popUp=true
UserAgent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.83 Safari/537.1
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 6fb8d3cd-015d-4e9a-a82d-5af34095c2e6
InnerException: Can't get ModuleId for given module name 'Smith.BuyNow'
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: Smith.DNN.Modules.MiniCart.MiniCart.GetModuleIdByName
StackTrace:
Message: DotNetNuke.Services.Exceptions.PageLoadException: Can't get ModuleId for given module name 'Smith.BuyNow' ---> System.ApplicationException: Can't get ModuleId for given module name 'Smith.BuyNow' at Smith.DNN.Modules.MiniCart.MiniCart.GetModuleIdByName(Int32 tabId, String moduleName) at Smith.DNN.Modules.MiniCart.MiniCart.GetEUVATSettings() at Smith.DNN.Modules.MiniCart.MiniCart.Page_Load(Object sender, EventArgs e) at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---
Source:
Server Name: WEB26
|
|
|
|
| |
|
|
|
|
Joined: 12/29/2010
Posts: 109
|
|
|
Any help is appreciated, as our store is currently not working at all.
|
|
|
|
| |
|
|
 |
 |
Joined: 5/4/2012
Posts: 41
|
|
|
Im not sure what the Smith_Products2 table is for but don't delete it. For some reason it is needed. In my store, I have both Smith_Products and Smith_Products2. Some of my active products in Smith_Products shows up in Smith_Products2.
Have you tried making another blank page such as OnlineStore2.aspx and inserting the Buy Now module on that page and see if that works? You will also need to create a product details page which may be causing the errors as well. Create OnlineStore2Details.aspx (blank page) and insert the ProductDetails module and click on the module and click settings to adjust the buy now module. See if that works.
Then if the Catalogs page works OnlineStore2.aspx, create a product and see what the TabModuleID is. Usually it is a 3 digit number.
www.urlhere.com/ProductDetails/tabid/###/ProductID/48/Default.aspx
Let me know how that goes.
|
|
|
|
| |
|
|
|
Joined: 1/1/0001
Posts: 0
|
|
|
Hello,
The Products2 table should not have been deleted as it is a necessary table for adding new products. I recommend performing another clean install. Be sure not to delete any tables after completing the clean install.
Thanks,
|
|
|
|
| |
|
|
|
|
Joined: 12/29/2010
Posts: 109
|
|
|
Thank you for the help Kevin and Constantine! I will try this now.
|
|
|
|
| |
|
|
|
|
Joined: 12/29/2010
Posts: 109
|
|
|
Okay - I spent a looonngg time trying to get another clean install done. Each time the module would time out during install, until i changed the web.config to allow for a longer time out period. I have another clean install now though, and all my tables are now live.
I am no longer getting the critical errors, as that was my fault for deleting that Products2 table. However, I'm still getting the problem with missing products in my BuyNow Module. They exist in the tables, and I've updated all the TabModuleId fields to be the same as my testcat tabmoduleID as it asks in the guide.
My products are still not showing up in the Buy Now Module. I did try creating a new blank page with the buynow module and it doesn't work there either.
|
|
|
|