----- Original Message -----
From: "Achilleas Mantzios" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 21, 2001 5:02 PM
Subject: Re: [aseek-users] Error: You have an error in your SQL syntax near
'http:', '5' at line 1
> > 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>
> > >
> >
>
>
> Thanx, anyway, accidentally i found the bad insert.
>
> it is :
>
> INSERT INTO wordsite(word, sites) VALUES('javascript:void(open('http:',
'^E5
>
> No harm done!!
So you can find in "sites" table site with name containing 'javascript',
then find any url, belonging to that site,
then find referer to this url, and find link in referer.
By default, sites containing apostrophe are not indexed, that's why it is
very strange.
I want to look at the page with that strange link.
