In general the original Sphider quite well indexes phrases like "Cheesy's waggly tail", so that words like cheesy's become searchable. Just checked it on my computer and it is working well for me.
But obviously you activated the option
Use word stemming
This option creates a lot of unexpected search results. For example the word 'Cheesy's' will be reduced to 'cheesy' during index procedure. Thus 'Cheesy's' will not be searchable afterwards. Even searching for 'cheesy' will not deliver any results, as the search algorithm is unable to highlight the keyword 'cheesy', as it does not exist in full text.
Uncheck the option '
Use word stemming' and 'Erase & Re-index' your site. In case you like the users of your search engine to query for 'cheesy' as well as for 'cheesy's', please have a look at Sphider-plus.
Regarding your second issue "ERROR: Database contains no tables":
Did you use a table prefix when creating the database? It is obligatory to use a table prefix. But it should not contain any special charachters. Some older versions of MySQL did not accept them . . .
Tec
Edited 1 time(s). Last edit at 05/11/2016 05:53PM by Tec.