Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS Access
 Errors with Active User MOD
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Flaimo
New Member

Austria
72 Posts

Posted - 18 June 2001 :  12:17:22  Show Profile  Visit Flaimo's Homepage  Send Flaimo an AOL message  Send Flaimo an ICQ Message  Send Flaimo a Yahoo! Message
i have installed the avatar, topic sorting, PM, sliding menu, active user and Links Manager MOD and i've converted the database to the access 2000 format. all forums except for one work fine.

http://www.charmed-net.de/forum/forum.asp?FORUM_ID=21&CAT_ID=5&Forum_Title=Charmed+vs%2E+Premiere+%7C+TV3+%7C++The+WB

i get this error:


Microsoft JET Database Engine-Fehler '80040e14'

Invalid use of vertical bars in query expression ''<a href="forum.asp?FORUM_ID=21&CAT_ID=5&Forum_Title=Charmed+vs''%''2E+Premiere+''%''7C+TV3+''%''7C++The+WB">Charmed vs. Premiere '|' TV3 '|' The WB</a>''.

/forum/inc_top.asp, Zeile 188



line 188 is that, so i guess it might have to do with the active user mod:

'This will be EOF or BOF for Guests if it's a different IP and for Registered users if they are not currently in the table
if rsWho.eof or rsWho.bof then
' THEY ARE A NEW USER SO INSERT THERE USERNAME
on error resume next
Set objRS2 = Server.CreateObject("ADODB.Recordset")
strSQL = "INSERT INTO " & strTablePrefix & "ONLINE (UserID,UserIP,DateCreated,CheckedIn,LastChecked,M_BROWSE) VALUES ('"
strSql = strSQL & strOnlineUser & "','" & strOnlineUserIP & "','" & strOnlineDate & "','" & strOnlineCheckInTime & "','" & strOnlineCheckInTime & "','" & strOnlineLocation & "')"
my_Conn.Execute (strSql)
if err.number <> 0 then response.write err.number & "|" & err.description
else
' THEY ARE A ACTIVE USER
' If they are a guest their IPs still match, if they are a registered user just the name matchs
If Left( strOnlineUser, 5 ) = "Guest" Then
strSql = "UPDATE " & strTablePrefix & "ONLINE SET M_BROWSE='" & strOnlineLocation & "' , LastChecked='" & strOnlineCheckInTime & "' WHERE UserIP='" & strOnlineUserIP & "' AND UserID ='Guest'"
else
strSql = "UPDATE " & strTablePrefix & "ONLINE SET M_BROWSE='" & strOnlineLocation & "' , LastChecked='" & strOnlineCheckInTime & "', UserIP= '" & strOnlineUserIP & "' WHERE UserID='" & strOnlineUser & "'"
end if
my_Conn.Execute (strSql)


flaimo,

http://flaimo.com/famousfonts

Edited by - flaimo on 18 June 2001 12:19:22

Edited by - flaimo on 19 June 2001 18:54:03

Flaimo
New Member

Austria
72 Posts

Posted - 18 June 2001 :  12:28:18  Show Profile  Visit Flaimo's Homepage  Send Flaimo an AOL message  Send Flaimo an ICQ Message  Send Flaimo a Yahoo! Message
ok, no i know what is meant by "vertical bars". The Forumtitle was "Charmed vs. Premiere | TV3 | The WB". I changed it to "Charmed vs. Premiere / TV3 / The WB" and now it works again. but i don't know why a "|" causes problems....
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 18 June 2001 :  14:10:49  Show Profile  Visit HuwR's Homepage
I think you will find it is because of the active_users mod and the bad wordfilter, as the filter uses | as the delimeter.

The active users mod passes the forum title through the formatstr function which calls the badwordfilter

Go to Top of Page

Flaimo
New Member

Austria
72 Posts

Posted - 19 June 2001 :  18:58:22  Show Profile  Visit Flaimo's Homepage  Send Flaimo an AOL message  Send Flaimo an ICQ Message  Send Flaimo a Yahoo! Message
ok, i've changed the title of the topic, maybe someone can move it to the right forum...


i get another error at the same line number. this time it's

Microsoft JET Database Engine-Fehler '80040e57'
The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.
/forum/inc_top.asp, Zeile 188



this error only comes up if you want to write an answer on that topic:

http://www.charmed-net.de/forum/topic.asp?TOPIC_ID=1214&FORUM_ID=11&CAT_ID=4&Topic_Title=1+Staffel+auf+nur+einer+Cassette+geht+das+den%3F&Forum_Title=Fanartikel+%2F+Tauschb%F6rse

all other topics seem to work; i can write answers for those
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.36 seconds. Powered By: Snitz Forums 2000 Version 3.4.07