[dlst]

Hi Overgrow, thanks for the hack and all the hard work.

I'm having the same troulbe eva2000 reported a while back but the fix doesn't work for me, and I'm stumped. The URL to the archive is:

http://www.offshoreonly.com/forum/archive/index.php

I get "no posts" page no matter which week I choose. I did what you suggested below, and here is a sample query:

SELECT title,threadid,lastpost FROM thread WHERE lastpost > '1010469600' AND lastpost < '1010988000' AND forumid='3' ORDER BY dateline ASC

Looks fine to me, and indeed, when run in phpmyadmin it returns no errors, but oddly, it also returns no rows. I thought this might be a date problem but the date format on the boards is stock, and is the US format.

Everything else works, including when you enter in a manual thread id:

http://www.offshoreonly.com/forum/archive/3/2002/01/2 (no posts)

http://www.offshoreonly.com/forum/ar...2002/01/2/1143 (there's a thread)

I don't really know if this is a valid way of accessing them, or if it really helps to know, but it seems that everything is working but the query to show a list of thread titles...

Anyway, any help you could offer would be greatly appreciated.

-dlst

Originally posted by Overgrow
Does it tell you "No posts, please go back" ?

Does it give you a totally blank screen?

or does it at least show what forum you are in?

This change is just for eva to troubleshoot... FIND

echo spacer(2)."Dates: $date1 to $date2<br>&nbsp;<br>";

	$query = "SELECT title,threadid,lastpost FROM thread 
WHERE lastpost > '$ts1' AND lastpost < '$ts2' 
AND forumid='$forumID' ORDER BY dateline ASC";

change to

echo spacer(2)."Dates: $date1 to $date2<br>&nbsp;<br>";

	$query = "SELECT title,threadid,lastpost FROM thread 
WHERE lastpost > '$ts1' AND lastpost < '$ts2' 
AND forumid='$forumID' ORDER BY dateline ASC";

echo $query;

Then when it spits the query out, run it in phpmyadmin and see if it is a valid query.