Here is all the errors

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -10 on MySQL result index 16 in /localhost/include/search_links.php on line 69

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -10 on MySQL result index 16 in /localhost/include/search_links.php on line 70

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -10 on MySQL result index 16 in /localhost/include/search_links.php on line 71

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -10 on MySQL result index 16 in /localhost/include/search_links.php on line 72

No. As long as you don't include the 'xml:' statement as part of your search query, nothing worth happens. Otherwise you will get something like:
Warning: include(create_sitemap.php) [function.include]: failed to open stream: No such file or directory in C:\Programme\xampp\htdocs\publizieren\sphider\include\search_links.php on line 47

Is version 2 of search_links.php still running on your system? Version 3 only got some small improvements which should not cause big problems.

But the error message is very strange to me because of /localhost/include/...
I would really expect something like /localhost/sphider/include/...

If you agree, let me have your e-mail account by pm. I will send a "running" full set of Sphider scripts to you.

Tec

Hello;

The 2nd version is working for me. There is nothing strange about the include because of i have installed it on my local server (root folder)...

For the first result page there could be a problem with undefined variable $start. Please try the following and let me know your results.

In .../include/search_links.php search for:

$from = ($start-1) * $results_per_page;

Delete that row and replace it with the following:

if (empty($start)) $start = '1';
if ($start == '1') {
$from = '0';
}else{
$from = ($start-1) * $results_per_page; // First $num_row of actual page
}


Tec

It works cool; thank you

I'm getting...
Fatal error: Maximum execution time of 60 seconds exceeded in C:\xampp\htdocs\search\include\search_links.php on line 43

line 43 : $res = mysql_query("SELECT * FROM ".$mysql_table_prefix."links WHERE site_id like '$site_id'";

Why is the 'like' needed? Can't it just be = ?

Should I just increase my execution time?

I have 61,356 records in link table.



Edited 1 time(s). Last edit at 10/31/2007 01:47AM by fastest963.

Why is the 'like' needed? Can't it just be = ? >>> Yes, works also with =

Should I just increase my execution time? >>> Yes, for so many links.

I have 61,356 records in link table. >>> I have no experience with such amount of links.

Tec

I found that changing

in /include/search_links.php

$res=mysql_query("select * from ".$mysql_table_prefix."links where site_id like '$site_id'";

and changing to

$res=mysql_query("select * from ".$mysql_table_prefix."links where site_id like ".$site_id."";

(removing the '' around $ite_id)
takes up to 1 minute off the search
(for me with 61400+ links)

Still, that command takes around 4 minutes to run (tested by a cmd mysql command)


I will be looking into faster way (table was optimized at 50,000 links and is indexed by site_id). Anyone know of a faster way??

thanks

How about Tec, you make it do something like if I was to search,
[zotagsearch.com]

search nyce and put domain=nyce.org

that is about 1500x faster and achieves the same result??

My English is not good enough to understand your posting. You have any question? You are commenting my mod? For the future you will use a 1500x better search engine?
Always keen to learn something which improves my possibilities, I will continue as my limited intelligence allows me.
Tec

Sorry Tec

Here is my full explanation

I was wondering (question) if there was a way to improve it (1500x) by having the serarch engine do something like what it does when you do search.php?domain=. The domain= command on the end is about 1500 times faster than your command currently and I was wondering if we could combine the two to use in the site:, for instance, if they typed in site it would preform as if I had on "indexing words of url" and I searched php with domain=php.net.