[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Phpgroupware-users] Phpbrain error when search
From: |
Dave Hall |
Subject: |
Re: [Phpgroupware-users] Phpbrain error when search |
Date: |
Wed, 07 May 2003 21:57:53 +1000 |
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--
_______________________________________________
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>