Learn DNN / DotNetNuke

You need to Register for free and Login to post a message in the forum.

Forum

Forums
Search Forum
Advanced SearchTopicsPosts

Forums > DotNetNuke® > DotNetNuke® Questions

SQL Server 2008 Documents Module DotNetNuke

Last Post 11/18/2008 10:27 AM by Lee Sykes. 4 Replies.

Sort:

Check this box to subscribe to this topic.	Prev Next
You are not authorized to post a reply.

Author

Messages

Lee Sykes
DNN Creative Staff

Nuke Master VI
Posts:4945

11/18/2008 5:29 AM
I'm going to document here some problems I am getting and if I find a solution I will add it. I've got a fresh installation of DNN 4.9, SQL Server Express 2008. Installed Documents module, seemed to install ok Add docs module to page get an error. Looking at tables in database appears as though the documents table has not been created, but the documentsettings table has been created. I have a feeling this could be a sqlserver 08 configuration problem - will investigate more and let you know - in meantime if anyone else has come across this let me know. The error is: DotNetNuke.Services.Exceptions.ModuleLoadException: Invalid object name 'Documents'. ---> System.Data.SqlClient.SqlException: Invalid object name 'Documents'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.Documents.SqlDataProvider.GetDocuments(Int32 ModuleId, Int32 PortalId) at DotNetNuke.Modules.Documents.DocumentController.GetDocuments(Int32 ModuleId, Int32 PortalId) at DotNetNuke.Modules.Documents.Document.LoadData() at DotNetNuke.Modules.Documents.Document.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

Lee Sykes Site Administrator Subscribe to the website : DotNetNuke Video Tutorials : The Skinning Toolkit : DotNetNuke Podcasts Twitter: www.twitter.com/DNNCreative

Lee Sykes
DNN Creative Staff

Nuke Master VI
Posts:4945

11/18/2008 5:35 AM
Further testing shows when installing other modules such as FAQ that the tables do not get created for that module either. Must be a configuration problem in SQL Server 2008 Express.

Lee Sykes Site Administrator Subscribe to the website : DotNetNuke Video Tutorials : The Skinning Toolkit : DotNetNuke Podcasts Twitter: www.twitter.com/DNNCreative

Lee Sykes
DNN Creative Staff

Nuke Master VI
Posts:4945

11/18/2008 7:57 AM
Erik Van Ballegoij (core team) informs me he has several dev sites on SQL 2008 already + they work fine. Tony Valenti at PowerDNN has also informed me they have several boxes running SQL Server Express 08 with DotNetNuke and it is 'sweet!' So, it's definitely a configuration problem. I suspect I have over complicated it by leaving SQL 2005 on the machine. I'm now going to run another test by starting again, uninstalling SQL 2005 and installing a fresh SQL Server 2008.

Lee Sykes Site Administrator Subscribe to the website : DotNetNuke Video Tutorials : The Skinning Toolkit : DotNetNuke Podcasts Twitter: www.twitter.com/DNNCreative

Mr. MobileNow
DotNetNuke Ninja

Nuke Ace
Posts:43

11/18/2008 8:59 AM
Make sure that both of the connection strings are the same in the web.config file. Also make sure that the SQL user that you're using has full permissions on the database. It is worth checking, but I expect that they already do because they would have had to in order for DotNetNuke to install at all.

-Tony Valenti DotNetNuke DNN Hosting DotNetNuke DNN Hosting UK DotNetNuke DNN Hosting in Australia I work for PowerDNN

Lee Sykes
DNN Creative Staff

Nuke Master VI
Posts:4945

11/18/2008 10:27 AM
Hello, Thanks for the tip. Yes both connection strings are in correctly and the user has full permissions. Something is preventing the dnn install from adding a table. - Well, Im starting with a fresh installation at the moment, so we will see what happens ...

Lee Sykes Site Administrator Subscribe to the website : DotNetNuke Video Tutorials : The Skinning Toolkit : DotNetNuke Podcasts Twitter: www.twitter.com/DNNCreative

You are not authorized to post a reply.

Forums > DotNetNuke® > DotNetNuke® Questions

Latest Forum Posts

Can you Run Xcode in Linux? by Aman Singh

Can you Run Xcode in Linux?

Can you Run Xcode in Linux? by Aman Singh

Can you Run Xcode in Linux?

Billed for subscription that was canceled by Ryan

I was just billed for a subscription that was canc eled / inactivetive how do I get a refund for th

Meta Title and Meta Description are not showing properly by DNN User

Hi, On my site the meta title and meta descriptions are not showing properly. It's showing the m

Search is not functioning properly by DNN User

Site: https://www.prv-engineering.co.uk/search If I search any item only the 1st option under sea

Search is not functioning properly by DNN User

Site: https://www.prv-engineering.co.uk/search If I search any item only the 1st option under sea

DNN Platform import site optio by Melanie Weaver

Is it possible to import site template in DNN Platform 8.0? We have internal Evoq Content 8.1 tha

Events Module for DNN V5? by Tugboat

Would anyone have a download link for the version 5.0.3 Events Module? Thanks!

"Ghost" TabID Number? by Tugboat

Hi! I have a portal instance with multiple child portals and on one of the child portals, there i

RE: DNN Load Testing by ayman sharkawy

Hi. Have you already implemented a site using the DNN . And how the performance of the site and its

Publish All Pages by NSUOK

I'm using DNN Evoq Content Basic 8.2.0. When I make the HTML Pro module display on all pages, I h

Simpler profile needed in 9.2.2 by Donald

We are upgrading a DNN 4.8.4 site to DNN 9.2.2. On 4.8.4, the top bar shows the user’s name. If yo

How to link from dnnmodal popup to web site page? by Donald

Hello all. I am using a dnnmodal.show popup. The popup works correctly, showing the content that I

RE: Document Collaboration by Nick Davern

That feature would be super beneficial for our needs as well! Does anyone have an update as to if th

RE: DNN 9.2, how to set default theme? by Andy Stephenson DNN Creative

you do that under "Manage/Themes". Note the highlight blue border around the default container and d

DNN 9.2, how to set default theme? by Donald

Please disregard, found Manage Themes I cannot find how to set a default portal theme in DNN 9.2

RE: Looking for DataSprings Dynamic Forms by Andy Stephenson DNN Creative

Your best chance would be to contact Chad Nash @ http://www.datasprings.com/

Looking for DataSprings Dynamic Forms by Jakir HM

Looking for DataSprings Dynamic Forms 3.4 for DNN 4.x 5.x for my site (https://themasters2018s.com/)

RE: Help with Cycle Image Carousel not displaying images by peter

I had the same problem with the Will Strohl Content Slider after upgrading to DNN 9.1 The above an

RE: Object reference not set to an instance of an object by Andy Stephenson DNN Creative

Check this one might be useful: http://www.dnnsoftware.com/answers/im-tryin-to-move-my-site-to-pr

Used
By

Testimonials

| The SoloCoder Podcast | Google | Privacy Statement | Terms Of Use