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

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.

Thanks. I edited the install scripts myself with the {databaseOwner}{objectQualifier} prefix and reinstalled. No errors.

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.

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

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)

So did you lose your File links or is everything working properly now?