Plugin: search reloaded

This may be a dumb question, but on the page to download this plugin you say there’s an optional temnplate function by calling

<?php sem_search_results(); ?>

from the theme’s search.php. Where would this line be put in the file?

copy your index.php file as search.php and replace the loop-related code with a call to it.

I have solved the wpPaginate problem, and this is a funny one. The problem was my own modification: setting LIMIT to 18446744073709551615.

As I said earlier, this is exactly what the MySQL documentation recommends, but apparently the documentation has a bug. With LIMITs over 4294967295 (unsigned int), MySQL does weird stuff.

This was on MySQL 4.1.11. YMMV.

OK, it appears to be working properly, however it needs to return the results in reverse date format; ie. newest to oldest. Right now it is just random. Was this intended?

it hopefully returns results by relevance…

how can i make it sort by date (rather than relevance), or better yet, how would I make it a setting the user can chose? if i search for the word “test” on my site, it does just appear to be randomly listed results.

If you prefer results to be ordered by date, don’t use the plugin. Ordering results by date is the default wp behavior.

The plugin orders search results by — *cough* — relevance. Relevance, as defined by MySQL’s full text search tools. Which suck, as you point out, and as which I’m all too aware of.

I tried. I really did. I tweak the raw results extensively to try to fix this. But you can only fix broken things so much. And MySQL, well, it just sucks.

i don’t recall ever saying anything sucks, so i’m not sure where you saw me point that out (maybe you’re referring to another post, but i’m too lazy to look). that being said, i must say that the plugin is quite great and i do thank you for making it available to the public.

I say MySQL sucks. Compare:

https://monstera.man.poznan.pl/wiki/index.php/Mysql_vs_postgres

I keep getting this error when using search reloaded and I have no idea how to solve it:

WordPress database error: [The used table type doesn’t support FULLTEXT indexes]

I am using Blix theme and Wordress 1.5

Is there a way I can search in comments too? I have Search Everything plug-in, but it doesn’t work with Search Reloaded activated.

Search reloaded does not search pages, it only searches posts.

Use this plugin to search in pages too
https://randomfrequency.net/wordpress/search-pages/

Or try Advanced Search — it searches post, pages and comments (at your choice) and uses MySQL FULLTEXT, even with support for boolean operators. You can also choose between sorting by relevance or by date.

(As for Rimmon’s problem, it appears that somebody fooled around with the table types. WP by default uses MyISAM which does support FULLTEXT.)