Sphider Help Forum

Getting a 500 Internal Server Error while trying to index or re-index a site can be very frustrating. These errors can be quite persistent and unpredictable. The larger the site, the more likely encountering a 500 HTTP error becomes --- and the more frustrating. While this error is not as disastrous...

Ahhh! Turns out that is a fairly new collation and your version of MySQL obviously does not have it.
Well, easy fix.
Edit install.php and replace all instances of of 'utf8mb4_0900_ai_ci' with 'utf8mb4_general_ci'. Then rerun install.php.

Did you edit settings/database.php and settings/my.cnf for database name, mysql_user, mysql_password, and mysql_server?

Just getting the "Sphider installation script" with nothing after than indicates a failure to connect to the database.

15 October 2023 - Processing of robots.txt files has been improved. Robots.txt is now case sensitive and consideration is given to "allow" directives. All common text files have been integrated into Sphider. The user may assign a default language to a web site, but Sphider will also try to...

I am puzzled... Obviously, I am no guru and am missing something. The 'keyword' field is capable of holding Unicode characters. What version of MySQL (or possibly MariaDB) is running? MySQL, from what I read, has finally made utf8 and utf8mb4 the same instead of utf8 == utf8mb3. If the DB is MariaDB...

"0 rows affected" is expected as there was no operation affecting actual data. Just a table creation which has no data. Can you run a "show create table keywords;" again just to confirm the table does have utf8mb4 varchar. The fact you can manually enter a unicode character into ...

That is a suggestion I will keep in mind. Thanks!

It doesn't.
The full text of the page is stored in the links table. When a phrase search is performed, Sphider looks for that string in the full text and not a chain of individual keywords.

Not all tables have varchar() fileds, and of those that do, only TWO are critical for this situation. Keywords and links are the critical tables. Go into the site setting and "Clear site", now go into the Clean tables tab and clean keywords. Your links and keywords tables should now be emp...

Using Google translate, I get: Good morning, I'm trying to use Sphider which seems very good to me. Only, I have a problem with accented characters (French). In my tables, for example, the word nièvre appears like this (with an è after ni). But in the Sphider_keywords table, the word appears like th...