On Sat, 24 Feb 2001, you wrote:
> 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.
mysql> select url,site_id,url_id from urlword where url_id in (5,6,12,14,17);
+---------------------------------------------+---------+--------+
| url | site_id | url_id |
+---------------------------------------------+---------+--------+
| http://www.eseek.gr/addurl/index.html | 1 | 5 |
| http://www.eseek.gr/services/index.html | 1 | 6 |
| http://www.eseek.gr/services/websearch.html | 1 | 12 |
| http://www.eseek.gr/services/link.html | 1 | 14 |
| http://www.trinity.gr/ | 2 | 17 |
+---------------------------------------------+---------+--------+
5 rows in set (0.02 sec)
mysql>
>
>
> ----- 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]
--
�������� ��������
Application Developer
Eurisko A.E.
�������� 9
106 71 �����
���: +301 3633362
���: +301 3633074
e-mail: [EMAIL PROTECTED]
