| Author |
 Topic  |
|
twin
New Member
78 Posts |
 Posted - 19 July 2002 : 05:05:43
|
Hi all,
i implemented the event-mod to my Intranet-Forum, Version 3.3.03 running with SQL-Server 7.0. The Forum is running fine and i recently implemented the active_users-mod without any Problems, but:
When i try to add a new event i'm running into following Error:
Kompilierungsfehler in Microsoft VBScript- Fehler '800a03ea'
Syntaxfehler
/iisHelp/common/500-100.asp, line 122
on error go to 0
---------^
Microsoft OLE DB Provider for ODBC Drivers- Fehler '80040e21'
Fehler bei einer aus mehreren Schritten bestehenden OLE DB-Operation.
Prüfen Sie die einzelnen OLE DB-Statuswerte, falls vorhanden. Daten wurden nicht verarbeitet .
/forum/events.asp, line 1328
And this is line 1328:
if (rs("PRIVATE") <> 1) or (rs("PRIVATE") = 1 and lcase(rs(strDBNTSQLNAME)) = lcase(strDBNTUSerName)) then%>
<br>
<table align="center" width="95%" cellpadding="0" cellspacing="0" border="0" bgcolor="gray">
<tr>
<td>
<table WIDTH="100%" CELLSPACING="1" BORDER="0" CELLPADDING="3" align="center">
<tr>
<td align="left" bgcolor="<% =strHeadCellColor %>"><b><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strHeadFontColor %>">
<%Response.Write Trim(Rs("Event_Title"))
line 1328 strMessage = Rs("Event_Details")%>
<%
if not(memberErased) then
Response.Write " - hinzugefügt von " & lcase(rs(strDBNTSQLNAME))
else
Response.Write " - hinzugefügt durch gelöschtes Mitglied"
end if
I know there was Profile-Bug (the wrong order of Variables) throwing the same Error, so may be the Problem is similar.
Thank you very much for any Help !!
twin
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 19 July 2002 : 05:20:50
|
quote:
I know there was Profile-Bug (the wrong order of Variables) throwing the same Error, so may be the Problem is similar.
Yes that is extremely likely.
Try finding the select query that will be earlier up in the code and make sure event_detals is the LAST column selected.
Heres the original thread on the MOD, a few people did mention similar problems with that field and I think changing the order in the select worked for them
http://forum.snitz.com/forum/topic.asp?ARCHIVE=true&whichpage=4&TOPIC_ID=4463
www.daoc-halo.com
Edited by - Gremlin on 19 July 2002 05:21:25 |
 |
|
|
twin
New Member
78 Posts |
Posted - 19 July 2002 : 06:06:50
|
Thanks a lot for immediate Response Gremlin !!!!
I will try out and post here again.
twin
|
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 19 July 2002 : 06:10:24
|
it is because event_details is a memo type field, so it must me declared at the end of your select statement, and if there are multiple memo fields, they should be assigned to local variabls imediately after the queery is executed, and in the order in which they appear in the select statement, this is due to some quirk of the ADO drivers
|
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 19 July 2002 : 06:32:47
|
Your welcome Twin, hope the fix works ok for you.
www.daoc-halo.com |
|
|
|
twin
New Member
78 Posts |
Posted - 19 July 2002 : 07:06:49
|
Hi Gremlin,
as described in the Topic i changed all select-queries from:
"SELECT event_id, start_date, end_date, event_title, event_details, PRIVATE FROM "
to
"SELECT event_id, start_date, end_date, event_title, PRIVATE, event_details FROM "
But that doesn't change anything. Same Error.
When i take out line 1328, this error doesn't occur, but there are following other errors then, so that can't be the Solution.
What can i do ???
|
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 19 July 2002 : 10:01:27
|
That is weird, I did expect that change to fix it. What other errors occur when you comment out that line ?
I've compared your code posted with the code from my own forum and It looks identical so should work (as mine does)
www.daoc-halo.com |
|
|
|
twin
New Member
78 Posts |
Posted - 19 July 2002 : 10:27:57
|
Hi gremlin, Hi HuwR !!
Without line 1328 i can add an event but when i view the calendar by months then i get the following:
Kompilierungsfehler in Microsoft VBScript- Fehler '800a03ea'
Syntaxfehler
/iisHelp/common/500-100.asp, line 122
on error go to 0
---------^
ADODB.Recordset- Fehler '800a0cc1'
Ein Objekt, das dem angeforderten Namen oder dem Ordinalverweis entspricht, kann nicht gefunden werden.
/forum/events.asp, line 1107
Line 1107: If ((rs("PRIVATE") <> 1) or ((rs("PRIVATE") = 1) and (lcase(rs(strDBNTSQLNAME)) = lcase(strDBNTUSerName)))) and (dToday >= strToDate(Rs("Start_Date")) AND dToday <= strToDate(Rs("End_Date"))) then
Sorry for my bad english and my "not existing" ASP-Knowledge :)
Perhaps you can send me your events.asp ?
Edit: Oh, i've forgotten soemthing. Do i have to change only the Select-Statements or the update, create....., too ??
twin
Edited by - twin on 19 July 2002 10:32:50 |
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
|
|
twin
New Member
78 Posts |
Posted - 19 July 2002 : 11:18:17
|
Sorry,
this events.asp isn't working because there have to be included Files like events_styles.asp, events_functions.asp .... which i don't have here.
this File is only 12 KB. The Original events.asp is 57 KB.
Maybe this have something to do with the wrong Date-Format of the Forum ? In Admin-Panel i choosed UK-Short.
By the way, it's Germany....
i really like to get this working, because i like this mod.
|
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 19 July 2002 : 12:15:43
|
quote:
Sorry,
this events.asp isn't working because there have to be included Files like events_styles.asp, events_functions.asp .... which i don't have here.
If you don't have these files, then what version are you using, you should if you are using the latest version
|
|
|
|
twin
New Member
78 Posts |
Posted - 19 July 2002 : 18:42:39
|
quote:
i implemented the event-mod to my Intranet-Forum, Version 3.3.03 running with SQL-Server 7.0
It's the german Version Snitz 4 Beta 3
|
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 19 July 2002 : 20:23:20
|
I think Huwr was asking what version of the Calendar MOD are you using. The latest version has much of the functions split out into separate include files now. I wondered when you said it was line 1328 how you had a file that large as with mine that particular piece of code was in events_functions.asp not events.asp
Perhaps you should try downloading and trying the most current version of the mod, it should be available at the Exchange
www.daoc-halo.com |
|
|
|
twin
New Member
78 Posts |
Posted - 21 July 2002 : 08:24:03
|
Thank you Gremlin,
i didn't know that there is a newer Version of events, so i try to use the newest Version with the non-US-update now.
i'll be back tomorrow :-)
twin
|
|
|
|
twin
New Member
78 Posts |
Posted - 23 July 2002 : 12:25:07
|
Well,
i implemented the most current Version of Events Mod with the non-US-update and it works !!!
But:
i normally use this Date-Format: TT.MM.YYYY and not TT/MM/YY. But whatever Date-Format i choose in Admin-Panel, the events always appear in DD/MM/YY. For what then is the non-US-update ??
When i can get this short Date-Problem running, i would be happy and i can live with the english Language in Events Calendar :-)
Or is there an german Patch ? ;-)
twin
Edit: Is there any way to delete Events ?? I put on my glasses but i can't find anything.......
Edit2: Oops, i found this very, very small :-) trashcan, sorry.
Edited by - twin on 23 July 2002 12:52:06
Edited by - twin on 23 July 2002 12:55:31 |
|
|
|
twin
New Member
78 Posts |
Posted - 25 July 2002 : 04:58:25
|
Push up
Nobody who knows about the Date-Format ?
twin
|
|
|
|
Topic |
|
Topic Locked
