Default friend emails

rated by 0 users
Answered (Verified) This post has 2 verified answers | 5 Replies | 3 Followers

Not Ranked
21 Posts
Points 330
cori posted on Tue, May 20 2008 4:05 PM

I'm trying to test upgrade a copy of our live db from CS 2.1 to CS 2008 and it turns out that every time I run the upgrade on that db CS 2008 sends out Friend Request emails.

  1. Doing this in a completely automated way, with no notification to the person running the upgrade, seems a foolish thing to do.  I certainly didn't see anything in the upgrade docs mentioning this. Luckily for us CS only sent about 50 emails (albeit it sent each one twice - once for each upgrade attempt) but nevertheless it sent those emails containing urls that won't even be findable on our forums for another month.  Kind of a pain in the neck.
  2. What existing relationship is CS2008 basing its decision to send these emails on?

Answered (Verified) Verified Answers

Top 25 Contributor
1,878 Posts
Points 37,860
CS Developers
Answered (Verified) Jose Lema replied on Tue, May 20 2008 7:52 PM

Hi Cori,

During the upgrade if two users both marked each other as favorite users, then they are automatically created as friends. If only one side marked the other as a favorite user, then a friend request was created.

One is glad to be of service...

Jose Lema

  • | Post Points: 20
Top 25 Contributor
1,878 Posts
Points 37,860
CS Developers
Answered (Verified) Jose Lema replied on Wed, May 21 2008 1:33 PM

Hi cori,

While I can't make any promises, I'll definitely share your feedback with the team. In the meantime, if you're planning on doing further upgrades, here's the tweak you'll need in order to avoid sending emails during the upgrade:

  1. Open the cs_Schema_Patch_3.1.27.sql file located in "Upgrade Tool/UpgradeFiles/SchemaPatches"
  2. Remove the last SQL block *before* "## END Schema Patch ##" that starts with:

EXECUTE sp_executesql N'
INSERT INTO mg_EmailQueue (SettingsID, EmailXml)
SELECT ... 

Hope that helps...

One is glad to be of service...

Jose Lema

  • | Post Points: 20

All Replies

Top 25 Contributor
1,878 Posts
Points 37,860
CS Developers
Answered (Verified) Jose Lema replied on Tue, May 20 2008 7:52 PM

Hi Cori,

During the upgrade if two users both marked each other as favorite users, then they are automatically created as friends. If only one side marked the other as a favorite user, then a friend request was created.

One is glad to be of service...

Jose Lema

  • | Post Points: 20
Not Ranked
21 Posts
Points 330
cori replied on Tue, May 20 2008 11:29 PM

Jose;

Thanks for the explanation. The logoc makes sense, but I still think it would be better for this to be documented somewhere in the upgrade docs (unless I missed it) and, ultimately, the decision to send or not send the request emails be left up to the tech permforming the upgrade.

  • | Post Points: 20
Top 25 Contributor
1,878 Posts
Points 37,860
CS Developers
Answered (Verified) Jose Lema replied on Wed, May 21 2008 1:33 PM

Hi cori,

While I can't make any promises, I'll definitely share your feedback with the team. In the meantime, if you're planning on doing further upgrades, here's the tweak you'll need in order to avoid sending emails during the upgrade:

  1. Open the cs_Schema_Patch_3.1.27.sql file located in "Upgrade Tool/UpgradeFiles/SchemaPatches"
  2. Remove the last SQL block *before* "## END Schema Patch ##" that starts with:

EXECUTE sp_executesql N'
INSERT INTO mg_EmailQueue (SettingsID, EmailXml)
SELECT ... 

Hope that helps...

One is glad to be of service...

Jose Lema

  • | Post Points: 20
Not Ranked
21 Posts
Points 330
cori replied on Wed, May 21 2008 1:56 PM

Jose;

This should be exactly what I need; thanks.

  • | Post Points: 20
Not Ranked
1 Posts
Points 5

No offense, but I don't see any logic in the automatic notifications feature, unless there were pending friend requests that were staged but had not been processed when the production data was upgraded.  In that case, this would simply be a resumption of existing processing that was suspended during the upgrade procedure.

The open question is what transactions are left incomplete if the notifications are _not_ generated - do the members' intentions to have friends join their network get lost / cancelled, or just remain in suspension indefinitely or some other process is initiated?

Or did these members never intend such invitations at all, and so won't miss them?

Without understanding what member action the server is attempting to service, there's no basis for deciding whether to let the upgrade issue the notifications or not.

Edited at 5:44 pm:

The upgrade is attempting to jumpstart the Friends feature by converting existing "Favorite" relationships.  In some communities, such as YouTube, these are completely distinct (for a reason).  Often one member favorites another as an "admirer" without wishing to "friend". Offering the friend feature is great; forcing it without the consent of the member may be taking a liberty in some cases, especially in non-American cultures where the meaning of "friend" is different, and a unilateral invitation from a complete stranger may be considered presumptuous, if not rude.

  • | Post Points: 5
Page 1 of 1 (6 items) | RSS
Powered by Community Server (Commercial Edition), by Telligent Systems

Copyright© 2008 Telligent Systems Inc. All rights reserved
CommunityServer.com  •  Telligent.com