I'm using CS 2007.1 upgraded from an earlier version -- I believe I have email working correctly on my site as I get mass emails, private messages and get notified be email when people post to subscribed forums BUT the "send email to user" popup tied to the "contact" button in forum posts does not result in email that is delivered to the user. We get the popup contact form -- and everything seems to work -- but no email.
In my new user registration settings I have the choice to show "allow site to contact me" and "allow partners to contact me" turned off -- so users never had the chance to tick these boxes.
Could it be that if all users in my database have this field in the database as "false" that they are all opted-out of contact emails?
The user only needs to have enabled email in order to receive an email. It uses the UserToUser email method to send the message. Check the emails table (mg_EmailQueue) and see if the email is getting queued. The email it is sending to could be invalid.
Wyatt Preul
Thanks Wyatt for helping out with this.
I checked the email address -- and watched the mg_EmailQueue table. The email never gets queued. I also noticed that I never got a "your mail have been sent successfully" confirmation after using the user-to-user email form (like I do when I send an invitation to someone to join the site). I tried this as admin, and sending as a registered user to a couple different user accounts with different email addresses. The form/dialog box dissappears and no email is queued.
Could the hang up be some kind of trust or permission issue with the sql server 2005 database (shot in the dark)?
Giving a this post a little post-Thanksgiving bump. Anything I could troubleshoot in the area of user-to-user email?
Sorry for the delay. Have you made any theme changes to the sendemail.aspx page in the User folder of the theme you are using. This is the page that is displayed in the modal. It uses the SendEmailForm control to send the email to the user.
I used "Beyond Compare" - my sendemail.aspx appears to be identical to the file in the 2007.1 web install update that I used. I did some monkeying around with the emails.xml resource file a while back. Will take a look at that too.
Upon further review, I've got the same emails.xml as the 2007.1 update package as well.
Well ... I've made no progress fixing this problem. I'm a little frustrated, as members of my community will say, hey did you get my email, I used that kewl feature of the web site to send you one, and I'm like, yeah, that's broken and my skills are weak. My new idea is to somehow remove that button from the forum posts and remove this feature. Unless ... some cares a whole awful lot, this won't get better I'm afeared. This place has lost the buzz it seems.
Are there any exceptions that get reported in the reporting part of the site? Make sure to check the "Include Unhandled Exceptions." Also, are you able to send an email to yourself using the contact dropdown?
You used the web install method? And are any other emails being sent.
Email seems to be working on the site as I get email when folks post to forums that I've subscribed to, and I can send mass email. I can't send a message to myself using the contact form.
I built the site on a local development server (windows 2003, IIS 6, ms sql 2005) and moved both code and database to Webhost4life. While there I have incorrectly, then later correctly applied SP2 (I think), and then upgraded the site to 2007.1. I've used Beyond Compare to study differences in files and bring all my fab customizations (and mistakes probably) along with me. Webhost4life has been working hard to control spam on their servers, and have implemented some things like, not allowing forwarding of domain email to comcast, gmail, etc. Another red herring might be that I trouble getting the blog email subscription feature working -- and eventually gave up. I now use Feedblitz for that, and it's been working well.
Despite these challenges, I still like what we've been able to create -- and hope to keep it running.
re: recent exceptions:
December 2, Error occurred while running background task SiteStatisticsUpdates
Nov 30, Error occurred while running background task GenerateWeblogYearMonthDayListJob
Nov 27, Error occurred while running background task GenerateWeblogYearMonthDayListJob
plus this one, email related
This error and one like it occurred on November 10.
User Agent: Path: as HTTP Referrer: Message: Error occurred while running background task Emails System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32 bytesExpected) at System.Data.SqlClient.TdsParserStateObject.ReadBuffer() at System.Data.SqlClient.TdsParserStateObject.ReadByte() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object pool
also this older one, from October 18
User Agent: Path: as HTTP Referrer: Message: Error occurred while running background task Emails System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.Prov
That's all for now -- I am hoping you look at that spaghetti and I say, dag nabit dude, your booleans are revolting!
Did I overshare? Awkward ...
i seem to be having the EXACT same problem.
Users can receive email notification via bulk mail and subscriptions.
However, the "Email" contact button on a thread does not work.
It sounds like you guys got stung my the incomplete CS2007.1 SQL Update Script in the MSI Installer and possibly elsewhere.
Here is Ken Robertson's advice on updating your SQL database.
http://communityserver.org/forums/p/493951/609357.aspx#609357
Regards,Dave
I followed Robertson's suggestion and ran the upgrade script from the Web installer ... but this feature of Community Server is still not available to my community. Are there other measures I can take to clean up the database and otherwise fix my installation? Can the problem lie with Webhost4life and their database permissions? I'm open to ideas as this is a vexing and troublesome issue.
When you say it's not available, do you mean users don't see the options to send emails, or they get the option but an error occurs when they try to send them.
Community Server Documentation please rate articles you read
Nintendo Wiikly | My Blog
Copyright© 2008 Telligent Systems Inc. All rights reserved CommunityServer.com • Telligent.com