> Forums > Active Social > Community Support > SQL Error on Active Social Installation
Last Post 18 Jul 2011 09:07 AM by Ben - DotNetNuke. 6 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Resolved
Marty G
Customers
Marty G
Post Count:20

--
01 Apr 2011 10:51 AM
    Installing on DNN 5.6.1 and getting this error:

    InfoStart Sql execution: 01.09.02.SqlDataProvider file
    WarningSQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid object name 'dbo.nt_sysobjects'. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) IF EXISTS (SELECT * FROM dbo.nt_sysobjects WHERE id = OBJECT_ID(N'[DF_activesocial_User_Events_LastUpdated]') AND type = 'D') BEGIN ALTER TABLE dbo.[nt_activesocial_User_Events] DROP CONSTRAINT [DF_activesocial_User_Events_LastUpdated] END
    InfoEnd Sql execution: 01.09.02.SqlDataProvider file


    Might it have something to do with the object qualifier??

    Thanks!
    Tags: active social, SQL Error, Intall
    Will Morgenweck Forum Admin
    DotNetNuke Staff
    Will Morgenweck
    Post Count:7672

    --
    01 Apr 2011 10:54 AM
    Moved to proper forum.

    You can ignore the error. It's part of a clean up script.
    Will Morgenweck
    Director of Product Management
    DotNetNuke Corp.
    Marty G
    Customers
    Marty G
    Post Count:20

    --
    01 Apr 2011 11:38 AM
    Thanks!
    mridul2100
    Registered Users
    mridul2100
    Post Count:2

    --
    12 Jul 2011 01:50 PM
    hello guys when i try to install active social i get error invalid sys objects.....

    this error show a invalid table something i see!.and module not installs!! answer me guys..
    Ben - DotNetNuke
    DotNetNuke Staff
    Ben - DotNetNuke
    Post Count:1645

    --
    12 Jul 2011 02:11 PM
    Hello mridul2100, I will email you directly about this issue.
    Centralhome.com
    Customers
    Centralhome.com
    Post Count:53

    --
    17 Jul 2011 09:35 PM
    Package Installation Report

    See below for the results of the package installation 
    Error loading files from temporary folder - see below
    StartJob Starting Installation
    Info Starting Installation - Active Social
    Info Starting Installation - Script
    Info Begin Sql execution
    Info Creating backup of previous version - sql\01.09.02.SqlDataProvider
    Info Created - sql\01.09.02.SqlDataProvider
    Info Executing 01.09.02.SqlDataProvider
    Info Start Sql execution: 01.09.02.SqlDataProvider file
    Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid object name 'dbo.oa_sysobjects'. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) IF EXISTS (SELECT * FROM dbo.oa_sysobjects WHERE id = OBJECT_ID(N'[DF_activesocial_User_Events_LastUpdated]') AND type = 'D') BEGIN ALTER TABLE dbo.[oa_activesocial_User_Events] DROP CONSTRAINT [DF_activesocial_User_Events_LastUpdated] END 
    Info End Sql execution: 01.09.02.SqlDataProvider file
    Info Finished Sql execution
    Failure Installation Failed - Script
    Info Installation Failed - Active Social
    Info Deleted temporary install folder
    EndJob Installation Failed 
     

    How do we fix this?
    Ben - DotNetNuke
    DotNetNuke Staff
    Ben - DotNetNuke
    Post Count:1645

    --
    18 Jul 2011 09:07 AM
    Emailing you directly Centralhome.
    You are not authorized to post a reply.
    > Forums > Active Social > Community Support > SQL Error on Active Social Installation
    test
    Copyright 2012 by DotNetNuke Corporation / Terms of Use / Privacy