Snitz Forums 2000 - Occasional Error when replying to topics...

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Help Groups for Snitz Forums 2000 Users

Help: General / Current Version (Old)

Occasional Error when replying to topics...

New Topic

Topic Locked

Printer Friendly

Author

Topic

dayve
Forum Moderator

USA
5820 Posts

Posted - 18 June 2001 : 23:17:17

This is an intermittent problem....

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/inc_top.asp, line 252

What would cause this error to occur on certain topics?? If I reply with quote the error does not occur.

The url that causes me the problem when replying:

Click here

Here is my inc_top.asp:

http://www.nineinchnailz.com/forum/inc_top.txt

Line 252 is part of this sql statement:

' LETS UPDATE THE TABLE SO IT SHOWS THERE LAST ACTIVE VISIT
strSql = "UPDATE " & strTablePrefix & "ONLINE SET M_BROWSE='" & strOnlineLocation & "' , LastChecked='" & strOnlineCheckInTime & "' WHERE UserID='" & strOnlineUser & "' AND " & strTablePrefix & "ONLINE.UserIP='" & strOnlineUserIP & "'"
my_Conn.Execute (strSql)

Please explain what I can do to resolve this issue, it is starting to annoy some of my members....

Dayve

Edited by - dayve on 18 June 2001 23:21:05

Edited by - dayve on 18 June 2001 23:28:20

dayve
Forum Moderator

USA
5820 Posts

Posted - 19 June 2001 : 00:08:20

could this have any relation to my problem??

Active User Problem

Dayve

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 19 June 2001 : 00:22:20

You just need to change the M_BROWSE field to a memo field in your database.

Easiest way to do this is to open your active_users_setup.asp file and change this: