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