workaround for the problem in topic 'no posts possible in moderated forum (YAF 1.9.1)'

ok - I fixed it for me by modifying the stored procedure, that fetches the "LatestTopics" list:

---------------------- snip ----------------------

ALTER PROCEDURE [dbo].[yaf_topic_latest]

---------------------- snip ----------------------

SET @SQL = @SQL + ' WHERE c.BoardID = '
+ CONVERT(VARCHAR,@BoardID)
+ ' AND v.UserID='
+ CONVERT(VARCHAR,@UserID)
+ ' AND (v.ReadAccess <> 0 or (f.Flags & 2) = 0) AND (t.Flags & 8 ) != 8
AND (t.LastMessageID IS NOT NULL)
ORDER BY t.LastPosted DESC'

---------------------- snip ----------------------

The first problem was solved by updating UrlRewriter.config.

The second problem remains:

if you create a new topic in a moderated forum, the LastMessageID remains NULL until the topic is approved.

The problem seems to be, that in page forum.ascx the Repeater control "LatestPosts" accesses this (not approved!) topic and its field LastMessageID.


Aside from the FormatException:
posts that are not approved should not be visible in the list of latest posts or anywhere else !!!


Ina

even worse:

after creating a new topic and receiving the described error, I can no longer acces the Web App at all:

-------------- error message -----------

Input string was not in a correct format.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.FormatException: Input string was not in a correct format.

Source Error:

Line 112: <asp:Repeater runat="server" ID="LatestPosts">
Line 113: <ItemTemplate>
Line 114: &nbsp;<a href='<%#yaf.Forum.GetLink(yaf.Pages.posts,"m={0}#{0}",DataBinder.Eval(Container.DataItem, "LastMessageID")%>'><%# yaf.Utils.BadWordReplace(Convert.ToString(DataBinder.Eval(Container.DataItem, "Topic")) %></a>
Line 115: <a href="<%#yaf.Forum.GetLink(yaf.Pages.posts,"m={0}#{0}",DataBinder.Eval(Container.DataItem, "LastMessageID")%>">
Line 116: <img src="<%# GetThemeContents("ICONS","ICON_LATEST" %>" border="0" alt=""></a><br />


Source File: c:\Inetpub\wwwroot\YAF\pages\forum.ascx Line: 114

..... ( do you need the stack trace ??) .....

-------------- error message -----------

it seems the database is corrupt:
the new topic in Table yaf_Topic has LastMessageID set to null

Ina

me again testing YAF 1.9.1, 9/1/2007


when posting to a moderated forum, I always receive

--------- snip ------------

The resource cannot be found.

Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly.

Requested URL: /YAF/yaf_info.aspx

--------- snip ------------

perhaps something missing in UrlRewriter.config?

(no problems in unmoderated forums)

Ina

in YAF 1.9.1, 9/1/2007

if a moderator is logged in and browses the member list, the moderators "edit signature" panel is always visible when viewing the properties of a user:

that means, when selecting a user, the moderators sees:
- profile panel of the selected user
- admin panel for suspending the selected user
- edit signature panel of the moderator himself

you forgot Intelligencia.UrlRewriter.dll in the BIN distribution ...