[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: RE: [Phpgroupware-users] Phpbrain error when search
From: |
Dave Hall |
Subject: |
Re: RE: [Phpgroupware-users] Phpbrain error when search |
Date: |
Thu, 08 May 2003 08:06:39 +1000 |
When did you check it out from cvs?
content-type: multipart/alternative;
boundary="----=_NextPart_000_001D_01C314A9.248636B0"
------=_NextPart_000_001D_01C314A9.248636B0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
Hello,
Where is the README file I don't find it?
maybe I am to tired for find it but I don't think so ;)
-----Message d'origine-----
De : address@hidden
[mailto:address@hidden
De la part de Dave Hall
Envoye : mercredi 7 mai 2003 13:58
A : address@hidden
Objet : Re: [Phpgroupware-users] Phpbrain error when search
Hey Serge,
I wrote the phpbrain app. This is a know issue. The index must be
created manually. This should be covered in the README in the phpbrain
directory. It is a limitation of the phpgw schema proc class(es).
Let me know how you go.
Cheers
Dave
content-type: multipart/alternative;
boundary="----=_NextPart_000_0002_01C3148D.5808C5A0"
------=_NextPart_000_0002_01C3148D.5808C5A0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Hello,
Some trouble when I try to make a search with phpbrain. I receive this :
Database error: Invalid SQL: SELECT *, MATCH text,keywords,title
AGAINST('test') AS score FROM phpgw_kb_faq WHERE published = 1 ORDER BY
score DESC
MySQL Error: 1191 (Can't find FULLTEXT index matching the column list)
File: /home/httpd/html/phpgroupware/phpbrain/inc/class.sokb.inc.php
Line: 341
Session halted.
Anyone Know that ?
thx for help.
------=_NextPart_000_0002_01C3148D.5808C5A0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DWindows-1252">
<META content=3D"MSHTML 6.00.2600.0" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D488383709-07052003><FONT face=3DArial=20
size=3D2>Hello,</FONT></SPAN></DIV>
<DIV><SPAN class=3D488383709-07052003><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D488383709-07052003><FONT face=3DArial =
size=3D2> =20
Some trouble when I try to make a search with phpbrain. I receive this=20
:</FONT></SPAN></DIV>
<DIV><SPAN class=3D488383709-07052003><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D488383709-07052003><FONT face=3DArial =
size=3D2>Database error:=20
Invalid SQL: SELECT *, MATCH text,keywords,title AGAINST('test') AS =
score FROM=20
phpgw_kb_faq WHERE published =3D 1 ORDER BY score DESC<BR>MySQL Error: =
1191 (Can't=20
find FULLTEXT index matching the column list)<BR><BR>File:=20
/home/httpd/html/phpgroupware/phpbrain/inc/class.sokb.inc.php<BR>Line: =
341=20
</FONT>
<P><FONT face=3DArial size=3D2>Session halted. </FONT></P>
<P><FONT face=3DArial size=3D2></FONT> </P>
<P><SPAN class=3D488383709-07052003><FONT face=3DArial size=3D2>Anyone =
Know that=20
?</FONT></SPAN></P>
<P><SPAN class=3D488383709-07052003><FONT face=3DArial size=3D2>thx for=20
help.</FONT></SPAN></P>
<P><SPAN=20
class=3D488383709-07052003><STRONG></STRONG></SPAN> </P></SPAN></DIV=
></BODY></HTML>
------=_NextPart_000_0002_01C3148D.5808C5A0--
------=_NextPart_000_001D_01C314A9.248636B0
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DWindows-1252">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
6.0.4712.0">
<TITLE>RE: [Phpgroupware-users] Phpbrain error when search</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=3D2>Hello,</FONT>
</P>
<P> <FONT SIZE=3D2>Where is =
the README file I don't find it?</FONT>
<BR> <FONT SIZE=3D2>maybe I am =
to tired for find it but I don't think so ;)</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>-----Message d'origine-----</FONT>
<BR><FONT SIZE=3D2>De : =
address@hidden</FONT>
<BR><FONT SIZE=3D2>[<A =
HREF=3D"mailto:address@hidden
gnu.org">mailto:phpgroupware-users-bounces+serge.rodrigues=3Dperiactes.be=
@gnu.org</A>]</FONT>
<BR><FONT SIZE=3D2>De la part de Dave Hall</FONT>
<BR><FONT SIZE=3D2>Envoye : mercredi 7 mai 2003 13:58</FONT>
<BR><FONT SIZE=3D2>A : address@hidden</FONT>
<BR><FONT SIZE=3D2>Objet : Re: [Phpgroupware-users] Phpbrain error when =
search</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Hey Serge,</FONT>
</P>
<P><FONT SIZE=3D2>I wrote the phpbrain app. This is a know =
issue. The index must be</FONT>
<BR><FONT SIZE=3D2>created manually. This should be covered in the =
README in the phpbrain</FONT>
<BR><FONT SIZE=3D2>directory. It is a limitation of the phpgw =
schema proc class(es).</FONT>
</P>
<P><FONT SIZE=3D2>Let me know how you go.</FONT>
</P>
<P><FONT SIZE=3D2>Cheers</FONT>
</P>
<P><FONT SIZE=3D2>Dave</FONT>
<BR><FONT SIZE=3D2>content-type: multipart/alternative;</FONT>
<BR> <FONT =
SIZE=3D2>boundary=3D"----=3D_NextPart_000_0002_01C3148D.5808C5A0&quo=
t;</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>------=3D_NextPart_000_0002_01C3148D.5808C5A0</FONT>
<BR><FONT SIZE=3D2>Content-Type: text/plain;</FONT>
<BR> <FONT =
SIZE=3D2>charset=3D"iso-8859-1"</FONT>
<BR><FONT SIZE=3D2>Content-Transfer-Encoding: 7bit</FONT>
</P>
<P><FONT SIZE=3D2>Hello,</FONT>
</P>
<P><FONT SIZE=3D2> Some trouble when I try to make a =
search with phpbrain. I receive this :</FONT>
</P>
<P><FONT SIZE=3D2>Database error: Invalid SQL: SELECT *, MATCH =
text,keywords,title</FONT>
<BR><FONT SIZE=3D2>AGAINST('test') AS score FROM phpgw_kb_faq WHERE =
published =3D 1 ORDER BY</FONT>
<BR><FONT SIZE=3D2>score DESC</FONT>
<BR><FONT SIZE=3D2>MySQL Error: 1191 (Can't find FULLTEXT index matching =
the column list)</FONT>
</P>
<P><FONT SIZE=3D2>File: =
/home/httpd/html/phpgroupware/phpbrain/inc/class.sokb.inc.php</FONT>
<BR><FONT SIZE=3D2>Line: 341</FONT>
</P>
<P><FONT SIZE=3D2>Session halted.</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=3D2>Anyone Know that ?</FONT>
</P>
<P><FONT SIZE=3D2>thx for help.</FONT>
</P>
<BR>
<BR>
<BR>
<P><FONT SIZE=3D2>------=3D_NextPart_000_0002_01C3148D.5808C5A0</FONT>
<BR><FONT SIZE=3D2>Content-Type: text/html;</FONT>
<BR> <FONT =
SIZE=3D2>charset=3D"iso-8859-1"</FONT>
<BR><FONT SIZE=3D2>Content-Transfer-Encoding: quoted-printable</FONT>
</P>
<P><FONT SIZE=3D2><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 =
Transitional//EN"></FONT>
<BR><FONT SIZE=3D2><HTML><HEAD></FONT>
<BR><FONT SIZE=3D2><META HTTP-EQUIV=3D3D"Content-Type" =
CONTENT=3D3D"text/html; =3D</FONT>
<BR><FONT SIZE=3D2>charset=3D3DWindows-1252"></FONT>
</P>
<BR>
<P><FONT SIZE=3D2><META content=3D3D"MSHTML 6.00.2600.0" =
name=3D3DGENERATOR></HEAD></FONT>
<BR><FONT SIZE=3D2><BODY></FONT>
<BR><FONT SIZE=3D2><DIV><SPAN =
class=3D3D488383709-07052003><FONT face=3D3DArial=3D20</FONT>
<BR><FONT =
SIZE=3D2>size=3D3D2>Hello,</FONT></SPAN></DIV></FONT=
>
<BR><FONT SIZE=3D2><DIV><SPAN =
class=3D3D488383709-07052003><FONT face=3D3DArial=3D20</FONT>
<BR><FONT =
SIZE=3D2>size=3D3D2></FONT></SPAN>&nbsp;</DIV></=
FONT>
<BR><FONT SIZE=3D2><DIV><SPAN =
class=3D3D488383709-07052003><FONT face=3D3DArial =3D</FONT>
<BR><FONT =
SIZE=3D2>size=3D3D2>&nbsp;&nbsp;&nbsp;=3D20</FONT>
<BR><FONT SIZE=3D2>Some trouble when I try to make a search with =
phpbrain. I receive this=3D20</FONT>
<BR><FONT SIZE=3D2>:</FONT></SPAN></DIV></FONT>
<BR><FONT SIZE=3D2><DIV><SPAN =
class=3D3D488383709-07052003><FONT face=3D3DArial=3D20</FONT>
<BR><FONT =
SIZE=3D2>size=3D3D2></FONT></SPAN>&nbsp;</DIV></=
FONT>
<BR><FONT SIZE=3D2><DIV><SPAN =
class=3D3D488383709-07052003><FONT face=3D3DArial =3D</FONT>
<BR><FONT SIZE=3D2>size=3D3D2>Database error:=3D20</FONT>
<BR><FONT SIZE=3D2>Invalid SQL: SELECT *, MATCH text,keywords,title =
AGAINST('test') AS =3D</FONT>
<BR><FONT SIZE=3D2>score FROM=3D20</FONT>
<BR><FONT SIZE=3D2>phpgw_kb_faq WHERE published =3D3D 1 ORDER BY score =
DESC<BR>MySQL Error: =3D</FONT>
<BR><FONT SIZE=3D2>1191 (Can't=3D20</FONT>
<BR><FONT SIZE=3D2>find FULLTEXT index matching the column =
list)<BR><BR><A HREF=3D"File:=3D20">File:=3D20</A></FONT>
<BR><FONT =
SIZE=3D2>/home/httpd/html/phpgroupware/phpbrain/inc/class.sokb.inc.php<=
;BR>Line: =3D</FONT>
<BR><FONT SIZE=3D2>341=3D20</FONT>
<BR><FONT SIZE=3D2></FONT></FONT>
<BR><FONT SIZE=3D2><P><FONT face=3D3DArial =
size=3D3D2>Session halted. </FONT></P></FONT>
<BR><FONT SIZE=3D2><P><FONT face=3D3DArial =
size=3D3D2></FONT>&nbsp;</P></FONT>
<BR><FONT SIZE=3D2><P><SPAN =
class=3D3D488383709-07052003><FONT face=3D3DArial =
size=3D3D2>Anyone =3D</FONT>
<BR><FONT SIZE=3D2>Know that=3D20</FONT>
<BR><FONT SIZE=3D2>?</FONT></SPAN></P></FONT>
<BR><FONT SIZE=3D2><P><SPAN =
class=3D3D488383709-07052003><FONT face=3D3DArial =
size=3D3D2>thx for=3D20</FONT>
<BR><FONT SIZE=3D2>help.</FONT></SPAN></P></FONT>
<BR><FONT SIZE=3D2><P><SPAN=3D20</FONT>
<BR><FONT =
SIZE=3D2>class=3D3D488383709-07052003><STRONG></STRONG><=
;/SPAN>&nbsp;</P></SPAN></DIV=3D</FONT>
<BR><FONT SIZE=3D2>></BODY></HTML></FONT>
</P>
<P><FONT SIZE=3D2>------=3D_NextPart_000_0002_01C3148D.5808C5A0--</FONT>
</P>
</BODY>
</HTML>
------=_NextPart_000_001D_01C314A9.248636B0--
_______________________________________________
Phpgroupware-users mailing list
address@hidden
http://mail.gnu.org/mailman/listinfo/phpgroupware-users
dave.hall.vcf
Description: Card for <dave.hall@mbox.com.au>