Problem installing blank DNN - Installing DNN Platform

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

Home All Forums

Home

Getting Started

Installing DNN ...

Problem installing blank DNN

1/18/2016 2:43 PM

Javiero BCN

Joined: 1/18/2016

Posts: 4

Problem installing blank DNN

Hello im obtaining this problem:

0:24 Minutes | 18% ERROR occured - System.Data.SqlClient.SqlException (0x80131904): La conversión del tipo de datos varchar en datetime produjo un valor fuera de intervalo. Se terminó la instrucción. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:14dd5ffa-52c2-4bb1-bed6-96472221b7bd Error Number:242,State:3,Class:16 -- DNN-8141 END -- CONTENT-5617 Page Settings Error: 12/31/9999 11:59:59 PM' is not valid for 'SelectedDate' IF OBJECT_ID(N'dbo.[Tabs]', N'U') IS NOT NULL UPDATE dbo.[Tabs] SET EndDate = NULL WHERE EndDate >= '9999-12-31'

Trying to do a blank install with DNN 8.0 downloaded from http://dotnetnuke.codeplex.com/

Windows Server 2012 Standard
SQL Server 2012 standard

in the same machine there are others previous DNN running without problems

Any idea welcome

1/18/2016 11:21 PM

Chris Hammond

www.christoc.com
Joined: 1/14/2003

Posts: 7319

Re: Problem installing blank DNN

My guess is it has to do with the date format and a setting you have in SQL for dates and your locale.

Any chance you can try the Default template in DNN8 and see if it causes the same problem?

It might also be something you can easily change in the .template file (it should just be XML) and then try the install again.

Chris Hammond
Former DNN Corp Employee, MVP, Core Team Member, Trustee
Christoc.com Software Solutions DotNetNuke Module Development, Upgrades and consulting.
dnnCHAT.com a chat room for DotNetNuke discussions

1/19/2016 3:57 AM

Sebastian Leupold

www.dnnwerk.de
Joined: 3/8/2004

Posts: 46212

Re: Problem installing blank DNN

this is a SQL Server data type issue, '9999-12-31' is not a valid value for DateTime, only for DateTime2.

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

1/19/2016 11:16 AM

Michael Tobisch

https://www.dnnwerk.at
Joined: 6/27/2005

Posts: 2083

Re: Problem installing blank DNN

Javiero,

I had the same problem with a German SQL Server. I solved it by changing the file 08.00.00.29.SqlDataProvider (in ~\Providers\DataProviders\SqlDataProvider) a bit before startng the installation. At the very end of the file, insert the red line:

-- CONTENT-5617	Page Settings Error: 12/31/9999 11:59:59 PM' is not valid for 'SelectedDate'
SET LANGUAGE US_ENGLISH

IF OBJECT_ID(N'{databaseOwner}[{objectQualifier}Tabs]', N'U') IS NOT NULL
	UPDATE {databaseOwner}[{objectQualifier}Tabs]
	SET EndDate = NULL
	WHERE EndDate >= '9999-12-31'
GO

-- CONTENT-5617 END

Happy DNNing!
Michael

Michael Tobisch
DNN★MVP

1/19/2016 12:12 PM

Javiero BCN

Joined: 1/18/2016

Posts: 4

Re: Problem installing blank DNN

Michael, has worked, I modified the file you indicate and installed without problems. Thank you!

Why not update the source code in that file with the SET LANGUAGE US_ENGLISH? May be other users are having this problem.

Page 1 of 2

Home

Getting Started

Installing DNN ...

Problem installing blank DNN

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:

No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
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.
Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
No Flaming or Trolling.
No Profanity, Racism, or Prejudice.
Site Moderators have the final word on approving / removing a thread or post or comment.
English language posting only, please.

Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

DNN Corp. (DotNetNuke)