Problem with e-mail Client
Comersus Version: 7097
Database type: Access
Frequency: Permanent issue
Hi,
I have been having a problem with my e-mail client.
I recently had to migrate to a new server as my old one went into liquidation.
Since the migration I have been unable to get the store to work properly.
The problem is that neither customers nor myself are recieving the automated e-mails sent by the store i.e. notification of Sale.
When I try to to retrieve login details, or I try to purchase goods, I get the following error message
Temporary error
Sorry for the inconvenience. Update Error in saveOrder error The SendUsing configuration value is invalid – ErrNumber-2147220960 – SQLUPDATE customers SET bonusPointsbonusPoints 05165 WHERE idCustomer1
I have been told this is because my e-mail settings are incorrect.
I have spoken to my server who have told me they use cdosys, and that I need to setup my host name as intmail.atlas.pipex.net, and that I would need to "Authenticate Against the Server with my Username and Password for the mailbox.
They have also told me that smtp server for the account is mail.runningandfitness.co.uk
I have tried using variatins of this in the Cart Configuration but cannot get the mail to work.
Can anyone help me with this problem?
Many thanks in anticipation
S Parker
About Author
There are 2 email component integration that are compatible with SMTP authentication: Jmail and CDO.Message
Try the following:
1. Configure email component as cdo
2. Enter your SMTP user and password at pMailServerUser and pMailServerPass (BackOffice Plus, Settings, Configuration)
3. Ask your web hosting support if the SMTP is
intmail.atlas.pipex.net or mail.runningandfitness.co.uk
If you cant make it work you can request an ASP example to your web hosting provider, which works for your server. With that code you can contact us at comersus.com/contact.html and request a customization of sendmail.asp script.
[Reply]
Hi Rollins,
Thank you for your prompt reply. In your reply you refer to the following
2. Enter your SMTP user and password at pMailServerUser and pMailServerPass (BackOffice Plus, Settings, Configuration)
Is this under the Email Settings section. If this is the case I only have the following fields available:
pEmailAdmin
pEmailSender
pSmtpServer
pDebugEmail
pEmailComponent
pSendPlainText
pExitSurvey
As I have reported previously I am reluctant to overwrite my current database as this will remove the data for over 300 products
Can you advise further?
Many thanks for your help
Sean
[Reply]
Go to BackOffice, Utilities, SQL and post (Replace ZZZZ by real information)
INSERT INTO settings (settingKey, settingValue, comments, idSettingGroup, idStore) VALUES ('pMailServerUser','ZZZZ','Username to authenticate', 2, 1);
INSERT INTO settings (settingKey, settingValue, comments, idSettingGroup, idStore) VALUES ('pMailServerPass','ZZZZ','Password to authenticate', 2, 1);
[Reply]
Hi Rollins,
Thank you for the information. I did what you suggested and came up with the following errors
Temporary errors
There are errors in your BackOffice+: Error in genericSqlexec: [Microsoft][ODBC Microsoft Access Driver] Characters found after end of SQL statement.
Any ideas?
Sean
[Reply]
Thanks for using Comersus and dont hesitate to contact us if you need further assistance.
[Reply]
Hi Rollins,
Thank you so much for your time and effort. Your last send enabled me to compare the scripts of the sendMail.asp and the Example from my server.
From this I was able to, finally, locate the last of the errors.
Once we had included the Username and Password, I then needed to change the server to reflect the requirements of Webfusion.
This I did in Settings/Configuration and voila I now have a working e-mail system
I appreciate the patients and understanding of both yourself and your colleagues in this matter.
All that is left for me to do is allow full access to the new comersus7f1 folder (or delete the existing comersus7f and rename comersus7f1) and I should be ready to go.
Again many thabks for your assistance over these past few weeks
Yours in appreciation
Sean Parker
[Reply]
Post one sentence at a time without the ;
Example:
INSERT INTO settings (settingKey, settingValue, comments, idSettingGroup, idStore) VALUES ('pMailServerUser','ZZZZ','Username to authenticate', 2, 1)
[Reply]
If you are sure that the example works in your server, you can contact us at http://www.comersus.com.html to request a quote to modify sendmail.asp to fit that specific example
[Reply]
Hi Rollins,
Thank you for that. Doing then one at a time without the ; worked. However I am still getting the ErrNumber-2147220973 whenever I try to obtain mail from the site.
In the UK most ISP's now require SMTP Authentication in order to send mail. If I were setting up an Outlook account I would need to ensure the "My Server Requires Authentication" box was ticked
I think this may be causing the problem I am getting in that currently comersus does not appear to be able to include this in it's software.
The following is an example of the script used by Webfusion:
'Configure the settings needed to send an email
objCdoCfg.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver"😉 ="intmail.atlas.pipex.net"
objCdoCfg.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport"😉 = 25
objCdoCfg.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusing"😉 = 2
objCdoCfg.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate"😉 = 1
objCdoCfg.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusername"😉 = username
objCdoCfg.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendpassword"😉 = password
objCdoCfg.Fields.Update
Is there any way this or part of it could be incorperated into the Comersus Coding?
Again many thanks for your assistance to date and I hope we can finally get this sorted
Reagrds
Sean Parker
[Reply]