Search found 308 matches

by captquirk
Fri May 17, 2024 7:01 pm
Forum: Sphider Help
Topic: search result
Replies: 2
Views: 6

Re: search result

Looking at the source code for the "testbild" results page, we see an abrupt end: <BODY> <h1>Seo Search - Search Engine for Europe and Switzerland</h1><h2><p align='center'>No advertising! No paid TOP entries!</p></h2><p><center><a href='../search.php'> <img src='/flaggen/gb.webp' alt='in ...
by captquirk
Fri May 17, 2024 5:38 pm
Forum: Sphider Help
Topic: search result
Replies: 2
Views: 6

Re: search result

Holy crap! I confirm that "testbild" gives a blank page... But "testbald", "testbold", "testbeld", "xtestbild", and anything else I tried gives an expected "No results found". Even "tstbild" works. It seems ONLY "testbild&quo...
by captquirk
Sat May 11, 2024 8:15 pm
Forum: Sphider Help
Topic: Errors creating tables
Replies: 4
Views: 141

Re: Errors creating tables

If you are referring to "$mysql_table_prefix", it depends. IF $mysql_table_prefix is defined, then all tables MUST use it. On the other hand, if $mysql_table_prefix is not defined, it is NULL and can be omitted. There are rules for defining CONSTRAINTS. You will find those in the MySQL hel...
by captquirk
Fri May 10, 2024 4:26 pm
Forum: Sphider Help
Topic: Errors creating tables
Replies: 4
Views: 141

Re: Errors creating tables

Did you edit the install script? I ask because I see a couple things that I would not expect. Error: Can't create table `hlink_keyword8 Error: Can't create table `hist_db`.`_search_rss_links` I don't know what may have been changed. While I have no problem with users modifying Sphider (I encourage i...
by captquirk
Sat May 04, 2024 4:31 pm
Forum: Sphider Help
Topic: clean tables - cli?
Replies: 3
Views: 159

Re: clean tables - cli?

Save this as cleankeywords.php in the admin directory: < {QUESTIONMARK} php require "../settings/database.php"; $del = 0; $query = "SELECT keyword_id, keyword FROM ".$mysql_table_prefix."keywords"; $stmt = $db->prepare($query); if ($stmt) { $stmt->execute() or die("...
by captquirk
Sat May 04, 2024 3:37 am
Forum: Sphider Help
Topic: clean tables - cli?
Replies: 3
Views: 159

Re: clean tables - cli?

On the Clean Tables tab, all of the items EXCEPT Clean Keywords should run very quickly and a timeout should never be an issue. However, Clean Keywords can be time consuming. The larger the database, the more this will be an issue. A timeout, therefore, can definitely be an issue. The Clean Keyword ...
by captquirk
Mon Mar 11, 2024 6:58 pm
Forum: Sphider Help
Topic: Always problems with with accented characters
Replies: 5
Views: 8323

Re: Always problems with with accented characters

Having it work by exporting as 8859-1 sounds rather weird, BUT --- If the import is also iso-8859-1 (and you are unable to change it), then it does make sense in a weird way. Exporting utf8 is the correct way, but if the import is iso8859-1, there WILL be corruption. Exporting as iso8859-1 of a utf8...
by captquirk
Fri Mar 08, 2024 4:44 pm
Forum: Sphider Help
Topic: Always problems with with accented characters
Replies: 5
Views: 8323

Re: Always problems with with accented characters

The server character set may or may not be the database character set! If you go into MySQL and run: SELECT * FROM INFORMATION_SCHEMA.SCHEMATA; you will see what the database character set is. The output should show all the databases (there are several MySQL specific databases), the character set fo...
by captquirk
Tue Mar 05, 2024 2:23 am
Forum: Sphider Help
Topic: How ton index with a menu call in every page ?
Replies: 3
Views: 4558

Re: How ton index with a menu call in every page ?

I had the solution before my eyes but that I could not see it.
LOL! Welcome to the club! I have been in that situation more times than I can count.
by captquirk
Sun Mar 03, 2024 7:34 pm
Forum: Sphider Help
Topic: How ton index with a menu call in every page ?
Replies: 3
Views: 4558

Re: How ton index with a menu call in every page ?

Look at the Sphider User Guide, page 47. Method 4 describes how to prevent certain parts of a page from being indexed: Method 4 - Ignoring parts of a page Sphider includes an option to exclude parts of pages from being indexed. This can, for example, be used to prevent search result flooding when ce...