----- Original Message -----
From: "Achilleas Mantzios" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 21, 2001 4:34 PM
Subject: Re: [aseek-users] Error: You have an error in your SQL syntax near
'http:', '5' at line 1
> On Wed, 21 Feb 2001, you wrote:
> > ----- Original Message -----
> > From: "Achilleas Mantzios" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Wednesday, February 21, 2001 3:33 PM
> > Subject: [aseek-users] Error: You have an error in your SQL syntax near
> > 'http:', '5' at line 1
> >
> >
> > > During index -D,
> > > i got this error.
> > >
> > > Here is the whole output.
> > >
> > > # sbin/index -D
> > > Loaded configuration from /usr/local/aspseek/etc/charsets.conf
> > > Loaded configuration from /usr/local/aspseek/etc/stopwords.conf
> > > Loaded configuration from /usr/local/aspseek/etc/aspseek.conf
> > > Saving real-time database ... done.
> > > Saving delta files
[..................................................]
> > done.
> > > Loading ranks [.............................................
.....]
> > done.
> > > Saving citation
[..................................................]
> > done.
> > > Calculating ranks
[..................................................]
> > done.
> > > In: 15040079. Out: 15040079. Rank: 452406.650041
> > > Urls: 1729194. Hrefs: 15040079
> > > Error: You have an error in your SQL syntax near 'http:', '5' at line
1
> > > index process finished.
> > > #
> > >
> > > I suppose the db and fs are both consistent.
> > > But then again i i should report this to the aspseek people.
> > >
> >
> > I suspect, that you defined wrong subset masks. Could you send
result of
> > query "SELECT * from subsets"?
> >
>
>
>
> mysql> SELECT * from subsets;
> Empty set (0.01 sec)
>
It seems to happen in GenerateWordSite(). Unfortunately, query causing
it is not known.
To find out it:
1) Replace lines
logger.log(CAT_SQL, L_ERR, "Error: %s\n", mysql_error(&m_my));
to
logger.log(CAT_SQL, L_ERR, "Error: %s <%s>\n", mysql_error(&m_my),
query);
in methods CMySQLDatabase::sql_query[w..](),
CMySQLDatabase::sql_real_query[w]() in the file "database.cpp"
2) recompile index
3) run "index -B", if it runs without error, then run "index -D".
4) see in the output query, which causes error.
Also, please send result of query "SELECT * from sites"
> mysql>
>
>
>
> > Alexander.
> >
> >
> > > �������� ��������
> > > 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]
