| Author |
 Topic  |
|
|
marpacwm
Starting Member
Canada
33 Posts |
 Posted - 25 May 2001 : 17:23:53
|
I'm running Snitz in a NT4 environment, so once a user registers, his NT login is used for accessing the forums. The trouble is that the profile signature that users create is not appended to their forum messages.
Does anyone know how to troubleshoot this problem, or how to solve it? Where is the signature information stored - I've looked through the database and can't find it.
Jim
Jim Trick |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 25 May 2001 : 17:36:57
|
It is added at the end of the post when the person posts a message. I think it is in the FORUM_MEMBERS table as M_SIG.
Make sure that when you post a message that the "Check here to include your profile signature" option is checked. It is below the message box.
|
 |
|
|
marpacwm
Starting Member
Canada
33 Posts |
Posted - 25 May 2001 : 18:24:35
|
Sorry, I should have indicated that I've looked at the M_SIG field, but this does not contain the signature the individual created when he registered. We also make sure that the Check Box is checked, so that the signature should be included. Any other ideas?
Jim Trick |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 25 May 2001 : 18:30:08
|
If the M_SIG field for the member is empty then he didn't create a signature.
Or if he said he did, then the M_SIG field isn't being updated with the new data when he submits it.
Ask the member to edit his profile and check to see if his signature is there. If not, ask him to enter in a signature and submit it. Then post a message again and see if it shows up.
If it doesn't show up after that, I will give you some code to debug the problem.
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 25 May 2001 : 18:31:28
|
also, have you modified any of the files?
Or is this "straight out of the box"?
|
|
|
|
marpacwm
Starting Member
Canada
33 Posts |
Posted - 28 May 2001 : 13:17:51
|
The only files modified concern email addresses, so I don't believe they are causing this problem. M_SIG contains the user's name, which is only part of the signature that was created by the user. Having said this, not even the name appears at the bottom of messages.
This problem affects all users.
Debug help would be appreciated.
Jim
Jim Trick |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 28 May 2001 : 14:24:36
|
So you're saying only part of the users signature is being updated into the database?
Did you do this as I had asked you to?quote:
Ask the member to edit his profile and check to see if his signature is there. If not, ask him to enter in a signature and submit it. Then post a message again and see if it shows up.
quote:
The only files modified concern email addresses, so I don't believe they are causing this problem.
I know that you might "believe" that it's not the problem, but I need to know for sure that the changes you made are not the problem.
What are the files you edited? Can you post a link to a txt version of the files you edited?
Also, you could try re-naming the files you edit, and place a fresh copy of the files from the zip and see if it works. If it does, then we know it's what you modified that might have caused the problem.
|
|
|
|
marpacwm
Starting Member
Canada
33 Posts |
Posted - 28 May 2001 : 16:41:04
|
Files that I had modified were: register.asp and pop_profile.asp. Using both modified files and original files, I found that changing the contents of the users' signature would update M_SIG, but only the first line of the signature would appear in the field. In other words, if the user created a three line signature block, only the first line appears in M_SIG.
The problem where the information in M_SIG does not appear under the messages still exists even with original forum files in place.
We're using the forum on an intranet so posting links is not feasible.
In a nutshell: using Snitz unmodified, in an NT environment, using NT login, no signature information appears under messages even when the user has created a signature, and has opted to include the signature below messages.
Thanks for your patience and quick responses. What could I try next? 
Jim
Jim Trick
Edited by - marpacwm on 28 May 2001 16:41:34 |
|
|
|
marpacwm
Starting Member
Canada
33 Posts |
Posted - 31 May 2001 : 11:17:38
|
Davio, are you there?
Jim Trick |
|
|
|
davemaxwell
Access 2000 Support Moderator
USA
3020 Posts |
Posted - 31 May 2001 : 13:32:57
|
in inc_functions.asp, do a find on getsig.
Change:
strSql = strSql & " WHERE M_NAME = '" & Request.Form("UserName") & "'"
to:
StrSql = strSql & " WHERE " & strMemberTablePrefix & "MEMBERS." & strDBNTSQLName & " = '" & fUserName & "' "
and see if that fixes it. It should (and should be reported as a bug....)
Dave Maxwell
--------------
Proud to be a "World Class" Knucklehead
Edited by - davemaxwell on 31 May 2001 13:33:45 |
|
|
|
marpacwm
Starting Member
Canada
33 Posts |
Posted - 31 May 2001 : 17:14:07
|
I've tried this and saw no change (still no signature appended to message). Just to make sure, I updated my profile by changing my signature slightly, but that had no effect either. In the database M_SIG still only shows the first line.
Jim Trick |
|
|
|
marpacwm
Starting Member
Canada
33 Posts |
|
|
marpacwm
Starting Member
Canada
33 Posts |
Posted - 05 June 2001 : 10:48:14
|
Sorry to keep pounding on this issue, but I would really like to solve the problem for my users. Any new ideas from anyone? One thing I don't understand - what happens to a three line signature that the user creates, when the M_SIG field in the database only shows the first line?
Jim Trick |
|
|
| |
Topic |
|
Topic Locked
