| Author |
 Topic  |
|
tomasalsbro
Average Member
Sweden
818 Posts |
 Posted - 16 January 2003 : 18:50:23
|
Hi,
I recieve this message trying to update members 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 1553
===============
What can have gone wrong 
Tomas |
!-Keep distance in traffic-!
www.whiplashinfo.se |
Edited by - ruirib on 17 January 2003 11:44:57 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
tomasalsbro
Average Member
Sweden
818 Posts |
Posted - 17 January 2003 : 03:25:34
|
Non,
just change the first letter in the usernamne bert to Bert.
So I'm very confused 
Tomas |
!-Keep distance in traffic-!
www.whiplashinfo.se |
Edited by - tomasalsbro on 17 January 2003 04:22:54 |
 |
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
tomasalsbro
Average Member
Sweden
818 Posts |
Posted - 17 January 2003 : 03:38:39
|
Yes Sir,
It's a members UserName.
Tomas |
!-Keep distance in traffic-!
www.whiplashinfo.se |
Edited by - tomasalsbro on 17 January 2003 04:22:20 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 17 January 2003 : 04:49:33
|
That's very weird. The message indicates that you're trying to add a field that is bigger than the space the corresponding database column can handle. I'd say look at all the user data you're trying to add.
Also did you make any changes to the database? |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
tomasalsbro
Average Member
Sweden
818 Posts |
Posted - 17 January 2003 : 05:02:40
|
Nop,
I have not chenged the database.
The only thing I have done latest is implemented Active Users vs. 4.0.17
The message appers even though no chenges have been done, just pushing the send buttom in the "Modify Users Profile" menu.
This is the path: http://www.whiplash.pp.se/forum/pop_profile.asp?mode=goModify
Tomas |
!-Keep distance in traffic-!
www.whiplashinfo.se |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 17 January 2003 : 05:08:01
|
| I would say check the changes due to the Active Users mod, since it seems likely to me that you changed the order of a field in a UPDATE statement or similar, so that data that was correct until those changes, surely is now being inserted in other field. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
tomasalsbro
Average Member
Sweden
818 Posts |
Posted - 17 January 2003 : 06:42:45
|
You could have right there, but after resetting the pop_profile.asp to its original, the problem still persits.
I guess the changes in the database made by the Active Users Mod must be the reason to this problems. This is the the changes by the mod:
========
Active Users 4.0 for Snitz 3.4 compatable
[DROP]
ONLINE
[END]
[DROP]
ACTIVE_USERS
[END]
[CREATE]
ACTIVE_USERS
MEMBER_ID#int#NULL#
AU_IP#varchar(40)#NULL#
AU_LOGINTIME#varchar(100)#NULL#
AU_LASTACTIVETIME#varchar(100)#NULL#
AU_LASTPAGE#varchar(250)#NULL#
AU_QUERYSTRING#text#NULL#
AU_USER_AGENT#text#NULL#
[END]
[ALTER]
MEMBERS
ADD#M_AUHIDE#varchar(1)#NULL#
ALTER#M_AUHIDE#varchar(1)#NULL#
[END]
[ALTER]
MEMBERS_PENDING
ADD#M_AUHIDE#varchar(1)#NULL#
[END]
[INSERT]
CONFIG_NEW
(C_VARIABLE,C_VALUE)#('STRAUANON','1')
(C_VARIABLE,C_VALUE)#('STRAUANONOVERRIDE','2')
(C_VARIABLE,C_VALUE)#('STRAUPALLOW','4')
(C_VARIABLE,C_VALUE)#('STRAUPCOLLAPSE','1')
(C_VARIABLE,C_VALUE)#('STRAUALLOW','3')
(C_VARIABLE,C_VALUE)#('STRAUREFRESH','0')
(C_VARIABLE,C_VALUE)#('STRAUIP','1')
(C_VARIABLE,C_VALUE)#('STRAUUA','2')
(C_VARIABLE,C_VALUE)#('STRAULOCAL','3')
(C_VARIABLE,C_VALUE)#('STRAUTIMEOUT','7')
(C_VARIABLE,C_VALUE)#('STRAUADMINCOLOR','orangered')
(C_VARIABLE,C_VALUE)#('STRAUMODCOLOR','forestgreen')
(C_VARIABLE,C_VALUE)#('STRAUADMINCOLOR','orangered')
(C_VARIABLE,C_VALUE)#('STRAUMODCOLOR','forestgreen')
(C_VARIABLE,C_VALUE)#('intAURecord','0')
(C_VARIABLE,C_VALUE)#('strAURecordDate','11111111111111')
[END]
========
Whats your opinions?
Perhaps any authorized should move this topic to "Help - Mod implementation"?
Tomas |
!-Keep distance in traffic-!
www.whiplashinfo.se |
Edited by - tomasalsbro on 17 January 2003 06:48:07 |
|
|
|
davemaxwell
Access 2000 Support Moderator
USA
3020 Posts |
Posted - 17 January 2003 : 08:06:26
|
I noticed that this field, M_AUHIDE, was added to the members table. Check your changes to pop_profile.asp and ensure that the SQL statement for the update is correct. My guess is the changes to the update did not get done correctly and one of the fields is being updated with the value from a wrong field. I would suggest doing a response.write of the sql statement and ensure that it's being done correctly.
Just because you only updated the value for the membername doesn't mean it's the only field being updated in the SQL. All the fields on the members table are updated in the SQL (albeit with the same values as before.) |
Dave Maxwell
Barbershop Harmony Freak |
|
|
|
tomasalsbro
Average Member
Sweden
818 Posts |
Posted - 17 January 2003 : 08:53:23
|
This is the changes made to POP_PROFILE.ASP:
=========
There are BOTH instances of this line on pop_profile.asp (about lines 820 and 952)
strSql = strSql & ", " & strMemberTablePrefix & "MEMBERS.M_SIG"
Paste this underneath both instances of the above line.
Select All
strSql = strSql & ", " & strMemberTablePrefix & "MEMBERS.M_AUHIDE"
Find BOTH instances of this: (about line 1211 and 1482)
if strBio = "1" then
strSql = strSql & ", M_BIO = '" & chkString(Request.Form("Bio"),"message") & "'"
end if
Paste this beneath both of them:
if strAUAnon = "1" then
strSql = strSql & ", M_AUHIDE = '" & ChkString(Request.Form("AUHide"),"") & "'"
end if
===========
I'm not competent enough to decide if this changes are correct or not.
Cheers / Tomas
|
!-Keep distance in traffic-!
www.whiplashinfo.se |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
tomasalsbro
Average Member
Sweden
818 Posts |
Posted - 17 January 2003 : 18:06:53
|
quote:
Originally posted by ruirib
Use a Response.Write to show the SQL statement causing the problem.
 I can't, because I don't now how to do that.
Tomas |
!-Keep distance in traffic-!
www.whiplashinfo.se |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 17 January 2003 : 19:02:37
|
Just before line# 1553, where you get the error, add this:
Response.Write strSql
Response.End
Make it look just like this, two statements, two lines, just before the line where you have the error. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
tomasalsbro
Average Member
Sweden
818 Posts |
Posted - 17 January 2003 : 19:56:39
|
OK ruirib,
I followed your instruction and voila! This is the result:
==============
UPDATE FORUM_MEMBERS SET M_NAME = 'Bert', M_NEWEMAIL = 'xxxxx@xxxxxx.net', M_KEY = ' ', M_RECEIVE_EMAIL = 1 , M_TITLE = ' ', M_POSTS = 2 , M_COUNTRY = ' ', M_ICQ = ' ', M_MSN = ' ', M_HOMEPAGE = ' ', M_SIG = ' ', M_LEVEL = 1, M_FIRSTNAME = 'Bert', M_LASTNAME = ' ', M_CITY = ' ', M_PHOTO_URL = ' ', M_LINK1 = ' ', M_LINK2 = ' ', M_AGE = ' ', M_MARSTATUS = ' ', M_SEX = ' ', M_OCCUPATION = ' ', M_HOBBIES = ' ', M_QUOTE = ' ', M_LNEWS = ' ', M_BIO = ' ', M_AUHIDE = '1, 1' WHERE MEMBER_ID = 1000
==============
Cheers / Tomas |
!-Keep distance in traffic-!
www.whiplashinfo.se |
Edited by - tomasalsbro on 17 January 2003 19:57:50 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 17 January 2003 : 20:04:29
|
Ok, your problem lies where shown in red.
==============
UPDATE FORUM_MEMBERS SET M_NAME = 'Bert', M_NEWEMAIL = 'xxxxx@xxxxxx.net', M_KEY = ' ', M_RECEIVE_EMAIL = 1 , M_TITLE = ' ', M_POSTS = 2 , M_COUNTRY = ' ', M_ICQ = ' ', M_MSN = ' ', M_HOMEPAGE = ' ', M_SIG = ' ', M_LEVEL = 1, M_FIRSTNAME = 'Bert', M_LASTNAME = ' ', M_CITY = ' ', M_PHOTO_URL = ' ', M_LINK1 = ' ', M_LINK2 = ' ', M_AGE = ' ', M_MARSTATUS = ' ', M_SEX = ' ', M_OCCUPATION = ' ', M_HOBBIES = ' ', M_QUOTE = ' ', M_LNEWS = ' ', M_BIO = ' ', M_AUHIDE = '1, 1' WHERE MEMBER_ID = 1000
==============
It should be:
M_AUHIDE = '1'
Check the mods instructions on the line you added to add this value, cause it's wrong now. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Topic |
|
|
|
Topic Locked
