dashCommerce

Okay, with lots of help from these forums, the site I'm building for my client is almost ready to go live. I've made some changes to the SimpleShipping scenario as described in another thread, and added all of the tax rates/ZIP codes for the State of Florida. Everything seems to be configured from the Admin side of things....

EXCEPT that I've just run a test transaction. It did not charge any tax even though the Send To address was in Florida. It did not calculate the shipping (which should have returned an error since the Minimum Order is supposed to be $70 and my order was for $1.25). And I was indeed able to go all the way through to PayPal and pay for my purchase (which is a Good Thing, I guess!!!).

Am I overlooking something???

P.S. I looked in the error logs, and noticed 2 errors each for checkout.btnShippingMethod.Click and checkout.btnBillingAddress.Click - each mention a null reference in checkout.aspx at lines 435, 667, and/or 363. Is that a clue for somebody????????

P.S.S. I did some more testing. The process above was able to complete the transaction because I used the PayPal button at the bottom of the screen. Today I tried using the Proceed to Checkout at the top of the screen, and the transaction cannot be completed. Here's the steps I took:

• Put an item in the cart
• Clicked on MyCart
• Created New User
• Clicked on My Cart
• Clicked on Proceed to Checkout
• Entered Billing Information, ticking the Use For Shipping box
• Clicked Continue
• "Updating Order" appears briefly
• dashCommerce :: Error appears stating "Oops! An error has occurred. This error has been logged. If the problem persists, please contact us!"

So I logged out as the user and logged in as the admin to see the errors... which are:

• checkout.btnShippingMethod_Click
• OrderController.Charge
• checkout.btnProcessOrder_Click
• checkout.btnBillingAddress_Click
• checkout.btnShippingAddress_Click

Unfortunately, I have NO idea of what has caused these errors, or what to do to repair the problems.....................

I'm still having problems with this, and it seems to be when the customer reaches the shipping method portion of the checkout page, and I'm now getting just the checkout.btnShippingMethod_Click errors. The error detail is here:

System.NullReferenceException: Object reference not set to an instance of an object.
   at MettleSystems.dashCommerce.Web.checkout.btnShippingMethod_Click(Object sender, EventArgs e) in C:\Users\Bruce\Documents\Visual Studio 2008\WebSites\AquaticsToGo\Web\checkout.aspx.cs:line 435

Why is this referencing stuff from my computer rather than the host? Anyhow, here's the line it references:

OrderController.SetShipping(WebUtility.GetUserName(), shippingAmount, rblShippingOptions.SelectedItem.Text);

Since I've modified the Simple Shipping scenario, it seems I should still tick off the Use Shipping box. Correct? Any idea why this is still messing up, or why no tax is being calculated???

I replaced the MettleSystems.dashCommerce.Store.dll and .Web.dll in hopes of getting back to something that might actually work somewhat, but it craps out at the same place and provides the exact same errors...

I think I've screwed things up so badly by now that it would be nice to go back to a pristine version, but I really don't want to lose all my configuration, etc. Can someone please provide a roadmap so that I can get things back to "normal?"

First off, don't panic. Taken as units of work, this application is pretty easy and doesn't do a lot of geeky weirdness. It's pretty straight forward.

BUT - you aren't doing yourself any favors by "developing remotely" - you should have a local copy setup for debugging situations like this. You have a great product base, so use something like the Database Publishing Wizard to script out your production db - depending on what version of Visual Studio you have, this tool is included in 2008, but it's easier to just use the tool if you aren't Visual Studio savvy. Script everything but the Users. Create a local database, add a user that has dbo rights and run the resultant script against your local db. Change your connection string in connectionString.config to point to your local database and you should be able to run the app locally.

Now, you can set a breakpoint in checkout.aspx.cs and step through the code to see what is causing the problems. At the very least you can provide more information in the forums so that folks can give you some salient advice.

Hope this helps.

Okay... thanks for that Zen moment... I'm breathing in through the nose and out through the mouth again!

I'm using VS2008 - when I connect to the database and select Publish to Provider, the Database Publishing Wizard begins, lets me select the db and then announces that it will close because it could not load file or assembly Microsoft.SqlServer.BatchParser, Version=9.0.242.0, Culture=neutral, PublicKeyToken==blahblahblah.

So I tried SQL Server Management Studio Express, connect to the database, select it, right-click and choose Tasks, Generate Scripts, and I get something that appears to work! After selecting the db, I'm presented with Options which seem fairly generic, then a series of screens where I can select specifics or All of the objects. The screens are:

1. database roles
2. schemas
3. stored procedures
4. tables
5. user-defined functions

I selected everything except the tables > Users, clicked Next and was asked to choose views... so I selected all and told it to script to New Query Window. It goes through its Happy HorsePoop. I disconnect, connect to my local SQLEXPRESS, open up the new db I created, and attempt to run this script, and get these messages:

Msg 7601, Level 16, State 2, Procedure dashCommerce_Store_ProductSearch, Line 15

Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'dashCommerce_Store_Product' because it is not full-text indexed.

Msg 208, Level 16, State 1, Procedure vw_aspnet_MembershipUsers, Line 3

Invalid object name 'dbo.aspnet_Users'.

Msg 208, Level 16, State 1, Procedure vw_aspnet_Users, Line 4

Invalid object name 'dbo.aspnet_Users'.

Msg 1767, Level 16, State 0, Line 2

Foreign key 'FK_aspnet_Membership_aspnet_Users' references invalid table 'dbo.aspnet_Users'.

Msg 1750, Level 16, State 0, Line 2

Could not create constraint. See previous errors.

Msg 4917, Level 16, State 0, Line 1

Constraint 'FK_aspnet_Membership_aspnet_Users' does not exist.

Msg 4916, Level 16, State 0, Line 1

Could not enable or disable the constraint. See previous errors.

Msg 1767, Level 16, State 0, Line 2

Foreign key 'FK_aspnet_PersonalizationPerUser_aspnet_Users' references invalid table 'dbo.aspnet_Users'.

Msg 1750, Level 16, State 0, Line 2

Could not create constraint. See previous errors.

Msg 4917, Level 16, State 0, Line 1

Constraint 'FK_aspnet_PersonalizationPerUser_aspnet_Users' does not exist.

Msg 4916, Level 16, State 0, Line 1

Could not enable or disable the constraint. See previous errors.

Msg 1767, Level 16, State 0, Line 2

Foreign key 'FK_aspnet_UsersInRoles_aspnet_Users' references invalid table 'dbo.aspnet_Users'.

Msg 1750, Level 16, State 0, Line 2

Could not create constraint. See previous errors.

Msg 4917, Level 16, State 0, Line 1

Constraint 'FK_aspnet_UsersInRoles_aspnet_Users' does not exist.

Msg 4916, Level 16, State 0, Line 1

Could not enable or disable the constraint. See previous errors.

Msg 1767, Level 16, State 0, Line 2

Foreign key 'FK_aspnet_Profile_aspnet_Users' references invalid table 'dbo.aspnet_Users'.

Msg 1750, Level 16, State 0, Line 2

Could not create constraint. See previous errors.

Msg 4917, Level 16, State 0, Line 1

Constraint 'FK_aspnet_Profile_aspnet_Users' does not exist.

Msg 4916, Level 16, State 0, Line 1

Could not enable or disable the constraint. See previous errors.

Yeah, don't do it that way - it won't work

Download the Database Publishing Wizard and do it that way. Trust me on this. The scripting mechanism you used is ok for a specific object, but when it comes to full databases, the DPW is the way to go. (BTW: sounds like your 2008 install is a little hosed, you may want to try to do a repair or re-install.)

Also, Users is not a table - it's a SQL Server object type, like tables, views, etc. So you may see it in that list when you run the DPW.

It doesn't seem to want to work ANY way for me.... I ran a Repair/Reinstall on my VS2008. I ran a Repair on the Database Publishing Wizard. As soon as I try to USE the DPW, I'm getting an error that says:

TITLE: Microsoft SQL Server
------------------------------

This wizard will close because it encountered the following error:

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server+Database+Publishing+Wizard&ProdVer=1.1.1.0&EvtSrc=Microsoft.SqlServer.Management.UI.WizardFrameworkErrorSR&EvtID=UncaughtException&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (Microsoft.SqlServer.ConnectionInfo)

------------------------------
BUTTONS:

OK
------------------------------

Any ideas?

umm - Call Microsoft . . . hold on . . . I've got their number . . . somewhere . . .

I don't know what to tell you that you don't already know - maybe uninstall and re-install?

I have a backup copy of the database on the host....

ANYhow -- with a calmer mind today I did a little more research and apparently I didn't have the 64 bit version of Server Management Objects. So I downloaded that and it appears that I will be able to create a script using the Data Publishing Wizard.

However, there doesn't seem to be a User thingamabob as indicated! The first series of choices asks about Database Roles, Schema, Stored Procedures, Tables, User-defined Functions, Views, and Full Text Catalogs. You mentioned that I'm not supposed to select USERS, but I don't see them anywhere.... HELP!