PlanetZ search

roy thinnes · Post by **roy thinnes** » Tue Feb 21, 2006 4:57 pm

hey, when I want to get the latest news here on PlanetZ, I'm getting this strange error message:
"phpBB was unable to query the forums database
Got error 28 from storage engine
SELECT u.user_id,f.forum_id, p.topic_id, u.username, p.post_time,t.topic_title,f.forum_name FROM posts p, posts_text pt, users u, forums f,topics t WHERE p.post_id = pt.post_id AND p.topic_id = t.topic_id AND p.forum_id = f.forum_id AND p.poster_id = u.user_id AND f.forum_type != 1 ORDER BY p.post_time desc LIMIT 200 " (...)
Am I missing something (sic!)?

roy thinnes · Post by **roy thinnes** » Thu Feb 23, 2006 5:59 pm

mmh, can someone confirm this? Just hit the "search" button above and press "search" without typing in anything. Do you get an error message?

Post by **hubird** » Thu Feb 23, 2006 6:48 pm

I get that message too, not surprising btw.

you want too much...it says: I did not find any post without any author and without any keywords in any forum...
what would you expect

<font size=-1>[ This Message was edited by: hubird on 2006-02-23 19:23 ]</font>

roy thinnes · Post by **roy thinnes** » Thu Feb 23, 2006 7:42 pm

but that way it worked before. It was the usual method to get the latest PlanetZ news.

Post by **hubird** » Thu Feb 23, 2006 7:51 pm

that's new to me

I'm afraid you'll have to use cookies plus planetz folder colours instead

John Cooper · Post by **John Cooper** » Fri Feb 24, 2006 9:20 am

Huh! It never occured to me to use the search feature to see just the newest posts. Nice idea

I'm not seeing that error. Are you still seeing it?

Perhaps I should add something to the search page to limit the number of results, or to give a date range.

Cheers,
-John

roy thinnes · Post by **roy thinnes** » Fri Feb 24, 2006 10:15 am

aah, everything's ok again! Maybe it was a server issue. John: I have to admit that it was someone else (atOm?) who posted this trick some years ago.

at0m · Post by **at0m** » Mon Feb 27, 2006 4:22 am

I'd think this is a rather server CPU/disk intense way just to get the most recent topics... I don't think I'd advise on that eh.

I've bookmarked Adern's like this, it has a php module to show posts since last visit. This is far more efficient on the server I think, and shows just what I need really quick. Not sure if that's possible here on z, since John's modified the php extensively back in the days...

samplaire · Post by **samplaire** » Mon Feb 27, 2006 9:37 am

On 2006-02-23 19:51, hubird wrote:
that's new to me
I'm afraid you'll have to use cookies plus planetz folder colours instead

When I'm on a particular computer for the first time all the folders are red (I mean PlanetZ folders) and that's ok. And then, after logging in, all the folders become yellow unabling me to see what's new. So the way you suggest (which works fine for me on my everyday computers) is not 100% usable.

John Cooper · Post by **John Cooper** » Mon Feb 27, 2006 10:27 pm

Hey guys,

I too have noticed some database errors on doing a big search. I think our database is getting so large that we're maxing out the server. The search code in the original phpBB uses a very inefficient sql query. bummer.

So I was inspired to write a new little search routine that might come in handy:

See the new "What's new?" link at next to the search button. It does a simpler search, just for the items that are new since your last visit date.

(This link is only visible when you're logged in).

Cheers,
-John

wayne · Post by **wayne** » Mon Feb 27, 2006 10:44 pm

Nice one, John

Post by **garyb** » Tue Feb 28, 2006 12:18 am

nice one.

roy thinnes · Post by **roy thinnes** » Tue Feb 28, 2006 5:28 am

thanks a lot,john! Works perfectly!

Post by **hubird** » Tue Feb 28, 2006 5:47 am

good one John!

at0m · Post by **at0m** » Tue Feb 28, 2006 7:11 am

Excellent, that'll save some time and page reloads when checking the z

Thanks John

at0m · Post by **at0m** » Tue Feb 28, 2006 11:16 am

How was it when you first tried it?

John Cooper · Post by **John Cooper** » Wed Mar 01, 2006 10:09 am

The limit is currently at 200.

Enough?
-John

Post by **hubird** » Wed Mar 01, 2006 1:13 pm

Does it work on email address or on login data?
In case of the latter this new function is great when you visit Planetz from different places like at work.
I'm afraid tho it is the email addres that matters.

Post by **hubird** » Wed Mar 01, 2006 1:56 pm

Cookies are always involved then?
So on another IP addres you always have to check all forum pages?
I hoped the new function worked different