| Author |
 Topic  |
|
psalesses
New Member
50 Posts |
 Posted - 11 January 2003 : 14:38:58
|
I just tried to install the mod but when I view cal.asp in month view, whereever the event is, it shows up with an error.
go here to see: http://www.alllacrosseamerica.com/usefulstuff/messageboards/cal.asp?view=monthly&date=1/11/2003
How do I fix that? This is the error I got:
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/usefulstuff/messageboards/cal.asp, line 628
< |
 |
|
|
red1
Junior Member
355 Posts |
Posted - 12 January 2003 : 18:45:14
|
odd, I thought I already got rid of this 
can you please try these:
1. Replace lines 581-589 with these:
strSql = "SELECT T.TOPIC_ID, " & _
"T.T_SUBJECT, " & _
"T.T_AUTHOR, " & _
"T.FORUM_ID, " & _
"T.T_STATUS, " & _
"T.T_EVENT_DATE, " & _
"C.CAT_MODERATION, " & _
"F.F_MODERATION, " & _
"T.T_MESSAGE " & _
2. Replace lines 625-633 with these:
Topic_ID = rs("TOPIC_ID")
Topic_Subject = rs("T_SUBJECT")
Topic_Author = rs("T_AUTHOR")
Forum_ID = rs("FORUM_ID")
Topic_Status = rs("T_STATUS")
Event_Date = StrToDate(rs("T_EVENT_DATE"))
Cat_Moderation = rs("CAT_MODERATION")
Forum_Moderation = rs("F_MODERATION")
Topic_Message = rs("T_MESSAGE")
< |
My Mods:
New Events Calendar
New Non-database Active Users |
|
|
|
Chris@Respect
Starting Member
24 Posts |
Posted - 14 January 2003 : 06:43:39
|
| Is it possible to allow just admin or mods to enter events into this?< |
|
|
|
Chris@Respect
Starting Member
24 Posts |
Posted - 15 January 2003 : 12:13:03
|
| Anyone?< |
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 15 January 2003 : 14:46:33
|
| Check line 12 of cal_constants.asp< |
|
|
|
Chris@Respect
Starting Member
24 Posts |
Posted - 16 January 2003 : 04:06:10
|
Thanks a lot laser - Perfect!! < |
|
|
|
jkmcgrath
Junior Member
USA
145 Posts |
Posted - 16 January 2003 : 09:46:40
|
Hi all,
I am having a formatting problem with this mod. Seems it wants to spread out even though I have set the tables to smaller sizes. It is on the day and week views. Month and year is perfect.
Here is a link so you can see what I am talking about.
http://dfseals.com/forum/cal.asp
THanks
John< |
Delta Force Seals |
|
|
|
n/a
deleted
593 Posts |
Posted - 17 January 2003 : 04:42:38
|
Has anyone thought of adjusting an event listing adjusted to a locale time (or adjusted server date/time)?
Here is something that I am trying to figure out how this can be addressed...
I have my forum running on a server (actually Brinkster) which is located somewhere in the EastCoast USA (EST), and my adjusted server time of the forum is -5 (Pacific Time)... and whenever it passes 6pm here the calender starts showing next day (physical server location/server time) and event listing for this day for a next day (tomorrow) and recent/upcoming event listing get confused ... while a small calendar maintain a highlighted on the current locale date (my time)especially when a small calendar is included in index.asp or portal, start generating errors for these, since the portal/website calendar is pulling date/time for an adjusted locale time while calender date/time functions for spooling/sorting event items are executing a real server date/time....
Am not sure whether anyone cares about this issue - as it may not affect people unless they have similar setups like me who is hosting on a server somewhere else on a different time zone and forum server date/time is set differently from the actual server time...
Has anyone modifed to synchronize this, I wonder? Anyone?
TIA< |
Taku
|
Edited by - n/a on 18 January 2003 17:32:26 |
|
|
|
Mountainman
Starting Member
Denmark
9 Posts |
Posted - 18 January 2003 : 16:55:07
|
Hi all.
Hope somebody here can help me.
My problem is, that guests cannot see the monthly view of the calendar. It jumps right to the forum default.asp
Registered users don't have that problem. They can use the Monthly view
Somewhere in the coding I did something wrong, and I can't find it
Please help.
The error can be seen at http://www.sdk-denmark.dk/forum< |
|
|
|
red1
Junior Member
355 Posts |
Posted - 18 January 2003 : 21:23:41
|
jkmcgrath: check the last line of daily and weekly, change this:
"</TD></TR></TABLE></TD></TR></TABLE>" & vbNewLine
to this:
"</TD></TR></TABLE>" & vbNewLine
LeoRat: I know I already fixed this in one of the updates... the calendar now uses the forum date/time instead of the server date/time
Mountainman: Did you change anything in the code? I don't know anything that would do that< |
My Mods:
New Events Calendar
New Non-database Active Users |
|
|
|
n/a
deleted
593 Posts |
Posted - 19 January 2003 : 02:00:22
|
Hi Red1, thanks.
I read references and "fixes" related to setting LCID session to whatever a needed locale/country id #... which I believe makes sense and solve most of the problems associated with different country locations of hosting servers and forum admin... but I didn't really find any mod date/time synchronization based on time zone difference per se (or full synchronization of server date/time settings in FORUM ADMIN OPTIONS)... my case is both are in LCID=1033 but in different time zones. 
I am wondering whether it is possible to add "calendar date/time settings selection" as an additional feature to this mod - basically synchronize settings with Admin Options, this may allow also and additionally allow synchronizaing date formats being used, if two different country/locale locations are involved for the cases like above - eg. server in uk and admin in us, etc. as well. Will it be possible to incorporate some feature likes synchronizing calendar date/time (like Windows?) with atomic time type but with Forum Date/Time set in Admin Options rather than resetting LCID.session but purely on time difference from the default "server/system" date/time A small calendar (on the portal or on the website) is showing correct forum date marked, but event items display are not synchronized by Forum date/time....but executing spooling of events items by server date/time....
Or maybe it's there and am missing something? Seems like this is a feature to have/add for MOD setup or updating??? If I am missing it, would you mind refresh me where I can find this particular settings to "adjust"? I'm using your V617 - the latest - I believe.
Thanks much...from a real fan of this MOD..
< |
Taku
|
Edited by - n/a on 19 January 2003 02:23:48 |
|
|
|
Mountainman
Starting Member
Denmark
9 Posts |
Posted - 19 January 2003 : 09:13:08
|
| Did not change anything, justa added the code bits as described (I think) ......< |
|
|
|
red1
Junior Member
355 Posts |
Posted - 19 January 2003 : 10:38:38
|
Mountainman: I can't reproduce the error that you're talking about; are you using private forums? I'm guessing that the problem is somewhere there and I'll get back to you as soon as I have figured it out.
LeoRat: I'm sorry but I'm not sure I completely understand what you're explaining. The older version of the mod used the ASP Date Function, which returned the server's date. The current version uses strForumTimeAdjust, which is the adjusted to the forum. If the date is wrong in your calendar then you should replace all the instances of the Date function with strForumTimeAdjust< |
My Mods:
New Events Calendar
New Non-database Active Users |
|
|
|
jkmcgrath
Junior Member
USA
145 Posts |
|
|
Mountainman
Starting Member
Denmark
9 Posts |
Posted - 20 January 2003 : 04:50:19
|
I am using private forums. I've set up a testforum, copied all the forum files, set up a new database without private forums and it works there.
It must be something related to the private forums.< |
|
|
|
Topic |
|
MOD: New Events Calendar for 3.4.03 beta
