Community Server 2007 SP3 (Pre-Release)

rated by 0 users
This post has 68 Replies | 19 Followers

Top 50 Contributor
Male
Posts 515
Points 7,945

Ben Tiedt:

TinyMCE in SP3 loads dialogs as modals by default. You can try disabling this by adding

<editorOption name="dialog_type" value="window" />

within the <editor> nodes in the communityserver.config file for both the "Standard" and "Enhanced" editors.  This will cause all dialogs to be loaded as new windows (slightly slower, but may correct this issue).

 

I saw you on my site earlier and appreciate you taking the time to look into it.  That did the trick!  Thanks! 

  • | Post Points: 5
Top 25 Contributor
Posts 1,878
Points 37,860
CS Developers
Jose Lema replied on Mon, Sep 10 2007 6:14 PM

Hi Edoardo,

Edoardo:

I'm running a CS configuration that, thru Morpheus, leverages an aspnetdb that is on a different database (same server, dedicated db) from the CS's one.
Now everthing works fine except for two things:

  • I cannot rename a user
  • I cannot delete a user

In both cases the sprocs cs_user_rename and cs_user_delete are fired against the CS db and they point to a aspnet_user table that's on the CS db (the wrong one in my configuration). The result is that any operation against the userlist crashes (inconsistency between the local cache and the aspnetdb).

Is this a supported scenario? Is this to be considered a bug?

A known limitation of Morpheus in a multi-database environment is that user renames and deletes are not supported without modifications. Since a centralized rename of a user would impact all potential satellites sites using the same membership database, we do not make the change automatically. If this is your scenario, then you can change the sproc to point to the fully qualified tablename (server.database.owner.object) on the appropriate database. So, assuming you have access to the db via the same credentials you could change a reference of "aspnet_user" to "myserver.mydb.dbo.aspnet_user".

The only alternative would be to implement a distributed scenario where all satellite sites are notified of a user rename or delete, which is considerably more work.

Hope that helps...

One is glad to be of service...

Jose Lema

  • | Post Points: 20
Top 100 Contributor
Posts 222
Points 3,455
Edoardo replied on Mon, Sep 10 2007 7:41 PM

Jose Lema:

A known limitation of Morpheus in a multi-database environment is that user renames and deletes are not supported without modifications. Since a centralized rename of a user would impact all potential satellites sites using the same membership database, we do not make the change automatically. If this is your scenario, then you can change the sproc to point to the fully qualified tablename (server.database.owner.object) on the appropriate database. So, assuming you have access to the db via the same credentials you could change a reference of "aspnet_user" to "myserver.mydb.dbo.aspnet_user".

It helps, indeed. I see and understand: altough you could tie the rename/delete to the membership provider this would result in being potentially disruptive against local caches of satellite sites that we might don't know about. I'll go ahead and change the sprocs, pretty easy.

Thank you!

Bye.
Dodo.

Running CS 2008.5 (v4.1.30912.2823) on Windows Server 2008 RTM and SQL2005 w/SP2.

  • Filed under:
  • | Post Points: 5
Top 150 Contributor
Posts 180
Points 2,685

Jose Lema:

Actually, our current plan is to release the final bits of SP3 early next week (just a bit ahead of schedule) Smile

We are not in the end of "next week", but I haven't seen the final version of the SP3 yet. Or did I just miss it?

Best regards,
Erik P. Ernst
Microsoft MVP - Dynamics NAV webmaster at http://dynamicsuser.net
  • | Post Points: 20
Top 500 Contributor
Posts 66
Points 945

[:'(] Sob. Any news? 

  • | Post Points: 5
Top 10 Contributor
Posts 3,399
Points 65,060
CS Developers
Ben Tiedt replied on Tue, Sep 18 2007 12:32 PM

Dennis van der Stelt:
As I see it, random comments can't be deleted. Of course there's something about them, but I can't see the difference. I just click one delete button on "review comments" page and sometimes they do, sometimes they don't. Good thing is, that the comments that can't be deleted, never can be deleted. It'd be much harder when they do delete after a while :-)

This issue has been resolved and the fix will be included in the final release of CS2007 SP3.  The fix will prevent this issue from occuring to new posts.  To correct existing posts, the following SQL can be executed against your CS database:

update cs_Posts
set UserID = u2.UserID
from cs_Posts
inner join cs_Sections s on cs_Posts.SectionID = s.SectionID
inner join cs_vw_Users_FullUser u1 on cs_Posts.UserID = u1.UserID
inner join cs_vw_Users_FullUser u2 on u1.Username = u2.Username and s.SettingsID = u2.SettingsID
where u1.SettingsID <> s.SettingsID

The issue is documented here: http://docs.communityserver.org/kb/article.aspx/405/deleting-comments-results-in-access-denied-message/

Ben Tiedt's Blog

  • | Post Points: 5
Top 25 Contributor
Posts 1,878
Points 37,860
CS Developers
Jose Lema replied on Tue, Sep 18 2007 4:50 PM

Erik P. Ernst:

We are not in the end of "next week", but I haven't seen the final version of the SP3 yet. Or did I just miss it?

Today we announced the immediate release of Community Server 2007.1 (which included all SP3 changes).

Hope that helps...

One is glad to be of service...

Jose Lema

  • | Post Points: 5
Not Ranked
Posts 2
Points 25

I am in need of the source code.

  • | Post Points: 5
Not Ranked
Posts 42
Points 645
murryc replied on Thu, Jan 17 2008 4:02 PM

Ben Tiedt:

tinyMCE in SP3 loads dialogs as modals by default. You can try disabling this by adding

<editorOption name="dialog_type" value="window" />

within the <editor> nodes in the communityserver.config file for both the "Standard" and "Enhanced" editors.  This will cause all dialogs to be loaded as new windows (slightly slower, but may correct this issue).

Thanks Ben. This fixed me up as well.

  • | Post Points: 5
Page 5 of 5 (69 items) < Previous 1 2 3 4 5 | RSS
Powered by Community Server (Commercial Edition), by Telligent Systems

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