Deleted Anonymous user. Anyway to fix this....??

Reply

|

Contact

By: bakhoven

Posted: Thu, Aug 24 2006 5:07 AM

Hi,

I was so stupid to delete the anonymous user from the community server Members.
 And when I try to get on the webpage he said an error has found...
I know that the problem is that I deleted the anonymous user but is there a way to fix it without reinstalling my Database.
Otherise I'm missing a lot of discussions in my forum and blogs.

Can someone help me...

Bakhoven

• Post Points: 35 |

Reply

|

Contact

By: Sean Kearney (CarKnee)

Posted: Thu, Aug 24 2006 11:01 AM In reply to

• Post Points: 5 |

Reply

|

Contact

By: Kevin Harder

Posted: Fri, Sep 1 2006 11:57 AM In reply to

Recreate_Anonymous_User.zip

Are you running Community Server 2.1?  Did you delete the anonymous user in the Control Panel Membership page and tell it to reassign all posts assigned to the Anonymous user to "anonymous"?

 If all of the above are true, then it would have deleted all of the anonymous user records in the database, but kept all of the posts. The post records would link to the now non-existant anonymous user account so they would not show up or possibly give an error when viewing them.

Attached is a simple SQL script to recreate the CS anonymous user once it has been deleted in the scenario above. It will do so with the same UserID as the old one, so anonymous posts should be visible and work again.  There are two settings in the script that you need to check to make sure they match your site's settings:  the application name (in aspnet_applications table - in most sites it is "dev" ) and the UserID of the deleted Anonymous user account. In most cases the anonymous userid is 2101, but you can double check this by looking in the cs_posts table and finding the UserId of posts you know are anonymous.

Hope that helps!

• Filed under: anonymous user |
• Post Points: 35 |

Reply

|

Contact

By: Brad Groux

Posted: Thu, Sep 14 2006 12:42 PM In reply to

• Post Points: 5 |

Reply

|

Contact

By: Brad Groux

Posted: Thu, Sep 14 2006 2:30 PM In reply to

• Post Points: 20 |

Reply

|

Contact

By: Matt Priour

Posted: Thu, Mar 29 2007 10:46 AM In reply to

AWESOME!!!

Thanks for that script. You should include it in the SQL Scripts directory when the program is installed. Our admin deleted anonymous without realizing the consequences and this saved our hide.

Matt

• Post Points: 20 |

Reply

|

Contact

By: Jason P. Brown

Posted: Fri, Mar 30 2007 5:22 PM In reply to

Great script, highly useful.  I had a total curious george moment and deleted my anonymous user without realizing I had some anonymous comments on the site.  This script fixed it right up, thanks! 

• Post Points: 20 |

Reply

|

Contact

By: onitaf

Posted: Fri, May 4 2007 8:27 AM In reply to

Hi all,

I recently started working on a new communityserver.com hosted site and today, when getting the database cleaned out and ready for our testing, I deleted theAnonymous user account. As the site is hosted I can not run the script myself. Is there anything else I can do. Step by step information please - I am very new at this.

Onita 

• Post Points: 20 |

Reply

|

Contact

By: Rick Reszler

Posted: Mon, May 7 2007 9:32 AM In reply to

Onita Hi,

I can assist you with this if you can email me your site URL here @ Hosted Community Server Support

• Post Points: 5 |

Reply

|

Contact

By: hscavino

Posted: Mon, Jan 14 2008 8:38 PM In reply to

Dude (Kevin) you saved my marriage.  The wife has spent 100's of hours updating our site.  Had this not worked I woulld have been on the wrong side of hell.  Thanks again for the script!

• Post Points: 5 |