 |
|
|
 |
Joined: 8/10/2003
Posts: 3594
|
|
|
At my fist install i get no eror report. Now I hve deinstall, delete the host cache and get this error on reinstall:
| Info |
Ausführen03.01.02.SqlDataProvider |
| Starte Job |
Starte SQL-Ausführung: Datei 03.01.02.SqlDataProvider |
| Abbruch |
Die SQL-Ausführung hat folgende Fehler verursacht: System.Data.SqlClient.SqlException: 'grmCheckAllAttributes' wird nicht als Funktionsname erkannt. 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 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE procedure grmGetRepositoryObjects ( @ModuleID int, @sFilter nvarchar(256), @sSort nvarchar(100), @Approved int, @CategoryId int, @Attributes nvarchar(150), @RowCount int ) AS BEGIN IF @RowCount > 0 SET ROWCOUNT @RowCount END SELECT *, (SELECT COUNT(grmRepositoryComments.ItemID) FROM grmRepositoryComments WHERE grmRepositoryComments.ObjectID=grmRepositoryObjects.ItemID) AS CommentCount FROM grmRepositoryObjects WHERE ModuleID = @ModuleID AND (Approved = @Approved) AND (@CategoryId = -1 OR CHARINDEX(';' + CONVERT(varchar, @CategoryId) + ';',CategoryId)>0) AND (@Attributes = '' OR grmCheckAllAttributes(@Attributes,';',grmRepositoryObjects.Attributes) = 1) AND ( @sFilter = '' OR UPPER(Name) LIKE UPPER('%' + @sFilter + '%') OR UPPER(Author) LIKE UPPER('%' + @sFilter + '%') OR UPPER(AuthorEMail) LIKE UPPER('%' + @sFilter + '%') OR Description LIKE '%' + @sFilter + '%' ) ORDER BY CASE @sSort WHEN 'Name' THEN Name WHEN 'Author' THEN Author END ASC, CASE @sSort WHEN 'Downloads' THEN Downloads WHEN 'RatingAverage' THEN RatingAverage END DESC, CASE @sSort WHEN 'UpdatedDate' THEN UpdatedDate END DESC . |
| Job-Ende |
SQL-Ausführung beendet: Datei 03.01.02.SqlDataProvider |
| |
| Info |
Ausführen03.01.03.SqlDataProvider |
| Starte Job |
Starte SQL-Ausführung: Datei 03.01.03.SqlDataProvider |
| Abbruch |
Die SQL-Ausführung hat folgende Fehler verursacht: System.Data.SqlClient.SqlException: 'grmAttributeCount' wird nicht als Funktionsname erkannt. 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 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE FUNCTION grmCheckAllAttributes ( @tcList VARCHAR(150), @tcDelimiter char(1), @ItemID int ) RETURNS INT AS BEGIN DECLARE @lcListWork varchar(150), @lnCommaPos int, @lcItem varchar(150), @hasAttributes int SET @lcListWork = @tcList SET @hasAttributes = 1 WHILE LEN(@lcListWork) > 0 BEGIN SET @lnCommaPos = CHARINDEX(@tcDelimiter, @lcListWork) IF @lnCommaPos > 0 BEGIN SET @lcItem = SUBSTRING(@lcListWork, 1, @lnCommaPos - 1) SET @lcListWork = SUBSTRING(@lcListWork, @lnCommaPos + 1, LEN(@lcListWork) - @lnCommaPos) END ELSE BEGIN SET @lcItem = @lcListWork SET @lcListWork = '' END IF @lcItem <> '' AND grmAttributeCount(@ItemID, CONVERT(int, @lcItem)) = 0 SET @hasAttributes = 0 END RETURN @hasAttributes END System.Data.SqlClient.SqlException: 'grmGetCategoryItemCount' wird nicht als Funktionsname erkannt. 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 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE procedure grmGetRepositoryCategories @ModuleID int as select *, grmGetCategoryItemCount(ItemID) as Count from grmRepositoryCategories where ModuleID = @ModuleID ORDER BY ViewOrder System.Data.SqlClient.SqlException: 'grmCheckAllAttributes' wird nicht als Funktionsname erkannt. 'grmCheckAllAttributes' wird nicht als Funktionsname erkannt. 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 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE procedure grmGetRepositoryObjects ( @ModuleID int, @sFilter nvarchar(256), @sSort nvarchar(100), @Approved int, @CategoryId int, @Attributes nvarchar(150), @RowCount int ) AS BEGIN IF @RowCount > 0 SET ROWCOUNT @RowCount END BEGIN IF @CategoryId = -1 SELECT a.*, (SELECT COUNT(grmRepositoryComments.ItemID) FROM grmRepositoryComments WHERE grmRepositoryComments.ObjectID=a.ItemID) AS CommentCount FROM grmRepositoryObjects a WHERE a.ModuleID = @ModuleID AND (a.Approved = @Approved) AND (@Attributes = '' OR grmCheckAllAttributes(@Attributes,';',a.ItemID) = 1) AND ( @sFilter = '' OR UPPER(a.Name) LIKE UPPER('%' + @sFilter + '%') OR UPPER(a.Author) LIKE UPPER('%' + @sFilter + '%') OR UPPER(a.AuthorEMail) LIKE UPPER('%' + @sFilter + '%') OR a.Description LIKE '%' + @sFilter + '%' ) ORDER BY CASE @sSort WHEN 'Name' THEN a.Name WHEN 'Author' THEN a.Author END ASC, CASE @sSort WHEN 'Downloads' THEN a.Downloads WHEN 'RatingAverage' THEN a.RatingAverage END DESC, CASE @sSort WHEN 'UpdatedDate' THEN a.UpdatedDate END DESC ELSE SELECT a.*, (SELECT COUNT(grmRepositoryComments.ItemID) FROM grmRepositoryComments WHERE grmRepositoryComments.ObjectID=a.ItemID) AS CommentCount FROM grmRepositoryObjects a, grmRepositoryObjectCategories b WHERE a.ModuleID = @ModuleID AND (a.Approved = @Approved) AND (a.ItemID = b.ObjectID AND b.CategoryId = @CategoryId) AND (@Attributes = '' OR grmCheckAllAttributes(@Attributes,';',a.ItemID) = 1) AND ( @sFilter = '' OR UPPER(a.Name) LIKE UPPER('%' + @sFilter + '%') OR UPPER(a.Author) LIKE UPPER('%' + @sFilter + '%') OR UPPER(a.AuthorEMail) LIKE UPPER('%' + @sFilter + '%') OR a.Description LIKE '%' + @sFilter + '%' ) ORDER BY CASE @sSort WHEN 'Name' THEN a.Name WHEN 'Author' THEN a.Author END ASC, CASE @sSort WHEN 'Downloads' THEN a.Downloads WHEN 'RatingAverage' THEN a.RatingAverage END DESC, CASE @sSort WHEN 'UpdatedDate' THEN a.UpdatedDate END DESC END . |
|
| |
|
|
 | |
|
|
 |
Joined: 11/18/2005
Posts: 156
|
|
|
Congratulations for the new version. I have two questions:
1- Upgrading from the previous version, do I need just to install the new one as a new module?
2- The title of each item listed by the Repository used to be limited in text. for example, I usually list presentation downloads, with the title of the session + speaker. I always fail to include both, because of the length of the title limitation, is this solved or any workaround for this?
Thanks and good luck.
|
| |
|
|
| |
|
|
 |
|
Joined: 3/4/2003
Posts: 2111
|
|
|
1. just install the new version over the old one
2. the length of the title field has not changed, however if you're not using both the summary ( the default template does not use the summary field ) and the description fields, simply change the [TITLE] tag to [SUMMARY] in both the template.html and form.html template files, then you can have a 'title' of unlimited length.
|
| |
|
|
| |
|
|
|
Joined: 8/10/2003
Posts: 3594
|
|
|
Hello Steve,
I have post the error message that i get in the logfile by SQL Provider 03.01.02 and 03.01.03 . Sorry they are in german laugauge.
In adittion i will give you the following information.
It was my first install of a reporsity module. I used DNN 4.0.3. On a Windows 2003 Hosting with MS SQL 2000 database.
The error are only by starting the SQL Provider command of version 03.01.02 and 03.01.03 . ( See my previous post).
Regards
Matthias
|
| |
|
|
| |
|
|
|
Joined: 11/18/2005
Posts: 156
|
|
|
Hello Steve:
I have done as you said in the following two places:
Form.html:
<TR style="padding-bottom: 8px;">
<TD ALIGN="Left" VALIGN="Top" WIDTH="150">[DNNLABEL:Title]</TD>
<TD ALIGN="Left" VALIGN="Top">[SUMMARY]</TD>
</TR>
Template.html:
<TD CLASS="Head" ALIGN="Left" VALIGN="Middle" style="padding-left: 3px;">[SUMMARY]</TD>
However, when I go to upload a new file, I can see the "rich text editor" which I guess now represents the SUMMARY tag and I can't see any other field below the rich text editor. There are no controls to upload a new file or even update the current record.
I tried that with both the default and filelist templates and both same result. Can you help please?
Thanks,
|
| |
|
|
| |