Author |
Topic  |
frankie
Junior Member
 
Vatican City
304 Posts |
Posted - 01 January 2001 : 15:04:27
|
HuwR, Please help:
For some reason the mod dosen't post or updates the USR_VALUE field to the MEMBERFIELDS table. So nothig shows up in the profile page next to the new labels!
Any ideas?!!
ô¿~ |
 |
|
HuwR
Forum Admin
    
United Kingdom
20593 Posts |
Posted - 01 January 2001 : 15:38:30
|
Could you send me your're register.asp, pop_profile and inc_profile files, I will have a quick look at them.
<font color=blue>'Resistance is futile'</font id=blue> |
 |
|
frankie
Junior Member
 
Vatican City
304 Posts |
Posted - 01 January 2001 : 16:46:18
|
I will. Thanks a punch HuwR <img src=icon_smile.gif border=0 align=middle>
ô¿~ |
 |
|
HuwR
Forum Admin
    
United Kingdom
20593 Posts |
Posted - 02 January 2001 : 04:37:18
|
Ok, I have checked your files, the reason it is not working is because you changed this code in inc_profile <pre id=code><font face=courier size=2 id=code> <td valign="top" bgColor="<% =strPopUpTableColor %>"><textarea maxLength="255" name=<%=rs2("USR_SHORTNAME")%> cols="20" rows=3><%= getUserFieldValue(rs2("USR_FIELD_ID"),RS("MEMBER_ID")) %></textarea></td> <% Else if rs2("USR_FIELDTYPE") = "S" then %> <td valign="top" bgColor=<% =strPopUpTableColor %>><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>"><INPUT name=<%=rs2("USR_SHORTNAME")%> size="20" value="<%= getUserFieldValue(rs2("USR_FIELD_ID"),RS("MEMBER_ID")) %>"></font></td> <% Else %> <td valign="top" bgColor=<% =strPopUpTableColor %>><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>"><INPUT name=<%=rs2("USR_SHORTNAME")%> type="checkbox" value="1" <% If fieldValue = "1" then %>checked<% End If %>></font></td> </font id=code></pre id=code>
to this
<pre id=code><font face=courier size=2 id=code> <td valign="top" bgColor="<% =strPopUpTableColor %>"><textarea maxLength="255" name=textarea1<%=rs2("USR_SHORTNAME")%> cols="20" rows=3 id=textarea1><%= getUserFieldValue(rs2("USR_FIELD_ID"),RS("MEMBER_ID")) %></textarea></td> <% Else if rs2("USR_FIELDTYPE") = "S" then %> <td valign="top" bgColor=<% =strPopUpTableColor %>><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>"><INPUT name=text1<%=rs2("USR_SHORTNAME")%> size="20" value="<%= getUserFieldValue(rs2("USR_FIELD_ID"),RS("MEMBER_ID")) %>" id=text1></font></td> <% Else %> <td valign="top" bgColor=<% =strPopUpTableColor %>><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>"><INPUT name=checkbox1<%=rs2("USR_SHORTNAME")%> type="checkbox" value="1" <% If fieldValue = "1" then %>checked<% End If %> id=checkbox1></font></td> </font id=code></pre id=code>
You need to remove text1,checkbox1 etc, the form INPUT names are extremely important, it does not know what to write to the DB if you change them
<font color=blue>'Resistance is futile'</font id=blue> |
 |
|
frankie
Junior Member
 
Vatican City
304 Posts |
Posted - 02 January 2001 : 18:15:06
|
HuwR,
Thanks alot, but I didn't make those changes at all. What I think that my VisualInterDev did!! <img src=icon_smile_big.gif border=0 align=middle>..thanks a punch! <img src=icon_smile.gif border=0 align=middle>
Note: I know better than that, I don't know how I missed it.
ô¿~
Edited by - frankie on 02 January 2001 18:17:55 |
 |
|
HuwR
Forum Admin
    
United Kingdom
20593 Posts |
Posted - 02 January 2001 : 18:27:48
|
it's only cos I ran it through my diff checker that I noticed
<font color=blue>'Resistance is futile'</font id=blue> |
 |
|
eernstbmi
Junior Member
 
Denmark
113 Posts |
Posted - 04 January 2001 : 17:35:39
|
I get this error whenever I try to modify a user, when I'm logged in as the Forum Admin:
<pre id=code><font face=courier size=2 id=code> Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/forum/pop_profile.asp, line 739 </font id=code></pre id=code>
It happens when I from the Members - list click on the Modify button. I've not problem in updating the user when I log in as the user.
Best regards, <b>Erik P. Ernst</b> |
 |
|
HuwR
Forum Admin
    
United Kingdom
20593 Posts |
Posted - 04 January 2001 : 17:41:15
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> I get this error whenever I try to modify a user, when I'm logged in as the Forum Admin:
<pre id=code><font face=courier size=2 id=code> Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/forum/pop_profile.asp, line 739 </font id=code></pre id=code>
It happens when I from the Members - list click on the Modify button. I've not problem in updating the user when I log in as the user.
Best regards, <b>Erik P. Ernst</b> <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote> Could you mail me your pop_profilee to check, there is nothing related to userfields near this line.
<font color=blue>'Resistance is futile'</font id=blue> |
 |
|
eernstbmi
Junior Member
 
Denmark
113 Posts |
Posted - 04 January 2001 : 17:43:53
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> Could you mail me your pop_profilee to check, there is nothing related to userfields near this line. <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Sure it's coming your way now.
Best regards, <b>Erik P. Ernst</b> |
 |
|
eernstbmi
Junior Member
 
Denmark
113 Posts |
Posted - 05 January 2001 : 07:49:43
|
Huwr, Thank you for your suggestions by email. None of them worked!
But I did some checking myself - after having resolved my HTTP 500 error display problem.
And I found that it was this line in pop_profile.asp: <pre id=code><font face=courier size=2 id=code> strsql = strsql & ", " & strMemberTablePrefix & "MEMBERS.M_ALLOWDOWNLOADS, " & strMemberTablePrefix & "MEMBERS.M_ALLOWUPLOADS " </font id=code></pre id=code>
After remming the line it worked fine.
Best regards, <b>Erik P. Ernst</b> |
 |
|
HuwR
Forum Admin
    
United Kingdom
20593 Posts |
Posted - 05 January 2001 : 08:29:14
|
Do you have the file attachment Mod ? if so your database is not setup. If you haven't then this line should not be there
<font color=blue>'Resistance is futile'</font id=blue> |
 |
|
eernstbmi
Junior Member
 
Denmark
113 Posts |
Posted - 05 January 2001 : 08:32:42
|
No I don't have the File Attachment add on. Just a plain Snitz 2000 with the Allowed Users add on. But that doesn't change the pop_profile.asp or the user table?
Best regards, <b>Erik P. Ernst</b> |
 |
|
HuwR
Forum Admin
    
United Kingdom
20593 Posts |
Posted - 05 January 2001 : 08:50:01
|
What you did will be fine, you can delete the line if you wish
<font color=blue>'Resistance is futile'</font id=blue> |
 |
|
evehawk
New Member

Australia
65 Posts |
Posted - 10 January 2001 : 11:09:04
|
Hurw, i have the same prob with frankie on SR4. the user member fields just not show up at all even in pofile view? i need any help i can get when u have time thanks
|
 |
|
HuwR
Forum Admin
    
United Kingdom
20593 Posts |
Posted - 10 January 2001 : 14:30:42
|
quote:
Hurw, i have the same prob with frankie on SR4. the user member fields just not show up at all even in pofile view? i need any help i can get when u have time thanks
send me your po_profile and inc_profile.asp files, I will check them over
'Resistance is futile' |
 |
|
Topic  |
|