error installation of doc view 1.5. - Bring2mind - Bring2mind

Bring2mind

Select the search type

Site
Web

Search

Support

Bring2mind Forums

Forums
Search Forum
Advanced SearchTopicsPosts

Forums > Document Exchange > Installation and Activation Issues

error installation of doc view 1.5.

Last Post 01/25/2010 1:38 PM by Peter Donker. 1 Replies.

Sort:

	Prev Next
You are not authorized to post a reply.

Author

Messages

MJ

New Member

New Member
Posts:9

01/25/2010 9:52 AM
i got this error during the installation of the modul doc view 1.5. i'm using dnn 5.2.2 and SQL 2005. this was the error message: Die SQL-Ausführung hat folgende Fehler verursacht: System.Data.SqlClient.SqlException: Invalid column name 'Name'. Invalid column name 'Name'. Invalid column name 'Name'. at System.Data.SqlClient.SqlConnection.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) CREATE TRIGGER dbo.DMX_TemplateView_Init ON dbo.Portals AFTER INSERT AS BEGIN DECLARE @PortalID INT SET @PortalId = (SELECT PortalID FROM INSERTED) DECLARE @AdminRoleId INT SET @AdminRoleId = (SELECT AdministratorRoleId FROM INSERTED) DECLARE @RegRoleId INT SET @RegRoleId = (SELECT RegisteredRoleId FROM INSERTED) INSERT INTO DMX_Extensions ([AccessRights], [Addon], [ControlToLoad], [Custom], [ExtensionKey], [Icon16], [Icon32], [IsPrivate], [MimeType], [ResourceFile], [PortalId], [ViewByDefault], [EntryTypes]) VALUES ('-1;', 'TemplateView', 'Bring2mind/DMX/ViewDetails.ascx', Null, 'Custom.File.WordTemplateDoc', 'DesktopModules/Bring2mind/DMX/images/File.Microsoft.Word.Gif', 'DesktopModules/Bring2mind/DMX/images/File.Microsoft.Word.Big.Gif', 0, Null, 'DesktopModules/Bring2mind/DMX/Addons/TemplateView/App_LocalResources/SharedResources', @PortalId, 0, Null) INSERT INTO DMX_Extensions ([AccessRights], [Addon], [ControlToLoad], [Custom], [ExtensionKey], [Icon16], [Icon32], [IsPrivate], [MimeType], [ResourceFile], [PortalId], [ViewByDefault], [EntryTypes], [SettingsControl]) VALUES ('-1;', 'TemplateView', 'Bring2mind/DMX/Addons/TemplateView/ViewDoc.ascx', Null, 'Custom.File.WordDataDoc', 'DesktopModules/Bring2mind/DMX/images/File.Microsoft.Word.Gif', 'DesktopModules/Bring2mind/DMX/images/File.Microsoft.Word.Big.Gif', 0, Null, 'DesktopModules/Bring2mind/DMX/Addons/TemplateView/App_LocalResources/SharedResources', @PortalId, 0, Null, 'Bring2mind/DMX/Addons/TemplateView/DataDocSettings.ascx') INSERT INTO DMX_Extensions ([AccessRights], [Addon], [ControlToLoad], [Custom], [ExtensionKey], [Icon16], [Icon32], [IsPrivate], [MimeType], [ResourceFile], [PortalId], [ViewByDefault], [EntryTypes]) VALUES ('-1;', 'TemplateView', 'Bring2mind/DMX/Addons/TemplateView/ViewCollection.ascx', Null, 'Custom.Collection.TemplateView', 'DesktopModules/Bring2mind/DMX/images/Collection.Gif', 'DesktopModules/Bring2mind/DMX/images/Collection.Big.Gif', 0, Null, 'DesktopModules/Bring2mind/DMX/Addons/TemplateView/App_LocalResources/SharedResources', @PortalId, 0, Null) INSERT INTO DMX_Attributes ([Addon], [EntryTypes], [IsPrivate], [Name], [PortalId], [ValueType], [ViewOrder], [ResourceFile]) VALUES ('TemplateView', 'Custom.File.WordDataDoc', 1, 'TemplateDocument', @PortalId, 'Integer', 0, 'DesktopModules/Bring2mind/DMX/Addons/TemplateView/App_LocalResources/SharedResources') INSERT INTO DMX_Attributes ([Addon], [EntryTypes], [IsPrivate], [Name], [PortalId], [ValueType], [ViewOrder], [ResourceFile]) VALUES ('TemplateView', 'Custom.Collection.TemplateView', 0, 'VisibleLevels', @PortalId, 'Integer', 0, 'DesktopModules/Bring2mind/DMX/Addons/TemplateView/App_LocalResources/SharedResources') INSERT INTO DMX_Attributes ([Addon], [EntryTypes], [IsPrivate], [Name], [PortalId], [ValueType], [ViewOrder], [ResourceFile]) VALUES ('TemplateView', 'Custom.Collection.TemplateView;Custom.File.WordDataDoc', 0, 'SectionNumber', @PortalId, 'String', 1, 'DesktopModules/Bring2mind/DMX/Addons/TemplateView/App_LocalResources/SharedResources') END System.Data.SqlClient.SqlException: Invalid column name 'Name'. Invalid column name 'Name'. at System.Data.SqlClient.SqlConnection.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) INSERT INTO DMX_Attributes ([Addon], [EntryTypes], [IsPrivate], [Name], [PortalId], [ValueType], [ViewOrder], [ResourceFile]) SELECT 'TemplateView', 'Custom.File.WordDataDoc', 1, 'TemplateDocument', p.PortalId, 'Integer', 0, 'DesktopModules/Bring2mind/DMX/Addons/TemplateView/App_LocalResources/SharedResources' FROM dbo.Portals p WHERE NOT EXISTS ( SELECT * FROM dbo.Portals q INNER JOIN DMX_Attributes ON q.PortalID = DMX_Attributes.PortalId WHERE (DMX_Attributes.Addon = 'TemplateView') AND (DMX_Attributes.Name= 'TemplateDocument') AND (p.PortalId = q.PortalID) ) System.Data.SqlClient.SqlException: Invalid column name 'Name'. Invalid column name 'Name'. at System.Data.SqlClient.SqlConnection.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) INSERT INTO DMX_Attributes ([Addon], [EntryTypes], [IsPrivate], [Name], [PortalId], [ValueType], [ViewOrder], [ResourceFile]) SELECT 'TemplateView', 'Custom.Collection.TemplateView', 0, 'VisibleLevels', p.PortalId, 'Integer', 0, 'DesktopModules/Bring2mind/DMX/Addons/TemplateView/App_LocalResources/SharedResources' FROM dbo.Portals p WHERE NOT EXISTS ( SELECT * FROM dbo.Portals q INNER JOIN DMX_Attributes ON q.PortalID = DMX_Attributes.PortalId WHERE (DMX_Attributes.Addon = 'TemplateView') AND (DMX_Attributes.Name= 'VisibleLevels') AND (p.PortalId = q.PortalID) ) System.Data.SqlClient.SqlException: Invalid column name 'Name'. Invalid column name 'Name'. at System.Data.SqlClient.SqlConnection.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) INSERT INTO DMX_Attributes ([Addon], [EntryTypes], [IsPrivate], [Name], [PortalId], [ValueType], [ViewOrder], [ResourceFile]) SELECT 'TemplateView', 'Custom.Collection.TemplateView;Custom.File.WordDataDoc', 0, 'SectionNumber', p.PortalId, 'String', 1, 'DesktopModules/Bring2mind/DMX/Addons/TemplateView/App_LocalResources/SharedResources' FROM dbo.Portals p WHERE NOT EXISTS ( SELECT * FROM dbo.Portals q INNER JOIN DMX_Attributes ON q.PortalID = DMX_Attributes.PortalId WHERE (DMX_Attributes.Addon = 'TemplateView') AND (DMX_Attributes.Name= 'SectionNumber') AND (p.PortalId = q.PortalID) ) . thanks for help. regards michael

Peter Donker

Veteran Member

Veteran Member
Posts:4536

01/25/2010 1:38 PM
Hi Michael, I'll look into this. I guess the DocView module needs an update. You'll find a new version in the right dependency folder on this site. Peter

You are not authorized to post a reply.

Forums > Document Exchange > Installation and Activation Issues

About Bring2mind

Bring2mind is the company of Peter Donker, a DotNetNuke enthusiast who has been involved with the platform from the very beginning. At the same time as the market for modules emerged, he realized there was no good document management solution for the platform yet and he set about creating this. In part he based the module on his experience with other document management systems he used while working as a researcher. His module, Document Exchange, was an instant success and has since become the premier document management solution for DotNetNuke. In 2004 he created Bring2mind as a vehicle for the module and is one of the few successful businesses solely based on a DotNetNuke product.

Contact Info

Please note we are located in Europe. Business hours are weekdays between 9 AM and 6 PM local time (Central European Time) which corresponds to 3 AM and noon EST.

© 2024 Bring2mind Terms Of Use Privacy Statement