This is strange. According to contents of this file, ASPseek returns 5 URLs
with IDs 5,6,12,14,17
What are "urlword.url" and "urlword.site_id" fields for these IDs?
It seems that "urlword" table contains wrong records.
----- Original Message -----
From: "Achilleas Mantzios" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 23, 2001 10:25 PM
Subject: [aseek-users] st variable
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]
