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

HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Errors getting 551 community edition installedErrors getting 551 community edition installed
Previous
 
Next
New Post
12/3/2010 10:21 AM
 
Hi Guys,
I am having a bit of a frustrating time. I seem have have gotten DNN 'confused'. This seems the best place for this post.

Story to date?

I installed Version 5.5.1 Community Edition on discountasp.net. Worked fine.

I tried adding modules including chat and it failed after the chat module.

I have tried to reinstall and it keeps failing.

So I dropped all the tables except the aspnet_ tables and dropped all the views and cleared out the application directory on the hosting site. I then redid the install for the webapps on discountasp.net and I continue to get this error below. 

Obviously the table Version does not exist since I have deleted it. I have no idea why it should be looking for this because it should know the table is not there.

Can anyone point me to post/documentation on how to fix this kind of problem? Is there a kind of 'hit the reset button' for the install process.....or an 'unstall' for the database?

I am starting to think that it might be better if I download the community edition and try installing it from scratch from my pc rather than this install by discountasp.net. 

Thanks...all assistance much appreciated in advance.

Peter 


System.Data.SqlClient.SqlException: Invalid object name 'dbo.Version'. 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.Data.SqlDataProvider.GetDataBaseVersion() at DotNetNuke.Data.SqlDataProvider.GetVersion() at DotNetNuke.Services.Install.InstallWizard.get_DatabaseVersion() at DotNetNuke.Services.Install.InstallWizard.TestDataBaseInstalled() at DotNetNuke.Services.Install.InstallWizard.Initialise() at DotNetNuke.Services.Install.InstallWizard.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)


Best Regards Peter
 
New Post
12/3/2010 12:24 PM
 
I think the issue is that you haven't deleted the Stored Procedures that DNN creates.  Specifically, there's a version check stored procedure that DNN will run first thing to see if you're up-to-date or have DNN installed.  Is it possible to completely delete the database and start over?  If you used an object qualifier for your installation, you can use Bruce Chapman's delete script.

Hope that helps,

Brian Dukes
Engage Software
St. Louis, MO
866-907-4002
DNN partner specializing in custom, enterprise DNN development.
 
New Post
12/3/2010 12:35 PM
 
Hi Brian,
it seems you are correct. I didn't drop all the SPs thinking it would not make a difference....sigh.

The guys at discountasp.net sent me this link on how to reset a database in their site.

http://community.discountasp.net/show... 

I reset the database and it worked fine. So this is a post that will help DNN installers on discountasp.net!

I must say, I've been with those guys 5 years now and they have always done a good job on support. I am always happy to give credit where due.

Best Regards Peter
 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Errors getting 551 community edition installedErrors getting 551 community edition installed


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