Memory error when using wildcard * on search

[Areku]

Hi there,

On a VB2.3.x, whenever I try to search for "video es*" i get:

Fatal error: Allowed memory size of 8388608 bytes exhausted at (null):0 (tried to allocate 129 bytes) in /home/virtual/site1/fst/var/www/html/forums/search.php on line 412

Fatal error: Allowed memory size of 8388608 bytes exhausted at (null):0 (tried to allocate 32 bytes) in /home/virtual/site1/fst/var/www/html/forums/admin/functions.php on line 2632

But if I try with "video ess*", search results come with no problems.

Any idea of what's going on?

Thanks!

[Dean C]

What modifications have you added to your vB ?

[Areku]

A few... the only one messing with SEARCH is the hack that shows the last x searches made along with its results... might it be this one??

[Andreas]

Well, I also get memory exhausted errors with an unmodified vB 3.0.3 using certain keywords on my board (625K posts, postindex has about 26.000.000 rows).
The problem is that some keywords simply return too many results.
Unfortunately, this is not fixable as long as FULLTEXT search isn't fully implemented
The only thing you can do is increasing PHP memory limits

[Dean C]

I doubt that very much. Try removing the hack and do the search again - you can always backup and reupload the file