On Wed, 21 Feb 2001, you wrote:
> ----- 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.
--
This is the url :
http://bookmarks.pathfinder.gr/folderz.php?username=ntokoros
This is the bad line.
<a class=link2
href=http://javascript:void(open(\'http://bookmarks.pathfinder.gr/add.php?title=\'
escape(%20document.title) \'&url=\'
escape(location.href),\'Backflip\',\'height=530,width=530,l%20ocation=no,scrollbars=no,menubars=no,toolbars=no,resizable=yes\'));
target=blank_>
�������� ��������
Application Developer
Eurisko A.E.
�������� 9
106 71 �����
���: +301 3633362
���: +301 3633074
e-mail: [EMAIL PROTECTED]
