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

HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...Text/HTML is currently unavailable errorText/HTML is currently unavailable error
Previous
 
Next
New Post
8/15/2011 5:53 AM
 
Try using the default container that comes with dnn upgrade
 
New Post
8/15/2011 8:50 AM
 
Problem occurs no matter module, and is not reletert to default DDN module, HTMLmodule or 3th parts developers module. The problem with start and stop dates are, what I understand, a function in the DNN platform, a feature that is called up by any module, regardless of module type.
 
New Post
8/16/2011 7:28 PM
 
I have resolved a problem that is similar to this one... The issue is with the StartDate and EndDate columns within the database causing some sort of problem with DNN 6, this problem does not exist with DNN 5.6.3.

If you want to go ahead and resolve the problem, you should get rid of the StartDate and EndDate paramaters for the module that is causing this issue by doing the following:

- You MUST have access to your database, You need to run these queries within MSSQL Management Studio.

A- Find the ModuleID

SELECT * FROM ModuleS WHERE StartDate LIKE '%9999%';

Since the the problem was caused by System.ArgumentOutOfRangeException: Value of '12/31/9999 12:00:00 AM' is not valid for 'SelectedDate'. 'SelectedDate' should be between 'MinDate' and 'MaxDate'. I have placed 9999 for the LIKE statement. If your error was 2011, for example, you should replace it with '%2011%'.

B- Keep the moduleID in mind on the resulting query, if the moduleID was 100, you'd run this query next (Replace 100 with the ModuleID you've received from the previous query):

UPDATE Modules SET StartDate=NULL WHERE ModuleID=100;
GO
UPDATE Modules SET EndDate=NULL WHERE ModuleID=100;
GO

After this, you will need to recycle the application pool for your site, once done, try to refresh the page you are on and editing the HTML Module or whatever module that caused the issue.
 
New Post
8/17/2011 5:12 AM
 
A simplier SQL approach should be combining both statements:
UPDATE Modules SET StartDate=NULL WHERE StartDate LIKE '%9999%';
UPDATE Modules SET EndDate=NULL WHERE EndDate LIKE '%9999%';

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
8/17/2011 11:07 AM
 
I have tried your proposed solution by using Microsoft SQL Management Studio Express, but with varying success.
First, I reverted the update back to DNN 5.6.3, and set EndDate to 2014.

When I try your solutions, the following happens:
  1. Reset EndData "9999" to "NULL" went fine in 3th parts module.
  2. Reset to "NULL" in default DNN HTML module did not work, but the database value was written to 12/31/9999 - again.
I ran the same script in DNN "host / SQL" with the same result.
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...Text/HTML is currently unavailable errorText/HTML is currently unavailable error


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