Search found 306 matches
- Sat May 11, 2024 8:15 pm
- Forum: Sphider Help
- Topic: Errors creating tables
- Replies: 4
- Views: 136
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: 136
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: 157
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: 157
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: 8235
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: 8235
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: 4488
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.
- Sun Mar 03, 2024 7:34 pm
- Forum: Sphider Help
- Topic: How ton index with a menu call in every page ?
- Replies: 3
- Views: 4488
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...
- Fri Mar 01, 2024 3:03 am
- Forum: Sphider Help
- Topic: Pre-indexing tips
- Replies: 0
- Views: 9624
Pre-indexing tips
Many times problems with indexing a site can be prevented... at least when indexing sites over which you have control. Here are three tips to improve the odds of proper indexing. Be consistent with the use of "http" and "https" in your links. While browsers are much more forgivin...
- Thu Feb 29, 2024 3:36 pm
- Forum: Sphider Help
- Topic: Experience with sphider 5.
- Replies: 1
- Views: 3715
Re: Experience with sphider 5.
Thank you!