| Author |
 Topic  |
|
vmplanet
Junior Member
112 Posts |
 Posted - 24 August 2003 : 17:26:30
|
I have a problem with the following line: (Cal.asp; 1383)
If cLng(arrRqCalForumID) = cLng(ForumForumID) then strOptions = strOptions & " selected"
Changing to:
If int(arrRqCalForumID) = int(ForumForumID) then strOptions = strOptions & " selected"
Doesn't help.
The only thing that helps is deleting the line complety. What does this line do? Is it important? And if so how to fix?
< |
 |
|
|
goldfish
New Member
82 Posts |
Posted - 04 September 2003 : 09:57:46
|
Not sure if this has been picked up yet (don't really have the time to flog through all the pages at the moment) but I spotted a small error in the non-recurring dates version of the Events Calendar.
In cal_default.asp (and cal_defaul_notable.asp) around line 18:-
" <TR><TD colSpan=""" & sgetcolSpan(7,6) & """ align=""center"" bgcolor=""" & strHeadCellColor & """ noWrap vAlign=""top"">" & vbNewLine & _
" <A href=""cal.asp""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strHeadFontColor & """><B>" & strCalEventsCalendar & "</B><FONT></A>" & vbNewLine & _
" </TD></TR>" & vbNewLine & _
This should be </font>...
Hope that helps someone...
Simon< |
Edited by - goldfish on 04 September 2003 09:59:04 |
|
|
|
ki5ck
New Member
69 Posts |
Posted - 08 September 2003 : 10:26:48
|
Just installed this mod, no errors. However, whenver I enter a new event -- no matter what day I put in -- it always uses today's date as the event day.
For example, suppose I want to enter a non-recurring event (a meeting) for next thursday. I enter 9/11/03 for the start and 9/11/03 for the end date. But when I post the topic, the date says 9/8/03. I did it several days ago, and found that it used that day, as well.
I didn't see this issue in the 16 pages here so far. Anybody have an idea?< |
|
|
|
Feen
Starting Member
Canada
9 Posts |
Posted - 19 September 2003 : 14:53:48
|
I'm looking for a copy of this MOD, but the link in the first post does not seem to be working.
Does anyone have a copy or know where I can download one.
Thanks in advance.
Feen.< |
|
|
|
Feen
Starting Member
Canada
9 Posts |
Posted - 22 September 2003 : 12:08:56
|
Anyone?
Help would be appreciates.
Feen.< |
|
|
|
n8pbm
Junior Member
USA
212 Posts |
|
|
Feen
Starting Member
Canada
9 Posts |
Posted - 23 September 2003 : 09:13:17
|
Thanks for the reply Mike, however, the link at Snitz Bitz is the same one that is in the first post of this thread. Right now it is not working =(
Maybe some one has a copy of the zip that they can email me.
Feen.< |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 23 September 2003 : 10:08:45
|
| It works for me at snitzbitz. Do you get an error or something?< |
Support Snitz Forums
|
|
|
|
Feen
Starting Member
Canada
9 Posts |
Posted - 23 September 2003 : 12:33:58
|
/sigh
It works now and I got it. Must have been something with my netowrk, it's been acting up lately.
Thanks to all for your patience.
Feen.< |
|
|
|
k5k
Starting Member
New Zealand
2 Posts |
Posted - 24 September 2003 : 09:35:15
|
installed it easy, worked fine straight away!
cheers< |
www.aklass.com |
|
|
|
Baroudeur
Starting Member
25 Posts |
Posted - 03 October 2003 : 05:21:31
|
Just want to know if there is a way to have a reduction square  on the title bar of calendar, the same there is in forum categories, to hide it or make it appear
Nice mod really, i love it  < |
This account was hacked into by Image, a very honest guy as you all can see! Stealing people's passwords is his pasttime. Beware of this, before you register at his forums! |
Edited by - Baroudeur on 03 October 2003 05:22:10 |
|
|
|
Maikadal
Starting Member
41 Posts |
Posted - 12 October 2003 : 22:15:08
|
OK, I have sucessfully installed the Events Calendar (Thanks guys!) And the Signup Mod. However, when I try to post an event, I get the following error:
Microsoft JET Database Engine error '80040e14'
Number of query values and destination fields are not the same.
/desertchill/forum/post_info.asp, line 867
Line 867 or post_info.asp reads:
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
Is there something wrong with this? Also, I am getting another error from the signup mod when I link to admin_signup.asp (this is part of the signup mod for the calendar). The error is:
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/desertchill/forum/admin_signup.asp, line 49
Line 49 or admin_signup.asp reads:
set rsSQL = my_Conn.Execute (strSql)
Can anyone help me with these two errors? Thanks much.
Maikadal< |
|
|
|
molitar
Starting Member
2 Posts |
Posted - 17 October 2003 : 00:06:43
|
with help of others I was able to fix this problem. The problem is that their is a missing value. Use this to determine what is missing.. Response.Write (strSql) how line should appear below...
strSql = strSql & ", 1 "
strSQL = strSQL & ", 0 "
strSQL = strSQL & ", 0 "
strSQL = strSQL & "," & IsEvent
strSql = strSql & ")"
Response.Write (strSql)
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
Response write will show you all the fields and values below...
INSERT INTO FORUM_TOPICS (FORUM_ID, CAT_ID, T_SUBJECT, T_MESSAGE, T_AUTHOR, T_LAST_POST, T_LAST_POST_AUTHOR, T_LAST_POST_REPLY_ID, T_DATE, T_STATUS, T_IP, T_STICKY, T_SIG, T_ARCHIVE_FLAG, T_REPLIES, T_UREPLIES, T_ISEVENT) VALUES (2, 2, 'test event 2', 'test event 2', 1, '20031016232810', 1, 0 , '20031016232810', 1 , '209.4.40.243', 0 , 0 , 1 , 0 , 0 ,1)
Note the field topics equal 17 and the values equal 17 total. The error happens because they both don't equal the same value.
NOW My error was I accidently replaced the line below instead of pasting below it..
<original code>
strSQL = strSQL & ", 0 "
strSql = strSql & ")"
<replaced code>
strSQL = strSQL & ", 0 "
strSQL = strSQL & "," & IsEvent
strSql = strSql & ")"
<fixed code>
strSQL = strSQL & ", 0 "
strSQL = strSQL & ", 0 "
strSQL = strSQL & "," & IsEvent
strSql = strSql & ")"
< |
|
|
|
Reinsnitz
Snitz Forums Admin
USA
3545 Posts |
Posted - 06 November 2003 : 13:57:50
|
The following code is generated by using the Events List at this address: http://www.hansaforce.com/forum2/cal.asp?view=eventslist using MySQL and stuff.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[MySQL][ODBC 3.51 Driver][mysqld-3.23.54]Invalid use of group function
/forum2/cal.asp, line 1098
The SQL statement generated by the strSQL in that executions is as follows:
SELECT T.TOPIC_ID, T.FORUM_ID, T.CAT_ID, T.T_SUBJECT, T.T_AUTHOR, T.T_STATUS, E.EVENT_DATE, C.CAT_MODERATION, F.F_MODERATION FROM (((FORUM2_TOPICS AS T INNER JOIN FORUM2_CAL_EVENTS AS E ON T.TOPIC_ID = E.TOPIC_ID) INNER JOIN FORUM2_CATEGORY AS C ON T.CAT_ID = C.CAT_ID) INNER JOIN FORUM2_FORUM AS F ON T.FORUM_ID = F.FORUM_ID) INNER JOIN FORUM2_CAL_EVENTS AS E2 ON E.TOPIC_ID = E2.TOPIC_ID WHERE T.T_ISEVENT = 1 AND T.FORUM_ID IN (1) AND E.EVENT_DATE >= '20031106000000' GROUP BY T.TOPIC_ID, T.FORUM_ID, T.CAT_ID, T.T_SUBJECT, T.T_AUTHOR, T.T_STATUS, E.EVENT_DATE, C.CAT_MODERATION, F.F_MODERATION ORDER BY min(E2.EVENT_DATE) Asc, T.TOPIC_ID Asc, E.EVENT_DATE Asc
The code prefixing that line and that line included are as follows (un-edited from original form):
strSql = strSql & _
"GROUP BY T.TOPIC_ID, T.FORUM_ID, T.CAT_ID, T.T_SUBJECT, T.T_AUTHOR, T.T_STATUS, " & _
"E.EVENT_DATE, C.CAT_MODERATION, F.F_MODERATION " & _
"ORDER BY min(E2.EVENT_DATE) Asc, T.TOPIC_ID Asc, E.EVENT_DATE Asc "
set rs = Server.CreateObject("ADODB.Recordset")
rs.open StrSql, My_conn
Any ideas would be greatly apreciated... this is a testing forum, so creating an account and experimenting will not hurt anything.< |
Reinsnitz (Mike) |
|
|
|
Reinsnitz
Snitz Forums Admin
USA
3545 Posts |
Posted - 08 November 2003 : 11:03:36
|
| bump... any ideas? This seems to be an out of the box bug with MySQL and the Group function?< |
Reinsnitz (Mike) |
|
|
|
Topic |
|
|
|
MOD: New Events Calendar for 3.4.03 beta
