Author |
Topic |
|
Yodabutt1
Starting Member
32 Posts |
Posted - 23 June 2003 : 15:36:31
|
Hi, I posted a few weeks ago in another topic, but haven't gotten a response...so forgive the somewhat duplication. I've tried twice to implement Red1's Recurring Data calendar on serverhacker mod'd code and also Crash's code. Both include Red1's previous non-recurring events mod. So I've used code compare software and followed the readme, etc.
In every case I get to the point that it displays the events that were previously in the database and migrated with the upgrade script on the calendar. When I submit a new event, it's added to the forum_topics, but not forum_cal_events...(I think that's the controller there) and thus the new event is a topic, but doesn't appear on the calendar.
Can anyone help me here. Red1?? Some1?? I've spent A LOT of time on this. I don't particularly know what i'm doing, but I can compare things pretty well, and don't see the problem.
so to recap, submitting an event creates a topic, but not an actual event.
Everything else seems good....i'm just not getting new events to show up on the calendar. PLEASE help me!!
Thanks!!!!!! |
|
Yodabutt1
Starting Member
32 Posts |
Posted - 02 July 2003 : 13:03:52
|
I've FINALLY got this mod creating events on Crash code. Now i get the following error when I try to edit an event:
Microsoft JET Database Engine error '80040e14'
The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.
/forum/post.asp, line 376
Anyone else had this problem? Know the fix? It's probably my fault..
That line is: set rs = my_Conn.Execute (strSql) so I suspect it's a problem elsewhere actually.
Thanks! |
Edited by - Yodabutt1 on 02 July 2003 13:21:05 |
|
|
rejordan
Starting Member
18 Posts |
Posted - 02 July 2003 : 13:55:59
|
What's strSQL look like at that point? |
|
|
Yodabutt1
Starting Member
32 Posts |
Posted - 03 July 2003 : 10:28:59
|
Here's a section of the code: the line in the error is highlighted in red. Thanks!
if strRqMethod = "EditTopic" or strRqMethod = "TopicQuote" then '## Forum_SQL strSql = "SELECT M.M_NAME, T.CAT_ID, T.FORUM_ID, T.TOPIC_ID, T.T_SUBJECT, T.T_AUTHOR, T.T_STICKY, T.T_ISEVENT, T.T_SIG, T.T_MSGICON, T.T_MESSAGE, " strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS M, " & strActivePrefix & "TOPICS T " strSql = strSql & " WHERE M.MEMBER_ID = T.T_AUTHOR AND T.TOPIC_ID = " & strRqTopicID
set rs = my_Conn.Execute (strSql) TxtSub = rs("T_SUBJECT") strAuthor = rs("T_AUTHOR") if strStickyTopic = "1" then strTopicSticky = rs("T_STICKY") end if
if strRqMethod <> "TopicQuote" then IsEvent = rs("T_ISEVENT") if strRqMethod = "EditTopic" then TxtMsg = rs("T_MESSAGE") MsgIcon = rs("T_MSGICON") else if strRqMethod = "TopicQuote" then TxtMsg = "quote: Originally posted by " & chkString(rs("M_NAME"),"display") & "" & vbNewline TxtMsg = TxtMsg & " " & rs("T_MESSAGE") & vbNewline TxtMsg = TxtMsg & "
" end if end if if Request.QueryString("poll") = "1" then '### Get poll from POLLS table strSql = "SELECT " & strTablePrefix |
|
|
Yodabutt1
Starting Member
32 Posts |
Posted - 14 July 2003 : 14:39:14
|
I finally fixed it myself. |
|
|
jeffery
Junior Member
USA
176 Posts |
Posted - 13 November 2003 : 11:16:18
|
yodabutt did you ever solve the problem with the serverhacker code on this? im having the same problem |
www.thomasforum.com |
|
|
jeffery
Junior Member
USA
176 Posts |
Posted - 13 November 2003 : 16:52:06
|
Has anyone had this problem. The events get posted but do not show on the calendar. |
www.thomasforum.com |
|
|
jeffery
Junior Member
USA
176 Posts |
|
|
Topic |
|