Sebastian Leupold wrote:
please check versions table in your database (e.g. by running "SELECT * FROM {objectQualifier}VERSIONS" in Host :: SQL and post the content here.
Ran as script as you asked, this is what came back...
System.Data.SqlClient.SqlException: Invalid object name 'wodnews_VERSIONS'. 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) SELECT * FROM wodnews_VERSIONS
When I don't tick run as a script I get this; There is an error in your query!
This is what I put in the SQL box; SELECT * FROM {objectQualifier}VERSIONS
Thank you for your help.