Page 1 of 2

I'm updating the forum software

Posted: Wed Apr 27, 2005 6:47 pm
by The Robman
As most of you noticed, this forum was hacked this morning, so I have just upgraded to the most recent release of the forum software.

I also have several mods installed, so there will be a few features broken after the upgrade, until I can re-apply all the mods, so don't worry if the "quick reply" box isn't there and you see a few un-resolved images, etc. I know about it and it will be fixed pretty soon.

Posted: Wed Apr 27, 2005 9:42 pm
by The Robman
I'm done for the evening, and I think I've got most of the mods re-applied. So if you find anything that's not working properly, please post the details here.

Thanks
Rob

Posted: Thu Apr 28, 2005 7:59 am
by johnsfine
A couple times a while back you gave me URLs that abused the search mechanism in order to generating a simple reverse chornological list of all recent posts. That doesn't work any more. I tried doing a few searches directly to see what the new rules are but I don't really understand them. It seems like any search that ought to return most of the posts for the requested number of days instead returns nothing.

As I've described before I don't want to use the "posts since last visit" because I do remote control stuff in unpredictable scraps of time around other activities. I would click "posts since last visit" then get interrupted and have to close it before I really looked at it. Next time I clicked it I wouldn't get all the posts it thinks I got the first time.

If there's a better way to see reverse chonological across all these forums tell me, though I'm also wondering why search has that strange restriction.

Posted: Thu Apr 28, 2005 8:30 am
by The Robman
What I do when I want to do that manually is enter a "*" as either a search term or an author and that would bring me back all the recent post, but I just tried it and it doesn't work manually either, so something in the upgrade to version 2.0.14 must have broke that.

I don't know how soon I'll be able to try researching it either. I'm guessing that it's a bug in the 2.0.14 software rather than something that I did, so I would need to post something about it over in the phpbb.com forum and see if I get a response.

Posted: Thu Apr 28, 2005 9:28 am
by The Robman
I just took a look at what changed with this new release and it appears that they did this on purpose (read this). The good news is that the changes where limited to one member and I was able to back them out, so your search should work now.

Posted: Thu Apr 28, 2005 9:31 am
by johnsfine
I accidentally discovered you fixed this, before you posted the fact that you had fixed it.

I did some testing to see if the fix was stable, since you hadn't announced it. It was stable. Then I came back here to find you had announced it.

Posted: Thu Apr 28, 2005 3:12 pm
by ElizabethD
1 day or 7 day request with a * in the search topic gave me this:

Code: Select all

Could not obtain matched posts list

DEBUG MODE

SQL Error : 2008 MySQL client run out of memory

SELECT m.post_id FROM phpbb_search_wordlist w, phpbb_search_wordmatch m WHERE w.word_text LIKE '%' AND m.word_id = w.word_id AND w.word_common <> 1 

Line : 308
File : search.php 

Posted: Thu Apr 28, 2005 3:46 pm
by The Robman
Yup, I'm getting that too now even though it was working earlier. I don't think I'm going to be able to look into this for a few days though.

There appears to be a problem with search results.

Posted: Thu Apr 28, 2005 4:31 pm
by SCCA Racer X
I did a search for "neo" and got the usual matches.

If I click on a topic title, I get:

ERROR
The requested URL could not be retrieved
--------------------------------------------------------------------------------
While trying to retrieve the URL: NONE://127.0.0.1:8888http://www.hifi-remote.com/forums/viewtopic.php?

The following error was encountered:

Zero Sized Reply
Squid did not receive any data for this request.

Your cache administrator is webmaster.
--------------------------------------------------------------------------------
Generated Thu, 28 Apr 2005 22:26:17 GMT by cmijob (squid/2.5.STABLE4)

If I click on the page number of threads which have more than one page, that works...

Anybody else see this too?

fixed?

Posted: Thu Apr 28, 2005 6:27 pm
by SCCA Racer X
I don't have this problem now - but I'm home from work so now I'm on a different machine.

Posted: Thu Apr 28, 2005 7:11 pm
by mtakahar
ElizabethD wrote:1 day or 7 day request with a * in the search topic gave me this:

Code: Select all

Could not obtain matched posts list

DEBUG MODE

SQL Error : 2008 MySQL client run out of memory

SELECT m.post_id FROM phpbb_search_wordlist w, phpbb_search_wordmatch m WHERE w.word_text LIKE '%' AND m.word_id = w.word_id AND w.word_common <> 1 

Line : 308
File : search.php 
I don't see anywhere to specify "last N days" on the search page. What am I missing? This query apparently doesn't have any conditions to specify that, either, retrieving all the posts. No wonder running out of the memory.

Hal

Posted: Thu Apr 28, 2005 7:34 pm
by Mark Pierson
ElizabethD wrote:1 day or 7 day request with a * in the search topic
These settings work for me:

Search for Keywords: = <blank>
Search for Author: = "*"
Search previous: = 1 day or 7 days

Posted: Thu Apr 28, 2005 8:43 pm
by mtakahar
Mark Pierson wrote:
ElizabethD wrote:1 day or 7 day request with a * in the search topic
These settings work for me:

Search for Keywords: = <blank>
Search for Author: = "*"
Search previous: = 1 day or 7 days
Ah, Ok, this worked for me, too.
What doesn't work is this:
Search for Keywords: ="*"
Search for Author: = <blank>

Hal

Re: There appears to be a problem with search results.

Posted: Fri Apr 29, 2005 8:00 am
by The Robman
SCCA Racer X wrote:While trying to retrieve the URL: NONE://127.0.0.1:8888http://www.hifi-remote.com/forums/viewtopic.php?
Let me know if that happens again, because that URL is totally corrupted.

Back at work, it acts the same.

Posted: Fri Apr 29, 2005 10:25 am
by SCCA Racer X
Rob:

I have no problem at home, but at work it is still broken.

My home machine runs Win98 SE. At work I'm on XP 2002 SP1 with IE 6.0.2800.1106.xpsp2_gdr.040517-1325. There are firewalls, etc, but they didn't get in the way before...

By the way, I'm a software quality engineer by trade, so I'm supposed to be a PITA when things aren't perfect. Hope this is a real issue with an easy solution, but if not, I'm guessing my boss doesn't want me surfing JP1 at work anyway! :wink:

Thanks,
Jeff