PlanetZ forums - scopeusers.com

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!)?

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

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>

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

that's new to me
I'm afraid you'll have to use cookies plus planetz folder colours instead

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

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.

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...

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.

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

Nice one, John

nice one.

thanks a lot,john! Works perfectly!

good one John!

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

Thanks John

How was it when you first tried it?

The limit is currently at 200.

Enough?
-John

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.

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