OS: Winxp
DB:MSSQL
Version:2.3.1.0

Hi, Joe

When Delete a thread in forums wiht MSSQL(not witt sqlite)  db ,error occurs:

Below code in EditThread.aspx.cs

////////////////////////////////////////////////////////////////////

private void btnDelete_Click(object sender, EventArgs e)
{
ForumThread.Delete(this.threadId);
Forum.UpdateUserStats(-1); // updates all users, error occurs.

if (hdnReturnUrl.Value.Length > 0)
{
WebUtils.SetupRedirect(this, hdnReturnUrl.Value);
return;
}

WebUtils.SetupRedirect(this, SiteUtils.GetCurrentPageUrl());
}
///////////////////////////////////////////////////

Then code go into file SQLParameterHelper.cs:

///////////////////////////////////////////////////////////////////////////////////////////

private void DefineSqlParameter(
String paramName,
SqlDbType type,
int size,
ParameterDirection dir,
object value,
bool sizeProvided)
{
...................
Debug.Assert(arParams[index].Direction == dir, "parameter's direction doesn't match cached parameters");
Debug.Assert(string.Equals(arParams[index].ParameterName,paramName, StringComparison.InvariantCultureIgnoreCase), "parameter's name doesn't match cached parameters");//this errors because  arParams[index].ParameterName  is "@UserID"  but  ParameterName is UserID,lack a @, So error occurs.
Debug.Assert(
((type != SqlDbType.NText)
&& (arParams[index].SqlDbType == type))
||
((type == SqlDbType.NText)
&& (arParams[index].SqlDbType == SqlDbType.NVarChar))
||
((type == SqlDbType.Image)
&& (arParams[index].SqlDbType == SqlDbType.VarBinary))
, "parameter's type doesn't match cached parameters"
);

arParams[index].Value = value;
index++;
}

////////////////////////////////////////////////////////////////////

And maybe have some other problem, because when i delete a thread, the page  can't redirect to the right page.

Thanks!

When delete the last post  of a thread, the page will redirect to a thread that did not exist it results in the access denied page.