He may of just given up lol.
I created an entry for each post and topic in the Sueetie_Content table that was missing one, but now I get an error for the same topic.
Line 182 in TagControl.cs = var _userIDs = TagSueetieForumTopic.SueetieUserIDs.Split('|').Select(n => int.Parse(n)).ToList();
Its having trouble parsing the topic because for some reason the ConcatForumTopicUsers function is passing a value with an extra | at the end.
So i edited the query slightly
Code: select distinct s.UserName, s.UserID
FROM dbo.[yaf_Message] m
JOIN dbo.yaf_topic t
ON t.TopicID = 10
JOIN dbo.yaf_User u ON
m.UserID = u.UserID
JOIN dbo.Sueetie_users s
ON s.Username = u.Name
where m.TopicID = 10 and u.BoardID = 1
All the users exist in the sueetie_Users and yaf_User tables.
SueetieUserIDs value =
Code:"8|8|8|8|8|8|8|11|11|11|11|11|14|14|14|14|14|16|16|16|16|16
|16|16|16|16|16|16|16|18|20|21|22|22|22|22|22|25|26|27|27|27|27
|34|40|43|44|49|56|56|75|75|76|89|89|89|89|89|97|97|97|97|97|97|97|97|97|97|97|"
Code:
Line 180: if (TagSueetieForumTopic != null)
Line 181: {
Line 182: var _userIDs = TagSueetieForumTopic.SueetieUserIDs.Split('|').Select(n => int.Parse(n)).ToList();
Line 183: foreach (int _userID in _userIDs)
Line 184: {
Source File: C:\inetpub\atomo\Sueetie.Controls\Controls\TagControl.cs Line: 182
Stack Trace:
[FormatException: Input string was not in a correct format.]
System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) +10161091
System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) +207
Sueetie.Controls.TagControl.<IsUserTagEditor>b__0(String n) in C:\inetpub\atomo\Sueetie.Controls\Controls\TagControl.cs:182
System.Linq.WhereSelectArrayIterator`2.MoveNext() +110
System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) +258
System.Linq.Enumerable.ToList(IEnumerable`1 source) +44
Sueetie.Controls.TagControl.IsUserTagEditor() in C:\inetpub\atomo\Sueetie.Controls\Controls\TagControl.cs:182
Sueetie.Controls.TagControl.OnInit(EventArgs e) in C:\inetpub\atomo\Sueetie.Controls\Controls\TagControl.cs:260
System.Web.UI.Control.InitRecursive(Control namingContainer) +143
System.Web.UI.Control.AddedControl(Control control, Int32 index) +271
YAF.Pages.posts.Page_Load(Object sender, EventArgs e) in C:\inetpub\atomo\Web\Forum\pages\posts.ascx.cs:274
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +25
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +42
System.EventHandler.Invoke(Object sender, EventArgs e) +0
System.Web.UI.Control.OnLoad(EventArgs e) +132
System.Web.UI.Control.LoadRecursive() +66
System.Web.UI.Control.LoadRecursive() +191
System.Web.UI.Control.LoadRecursive() +191
System.Web.UI.Control.LoadRecursive() +191
System.Web.UI.Control.LoadRecursive() +191
System.Web.UI.Control.LoadRecursive() +191
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2428
Any ideas?
Edited by user Saturday, February 26, 2011 12:29:26 AM(UTC)
| Reason: Not specified