Hi. This module has been fantastic and I've used it since day one. However, I never updated it since day one either  " border=0> soooo... I downloaded the latest version today and decided to run it on my evaluation site and ran into some errors. I was wondering if you could shed some light on weather this was a module issue that you could fix or something on my end that I should fix? There's no rush as it's only throwing errors on my test site but just passing this along...
Thanks!
Mike DNN Version 4.8.4
Hosted on PowerDNN On install: Resource Upload Logs | | StartJob | Starting Installation | StartJob | Reading files | Info | Loading ICG.Modules.ExpandableTextHtml.dll | Info | File ICG.Modules.ExpandableTextHtml.dll read successfully | Info | Loading Settings.ascx | Info | File Settings.ascx read successfully | Info | Loading Settings.ascx.resx | Info | File Settings.ascx.resx read successfully | Info | Loading Uninstall.SqlDataProvider | Info | File Uninstall.SqlDataProvider read successfully | Info | Loading ViewExpandableTextHtml.ascx | Info | File ViewExpandableTextHtml.ascx read successfully | Info | Loading ViewExpandableTextHtml.ascx.resx | Info | File ViewExpandableTextHtml.ascx.resx read successfully | Info | Loading 01.00.00.SqlDataProvider | Info | File 01.00.00.SqlDataProvider read successfully | Info | Loading 01.01.00.SqlDataProvider | Info | File 01.01.00.SqlDataProvider read successfully | Info | Loading 01.01.05.SqlDataProvider | Info | File 01.01.05.SqlDataProvider read successfully | Info | Loading 01.02.00.SqlDataProvider | Info | File 01.02.00.SqlDataProvider read successfully | Info | Loading 01.04.00.SqlDataProvider | Info | File 01.04.00.SqlDataProvider read successfully | Info | Loading 01.05.05.SqlDataProvider | Info | File 01.05.05.SqlDataProvider read successfully | Info | Loading 02.01.00.SqlDataProvider | Info | File 02.01.00.SqlDataProvider read successfully | Info | Loading EditExpandableTextHtml.ascx | Info | File EditExpandableTextHtml.ascx read successfully | Info | Loading EditExpandableTextHtml.ascx.resx | Info | File EditExpandableTextHtml.ascx.resx read successfully | Info | Loading ExpandableTextHtml.dnn | Info | File ExpandableTextHtml.dnn read successfully | EndJob | Reading files done. | | StartJob | Reading Installation Manifest file | Info | DNN file is in valid 3.0 format. | Info | xml loaded. | Info | Loading files info | Info | Found valid path (App_LocalResources) for ViewExpandableTextHtml.ascx.resx. | Info | Found valid path (App_LocalResources) for EditExpandableTextHtml.ascx.resx. | Info | Found valid path (App_LocalResources) for Settings.ascx.resx. | Info | Loading Modules info | Info | Loading Control info for 'ExpandableTextHtml' module | EndJob | Manifest file finished successfully | | StartJob | Begin Sql execution | Info | Executing 01.01.05.SqlDataProvider | StartJob | Start Sql execution: 01.01.05.SqlDataProvider file | EndJob | End Sql execution: 01.01.05.SqlDataProvider file | | Info | Executing 01.02.00.SqlDataProvider | StartJob | Start Sql execution: 01.02.00.SqlDataProvider file | Failure | SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid column name 'IsExpanded'. 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 PROCEDURE dbo.ICG_ETH_GetExpandableTextHtml @ModuleId int, @ItemId int AS SELECT ModuleId, ItemId, title, body, lastUpdated, IsExpanded FROM ICG_ETH_ExpandableTextHtml WHERE ModuleId = @ModuleId AND ItemId = @ItemId System.Data.SqlClient.SqlException: Invalid column name 'IsExpanded'. 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 PROCEDURE dbo.ICG_ETH_AddExpandableTextHtml @ModuleId int, @Title VARCHAR(1000), @Body NTEXT, @LastUpdated DATETIME, @IsExpanded BIT AS INSERT INTO ICG_ETH_ExpandableTextHtml ( ModuleId, Title, Body, LastUpdated, IsExpanded ) VALUES ( @ModuleId, @Title, @Body, @LastUpdated, @IsExpanded ) System.Data.SqlClient.SqlException: Invalid column name 'IsExpanded'. 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 PROCEDURE dbo.ICG_ETH_UpdateExpandableTextHtml @ModuleId int, @ItemId int, @Title VARCHAR(1000), @Body NTEXT, @LastUpdated DATETIME, @IsExpanded BIT AS UPDATE ICG_ETH_ExpandableTextHtml SET Title = @Title, Body = @Body, LastUpdated = @LastUpdated, IsExpanded = @IsExpanded WHERE ModuleId = @ModuleId AND ItemId = @ItemId | EndJob | End Sql execution: 01.02.00.SqlDataProvider file | | Info | Executing 01.04.00.SqlDataProvider | StartJob | Start Sql execution: 01.04.00.SqlDataProvider file | EndJob | End Sql execution: 01.04.00.SqlDataProvider file | | Info | Executing 01.05.05.SqlDataProvider | StartJob | Start Sql execution: 01.05.05.SqlDataProvider file | Failure | SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid column name 'IsExpanded'. 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) --Modify the needed procedures ALTER PROCEDURE dbo.ICG_ETH_GetExpandableTextHtml @ModuleId int, @ItemId int AS SELECT ModuleId, ItemId, title, body, lastUpdated, IsExpanded, SortOrder FROM ICG_ETH_ExpandableTextHtml WHERE ModuleId = @ModuleId AND ItemId = @ItemId System.Data.SqlClient.SqlException: Invalid column name 'IsExpanded'. 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 PROCEDURE dbo.ICG_ETH_AddExpandableTextHtml @ModuleId int, @Title VARCHAR(1000), @Body NTEXT, @LastUpdated DATETIME, @IsExpanded BIT, @SortOrder INT AS INSERT INTO ICG_ETH_ExpandableTextHtml ( ModuleId, Title, Body, LastUpdated, IsExpanded, SortOrder ) VALUES ( @ModuleId, @Title, @Body, @LastUpdated, @IsExpanded, @SortOrder ) System.Data.SqlClient.SqlException: Invalid column name 'IsExpanded'. 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 PROCEDURE dbo.ICG_ETH_UpdateExpandableTextHtml @ModuleId int, @ItemId int, @Title VARCHAR(1000), @Body NTEXT, @LastUpdated DATETIME, @IsExpanded BIT, @SortOrder INT AS UPDATE ICG_ETH_ExpandableTextHtml SET Title = @Title, Body = @Body, LastUpdated = @LastUpdated, IsExpanded = @IsExpanded, SortOrder = @SortOrder WHERE ModuleId = @ModuleId AND ItemId = @ItemId System.Data.SqlClient.SqlException: Incorrect syntax near 'CAST'. Incorrect syntax near '@OrderBy'. 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 PROCEDURE dbo.[ICG_ETH_GetExpandableTextHtmls] @ModuleId int, @OrderBy VARCHAR(1000) AS DECLARE @SQL VARCHAR(5000) SET @SQL = ' SELECT ModuleId, ItemId, title, body, lastUpdated, isExpanded, SortOrder FROM ICG_ETH_ExpandableTextHtml WHERE ModuleId = ' CAST(@ModuleId AS VARCHAR) ' ' SET @SQL = @SQL @OrderBy EXEC(@SQL) | EndJob | End Sql execution: 01.05.05.SqlDataProvider file | | Info | Executing 02.01.00.SqlDataProvider | StartJob | Start Sql execution: 02.01.00.SqlDataProvider file | EndJob | End Sql execution: 02.01.00.SqlDataProvider file | | EndJob | Finished Sql execution | | StartJob | Creating files | Info | Created C:\Inetpub\vhosts\mike-emond.com\httpdocs\bin\ICG.Modules.ExpandableTextHtml.dll | Info | Created C:\Inetpub\vhosts\mike-emond.com\httpdocs\DesktopModules\ExpandableTextHtml\ViewExpandableTextHtml.ascx | Info | Created C:\Inetpub\vhosts\mike-emond.com\httpdocs\DesktopModules\ExpandableTextHtml\EditExpandableTextHtml.ascx | Info | Created C:\Inetpub\vhosts\mike-emond.com\httpdocs\DesktopModules\ExpandableTextHtml\Settings.ascx | Info | Created C:\Inetpub\vhosts\mike-emond.com\httpdocs\DesktopModules\ExpandableTextHtml\App_LocalResources\ViewExpandableTextHtml.ascx.resx | Info | Created C:\Inetpub\vhosts\mike-emond.com\httpdocs\DesktopModules\ExpandableTextHtml\App_LocalResources\EditExpandableTextHtml.ascx.resx | Info | Created C:\Inetpub\vhosts\mike-emond.com\httpdocs\DesktopModules\ExpandableTextHtml\App_LocalResources\Settings.ascx.resx | Info | Created C:\Inetpub\vhosts\mike-emond.com\httpdocs\DesktopModules\ExpandableTextHtml\Providers\DataProviders\SqlDataProvider\01.00.00.SqlDataProvider | Info | Created C:\Inetpub\vhosts\mike-emond.com\httpdocs\DesktopModules\ExpandableTextHtml\Providers\DataProviders\SqlDataProvider\01.01.00.SqlDataProvider | Info | Created C:\Inetpub\vhosts\mike-emond.com\httpdocs\DesktopModules\ExpandableTextHtml\Providers\DataProviders\SqlDataProvider\01.01.05.SqlDataProvider | Info | Created C:\Inetpub\vhosts\mike-emond.com\httpdocs\DesktopModules\ExpandableTextHtml\Providers\DataProviders\SqlDataProvider\01.02.00.SqlDataProvider | Info | Created C:\Inetpub\vhosts\mike-emond.com\httpdocs\DesktopModules\ExpandableTextHtml\Providers\DataProviders\SqlDataProvider\01.04.00.SqlDataProvider | Info | Created C:\Inetpub\vhosts\mike-emond.com\httpdocs\DesktopModules\ExpandableTextHtml\Providers\DataProviders\SqlDataProvider\01.05.05.SqlDataProvider | Info | Created C:\Inetpub\vhosts\mike-emond.com\httpdocs\DesktopModules\ExpandableTextHtml\Providers\DataProviders\SqlDataProvider\02.01.00.SqlDataProvider | Info | Created C:\Inetpub\vhosts\mike-emond.com\httpdocs\DesktopModules\ExpandableTextHtml\Uninstall.SqlDataProvider | Info | Created C:\Inetpub\vhosts\mike-emond.com\httpdocs\DesktopModules\ExpandableTextHtml\ExpandableTextHtml.dnn.config | EndJob | Files created | | StartJob | Registering DesktopModule | Info | Registering Definitions | Info | Registering Controls | EndJob | Registering finished | | EndJob | Installation successful. |
|
Module instance error: Error: ExpandableTextHtml is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Invalid column name 'isExpanded'. ---> System.Data.SqlClient.SqlException: Invalid column name 'isExpanded'. 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 ICG.Modules.ExpandableTextHtml.Components.SqlDataProvider.GetExpandableTextHtmls(Int32 moduleId, String orderBy) at ICG.Modules.ExpandableTextHtml.Components.ExpandableTextHtmlController.GetExpandableTextHtmls(Int32 moduleId, String orderBy) at ICG.Modules.ExpandableTextHtml.ViewExpandableTextHtml.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace --- |