What do you do when you cannot login to CommunityServer?
So, it has been a while since my last post.
Basically, I was busy/lazy/whatever - life is hectic, we all know that. Additionally, however, I had a problem where I could not even login to my blog. I just ignored it and went back to real life, but today I was trying to avoid doing something else and decided to figure out what the hell was going on.
This is (if I recall correctly) CommunityServer 2008, hosted on SQL 2005, on GoDaddy
I was CERTAIN that I had my password correct, and confirmed this by opening up the SQL manager on GoDaddy and looking at the following tables;
aspnet_Membership - this confirms the username
aspnet_Profile - this confirms the password (it is hashed, but you can overwrite it)
After some googling, I saw a post by Dave Stokes - if you are having problems and see his name on a post, you are well on your way to a solution - he was pointing out the cs_Exceptions table to find more information about the error. Looking in there, I was able to find the following error;
CommunityServer.Components.CSException: Iterator Failed. Type CommunityServer.Blogs.Components.GenerateWeblogYearMonthDayListJob. Method GenerateWeblogYearMonthDayList. Reason Could not allocate a new page for database 'MyDatabase' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
ORLY?!
So, how do you free up space in a SQL database that is hosted on GoDaddy? Awesome question, I am glad I asked it of myself. I started deleting individual users and posts (spam) to try and free it up, but that was beyond slow - and then I saw this command;
DELETE FROM cs_posts_deleted_archive
It looks as though CS doesn't ever empty that archive, but that command did it.
All of a sudden, I can logon, and post the solution about how I can now log on - hopefully it saves someone else the ~2 hours or so (in this sitting) that it took me
Kieran