|
| From: | Serge Rodrigues |
| Subject: | RE: [Phpgroupware-users] Phpbrain error when search |
| Date: | Wed, 7 May 2003 14:58:37 +0200 |
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="">
help.</FONT></SPAN></P>
<P><SPAN=20
class=3D488383709-07052003><STRONG></STRONG></SPAN> </P></SPAN></DIV=
></BODY></HTML>
------=_NextPart_000_0002_01C3148D.5808C5A0--
| [Prev in Thread] | Current Thread | [Next in Thread] |