| Author |
 Topic  |
|
|
Wixxerd
Starting Member
25 Posts |
 Posted - 22 June 2001 : 12:06:24
|
Microsoft OLE DB Provider for ODBC Drivers error '80040e57'
[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated.
/inc_top.asp, line 292
This is occuring when any user tries to reply to a topic whose subject line exceeds something like 25 chars. (I even up'd the space allocated for the T_SUBJECT field...didn't fix it)
Has anyone else seen this?
Edited by - Wixxerd on 22 June 2001 12:37:37
Edited by - Wixxerd on 22 June 2001 12:41:52 |
|
|
big9erfan
Average Member
540 Posts |
|
|
Wixxerd
Starting Member
25 Posts |
Posted - 22 June 2001 : 13:00:27
|
quote:
Do you have the active users mod installed?
http://www.ugfl.net/forums
Yup. Is that a problem?
|
 |
|
|
Wixxerd
Starting Member
25 Posts |
Posted - 22 June 2001 : 13:14:28
|
Thanks for pointing me in the right dir, I just changed line #134 in Inc_Top.asp to "strOnlineLocation = "Replying To Message ' <a href=""topic.asp?" & strOnlineQueryString & """>" & Left(Request.QueryString("Topic_Title"),10) & "</a> '" " in order to resolve this... 
|
|
|
|
round
New Member
Taiwan
67 Posts |
Posted - 27 June 2001 : 05:36:47
|
I got the exactly the same problem. I did have active users mod installed. After I have tryied Wixxerd's method, it works well with long English subject line, but it still won't work for long Chinese subjuct line. What can I do now?? I really have no idea how to solve the problem, please please help me. Thanks.
Edited by - round on 27 June 2001 18:29:27 |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 27 June 2001 : 19:14:37
|
You just need to change the FORUM_ONLINE.M_BROWSE field in your database to a MEMO field instead of nvarchar (250).
Easiest way to do this, if you still have the active_users_setup.asp file is to edit it in there and then rerun it. This will only work if you have the version of the active_users_setup.asp file that has the drop command at the top, that will drop the table if it already exists. |
|
|
|
round
New Member
Taiwan
67 Posts |
Posted - 27 June 2001 : 20:25:27
|
Thanks Richard,
Here is the original active_users_setup.asp file:
strSql = "CREATE TABLE " & strTablePrefix & "ONLINE ( "
strSql = strSql & "UserID varchar (100) , "
strSql = strSql & "UserIP varchar (40) , "
strSql = strSql & "DateCreated varchar (100) , "
strSql = strSql & "LastDateChecked varchar (100) , "
strSql = strSql & "CheckedIn varchar (100) , "
strSql = strSql & "LastChecked varchar (100) , "
strSql = strSql & "M_BROWSE varchar (250) ) "
Would you please please tell me where I should change? Sorry, I am very slow. Thanks so mcuh.
round |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 27 June 2001 : 20:32:56
|
change the last line from:
strSql = strSql & "M_BROWSE varchar (250) ) "
to this:
strSql = strSql & "M_BROWSE MEMO ) " |
|
|
|
round
New Member
Taiwan
67 Posts |
Posted - 27 June 2001 : 20:50:54
|
Thanks you, Richard
I just changed it, and rerun active_users_setup.asp. But I got this error message when I go to my forum:
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'FORUM_ONLINE'.
/forum/inc_top.asp, line 214
Any clue? Please please help me again. Thanks so much.
Edited by - round on 28 June 2001 20:32:12 |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 28 June 2001 : 20:40:25
|
| Did you get an error message when you ran active_users_setup.asp ? |
|
|
|
round
New Member
Taiwan
67 Posts |
Posted - 28 June 2001 : 20:47:25
|
Thanks Richard,
No, I didn't get any error message when I reran active_users_setup.asp. What else I can try now? Thanks again.
round |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 28 June 2001 : 20:55:05
|
It acts like the FORUM_ONLINE table isn't in the database.
I wasn't aware you were using MS SQL.
What you might try doing is changing the MEMO to just TEXT |
|
|
|
round
New Member
Taiwan
67 Posts |
Posted - 28 June 2001 : 21:17:07
|
Dear Richard:
Yes, it solve my problem. Thanks you so much. I am so happy now   
round |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 29 June 2001 : 01:09:00
|
| you're welcome |
|
|
| |
Topic |
|
Topic Locked
