Search found 9 matches

by SvOlli
Sat Mar 05, 2011 9:51 am
Forum: Bugs
Topic: Running s9y with gatling
Replies: 3
Views: 3446

Re: Running s9y with gatling

I found the cause of my problems: gatling seems to have a bug in the FastCGI interface.

When using SSL, the payload of the POST request gets dropped after CONTENT_LENGTH.
by SvOlli
Fri Mar 04, 2011 6:23 pm
Forum: Bugs
Topic: Running s9y with gatling
Replies: 3
Views: 3446

Re: Running s9y with gatling

Hello Garvin,

thanks for the help. I just sent a PM to you with more details.

SvOlli
by SvOlli
Thu Mar 03, 2011 8:36 pm
Forum: Bugs
Topic: Running s9y with gatling
Replies: 3
Views: 3446

Running s9y with gatling

Hello,

I want to migrate my blog from an Apache webserver to a rather nice webserver called gatling available at http://www.fefe.de/gatling/ . It uses fast-cgi for the PHP integration. As a first test I wanted to set up a vanilla blog to see if it works, and I ran into the following problem: when ...
by SvOlli
Thu Mar 11, 2010 12:09 am
Forum: Bugs
Topic: Search broken using UTF-8 and SQLite
Replies: 10
Views: 10247

Re: Search broken using UTF-8 and SQLite

You're welcome, and I couldn't have done it without you pointing me to include/functions_entries.inc.php, serendipity_searchEntries().

I've updated my patch, as my first attempt had one drawback: it searched twice just to get the same results, if there was none or less than four matches.

diff ...
by SvOlli
Tue Mar 09, 2010 10:44 pm
Forum: Bugs
Topic: Search broken using UTF-8 and SQLite
Replies: 10
Views: 10247

Re: Search broken using UTF-8 and SQLite

Who needs sleep anyway? ;-)

When the search didn't bring up enough matches, the search was restarted with an appended "*". SQLite treats "*" like any other character, so the second search didn't bring up anything at all.

Here's my suggestion for a fix / workaround:

diff --git a/include/functions ...
by SvOlli
Tue Mar 09, 2010 9:56 pm
Forum: Bugs
Topic: Search broken using UTF-8 and SQLite
Replies: 10
Views: 10247

Re: Search broken using UTF-8 and SQLite


Do you have an external SQLite3 tool that you could use to execute SQL queries? If so, you could try:


SELECT * FROM serendipity_entries WHERE body LIKE '%lighttpd%'
Using the SQLite2 tool, it works as expected: it finds the article.

I tried it again on some other data, and it seems to me that ...
by SvOlli
Mon Mar 08, 2010 10:05 pm
Forum: Bugs
Topic: Search broken using UTF-8 and SQLite
Replies: 10
Views: 10247

Re: Search broken using UTF-8 and SQLite

Hmmm... I tried it again and it's not quite that either. Fact is, that it doesn't find obvious texts. Please try it yourself: go to http://blog.h8u.de/ and search for the terms "Qt 4.6" and "lighttpd". Both are available in the latest article "Das Ende meines Apachen...?", but cannot be found using ...
by SvOlli
Mon Mar 08, 2010 7:39 am
Forum: Bugs
Topic: Search broken using UTF-8 and SQLite
Replies: 10
Views: 10247

Re: Search broken using UTF-8 and SQLite

After some more testing and by accident I found the real cause. It has nothing to do with umlauts and probably nothing with the database: you can't search anything that's the text of a link.

If your text includes:
<a href="http://www.s9y.org">jump to s9y page</a>
a search for "jump" or "page ...
by SvOlli
Sun Mar 07, 2010 7:23 pm
Forum: Bugs
Topic: Search broken using UTF-8 and SQLite
Replies: 10
Views: 10247

Search broken using UTF-8 and SQLite

Hello,

I'm running s9y for almost five years now, using SQLite as database engine. On the migration 1.4.1 -> 1.5.2, I also changed the database format from Latin-1 to UTF-8. After that the search does not find anything if I search for an umlaut, which worked when the blog was run using Latin-1 ...