hi, thanks in advance

I am using Dnn 4.02 and SQL 2005 doing a Resource Site for people downloading stuff, Everything seems work well before i got this problem. wthen the Portal space in the \....\Porpal\0\  dir exceed 2GB large, I can't uploading files anymore and got this error:

A critical error has occurred. 
  Value was either too large or too small for an Int32

Also, when i try to access File Manager of DNN, It show s me this:

Error: File Manager is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Value was either too large or too small for an Int32. ---> System.OverflowException: Value was either too large or too small for an Int32. at System.Convert.ToInt32(Int64 value) at DotNetNuke.Entities.Portals.PortalController.GetPortalSpaceUsed(Int32 PortalId) at DotNetNuke.Modules.Admin.FileSystem.FileManager.UpdateSpaceUsed() at DotNetNuke.Modules.Admin.FileSystem.FileManager.BindFileList() at DotNetNuke.Modules.Admin.FileSystem.FileManager.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

i wonder how come Dnn can only handle 2GB website, or is this a known problem for dnn.

Can anybody help me to solve this: Really reall need help, Please!

A poor guy waiting for the reply here or in my mailbox: maoker.mao@gmail.com

thank you very much again!

 

you might be ably to temporaly fix this with the following sql script.  You will need to update the script if you are using a different qualifier other than dnn_

I provided both rollout and rollback in case it doesnt help.  You will also probably need to disable teh schedule task that auto syncs the filesystem to the database.  you will also need to realize that the size info is not correct anymore

--rollout
SELECT * into dnn_files_backup from dnn_Files
UPDATE dnn_Files set [size] = [size]/1024 where portalID = 0


--rollback
DELETE FROM dnn_Files

SET IDENTITY_INSERT dnn_files ON
INSERT into dnn_files(FileID, PortalID, [FileName], Extension, [Size], Width, Height, ContentType, Folder)
SELECT FileID, PortalID, [FileName], Extension, [Size], Width, Height, ContentType, Folder FROM dnn_files_backup
SET IDENTITY_INSERT dnn_files OFF