Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Classic ASP versions(v3.4.XX)
 Recent Posts not Showing in Profile
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

leatherlips
Senior Member

USA
1838 Posts

Posted - 16 May 2006 :  12:00:17  Show Profile  Visit leatherlips's Homepage
I've just discovered a problem with my forum. If you create a new post, it will appear in your profile under Recent Topics. However, if you post within an existing topic, it will not appear in your profile. The only thing I have done to the pop_profile.asp page is added two small bits of code for the Active Users MOD. I'm not sure if that is the problem though because I removed those two bits of code and the same thing still happens.

To see what I mean, you can go to my forum and post under:

Username: demo
Password: demo

Post a new topic and then post under an existing topic and then check the profile. New topics will be listed, but replies to existing ones will not.

Mangione Magic Forum - The Music of Chuck Mangione

My Mods: Googiespell MOD | Link To Reply MOD | Petition MOD | Contact Page MOD | Share This Topic MOD | MP3 MOD | PageEar MOD | Google Viewer MOD

HuwR
Forum Admin

United Kingdom
20595 Posts

Posted - 16 May 2006 :  12:25:29  Show Profile  Visit HuwR's Homepage
can you post a link to a text version of your pop_profile.asp so we can have a look
Go to Top of Page

leatherlips
Senior Member

USA
1838 Posts

Posted - 16 May 2006 :  12:31:56  Show Profile  Visit leatherlips's Homepage
Certainly. Thank you for willing to help.

This link was removed by leatherlips after the problem (or lack thereof ) was resolved.

Mangione Magic Forum - The Music of Chuck Mangione

My Mods: Googiespell MOD | Link To Reply MOD | Petition MOD | Contact Page MOD | Share This Topic MOD | MP3 MOD | PageEar MOD | Google Viewer MOD

Edited by - leatherlips on 16 May 2006 19:38:11
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20595 Posts

Posted - 16 May 2006 :  13:21:35  Show Profile  Visit HuwR's Homepage
well, I can't see anything wrong with that, so the problem must lie somewhere else. have you modified any other files, and/or modified any of the tables in the database
Go to Top of Page

leatherlips
Senior Member

USA
1838 Posts

Posted - 16 May 2006 :  13:28:26  Show Profile  Visit leatherlips's Homepage
I have made a lot of changes so it may be hard to find .

I have however kept a text file of everychange I have ever made as a reference for myself .

Here is my file with the changes. Perhaps you can spot an issue?

This link was removed by leatherlips after the problem (or lack thereof ) was resolved.

Mangione Magic Forum - The Music of Chuck Mangione

My Mods: Googiespell MOD | Link To Reply MOD | Petition MOD | Contact Page MOD | Share This Topic MOD | MP3 MOD | PageEar MOD | Google Viewer MOD

Edited by - leatherlips on 16 May 2006 19:39:16
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20595 Posts

Posted - 16 May 2006 :  13:41:49  Show Profile  Visit HuwR's Homepage
sorry, that didn't help much am trying to figure out what might cause it to happen, but currently can't find anything. is your database access or sql ?
Go to Top of Page

leatherlips
Senior Member

USA
1838 Posts

Posted - 16 May 2006 :  14:08:10  Show Profile  Visit leatherlips's Homepage
My database is Access. Do you know what setting I may have deleted that caused this?

Mangione Magic Forum - The Music of Chuck Mangione

My Mods: Googiespell MOD | Link To Reply MOD | Petition MOD | Contact Page MOD | Share This Topic MOD | MP3 MOD | PageEar MOD | Google Viewer MOD
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20595 Posts

Posted - 16 May 2006 :  14:15:54  Show Profile  Visit HuwR's Homepage
do you think you could email me a copy of your db, my email address is huw at forum.snitz.com
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20595 Posts

Posted - 16 May 2006 :  18:10:01  Show Profile  Visit HuwR's Homepage
leather lips, could you do me a quick favour, could you add the following line
response.write strSQL

to line 388 in your pop_profile (just before the set rs2 = my_Conn.Execute(strsql)) line
could you then have a look at the demo members profile, and copy the SQL string that it displays on the page, or just let me know when you have added that line and I will check for myself.

I ran some dummy queries on your db and that seems to work fine, so need to find out exactly what your code is sending to the db in it's query
Go to Top of Page

leatherlips
Senior Member

USA
1838 Posts

Posted - 16 May 2006 :  18:22:43  Show Profile  Visit leatherlips's Homepage
I did what you asked, and here is what the Profile said:

SELECT F.FORUM_ID, T.TOPIC_ID, T.T_SUBJECT, T.T_STATUS, T.T_LAST_POST, T.T_REPLIES FROM ((FORUM_FORUM F LEFT JOIN FORUM_TOPICS T ON F.FORUM_ID = T.FORUM_ID) LEFT JOIN FORUM_REPLY R ON T.TOPIC_ID = R.TOPIC_ID) WHERE (T_DATE > '20060416183147') AND (T.T_AUTHOR = 28 OR R.R_AUTHOR = 28) AND (T_STATUS < 2 OR R_STATUS < 2) AND F.F_TYPE = 0 ORDER BY T.T_LAST_POST DESC, T.TOPIC_ID DESC

Mangione Magic Forum - The Music of Chuck Mangione

My Mods: Googiespell MOD | Link To Reply MOD | Petition MOD | Contact Page MOD | Share This Topic MOD | MP3 MOD | PageEar MOD | Google Viewer MOD
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20595 Posts

Posted - 16 May 2006 :  18:35:37  Show Profile  Visit HuwR's Homepage
ok, that explains it it is actually doing what it is supposed to do, you are just misunderstanding it's function, the code displays "recent topics" that you have posted in, and by recent topics it means topics started within the last 30 days, it is not displaying posts you have made in the last 30 days, soif you reply to a topic that was 31 days old, it would not appear in the list even though the reply is new
Go to Top of Page

leatherlips
Senior Member

USA
1838 Posts

Posted - 16 May 2006 :  19:02:00  Show Profile  Visit leatherlips's Homepage
Well don't I feel silly...

Thanks for all your time. I really appreciate it.

Mangione Magic Forum - The Music of Chuck Mangione

My Mods: Googiespell MOD | Link To Reply MOD | Petition MOD | Contact Page MOD | Share This Topic MOD | MP3 MOD | PageEar MOD | Google Viewer MOD
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20595 Posts

Posted - 16 May 2006 :  19:04:46  Show Profile  Visit HuwR's Homepage
no worries
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 1.67 seconds. Powered By: Snitz Forums 2000 Version 3.4.07