Browse by Tags

Sometimes there might be a need to add your users to different roles, depending on certain invitations, at registration time. Is that possible in Community Server (CS)? Well, in this case CSModules can be your friend as in many other situations. The other day there was a request for this functionality in the CSOrg Forums . I thought it would be an interesting case to do some sample code for a CSModule that did this by reading an argument from the query string. You might think that this could be done...

Previously on J-O Erikssons blog: A long, long time ago. At least in Internet Time. At J-O Eriksson's old blog there was an article about a solution to handle sending Newsletters to your Community Server users with the help of CS Roles . As time went by, new articles was written, other areas of Community Server was examined, and the solution was forgotten. Until one day when J-O needed to use this solution on one of his sites. He discovered that it no longer worked! It was broken, kaputt! After much...

I decided to call on The Wizard , who always seem able to name the right man for the job if it's not one he can do himself. After describing my ongoing problems, he suggested I drop a line to Telligent's resident SQL guru, Terry Denham. While I was drafting an email to him, a thought hit me, so I clicked out of Outlook and stepped back into SQL Studio. I restored the database to it's pristine state, minus all schema and data changes, then I created a new script in SQL Compare to create only the tables...

Copy fresh set of CS 2.1 SP2 web files, hook up site in IIS, amend web.config, load Firefox, hit Return, hold breath. Error. But of course. ASP.NET is complaining about an unrecognised section in web.config, which reminded me I hadn't updated the ASP.NET script mappings for that site to ASP.NET 2.0, which was swiftly rectified by running aspnet_regiis.exe (with -s flag). Then also ran the ASP.NET schema update script, as I'd neglected to do that earlier. Hit F5 and... "Object not found...

My simple plan to get the database collation (and those of all it's tables) switched was based on these steps: Script entire database Create new db based on amended script with new collation Copy data Step 1 seemed like it should've straightforward enough, but of course, it turned out not to be. Running the Generate Scripts task from SSMS simply refused to complete - failing at a very early stage and returning an SMO error complaining that "Collection cannot be modified when TextMode...

If you're using the Reader application in Community Server , did you know that the posts never expire and will over time add to the size of your database? Last Friday I wrote an article about how you can create a CSJob that lets you run a SQL Stored Procedure on your CS Database on a scheduled basis. After that, it has been rather quiet in my blog for a little over a week. It has been one of those weeks again, which seems to come every now and then, where I almost had no time to even breath. [:-...

If you have your Community Server web site at a hoster, have you been confronted with the issue of a growing CS Database? In a conversation with Keyvan the other day, he pointed me to a forum thread at communityserver.org, and hinted that this might be a good idea for a CSJob. In that thread a user wants to delete certain posts in the CS Database at certain intervals (although the question from the beginning is more like if mirrored blog posts does expire or if they have to be deleted manually)....