Search found 302 matches

by captquirk
Tue Oct 15, 2019 4:05 pm
Forum: Sphider Help
Topic: InnoDB Vs MyIsam
Replies: 3
Views: 24705

Re: InnoDB Vs MyIsam

MyISAM does not support FOREIGN-KEY referential-integrity constraints while InnoDB does.
Such constraints are now an essential part of Sphider 3.3.0.
by captquirk
Sat Oct 05, 2019 8:40 pm
Forum: Sphider Help
Topic: Index Button leads to login form and nothing happens
Replies: 1
Views: 18648

Re: Index Button leads to login form and nothing happens

The problem is likely that the session id is not being saved or otherwise inaccessible. I've never encountered this so have no ideas. Maybe this will help: https://stackoverflow.com/questions/155920/php-session-data-not-being-saved UPDATE: Just a thought... Sphider sessions do use cookies. Does your...
by captquirk
Sun Jun 23, 2019 6:07 pm
Forum: Sphider Help
Topic: Sphider Backup Tips
Replies: 0
Views: 44702

Sphider Backup Tips

Sphider comes with the ability to backup and restore your database. How well this works depends on not only the size of the database, but on your MySQL settings. The restore could restore a single record at a time, but this would be time consuming. It would be reliable, but for a larger database you...
by captquirk
Sun Jun 16, 2019 8:55 pm
Forum: Announcements
Topic: Sphider 3.2.0-MB released
Replies: 0
Views: 46048

Sphider 3.2.0-MB released

Sphider 3.2.0-MB has been released. A fix was made to correct missing keyword-link relationships. New features are the ability to set a minimum score for search results and the ability to use a 5 star system to rank the relevancy of results. I-frame support has been added.
by captquirk
Thu Jun 13, 2019 1:45 am
Forum: Sphider Help
Topic: Embed Search Box and Results In Another Web Page
Replies: 1
Views: 14057

Re: Embed Search Box and Results In Another Web Page

You can easily embed the query on any page, but the results will appear on the search.php page. Another approach is to customize the search.php page. Instead of embedding search.php on your page, you are embedding your content in search.php. You can still have query boxes on other pages, with result...
by captquirk
Mon May 27, 2019 9:08 pm
Forum: Sphider Help
Topic: HOW can I get the ER diagram of sphider?
Replies: 2
Views: 17050

Re: HOW can I get the ER diagram of sphider?

A note concerning the prior post: MySQL Workbench has a reverse engineering toll which is SUPPOSED to build a more proper ER diagram, but it fails to draw the actual relationships. The reason MySQL Workbench is unable to draw the relationships is because the SQL instructions which build the tables d...
by captquirk
Sun May 26, 2019 7:41 pm
Forum: Sphider Help
Topic: HOW can I get the ER diagram of sphider?
Replies: 2
Views: 17050

Re: HOW can I get the ER diagram of sphider?

erd.png This is no where near a proper ER, but it should give an idea of what's what. The settings table stands on its own and controls the workings of the admin, spidering, and search functionality. The sites table has the details of each site in the catalog. The site_id connects it to the images ...
by captquirk
Sat May 25, 2019 12:49 am
Forum: Sphider Help
Topic: Whatever happened to the Sphiders for SQLite and PostgreSQL?
Replies: 0
Views: 40065

Whatever happened to the Sphiders for SQLite and PostgreSQL?

Sphider did have forks which supported SQLite and PostgreSQL in lieu of MySQL/MariaDB. These were forks of the PDO version of Sphider and have not been updated since version 2.1 in November of 2018. There are no plans to resume work on these because of very limited demand. While they are no longer p...
by captquirk
Thu May 16, 2019 6:06 pm
Forum: Sphider Help
Topic: Your demo not working
Replies: 1
Views: 13921

Re: Your demo not working

Typo.
Fixed.
Thank you.
by captquirk
Thu May 16, 2019 12:33 am
Forum: Sphider Help
Topic: can't indexing a lot of sites
Replies: 3
Views: 17199

Re: can't indexing a lot of sites

Sphider 3.1.1-MB eliminates the need for the troublesome removeAccents() function. Rather than trying to force the word to conform to an all too English "a to z" alphabet check, the word is now compared to a unicode alphabetical check. The function had outlived its original purpose, which ...