eCart Column Calamity

Hi

I’m trying to add a new Column (called Stock) to eCart (using eCart 4.5.2 on an ASP VB web site).

Turns out it’s not as easy as adding a Column via the eCart Panel as all that does is update DMWCart_VB.asp and WA_eCart_Definition_VB.asp.

I had to go through every page with an Add to Cart button and update it with the new Column. (I couldn’t use the wizard because it would screw up the CSS styling I had on the buttons.)

So far, so good. I could now add items to the Cart using the updated Add to Cart buttons.

But I couldn’t then go from the Cart page to the CheckoutSSL page without getting a 500 server error. So I manually made some changes to the Cart page to so its form would also pass the new Stock Column info to the secure Checkout page, adding the line in the appropriate place:

<input type="hidden" name="Stock_<%=DMWCart_Index%>" id="Stock_<%=DMWCart_Index%>" value="<%=WA_eCart_DisplayInfo(DMWCart, "Stock")%>" />

That seemed to move the info properly to the CheckoutSSL page but I would then get a 500 internal server error when clicking Continue to the ConfirmSSL page.

I tried adding the following code to the CheckoutSSL page in the appropriate places:

ATC_Stock = "" & cStr(Request.Form("Stock_"&(displayIndex))) & ""

AND

, ATC_Stock

But still got a 500 error from the ConfirmSSL page.

Trouble is, I don’t know how to modify the ConfirmSSL page code to solve this problem (and I can’t tell what/where the code is causing the 500 error because this server won’t tell me the line).

So my question is: How do I manually modify my ConfirmSSL page to accept a new eCart Column called Stock … AND are the lines of code I’ve manually added to the Cart and CheckoutSSL pages the correct ones?

Please advise.

I’d like to add more columns to this eCart in the near future so it’s imperative I find out how this works.

Thanks,

Craig

Please attach a copy of the page you are getting errors on and I'll take a look to see if I can spot the problem.

Thanks, Ray. I'm attaching three pages: cart.asp, checkoutSSL.asp, and confirmSSL.asp (as confirmSSL4WA.asp because I took a block of code out for security purposes) .

As mentioned above, I have made manual changes to cart.asp and checkoutSSL.asp but confirmSSL.asp remains essentially as it was before I attempted to add a column called Stock to eCart.

The logic appears sound and updates all look correct. What browser are you using? Is there a url where I can reproduce the problem?

You should be able to turn on error message details in both your browser and server to get more information about the actual error:
http://stackoverflow.com/questions/2640526/detailed-500-error-message-asp-iis-7-5

Another, though slower, solution is to remove chunks of code one at a time and narrow down where the error occurs.

If you use:
<%
Response.Write "made it"
Response.End
%>

and move that down the page. You can narrow down where the code is errors because eventually it won't make it to the line of code, representing the fact that the error occurs above. Then move the code into the code chunk to eventually narrow down the exact line of code where the error occurs. Once you know the line of code it will be much easier diagnosing why.

Is it possible that you haven't uploaded the new updated cart definition files to the secure server after adding the column, leaving it out of sync?

Hi Ray

Okay, so am I correct in understanding from your response that adding a new column to eCart shouldn't result in any changes at all to the confirmSSL.asp page? And if the other two pages are correct code-wise, then - in theory anyway - all should work well together?

The browser I am using is Firefox. Didn't try any other browsers as once I discovered that I couldn't quickly fix the error, I restored all the changed files on the server to their previous versions as it is a live site. And as such, there is not currently a URL for you to reproduce the problem.

As far as turning on the error message details, the web host would have to do that. I will badger them again tomorrow to do so but don't know if they will.

I am 100% positive I uploaded the cart definition files. I do wonder, however, if the browser was at fault somehow as - if the code is all correct as you say - I've found that both Firefox and Chrome can be terrible for using outdated files from their cache instead of checking for newer versions. I think they like to pretend that they are faster than they really are that way.

So, if all the code is correct, here is what I will do: I expect the site to be busy on Friday, so on Saturday I will try uploading all the changed files again and try testing it again. Hopefully. I'll be able to convince the host to turn on error reporting.

I will report back on Saturday as to what happens. Please let me know in the interim if you have any other thoughts.

Hi Ray

You were right - the code is good. Tonight I created a parallel cart (so to speak) by appending a 1 to all of the relevant files (e.g. cart1.asp) and changing the relevant links in the code. I uploaded it to the server and was able to checkout using this 'parallel cart' without issue.

So the error that I experienced must have been caused by Firefox using old code from its cache.

Tomorrow, I will upload the new files as the 'live' cart and expect all should go well.

Thank you for your help.