Forums » Community Server 2008 » Bugs and Issues » Default friend emails

Default friend emails

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

cori
Not Ranked
21 Posts
Points 315
Reply | Contact
By: cori
Posted: 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

Jose Lema
Top 25 Contributor
1,873 Posts
Points 37,620
CS Developers
Reply |Contact
Answered (Verified) By: Jose Lema
Posted: Tue, May 20 2008 7:52 PM In reply to

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

 
Answered (Verified)
  • Post Points: 20 |
Jose Lema
Top 25 Contributor
1,873 Posts
Points 37,620
CS Developers
Reply |Contact
Answered (Verified) By: Jose Lema
Posted: Wed, May 21 2008 1:33 PM In reply to

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

 
Answered (Verified)
  • Post Points: 20 |

All Replies

Jose Lema
Top 25 Contributor
1,873 Posts
Points 37,620
CS Developers
Reply |Contact
Answered (Verified) By: Jose Lema
Posted: Tue, May 20 2008 7:52 PM In reply to

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

 
Answered (Verified)
  • Post Points: 20 |
cori
Not Ranked
21 Posts
Points 315
Reply |Contact
By: cori
Posted: Tue, May 20 2008 11:29 PM In reply to

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 |
Jose Lema
Top 25 Contributor
1,873 Posts
Points 37,620
CS Developers
Reply |Contact
Answered (Verified) By: Jose Lema
Posted: Wed, May 21 2008 1:33 PM In reply to

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

 
Answered (Verified)
  • Post Points: 20 |
cori
Not Ranked
21 Posts
Points 315
Reply |Contact
By: cori
Posted: Wed, May 21 2008 1:56 PM In reply to

Jose;

This should be exactly what I need; thanks.

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

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