quote:

---

Originally posted by stwilson

I love this mod and I don't even have it working fully yet. Thank you N8PBM. Here are my issues:

Whan I try to signup for an event I get this error:

error '80020009'
Exception occurred.

/new_forum/eventlist.asp, line 373

ADDITIONALLY, after you delete an event it shows this error, even though it does delete the event:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'T_LIST_INCLUDE'.

/new_forum/topic.asp, line 126

Anyone else have these issues? Any thoughts on how to solve this? Thanks.

---

Microsoft JET Database Engine error '80040e10' 

No value given for one or more required parameters. 

/topic.asp, line 115

'########Sign up Mod added T.T_LIST_INCLUDE below########
strSql = "SELECT M.M_NAME, M.M_RECEIVE_EMAIL, M.M_AIM, M.M_ICQ, M.M_MSN, M.M_YAHOO" & _
	", M.M_TITLE, M.M_HOMEPAGE, M.MEMBER_ID, M.M_LEVEL, M.M_POSTS, M.M_COUNTRY" & _
	", T.T_DATE, T.T_SUBJECT, T.T_AUTHOR, T.TOPIC_ID, T.T_STATUS, T.T_LAST_EDIT" & _
	", T.T_LAST_EDITBY, T.T_LAST_POST, T.T_SIG, T.T_REPLIES, T.T_ISEVENT, T.T_LIST_INCLUDE" & _
	", C.CAT_STATUS, C.CAT_ID, C.CAT_NAME, C.CAT_SUBSCRIPTION, C.CAT_MODERATION" & _
	", F.F_STATUS, F.FORUM_ID, F.F_SUBSCRIPTION, F.F_SUBJECT, F.F_MODERATION, T.T_MESSAGE"
if CanShowSignature = 1 then
	strSql = strSql & ", M.M_SIG"
end if
strSql = strSql & " FROM " & strActivePrefix & "TOPICS T, " & strTablePrefix & "FORUM F, " & _ 
	strTablePrefix & "CATEGORY C, " & strMemberTablePrefix & "MEMBERS M " & _
	" WHERE T.TOPIC_ID = " & Topic_ID & _
	" AND F.FORUM_ID = T.FORUM_ID " & _
	" AND C.CAT_ID = T.CAT_ID " & _
	" AND M.MEMBER_ID = T.T_AUTHOR "

set rsTopic = Server.CreateObject("ADODB.Recordset")
rsTopic.open strSql, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText

quote:

---

Originally posted by n8pbm

In the admin_signup.asp page you might try this code to replace Line 31 - 44:

	.....

I have no way of testing it - If it works for the admin screen then we can move to the signup.asp one.

---