| Author |
 Topic  |
|
masterao
Senior Member
Sweden
1678 Posts |
|
|
VodkaFish
Average Member
USA
654 Posts |
 Posted - 16 January 2003 : 22:14:28
|
I get this all the time:
Microsoft JET Database Engine error '80004005'
Record is deleted.
/forums/inc_func_common.asp, line 247
The function is this one:
sub deleteInactiveUsers()
strAUTimedOut = DateToStr(DateAdd("n",-strAUTimeout,strForumTimeAdjust))
strSql = "DELETE FROM " & strTablePrefix & "ACTIVE_USERS WHERE AU_LASTACTIVETIME < '" & strAUTimedOut & "'"
my_conn.execute (strSql)
end sub
Did I not upgrade something? Miss a bug fix somewhere? Is my database just real slow because of heavy traffic? (I'm using Access 2000 for the moment). |
v ø d k â f ï § h |
 |
|
|
jmarkling
Starting Member
Denmark
34 Posts |
Posted - 17 January 2003 : 06:32:33
|
Mine version of 4 14 works 98% of the time when Viewing "Active Users" but sometimes, I get this error.
Microsoft OLE DB Provider for SQL Server error '80040e14'
Line 1: Incorrect syntax near '='.
/forum/active_users.asp, line 413
www.pw3.dk/forum |
JEM |
Edited by - jmarkling on 17 January 2003 10:11:04 |
|
|
|
tomasalsbro
Average Member
Sweden
818 Posts |
Posted - 17 January 2003 : 07:59:52
|
I got this error message after implementing Active Users:
in Modifie the Profile:
============
Microsoft JET Database Engine error '80040e57'
The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.
/forum/pop_profile.asp, line 1560
============
What has gone wrong?
Tomas
|
!-Keep distance in traffic-!
www.whiplashinfo.se |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 17 January 2003 : 13:15:31
|
quote:
Originally posted by VodkaFish
I get this all the time:
Microsoft JET Database Engine error '80004005'
Record is deleted.
/forums/inc_func_common.asp, line 247
The function is this one:
sub deleteInactiveUsers()
strAUTimedOut = DateToStr(DateAdd("n",-strAUTimeout,strForumTimeAdjust))
strSql = "DELETE FROM " & strTablePrefix & "ACTIVE_USERS WHERE AU_LASTACTIVETIME < '" & strAUTimedOut & "'"
my_conn.execute (strSql)
end sub
Did I not upgrade something? Miss a bug fix somewhere? Is my database just real slow because of heavy traffic? (I'm using Access 2000 for the moment).
I assume that everything else works as it should, or?
Im not familiar with that error msg, so Im not exactly sure what the problem could be.
Do you have many visitors online at your site at the same time? What value have you set the AU-timeout to? |
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 17 January 2003 : 13:21:40
|
quote:
Originally posted by jmarkling
Mine version of 4 14 works 98% of the time when Viewing "Active Users" but sometimes, I get this error.
Microsoft OLE DB Provider for SQL Server error '80040e14'
Line 1: Incorrect syntax near '='.
/forum/active_users.asp, line 413
Change all instances of topic_id to TOPIC_ID in the function WhatPage(fScript, fQuery) in active_users.asp. That is also mentioned in this topic as a bug-fix, IIRC. |
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 17 January 2003 : 13:26:33
|
quote:
Originally posted by tomasalsbro
I got this error message after implementing Active Users:
in Modifie the Profile:
============
Microsoft JET Database Engine error '80040e57'
The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.
/forum/pop_profile.asp, line 1560
============
What has gone wrong?
Tomas
That is a bit difficult to say without some further info.
I noticed that you posted this in it's own topic, and you seem to get good help there. It is better that you continue follow that topic instead for this one. |
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
VodkaFish
Average Member
USA
654 Posts |
Posted - 17 January 2003 : 16:20:27
|
quote:
Originally posted by masterao
[quote]Originally posted by VodkaFish
I assume that everything else works as it should, or?
Im not familiar with that error msg, so Im not exactly sure what the problem could be.
Do you have many visitors online at your site at the same time? What value have you set the AU-timeout to?
Everything else does work very well. If I hit refresh, the error generally goes away.
I usually have 20-40 users on the forums at a time. Hits 50s every couple of days, more once in a while (record still gets reset a lot for me).
The timeout is set to 5 minutes. |
v ø d k â f ï § h |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 17 January 2003 : 20:12:02
|
The error could be because of the # of concurrent visitors and the short timeout period, but it could also be because of something else. How large is your database at the moment?
Im not that well-read on access to explain that error, but perhaps someone else knows more about it? |
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
VodkaFish
Average Member
USA
654 Posts |
Posted - 17 January 2003 : 22:46:35
|
| I'm under the impression it's because of too many users and a slow setup. I'm moving my site within days now, so I'll wait to see if I still run into the error. |
v ø d k â f ï § h |
|
|
|
stwilson
Junior Member
USA
385 Posts |
Posted - 18 January 2003 : 02:11:14
|
I have a problem where my Active Users Record is getting reset. A few days ago I was at 40, not it's down to 33. I have scanned this thread, so if I missed the answer I apologize. Has anyone else had this problem?
Shannon |
Shannon
RidingArizona.com |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 18 January 2003 : 05:11:39
|
Vodkafish, that could indeed be the reason.
Shannon, there has been a few posts reporting that the record has been reset. There hasn't been any solutions presented for the problem, since the last time when everyone experienced it and a fix was incorporated into the code. What setup do you have on your forum (server-setup, forum-version, db-type)? |
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
stwilson
Junior Member
USA
385 Posts |
Posted - 18 January 2003 : 09:04:20
|
Jan,
I am on 3.4.03 on SQL. Thank you for your reply.
Shannon |
Shannon
RidingArizona.com |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 18 January 2003 : 10:36:46
|
IIRC, the problem with the record being reset has been raised by a few who have used an sql-database, but I may be wrong on this.
Shannon and stwilson, do you know the situations in which the record has been reset? |
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
Edited by - masterao on 18 January 2003 10:51:37 |
|
|
|
jmarkling
Starting Member
Denmark
34 Posts |
Posted - 18 January 2003 : 10:41:36
|
quote:
Originally posted by masterao
quote:
Originally posted by jmarkling
Mine version of 4 14 works 98% of the time when Viewing "Active Users" but sometimes, I get this error.
Microsoft OLE DB Provider for SQL Server error '80040e14'
Line 1: Incorrect syntax near '='.
/forum/active_users.asp, line 413
Change all instances of topic_id to TOPIC_ID in the function WhatPage(fScript, fQuery) in active_users.asp. That is also mentioned in this topic as a bug-fix, IIRC.
Sry sometimes I just can't make the effort to spend time looking trough 12 pages of bugs and errors...
Well I looked at the function and I cant find any pure topic_id instans either the are ftopic_id or TOPIC_ID and If I run a findAndReplace it will replace a few, but then it won't work on the server...
function WhatPage(fScript, fQ)
fQuery = fQ
strPage = "<a href=""" & fScript
if trim(fQuery) <> "" then
strPage = strPage & "?" & fQuery
end if
strPage = strPage & """>"
select case lcase(trim(fScript))
case "active.asp"
strPage = strPage & fLang(strLangMOD_Ls3kAU_01160)
case "cal.asp"
strPage = strPage & strCalEventsCalendar
case "members.asp"
strPage = strPage & fLang(strLangMOD_Ls3kAU_01170)
case "search.asp"
strPage = strPage & fLang(strLangMOD_Ls3kAU_01180)
case "faq.asp"
strPage = strPage & fLang(strLangMOD_Ls3kAU_01190)
case "policy.asp"
strPage = strPage & fLang(strLangMOD_Ls3kAU_01200)
case "register.asp"
strPage = strPage & fLang(strLangMOD_Ls3kAU_01210)
case "active_users.asp"
strPage = strPage & fLang(strLangMOD_Ls3kAU_01220)
case "default.asp"
strPage = strPage & fLang(strLangMOD_Ls3kAU_01230)
case "members.asp"
strPage = strPage & fLang(strLangMOD_Ls3kAU_01240)
case "post_info.asp"
strPage = strPage & fLang(strLangMOD_Ls3kAU_01241)
case "pop_profile.asp"
if instr(lcase(fQuery), "display") then
strPage = strPage & fLang(strLangMOD_Ls3kAU_01250)
else
strPage = fLang(strLangMOD_Ls3kAU_01260)
end if
case "forum.asp"
strQuery = fQuery
fForum_ID = analyzeQuery(strQuery, "FORUM_ID")
if fForum_ID = "" then
strPage = fLang(strLangMOD_Ls3kAU_01270)
else
strSql = "SELECT F_SUBJECT FROM " & strTablePrefix & "FORUM WHERE FORUM_ID=" & fForum_ID
set rst = my_conn.execute(strSql)
if rst.EOF or rst.BOF then
strPage = fLang(strLangMOD_Ls3kAU_01270)
else
fSubject = rst("F_SUBJECT")
rst.close
set rst = nothing
if chkForumAccess(fForum_ID, MemberID, false) then
strQuery = fQuery
if lcase(analyzeQuery(strQuery, "ARCHIVE")) = "true" then
strPage = fLang(strLangMOD_Ls3kAU_01280) & "<br><a href=""forum.asp?" & fQuery & """>"
else
strPage = fLang(strLangMOD_Ls3kAU_01290) & "<br><a href=""forum.asp?" & fQuery & """>"
end if
strPage = strPage & fSubject
else
strPage = fLang(strLangMOD_Ls3kAU_01300)
end if
end if
end if
case "topic.asp"
strQuery = fQuery
fTopic_ID = analyzeQuery(strQuery, "TOPIC_ID")
if fTopic_ID = "" then
strPage = fLang(strLangMOD_Ls3kAU_01270)
else
strQuery = fQuery
if lcase(analyzeQuery(strQuery, "ARCHIVE")) = "true" then
strSql = "SELECT FORUM_ID, TOPIC_ID, T_SUBJECT FROM " & strTablePrefix & "A_TOPICS WHERE TOPIC_ID=" & fTopic_ID
else
strSql = "SELECT FORUM_ID, TOPIC_ID, T_SUBJECT FROM " & strTablePrefix & "TOPICS WHERE TOPIC_ID=" & fTopic_ID
end if
set rst = my_conn.execute(strSql)
if rst.EOF or rst.BOF then
strPage = fLang(strLangMOD_Ls3kAU_01270)
else
fSubject = rst("T_SUBJECT")
fForum_ID = rst("FORUM_ID")
rst.close
set rst = nothing
if chkForumAccess(fForum_ID, MemberID, false) then
strQuery = fQuery
if lcase(analyzeQuery(strQuery, "ARCHIVE")) = "true" then
strPage = fLang(strLangMOD_Ls3kAU_01310) & "<br><a href=""topic.asp?" & fQuery & """>"
else
strPage = fLang(strLangMOD_Ls3kAU_01320) & "<br><a href=""topic.asp?" & fQuery & """>"
end if
strPage = strPage & fSubject
else
strOnlineLocation = fLang(strLangMOD_Ls3kAU_01330)
end if
end if
end if
case "post.asp"
strQuery = fQuery
fMethod = analyzeQuery(strQuery, "method")
if lcase(fMethod) = "topicquote" OR lcase(fMethod) = "replyquote" then
fMethod = "reply"
end if
select case lcase(fMethod)
case "reply"
strQuery = fQuery
fTopic_ID = analyzeQuery(strQuery, "TOPIC_ID")
strQuery = fQuery
fForum_ID = analyzeQuery(strQuery, "FORUM_ID")
if fTopic_ID = "" or fForum_ID = "" then
strPage = fLang(strLangMOD_Ls3kAU_01270)
else
strSql = "SELECT T_SUBJECT FROM " & strTablePrefix & "TOPICS WHERE TOPIC_ID=" & fTopic_ID
set rst = my_conn.execute(strSql)
if rst.EOF or rst.BOF then
strPage = fLang(strLangMOD_Ls3kAU_01270)
else
fSubject = rst("T_SUBJECT")
rst.close
set rst = nothing
if chkForumAccess(fForum_ID, MemberID, false) then
strPage = fLang(strLangMOD_Ls3kAU_01340) & "<br><a href=""link.asp?TOPIC_ID=" & fTopic_ID & """>"
strPage = strPage & fSubject
else
strOnlineLocation = fLang(strLangMOD_Ls3kAU_01350)
end if
end if
end if
case "edit"
strQuery = fQuery
fTopic_ID = analyzeQuery(strQuery, "TOPIC_ID")
strQuery = fQuery
fForum_ID = analyzeQuery(strQuery, "FORUM_ID")
if fTopic_ID = "" or fForum_ID = "" then
strPage = fLang(strLangMOD_Ls3kAU_01270)
else
strSql = "SELECT T_SUBJECT FROM " & strTablePrefix & "TOPICS WHERE TOPIC_ID=" & fTopic_ID
set rst = my_conn.execute(strSql)
if rst.EOF or rst.BOF then
strPage = fLang(strLangMOD_Ls3kAU_01270)
else
fSubject = rst("T_SUBJECT")
rst.close
set rst = nothing
if chkForumAccess(fForum_ID, MemberID, false) then
strPage = fLang(strLangMOD_Ls3kAU_01351) & "<br><a href=""link.asp?TOPIC_ID=" & fTopic_ID & """>"
strPage = strPage & fSubject
else
strOnlineLocation = fLang(strLangMOD_Ls3kAU_01352)
end if
end if
end if
case "topic"
strQuery = fQuery
fForum_ID = analyzeQuery(strQuery, "FORUM_ID")
if fForum_ID = "" then
strPage = fLang(strLangMOD_Ls3kAU_01270)
else
strSql = "SELECT F_SUBJECT FROM " & strTablePrefix & "FORUM WHERE FORUM_ID=" & fForum_ID
set rst = my_conn.execute(strSql)
if rst.EOF or rst.BOF then
strPage = fLang(strLangMOD_Ls3kAU_01270)
else
fSubject = rst("F_SUBJECT")
rst.close
set rst = nothing
if chkForumAccess(fForum_ID, MemberID, false) then
strPage = fLang(strLangMOD_Ls3kAU_01360) & "<br><a href=""link.asp?FORUM_ID=" & fForum_ID & """>"
strPage = strPage & fSubject
else
strOnlineLocation = fLang(strLangMOD_Ls3kAU_01370)
end if
end if
end if
case "edittopic"
strQuery = fQuery
fTopic_ID = analyzeQuery(strQuery, "TOPIC_ID")
strQuery = fQuery
fForum_ID = analyzeQuery(strQuery, "FORUM_ID")
if fTopic_ID = "" or fForum_ID = "" then
strPage = fLang(strLangMOD_Ls3kAU_01270)
else
strSql = "SELECT T_SUBJECT FROM " & strTablePrefix & "TOPICS WHERE TOPIC_ID=" & fTopic_ID
set rst = my_conn.execute(strSql)
if rst.EOF or rst.BOF then
strPage = fLang(strLangMOD_Ls3kAU_01270)
else
fSubject = rst("T_SUBJECT")
rst.close
set rst = nothing
if chkForumAccess(fForum_ID, MemberID, false) then
strPage = fLang(strLangMOD_Ls3kAU_01371) & "<br><a href=""link.asp?TOPIC_ID=" & fTopic_ID & """>"
strPage = strPage & fSubject
else
strOnlineLocation = fLang(strLangMOD_Ls3kAU_01372)
end if
end if
end if
case else
strPage = strPage & fLang(strLangMOD_Ls3kAU_01380)
end select
case else
strPage = strPage & Mid(fScript, 1, instr(fScript, ".")-1)
end select
strPage = strPage & "</a>"
if lcase(instr(fscript, "admin_")) > 0 Then
strPage = fLang(strLangMOD_Ls3kAU_01380)
end if
WhatPage = strPage
end function
|
JEM |
|
|
|
Topic |
|
Topic Locked
