Search found 309 matches
- Sat May 18, 2024 4:26 pm
- Forum: Sphider Help
- Topic: search result
- Replies: 4
- Views: 36
Re: search result
In search_results.php, there is a function, about line 44: if ($search_results['total_results']==0) { echo "<div id ='result_report'>"; In the case of "testbild", the <div id="result_report"> is not being output. One can conclude that total_results is NOT zero! If you l...
- Fri May 17, 2024 7:01 pm
- Forum: Sphider Help
- Topic: search result
- Replies: 4
- Views: 36
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 ...
- Fri May 17, 2024 5:38 pm
- Forum: Sphider Help
- Topic: search result
- Replies: 4
- Views: 36
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...
- Sat May 11, 2024 8:15 pm
- Forum: Sphider Help
- Topic: Errors creating tables
- Replies: 4
- Views: 153
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...
- Fri May 10, 2024 4:26 pm
- Forum: Sphider Help
- Topic: Errors creating tables
- Replies: 4
- Views: 153
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...
- Sat May 04, 2024 4:31 pm
- Forum: Sphider Help
- Topic: clean tables - cli?
- Replies: 3
- Views: 214
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("...
- Sat May 04, 2024 3:37 am
- Forum: Sphider Help
- Topic: clean tables - cli?
- Replies: 3
- Views: 214
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 ...
- Mon Mar 11, 2024 6:58 pm
- Forum: Sphider Help
- Topic: Always problems with with accented characters
- Replies: 5
- Views: 8505
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...
- Fri Mar 08, 2024 4:44 pm
- Forum: Sphider Help
- Topic: Always problems with with accented characters
- Replies: 5
- Views: 8505
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...
- Tue Mar 05, 2024 2:23 am
- Forum: Sphider Help
- Topic: How ton index with a menu call in every page ?
- Replies: 3
- Views: 4649
Re: How ton index with a menu call in every page ?
LOL! Welcome to the club! I have been in that situation more times than I can count.I had the solution before my eyes but that I could not see it.