Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...5.1.15.1.1
Previous
 
Next
New Post
7/29/2009 10:12 AM
 
5.1.1 

In a newsletter today, Bill Walker recommended to upgrade to 5.1.1. - and I did it!!

Since that I run into problems with this error message:

Unhandled Error
Error Details
File 
Error   Could not allocate space for object 'dbo.EventLog'.'PK_EventLog' in database 'spa0822803380569' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

I have never been in the database before, but I tried now :O)

I deleted what I thought could be deleted, but it didn't help me!

I can find the PK_EventLog but not the dbo.EventLog.

I don't know where I can set the autogrowth on?

Can someone help me, and tell me what to do - please soon - my site is down :O)

Best Regards,

Per

 
New Post
7/29/2009 11:16 AM
 

How are you accessing the database?  Are you using SQL Server Management Studio, SQL Enterprise Manager, the SQL page on your DNN site, or something else?

Do you know that there is more space on the database server?  If not, autogrowth won't help you very much (it may already be on, but there's no more space to grow into).

Hope I can help,


Brian Dukes
Engage Software
St. Louis, MO
866-907-4002
DNN partner specializing in custom, enterprise DNN development.
 
New Post
7/29/2009 12:05 PM
 

Yes, I also hope, you can help?

What I find very strange is, that the site is not very big!

I am runnung many dnn sites - mainly in 4.9.4, and I am very happy with them (but not 5.x :O)

One of the dnn site is a very big portal - much, much bigger than this one, so I don't understand, if I have run out of space?

I am using GoDaddy, and I have never had reason to go into the database. Today I was there to try delete files as recommended, but I can not see, I can delete more. I can see that the EventLog is very big - the biggest in the Primary folder. Is it a way to reset this logfiles? I try an icon that should rebuild the index, but there is comming an error, that says I shall contact the system administrator.

I really don't understand, how I can clean this site, and why I get this, when other sites is much bigger - and yesterday there was nothing. First after that I upgraded to this 5.1.1. - which I should never have done :O)

Is it a way to downgrade to 4.9.4?

The site is online now, but I can not log in without this error - and the strange thing is, that sometimes I can...? Then when I am insite.. doing something and click return, I get the error again..

I really hope you can help in a way, so I don't have to build a new site - in 2 language!!!

Best Regards,

Per

 
New Post
7/29/2009 12:24 PM
 

Can you run SQL through the GoDaddy tool?  Which version of SQL Sever are you using?

If you can run SQL, run this query:

SELECT * FROM sysfiles

This will show you information on the files in your database.  If any have the growth column set to 0, that means that autogrowth isn't turned on for that file.  If all of the files have a growth value, then there is a bigger issue with disk space.  You can also check whether any files have a size value at or close to their maxsize value.

To setup autogrowth on a file, run the following SQL query:

ALTER DATABASE spa0822803380569
MODIFY FILE NAME = [name of the file],
FILEGROWTH = 10 %

using the name of the file from the first query.  You can also change the 10% to 1MB or any other value that makes more sense for your specific database.

If you find that autogrowth is on, but that the file has hit its max size, you can adjust the max size like this:

ALTER DATABASE spa0822803380569
MODIFY FILE NAME = [name of the file],
MAXSIZE = UNLIMITED

You can also specify a number of MB instead of UNLIMITED.

Hope that helps,

 


Brian Dukes
Engage Software
St. Louis, MO
866-907-4002
DNN partner specializing in custom, enterprise DNN development.
 
New Post
7/29/2009 12:34 PM
 

Pyyyh.... Brian

Actually, I don't know anything about databases, and as I told you, it is first time I have tried to go into it - so I really hope I can manage what you are saying?!

I am runng 2005

But ok, I will try, what you are saying, and hope I don't destroy more :O)

Best Regards,

Per

 

 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...5.1.15.1.1


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out