PDA

View Full Version : Last post link in archives is corrupted


Paulo
11-03-2007, 09:10 AM
I have upgrade 2.2 to 3.0rc2 and some links to last post in archive module is bad.
Ex:
The link to the thread is correct:
http://www.astunet.net/forum/showthread.php?t=3020
but the link to the last post is:
http://www.astunet.net/forum/showthread.php?p=0#post0

The same link in forum is correct but not in portal.

Why?

Thank you

Paulo

Brian
11-03-2007, 10:16 AM
Try looking in your modules/news.php file for this code:
SELECT $ratingsql thread.threadid, post.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, sticky, thread.attach, thread.lastpostid, thread.lastposter, user.*, thread.lastpost, IF(views<=thread.replycount, thread.replycount+1, views) AS views, thread.forumid, post.postid, pagetext

Replace with this:
SELECT $ratingsql user.*, thread.threadid, post.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, sticky, thread.attach, thread.lastpostid, thread.lastposter, thread.lastpost, IF(views<=thread.replycount, thread.replycount+1, views) AS views, thread.forumid, post.postid, pagetext

And that should take care of the problem.

Our Sponsors
 

Paulo
11-03-2007, 12:23 PM
Nice ! It's ok now.

Thanks Brain.

redlabour
11-18-2007, 04:05 AM
Thx! :)