| Author |
 Topic  |
|
|
ch_chia
Starting Member
17 Posts |
 Posted - 24 April 2001 : 03:02:55
|
Microsoft JET Database Engine (0x80040E57)
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 248
I had tranform the Snitz Forum 3.2a6 to Simplified Chinese, but when i want to reply a topic with subject more than 10 boublebyte character then it wil show out the above error, please help!
my site is
http://expert.mygamesite.net/forum
p/s: there is no error if i want to edit the message!
Edited by - ch_chia on 24 April 2001 03:05:36
Moved by Richard from DEV Bug Reports (Open) |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 24 April 2001 : 03:18:36
|
| What do you have on your line #248? (and about 10 lines above it too) |
 |
|
|
ch_chia
Starting Member
17 Posts |
Posted - 24 April 2001 : 03:34:21
|
' SET WHEN TO TIMEOUT THE USER
' DO THIS IN SECONDS
strOnlineDate = DateToStr(Date)
strOnlineCheckInTime = DateToStr(Now())
strOnlineTimedOut = strOnlineCheckInTime - 60 'time out the user after 1 minutes ( 60 seconds )
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = strConnString
objConn.Open
strSql = "SELECT " & strTablePrefix & "ONLINE.UserID, " & strTablePrefix & "ONLINE.UserIP, " & strTablePrefix & "ONLINE.LastChecked"
strSql = strSql & " FROM " & strTablePrefix & "ONLINE "
strSql = strSql & " WHERE " & strTablePrefix & "ONLINE.UserIP='" & strOnlineUserIP & "' AND " & strTablePrefix & "ONLINE.UserID='" & strOnlineUser & "'"
set rsWho = my_Conn.Execute (strSql)
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
strSql = "SELECT " & strTablePrefix & "ONLINE.UserID, " & strTablePrefix & "ONLINE.UserIP, " & strTablePrefix & "ONLINE.LastChecked"
strSql = strSql & " FROM " & strTablePrefix & "ONLINE "
strSql = strSql & " WHERE " & strTablePrefix & "ONLINE.UserID='" & strOnlineUser & "' AND " & strTablePrefix & "ONLINE.UserIP = '" & strOnlineUserIP & "'"
set rsLastChecked = my_Conn.Execute (strSql)
' 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) <--Line 248
end if
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 24 April 2001 : 03:36:44
|
you need to increase the size of the M_BROWSE field in the forum_online table.
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 24 April 2001 : 03:43:46
|
| I moved your post here because it's not a bug with the Forum, but a bug with a MOD that you added to the forum. |
|
|
|
ch_chia
Starting Member
17 Posts |
Posted - 24 April 2001 : 03:47:54
|
the maximun field size is only 255, i still having problem for this, but i wonder why there is no problem when i want to edit the message? this problem only happend when i want to reply, maybe we can make the "reply" call the database just like what "edit" do!?
please help!
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 24 April 2001 : 03:48:28
|
| just change that field to a MEMO field. |
|
|
|
ch_chia
Starting Member
17 Posts |
Posted - 24 April 2001 : 03:57:35
|
Thanks! I fixed it now!
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 24 April 2001 : 04:01:17
|
| you're welcome. |
|
|
| |
Topic |
|
Topic Locked
