HomeHome Product Discus... Product Discus...SmithCartSmithCartError after upgrade to 2.44.14Error after upgrade to 2.44.14
Previous
 
Next
New Post
12/28/2009 5:33 PM
 

After upgrading from 2.44.10 to 2.44.14, I am encountering an error condition after clicking the Edit link on the Manage Products page. For some reason I don't think the original upgrade went smoothly since some procs where missing. I've fixed the missing procs by manually running the 01.00.03.SqlDataProvider script. Additionally, I did a repair install with the 2.44.14 package. But I'm still unable to edit a product. What's the best course of action from this point?

--David

Here is the event log entry created by DNN:

AssemblyVersion: 5.1.4
PortalID: 0
PortalName: Project Bluesphere
UserID: 9
UserName: ***
ActiveTabID: 191
ActiveTabName: Store
RawURL: /Store/tabid/191/ctl/AddProducts/mid/715/ProductID/10/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://www.projectbluesphere.com/Store/tabid/191/ctl/ManageProducts/mid/715/Default.aspx
UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.1.6) Gecko/20091201 Firefox/3.5.6
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: f5d79f2d-83df-4f3c-ba59-6eb5d45f2082
InnerException: Object reference not set to an instance of an object.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: Smith.DNN.Modules.BuyNow.AddProducts.BindProdcutDetails
StackTrace:
Message: DotNetNuke.Services.Exceptions.PageLoadException: Object reference not set to an instance of an object. ---> System.NullReferenceException: Object reference not set to an instance of an object. at Smith.DNN.Modules.BuyNow.AddProducts.BindProdcutDetails() at Smith.DNN.Modules.BuyNow.AddProducts.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.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---
Source:
Server Name: ***

 
New Post
12/28/2009 10:28 PM
 

Somehow you have gotten out of sync on a field in the product table or a stored procedure. Export your products and categories to csv in sql server. Also, I recommend backing up your dnn install and database first in case you need to rollback later. Delete the module from the dnn -> host menu. Then install the new build. On the newly installed module configure the cart settings for gateway, tax shipping, etc. Add a new category, manufacturer and test product and verify that the checkout is working. Then import your products using the import procedure on page 73 of the cart manual http://www.smith-consulting.com/Portals/0/docs/smithshoppingcartmanual.pdf


At your service,
Dave Smith
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
12/29/2009 4:09 PM
 

Ahh, I didn't think to compare the database for differences so I fired up SQL Compare from Red-gate.com and compared the production database to a demo database. It saw the differences and fixed them for me so I didn't have to re-install. Back in business!

Thanks Dave for the quick response.

--David

 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartError after upgrade to 2.44.14Error after upgrade to 2.44.14