Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

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
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsDocumentsDocumentsDownloaded files are empty or unreadableDownloaded files are empty or unreadable
Previous
 
Next
New Post
3/5/2007 8:45 PM
 
frankosaurus

Joined: 3/5/2007
Posts: 18
BTW, the problem is occuring on our production server which is Windows Server 2003. I just tested it locally on my development Windows XP Pro box and it worked fine. Perhaps its a configuration issue? Any ideas?

-Frank
 
New Post
3/5/2007 9:25 PM
 
Anthony Glenwright

www.inventua.com
Joined: 3/31/2004
Posts: 558

Hi Frank,

The original issue with downloads was a bug in the core.  But if you have upgraded to DNN 3.3.7, the problem should have been fixed.  Try clicking the "synchronize files" button in the File Manager (use the "recursive" checkbox to do them all at once), and see if that helps.
 
New Post
3/5/2007 11:17 PM
 
frankosaurus

Joined: 3/5/2007
Posts: 18
anthony.glenwright wrote

Hi Frank,

The original issue with downloads was a bug in the core.  But if you have upgraded to DNN 3.3.7, the problem should have been fixed.  Try clicking the "synchronize files" button in the File Manager (use the "recursive" checkbox to do them all at once), and see if that helps.



I tried synchronizing files-- no luck. It doesn't work when I upload new files from scratch, either.

If the problem is in the core, is there a way I can check the relevant code? (is it in an .aspx file or compiled into the DotNetNuke dll?) ...Any information on that specific bug that I could check? Is it at all related to server environment? ...Note my previous post that it worked when I ran the site on my local Windows XP machine.

I found this in my web.config httpHandlers section... is this correct?
<add verb="*" path="LinkClick.aspx" type="DotNetNuke.Services.FileSystem.FileServerHandler, DotNetNuke"/>

thanks for the suggestions....
 
New Post
3/6/2007 11:44 AM
 
frankosaurus

Joined: 3/5/2007
Posts: 18
I checked back in my upgrade error logs to see if anything is related. Could the following be related to the problem, from my DNN 3.2.3 upgrade?

System.Data.SqlClient.SqlException: The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_Files_Folders". The conflict occurred in database "mydatabase", table "dbo.Folders", column 'FolderID'.
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)


ALTER TABLE dbo.Files ADD CONSTRAINT
FK_Files_Folders FOREIGN KEY
(
FolderID
) REFERENCES dbo.Folders
(
FolderID
)


...or this error, for the 3.3.1 upgrade?

System.Data.SqlClient.SqlException: The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_Files_Folders". The conflict occurred in database "mydatabase", table "dbo.Folders", column 'FolderID'.
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)


/* This sets all cache root folders to protected */
/*************************************************/

UPDATE Folders
SET IsProtected = 1
WHERE
FolderPath = 'Cache/'

/* This tries to apply a foreign key on the files/folders tables */
/*****************************************************************/

IF NOT EXISTS ( SELECT * FROM sysobjects WHERE id = object_id(N'FK_Files_Folders') AND OBJECTPROPERTY(id, N'IsForeignKey') = 1)
BEGIN
ALTER TABLE dbo.Files ADD CONSTRAINT
FK_Files_Folders FOREIGN KEY
(
FolderID
) REFERENCES dbo.Folders
(
FolderID
)
END

....Then again, I'm running an identical database on my local machine, so I can't see how this problem would not be coming up when I run it locally.
 
New Post
3/6/2007 2:30 PM
 
frankosaurus

Joined: 3/5/2007
Posts: 18
I tried removing the Files with no FolderID reference, creating the FK contstraint, and re-synchronizing the file manager. It didn't help. I'm going to roll back to DNN 3.1.1 (what I was originally using) and retry the upgrades, step by step.

By the way, the links still work in Windows XP Pro, but not Windows 2003 Server. Last time I had an issue with pdf files like this, it was related to IIS gzip compression... but I have disabled gzip compression for pdf files on my server. Could this be related to the problem?
 
 Page 2 of 3
Previous123Next 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsDocumentsDocumentsDownloaded files are empty or unreadableDownloaded files are empty or unreadable


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