Webboard: Malformed or too long query strings

Author: Ulrich
Email: 
Message:
Hello everybody,



we are running version 3.2.24 in single mode.

A foreign company built a search application for our intranet and also our internet site, using the PHP extensions.

When the search results in too many hits, we encounter an error.

I examined the query strings by enabling MySQL's query log.

One query goes like this:



SELECT rec_id,url,last_mod_time,docsize,next_index_time,referrer,crc32,site_id,pop_rank FROM url WHERE rec_id IN (965709,966659)



In this case the query found only two documents. But if the query finds lots and lots of documents (let's say 4000 ot 7000), the above query is split into several queries, each containing 256 numbers (rec_ids) between the brackets.

Using the search.php which comes along with the tarball, there's no problem, everything works fine.

But using our application, suddenly there are at least 498 numbers between the brackets. I can't tell exactly because the log file cuts the entry. I'm also not sure if the query statement is complete because it is cut.

But that's the point where the error occurs, I think.

My question is now if it is possible that under certain circumstances such a long query statement is built. If yes, which are these circumstances?

I also recompiled PHP (we are running 4.4.9) with the latest version of the extensions (1.96) from your website. But it didn't help.

May switching to multi mode clean the situation, as we have far more than 8000 documents indexed? (On the other hand: I discovered that single mode and blob mode (parallel installation of 3.3.8) only have a different first query, all the other queries are equal.)

With kind regards

                  Ulrich

Reply: <http://www.mnogosearch.org/board/message.php?id=20973>