Maybe the better solution is to just switch to postgres and use tsearch2, which can do multibyte free text search.

The problem is that the above is using non-standard sql (or at least it looks invalid, not sure without seeing the table definitions). Try adding the additional columns you are selecting into your group by clause... something like:

SELECT max(v.version) AS maxVer,
v.id,
a.realname,
v.version ...

tee hee... we like to keep you on your toes. I had worked up a similar fix using serendipity_db_bool but yours works as well. I can submit a patch if you want but I suspect you've got it from here. Thanks much for the feedback.

I finally had some time to investigate, and I think the problem comes from this change in includes/functions_entries.inc.php

http://svn.berlios.de/wsvn/serendipity/trunk/include/functions_entries.inc.php?op=diff&rev=756&sc=1

specifically, the check for isdraft -->

if ($entry['isdraft ...

Hi!


RIght, but the thing is that if you change the timestamp of a given entry, you will change the order of entries in both your website and your rss feed, which to me means you should probably also send a note for people to come and grab your feed again no?


Yes, which is why serendipity ...

Ah yes, I was thinking at the time I looked at the code some type of if statement was warrented but couldn't remember when I posted that comment. So maybe it needs to test "if category selected then $serendipity['GET']['category'] " else do nothing. Would be a simple change to test out anyway.

Hi!
Yes, the channel's pubdate is identical to the timestamp of any last update to a s9y entry, which will push the Conditonal Get caching of an RSS feed to refresh, when an existing entry is changed.


RIght, but the thing is that if you change the timestamp of a given entry, you will change the ...

I glanced at this yesterday whilst waiting for a reply on my bug and istm the problem is that the archives code does a $serendipity['GET']['category'] before doing the count, which afaict isn't neccesary. (I think this causes the join to categories which you shouldn't really ever want to do in the ...

This is using s9y 1.0.

I actually did try to modify the entry to update the last_modified date, but for some reason it didnt change the last_modified date at all. Unless there is some logic in the code the checks the amount of change before updating last modified, this probably means there is some ...

My scenario is that I wrote a blog post about 2 weeks ago but left it as draft. I published a few articles since then. When I went to publish it yesterday, I updated the time to be the current date so that it would be the latest entry. On my website, it is the first entry, and when I look in my rss ...