|
|
 |
Joined: 1/1/0001
Posts: 0
|
|
|
hi Robert
Some hosting companies/email service providers don't allow replacing the "from" email with an email address other than the one you authenticate with under the dnn host settings smtp section. For example, if you are using google apps, etc for your email server then they will replace the "from" address with the email account you authenticate with in your host smtp settings. Alot of email services consider this a relay which spammers are famous for. What email service are you using for your email?
Thanks,
|
|
|
|
 | |
|
|
|
Joined: 5/31/2011
Posts: 11
|
|
|
Thanks for the reply Kevin. That is not the problem, a) because the from addresses are the same and b) because I am able to successfully send the confirmation email out of SmithCart using the resend function in the order admin screen. If there was a problem with the mail server, then I would not be able to send ANY email confirmations out. And I would not be receiving an "object reference" error in the DNN log. This appears to be a problem inside SmithCart, possibly related to a setting? If you need a login to my site, please let me know.
|
|
|
|
| |
|
|
 |
 |
Joined: 3/11/2010
Posts: 1979
|
|
|
Hi Robert,
In the buynow module settings do you have one of the checkboxes checked for the "on checkout complete events" either on checkout complete call web service or on checkout complete call stored procedure? I know you said you are running cart v4.5, is your cart install an upgrade from a previous version or a clean install?
Scott Kelly
Project Manager
|
|
|
|
| |
|
|
|
Joined: 5/31/2011
Posts: 11
|
|
|
Neither of those checkboxes are checked. The v4.5 is an upgrade from a previous version. Curiously, when I first installed 4.5 and set up the email templates and did a test order, I received an error on checkout saying a certain SmithCart stored procedure did not exist (can't remember which one; but it was related to the email template table). I then retried installing 4.5 to see if that stored procedure would then be created, and it was not. I ended up finding the stored procedure definition in the SmithCart installation package and manually created the stored procedure using SQL Server Management Studio. After doing this I no longer received the error saying the stored procedure couldn't be found, but the email confirmations were still never sent out.
|
|
|
|
| |
|
|
|
|
Joined: 3/11/2010
Posts: 1979
|
|
|
Sounds like something else may be out of sync besides the add email template sproc after your upgrade. What version of the cart did you upgrade from? Couple things you can try but make sure you have a full backup before trying item 1 if this is a live site:
1. Manually copy the dlls from the cart v4.5 zip to your \bin folder
2. Create a new dnn sandbox and install the cart and test to see if you have the same error.
Scott Kelly
Project Manager
|
|
|
|
| |
|
|
|
Joined: 5/31/2011
Posts: 11
|
|
|
I tried #1, made no difference. Question though, if I uninstall the module, will it delete the data tables also? I would like to try deleting the module and reinstalling as if new, but I don't want to lose my store's category and product lists.
I am wondering why the dnn log does not give a stack trace as it normally does when an error occurs. All I get is that there was an object reference problem in the SendEmail (?) routine.
|
|
|
|
| |
|
|
|
|
Joined: 3/11/2010
Posts: 1979
|
|
|
Here is a link to a post that explains how to do a clean install with backup and restore of your data so you keep your categories, products, etc.
http://www.smith-consulting.com/Forum...
Scott Kelly
Project Manager
|
|
|
|
| |
|
|
|
Joined: 5/31/2011
Posts: 11
|
|
|
Today I completely uninstalled SmithCart, deleted all tables, sp's, assemblies and then installed fresh into my test website. I imported the data that I had backed up to a temporary SQL database and got the store operational again. However upon placing an order I got the exact same Object Reference error that I had before I did any of this. This problem is getting pretty annoying and the cart is useless to me without having the order confirmations sent out to the customer and my store admin.
Before you ask: 1) this is not a problem with my email settings in DNN, I am able to resend confirmation emails from within the order info screen in SmithCart 2) email templates are set up in the store admin menu 3) I'm using SmithCart 4.52 for DNN 5.
Unfortunately the dnn event log does not show much data except what I posted before: "StackTrace : at Smith.DNN.Modules.BuyNow.Confirm.SendEmail(CustomerInfo customer, UserInfo objUserInfo)"
|
|
|
|
| |
|
|
|
Joined: 1/1/0001
Posts: 0
|
|
|
Hi Robert,
What re your settings for the following:
Email Setup
Third Party CC (if checked try unchecked)
Third Party Email Address (only one, does not allow multiple addresses separated by semicolons)
Checkout Step 1 Setup
Confirmation Page Setup
Confirmation Status Page Setup
Enable On Checkout Complete (Stored Proc) (if checked try unchecked)
Enable On Checkout Complete (Web Service) (if checked try unchecked)
Since this is a clean install, and you then imported your data, the issue points toward the actual data itself. as a test can you create an new DNN sandbox using the following link without importing your data and testing :
http://www.smith-consulting.com/Forum...
This method does NOT require you to reinstall DNN. It does NOT require you to install another instance of SQL. What it DOES is give you a sandbox to play in (a development site exactly like your existing site that you can test stuff in first.)
Thanks,
|
|
|
|
| |
|
|
|
Joined: 5/31/2011
Posts: 11
|
|
|
Kevin,
I only have 3 categories and about 6 products set up. There are related products set up for a couple product sku's, and one has a bundle set up. I tried an order that does not have any bundling or related sku's and it still errors out. I removed the CC for the email and it does not help. I am attaching an image showing all the settings. The paypal settings are for the Paypal sandbox so they are only used for testing.
I would be happy to wipe out the database of all my products, orders, categories, etc and add a new product from scratch to see if that makes a difference. Since I have a backup that I can restore from, it's easy to test. Wouldn't this be pretty much the same as the sandbox idea? The problem with the sandbox idea is that this site is hosted elsewhere and so it makes it difficult to just create a new dnn directory and run off that.
Thanks
|
|
|  | Login to download attachment |
|
|
|
| |
|
|
 |
 |
Joined: 8/1/2010
Posts: 252
|
|
|
I think I have the same problem as Robert.
Just a stab in the dark, but my country is not in the USA and this has caused show stopper issues before with the shipping state. Robert is your setup store in the USA?
|
|
|
|
| |
|
|
|
Joined: 5/31/2011
Posts: 11
|
|
|
Hi Daniel, I am in the U.S. So that doesn't seem to be the issue. I've tried many different settings, products, etc, even uninstalled and reinstalled the module and nothing seems to help.
|
|
|
|
| |
|
|
|
Joined: 5/31/2011
Posts: 11
|
|
|
Kevin, did you take a look at my screenshot of the SmithCart settings, and if so, did you see anything out of the ordinary? Can you work with me directly to find and resolve this problem? Others seem to have similar problems from what I have seen in the forums. My ecommerce site is on hold until this is ironed out. Thanks.
|
|
|
|
| |
|
|
|
Joined: 1/1/0001
Posts: 0
|
|
|
Hi Robert,
I took a look at your settings nothing seems to immediately jump out at me as a misconfiguration. Also I am unable to replicate this issue on our test portal, but I may not have the exact same configuration as you. Can you login to our test site http://www7.smith-consulting.com/ and try to replicate the error. This will determine if the issue is with the latest version of the cart or an issue with your specific dnn portal/cart install.
Please email me at kevin@smith-consulting.com if you need login credentials.
|
|
|
|
| |
|
|
|
|
Joined: 8/1/2010
Posts: 252
|
|
|
Robert Kittredge wrote:
Kevin, did you take a look at my screenshot of the SmithCart settings, and if so, did you see anything out of the ordinary? Can you work with me directly to find and resolve this problem? Others seem to have similar problems from what I have seen in the forums. My ecommerce site is on hold until this is ironed out. Thanks.
Hi Robert,
We seem to be in a similar boat. In the meantime I've got my e-commerce site up without emails, and configured my payment gateways (e.g PayPal) to notify us. Maybe that'll get the cash flowing in until this is sorted. Although error messages at the end of the checkout process are a bad look. I think these exception are handled a little more gracefully with SC 4.57 but then you might get other issues so take care upgrading as always.
I note that you are using DNN 5.06.02, not 6.0.1 with the email bug, so that's another reason I am unconvinced this email issue is DNN's fault.
Daniel.
|
|
|
|