Module Discussions

Module Discussions

Upgrade Error
Last Post 10/23/2009 02:02 PM by David O'Leary. 6 Replies.
Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
Please login to post a reply.
Author Messages
Steve Aunan
New Member
New Member
Posts:5
Avatar

--
6/29/2009 02:28 PM
    Trying to upgrade Articles 3.2.6 to 4.0.14 on DNN 4.8.4. (Categories upgrade to 3.2 went fine.) I'm doing this on localhost before upgrading the production site. Do the following errors mean the upgrade failed?

    Two SQL errors:

    1) 3.2.7 data provider

    StartJob Start Sql execution: 03.02.07.SqlDataProvider file
    Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid object name 'Article'. 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) UPDATE Article SET Article.imagefile = 'FileID=' + cast(files.FileID as nvarchar(10)) FROM Article INNER JOIN Files ON Article.ImageFile = Files.FileName WHERE Article.ImageFile like '%.jpg' OR Article.ImageFile like '%.gif'
    EndJob End Sql execution: 03.02.07.SqlDataProvider file


    2) 3.3.0 provider error

    Info Executing 03.03.03.SqlDataProvider
    StartJob Start Sql execution: 03.03.03.SqlDataProvider file
    Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Cannot find the object "Article_Comments" because it does not exist or you do not have permissions. 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) /***************************************************************************/ ALTER TABLE Article_Comments ALTER COLUMN Email nvarchar (100) ALTER TABLE Article_Comments ALTER COLUMN Comment nvarchar (2000) ALTER TABLE Article_Comments ALTER COLUMN [Name] nvarchar (100)
    EndJob End Sql execution: 03.03.03.SqlDataProvider file
    David O'Leary
    Efficion Consulting Staff
    Basic Member
    Basic Member
    Posts:151
    Avatar

    --
    6/29/2009 02:46 PM
    Thank you for reporting this issue. I have confirmed that there was a problem with missing {DatabaseOwner} and {ObjectQualifier} tokens for those statements within two scripts. I have fixed the scripts and they will be included in the next release.

    The install should have been successful overall, but you will have problems if you don't run new versions of the scripts. I will e-mail you the specific script to run separately.
    Steve Aunan
    New Member
    New Member
    Posts:5
    Avatar

    --
    6/29/2009 03:27 PM
    Thanks. I edited the install scripts myself with the {databaseOwner}{objectQualifier} prefix and reinstalled. No errors.
    OdKirill
    New Member
    New Member
    Posts:4
    Avatar

    --
    10/08/2009 11:54 AM
    Hello!
    I use dnn 4.9.5 and i try to upgrade
    Articles 03.02.06
    to
    Articles 04.01.04
    but i get error

    ...
    EndJob Manifest file finished successfully

    StartJob Begin Sql execution
    Info Executing 03.02.07.SqlDataProvider
    StartJob Start Sql execution: 03.02.07.SqlDataProvider file
    Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: The multi-part identifier "a.imagefile" could not be bound. 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) in D:\work\MISIS\SOURCE\Library\Providers\DataProviders\SqlDataProvider\SqlDataProvider.vb:line 141 at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) in D:\work\MISIS\SOURCE\Library\Providers\DataProviders\SqlDataProvider\SqlDataProvider.vb:line 435 UPDATE dbo.dnn_Article SET a.imagefile = 'FileID=' + cast(f.FileID as nvarchar(10)) FROM dbo.dnn_Article a INNER JOIN dbo.dnn_Files f ON a.ImageFile = f.FileName WHERE a.ImageFile like '%.jpg' OR a.ImageFile like '%.gif'
    EndJob End Sql execution: 03.02.07.SqlDataProvider file

    Info Executing 03.03.00.SqlDataProvider
    StartJob Start Sql execution: 03.03.00.SqlDataProvider file
    EndJob End Sql execution: 03.03.00.SqlDataProvider file

    ...

    What maybe ?

    Thanks,
    Kirill.
    David O'Leary
    Efficion Consulting Staff
    Basic Member
    Basic Member
    Posts:151
    Avatar

    --
    10/12/2009 08:51 AM
    Check your Collation... I'm wondering if it might be that you have Case Sensitive turned on and in the script I reference both ImageFile and imagefile
    OdKirill
    New Member
    New Member
    Posts:4
    Avatar

    --
    10/14/2009 06:01 AM
    I changed
    03.02.07.SqlDataProvider

    UPDATE {databaseOwner}{objectQualifier}Article
    SET {databaseOwner}{objectQualifier}Article.ImageFile = 'FileID=' + cast(f.FileID as nvarchar(10))
    FROM {databaseOwner}{objectQualifier}Article
    INNER JOIN {databaseOwner}{objectQualifier}Files f ON {databaseOwner}{objectQualifier}Article.ImageFile = f.FileName
    WHERE {databaseOwner}{objectQualifier}Article.ImageFile like '%.jpg' OR {databaseOwner}{objectQualifier}Article.ImageFile like '%.gif'
    GO

    it works ok , but (0 row(s) affected)
    David O'Leary
    Efficion Consulting Staff
    Basic Member
    Basic Member
    Posts:151
    Avatar

    --
    10/23/2009 02:02 PM
    So did you lose your File links or is everything working properly now?
    Please login to post a reply.