| Author |
 Topic  |
|
c1sissy
New Member
85 Posts |
 Posted - 30 December 2003 : 20:53:08
|
http://hwcssvu.tripod.com/members.txt
Now I am off to the homesite to see if I can get this to work according to what you are stating in your post.
<edit>  I despise this host! Now I can't get in to see if I corrected this or not.SCREAM!</edit> |
c1sissy
Can I hypnotise myself to learn faster??!!!
http://rienfam.tripod.com |
Edited by - c1sissy on 30 December 2003 21:03:29 |
 |
|
|
c1sissy
New Member
85 Posts |
Posted - 30 December 2003 : 21:08:58
|
Ok, this is what is happening now, I believe that I did what you told me to do correctly.
If I click on members at the top of the page I get redirected to the home page again.
IF I click on members in the statistics box I get the following
SELECT MEMBER_ID, M_STATUS, M_NAME, M_LEVEL, M_EMAIL, M_COUNTRY, M_HOMEPAGE, M_AIM, M_ICQ, M_MSN, M_YAHOO, M_TITLE, M_POSTS, M_LASTPOSTDATE, M_LASTHEREDATE, M_DATE M_AIM, M_ICQ, M_MSN, M_YAHOO, M_TITLE, M_POSTS, M_LASTPOSTDATE, M_LASTHEREDATE, M_DATE, M_PMRECEIVE FROM FORUM_MEMBERS WHERE M_NAME <> 'n/a' ORDER BY M_POSTS DESC, M_NAME ASC
|
c1sissy
Can I hypnotise myself to learn faster??!!!
http://rienfam.tripod.com |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 31 December 2003 : 03:59:28
|
Thanks for uploading the text-file to another server. That made it a lot easier to locate where the error was.
Look for the following on lines 107-111 and remove the line marked red:
'New Search Code
If strMode = "search" and (srchUName = "1" or srchFName = "1" or srchLName = "1" or srchInitial = "1" ) then
strSql = "SELECT MEMBER_ID, M_STATUS, M_NAME, M_LEVEL, M_EMAIL, M_COUNTRY, M_HOMEPAGE, "
strSql = strSql & "M_AIM, M_ICQ, M_MSN, M_YAHOO, M_TITLE, M_POSTS, M_LASTPOSTDATE, M_LASTHEREDATE, M_DATE "
strSql = strSql & "M_AIM, M_ICQ, M_MSN, M_YAHOO, M_TITLE, M_POSTS, M_LASTPOSTDATE, M_LASTHEREDATE, M_DATE, M_PMRECEIVE "
Then look for the following on lines 148-151 and remove the redmarked line:
'## Forum_SQL - Get all members
strSql = "SELECT MEMBER_ID, M_STATUS, M_NAME, M_LEVEL, M_EMAIL, M_COUNTRY, M_HOMEPAGE, "
strSql = strSql & "M_AIM, M_ICQ, M_MSN, M_YAHOO, M_TITLE, M_POSTS, M_LASTPOSTDATE, M_LASTHEREDATE, M_DATE "
strSql = strSql & "M_AIM, M_ICQ, M_MSN, M_YAHOO, M_TITLE, M_POSTS, M_LASTPOSTDATE, M_LASTHEREDATE, M_DATE, M_PMRECEIVE "
That will fix your members.asp.
Have a good New Year's Eve.  |
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
c1sissy
New Member
85 Posts |
Posted - 05 March 2004 : 21:49:37
|
Hi Jan, sorry so long to get back on the scene!
Anyhow, I tried the fix, but it still isn't working out for me. I have a link to the text file for all to see. If need be i can give access to the forum. Let me know. But I would like to work it out myself first ;)
http://c1sissy.tripod.com/Untitled1.txt
Let me explain what is still going on, If I click members at the top of the page I go right to the home page. If I click members in the statistics box I get the following:
SELECT MEMBER_ID, M_STATUS, M_NAME, M_LEVEL, M_EMAIL, M_COUNTRY, M_HOMEPAGE, M_AIM, M_ICQ, M_MSN, M_YAHOO, M_TITLE, M_POSTS, M_LASTPOSTDATE, M_LASTHEREDATE, M_DATE, M_PMRECEIVE FROM FORUM_MEMBERS WHERE M_NAME <> 'n/a' ORDER BY M_POSTS DESC, M_NAME ASC |
c1sissy
Can I hypnotise myself to learn faster??!!!
http://rienfam.tripod.com |
Edited by - c1sissy on 05 March 2004 22:18:10 |
|
|
|
Topic |
|
|
|
Topic Locked
