Here is the situation.
mysql> select * from sites;
+---------+---------------------------+
| site_id | site |
+---------+---------------------------+
| 1 | http://www.eseek.gr/ |
| 2 | http://www.trinity.gr/ |
| 3 | http://achill/ |
| 4 | http://achill.eurisko.gr/ |
| 5 | http://www.in.gr/ |
+---------+---------------------------+
5 rows in set (0.00 sec)
then i do a:
http://194.219.147.3/cgi-bin/search.cgi?q=internet&st=1
and includes also the site with site_id = 2
Here is the sql log
============================================================================================================
010223 16:24:40 10 Query SELECT word_id FROM wordurl WHERE word = 'internet'
10 Query SELECT urls,word_id,totalcount,urlcount FROM
wordurl WHERE word_id = 119
10 Query SELECT urls,word_id,totalcount,urlcount FROM
wordurl1 WHERE word_id = 119
10 Query SELECT site FROM sites WHERE site_id=1
010223 16:24:41 10 Query INSERT INTO stat(addr, proxy, query, ul, np, ps,
urls, sites, start, finish, site, sp, referer) VALUES ('194.219.147.3', '',
'internet', '', 0, 20, 5, 1, 982938280.987, 982938281.000, 1, '','')
10 Query SELECT us.description, us.keywords, us.title,
us.docsize, u.crc, u.url, us.content_type,
u.last_modified, u.etag, us.txt,us.words FROM urlword u, urlwords05 us WHERE
u.url_id=5 AND us.url_id=u.url_id
10 Query SELECT url_id, url FROM urlword WHERE
crc='c0b49a57edf14ad1ffd060ace48adce5' AND deleted=0 AND url_id!=5 AND site_id=1 LIMIT
10
10 Query SELECT us.description, us.keywords, us.title,
us.docsize, u.crc, u.url, us.content_type,
u.last_modified, u.etag, us.txt,us.words FROM urlword u, urlwords06 us WHERE
u.url_id=6 AND us.url_id=u.url_id
10 Query SELECT url_id, url FROM urlword WHERE
crc='a1eafdbee776f29aa3a43f3f04245798' AND deleted=0 AND url_id!=6 AND site_id=1 LIMIT
10
10 Query SELECT us.description, us.keywords, us.title,
us.docsize, u.crc, u.url, us.content_type,
u.last_modified, u.etag, us.txt,us.words FROM urlword u, urlwords12 us WHERE
u.url_id=12 AND us.url_id=u.url_id
10 Query SELECT url_id, url FROM urlword WHERE
crc='619679c321133a563d27ac035c52a814' AND deleted=0 AND url_id!=12 AND site_id=1
LIMIT 10
10 Query SELECT us.description, us.keywords, us.title,
us.docsize, u.crc, u.url, us.content_type,
u.last_modified, u.etag, us.txt,us.words FROM urlword u, urlwords14 us WHERE
u.url_id=14 AND us.url_id=u.url_id
10 Query SELECT url_id, url FROM urlword WHERE
crc='2f952a65135b63a9a056b459c0f3f60e' AND deleted=0 AND url_id!=14 AND site_id=1
LIMIT 10
10 Query SELECT us.description, us.keywords, us.title,
us.docsize, u.crc, u.url, us.content_type,
u.last_modified, u.etag, us.txt,us.words FROM urlword u, urlwords01 us WHERE
u.url_id=17 AND us.url_id=u.url_id
10 Query SELECT url_id, url FROM urlword WHERE
crc='b30642d42881724e85b5ef98c90c2059' AND deleted=0 AND url_id!=17 AND site_id=1
LIMIT 10
============================================================================================================
Also i notice that the urls for the word_id=119 exist in file 19w/119
I attach it too.
Is it possible that this file is corrupted???
Anybody got a clue??
�������� ��������
Application Developer
Eurisko A.E.
�������� 9
106 71 �����
���: +301 3633362
���: +301 3633074
e-mail: [EMAIL PROTECTED]
119
