| Author |
 Topic  |
|
gorman
Starting Member
Italy
47 Posts |
 Posted - 04 May 2002 : 11:07:13
|
Hi to everybody and thanks in advance for any help on this.
I have this problem. Regular users of our forum can't see archived posts beyond the first message in any topic and/or their personal replies to it. Does anybody have an idea of where I should be looking for the correction to apply?
URL: www.gamesradar.it/Forum_new
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 04 May 2002 : 11:28:02
|
None of your forums have topics that are archived as far as I can see.
«------------------------------------------------------»
Want to know when the next version comes out,
as soon as possible? Join our Mailing Lists ! |
 |
|
|
gorman
Starting Member
Italy
47 Posts |
Posted - 04 May 2002 : 11:47:25
|
quote:
None of your forums have topics that are archived as far as I can see.
Don't ask me why, because I don't know the answer, but to see the archived posts you must be logged on... try user:parappa pass:apparap it's an account I use for testing.
Forums that have archived topics are Mondo Computer, Dailyrando, Games Contact, Di che Sony Sei...
And thanks for all the help.
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 04 May 2002 : 12:09:33
|
I see what you're talking about.
Can I ask why you changed topic.asp to messaggi.asp? If you modified the original code that came in topic.asp then that would be the cause of it not showing the other topics.
«------------------------------------------------------»
Want to know when the next version comes out,
as soon as possible? Join our Mailing Lists ! |
|
|
|
gorman
Starting Member
Italy
47 Posts |
Posted - 04 May 2002 : 14:14:23
|
quote:
I see what you're talking about.
Can I ask why you changed topic.asp to messaggi.asp? If you modified the original code that came in topic.asp then that would be the cause of it not showing the other topics.
Messaggi.asp is just a "container" for the rest of the site. It encapsules (if that's the right word, I'm Italian...) the bar on the right and topic.asp. If it could help, I could send you both files by e-mail.
Let me add that the forum has been operative since September 2001 in this form. I added some mods (Active Users, Avatars, Ban by IP, Personal Messages) and it always worked fine.
Then I decided to archive the old messages and... people could not see them. I fixed a problem with the Active Users mod using info found on this forum (suggested by GauravBhabu).
And as far as I was concerned everything was working perfectly. Problem was only administrators and moderators could see all the archived posts. Other users could see just the first post for each topic, plus their own personal replies in that topic.
Edited by - gorman on 04 May 2002 14:24:38
Edited by - gorman on 04 May 2002 14:25:04 |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 04 May 2002 : 15:14:49
|
Ok, post a link to a txt version of your messaggi.asp file.
«------------------------------------------------------»
Want to know when the next version comes out,
as soon as possible? Join our Mailing Lists ! |
|
|
|
gorman
Starting Member
Italy
47 Posts |
|
|
gorman
Starting Member
Italy
47 Posts |
Posted - 05 May 2002 : 16:00:06
|
Did anybody manage to find the solution to my problem? Sorry if I insist... but thousands of users are bugging me constantly... :)
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 05 May 2002 : 16:08:41
|
What database are you using?
«------------------------------------------------------»
Want to know when the next version comes out,
as soon as possible? Join our Mailing Lists ! |
|
|
|
gorman
Starting Member
Italy
47 Posts |
Posted - 05 May 2002 : 16:11:09
|
quote:
What database are you using?
Access 2000
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 05 May 2002 : 16:44:12
|
We will have to do some testing to see what might be causing this. You ready?
We know it is calling the GetFirst() subroutine in your topic.asp file, which shows the first post in a topic. Now we need to find out why it doesn't show the replies.
Does the replies show up ok when you're not in the archives?
Can you check in your database in your A_REPLIES table to make sure the replies are in there?
«------------------------------------------------------»
Want to know when the next version comes out,
as soon as possible? Join our Mailing Lists ! |
|
|
|
gorman
Starting Member
Italy
47 Posts |
Posted - 05 May 2002 : 17:08:22
|
The forum is working perfectly, replies are shown normally for all topics (apart from archived ones).
Furthermore, even if I don't have access to the database from home, I know for sure that the archived replies are there, because I (logging on as administrator or moderator) can see them perfectly. It's just regular users that don't see them...
If I enter into a post, logged as administrator, this for example, I see the post with its replies.
If I log out from that page, I see (not logged on) just the original post.
If I relog as a normal user the situation doesn't changes, I see only the original post.
Edited by - gorman on 05 May 2002 17:18:17 |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 05 May 2002 : 17:35:35
|
Just to play it safe, just check in the database when you can. Although it is obvious that it is in there. When programming and trying to fix a bug, you check the obvious first before looking any where else. Most times you find it's the obvious that was the problem after looking through the likely reasons why this bug might occur. 
Anyways, put a Response.Write strSql on your line 225 in your topic.asp file:else 'end MySql specific code
set rsReplies = Server.CreateObject("ADODB.Recordset")
rsReplies.cachesize = strPageSize
Response.Write strSql
rsReplies.open strSql, my_Conn, 3 Of course the sql statement will show up on the messaggi.asp page, so you will need to be at a page that has many replies in the archives and copy the sql and then take out the response.write code, so your users won't complain on what all that code at the top is for.
If you can, try get the sql statement when you're logged in as admin and when you're not logged in.
Just to confirm, only admins and moderators can see the archive replies. Regular members and users that are logged out cannot.
«------------------------------------------------------»
Want to know when the next version comes out,
as soon as possible? Join our Mailing Lists ! |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 05 May 2002 : 17:51:20
|
Wait, don't do that yet. Lets try something simplier.
In your topic.asp file starting at line 228 you find this code:
Response.Write "1"
If not (rsReplies.EOF or rsReplies.BOF) then '## No replies found in DB
Response.Write "2"
rsReplies.movefirst
rsReplies.pagesize = strPageSize
rsReplies.absolutepage = mypage '**
maxpages = cint(rsReplies.pagecount)
end if
Add the code in red and let me know if you see the numbers in your archives.
Also what connection string are you using? Access 2000 or Access 97?
«------------------------------------------------------»
Want to know when the next version comes out,
as soon as possible? Join our Mailing Lists ! |
|
|
|
gorman
Starting Member
Italy
47 Posts |
Posted - 06 May 2002 : 06:26:09
|
quote:
Can you check in your database in your A_REPLIES table to make sure the replies are in there?
I checked and the replies are there, all 95.000 of them! 
|
|
|
|
gorman
Starting Member
Italy
47 Posts |
Posted - 06 May 2002 : 11:30:50
|
To be clearer: where should I look in topic.asp to see where it checks for the current user to be moderator or administrator in order to show replies.
The replies are in the database, if a moderator or an administrator is logged on he can see them.
If a normal user is logged on he can see only the first post in the topic.
|
|
|
|
Topic |
|
Topic Locked
