RE: [Slashcode-general] "search" plugin "ADD FULLTEXT" fails on new, latest install

[Gaulin, M. <mg...@gl...>]

Hi Shane
Yeah, those where the errors I got.  I took your advice and switched the =
tables to MyISAM and reran the ADD INDEX commands and they all worked.  =
So far so good!
Thanks for your help.
	Mark

-----Original Message-----
From: Shane [mailto:sh...@lo...]
Sent: Friday, December 10, 2004 11:17 AM
To: Gaulin, Mark
Cc: slashcode List
Subject: Re: [Slashcode-general] "search" plugin "ADD FULLTEXT" fails on
new, latest install


I thought you could do InnoDB and fulltext, you just can't have =20
fulltext on an indexed column when tabletype=3D=3DInnodb?

Restrictions on InnoDB tables:

http://dev.mysql.com/doc/mysql/en/InnoDB_restrictions.html

If you look at the table story_text:

| story_text | CREATE TABLE `story_text` (
   `stoid` mediumint(8) unsigned NOT NULL default '0',
   `title` varchar(100) NOT NULL default '',
   `introtext` text,
   `bodytext` text,
   `relatedtext` text,
   `rendered` text,
   PRIMARY KEY  (`stoid`)
) TYPE=3DInnoDB |

the Slash::Search plugin's doing this (in mysql_prep):

ALTER TABLE story_text ADD FULLTEXT title (title), ADD FULLTEXT =20
intro_body (introtext,b
odytext);
ALTER TABLE comments.....

Here's the errors I got when doing a fresh-install:

Error:Slash::Install:/Library/Perl/5.8.1/darwin-thread-multi-2level/=20
Slash/Install.pm:578:DB=3D'slash' -- hostinfo=3D'Localhost via UNIX =
socket' =20
-- The used table type doesn't support FULLTEXT indexes -- ALTER TABLE =20
story_text ADD FULLTEXT title (title), ADD FULLTEXT intro_body =20
(introtext,bodytext)
Which was called =20
by:Slash::Install:/Library/Perl/5.8.1/darwin-thread-multi-2level/Slash/=20
Install.pm:175:DB=3D'slash' -- hostinfo=3D'Localhost via UNIX socket' -- =
=20
The used table type doesn't support FULLTEXT indexes -- ALTER TABLE =20
story_text ADD FULLTEXT title (title), ADD FULLTEXT intro_body =20
(introtext,bodytext)
=3D=3D=3D (Search) Failed on :ALTER TABLE story_text ADD FULLTEXT title  =

(title), ADD FULLTEXT intro_body (introtext,bodytext):
Error:Slash::Install:/Library/Perl/5.8.1/darwin-thread-multi-2level/=20
Slash/Install.pm:578:DB=3D'slash' -- hostinfo=3D'Localhost via UNIX =
socket' =20
-- The used table type doesn't support FULLTEXT indexes -- ALTER TABLE =20
comments add fulltext (subject)
Which was called =20
by:Slash::Install:/Library/Perl/5.8.1/darwin-thread-multi-2level/Slash/=20
Install.pm:175:DB=3D'slash' -- hostinfo=3D'Localhost via UNIX socket' -- =
=20
The used table type doesn't support FULLTEXT indexes -- ALTER TABLE =20
comments add fulltext (subject)
=3D=3D=3D (Search) Failed on :ALTER TABLE comments add fulltext =
(subject):
Error:Slash::Install:/Library/Perl/5.8.1/darwin-thread-multi-2level/=20
Slash/Install.pm:578:DB=3D'slash' -- hostinfo=3D'Localhost via UNIX =
socket' =20
-- The used table type doesn't support FULLTEXT indexes -- ALTER TABLE =20
comment_text add fulltext (comment)
Which was called =20
by:Slash::Install:/Library/Perl/5.8.1/darwin-thread-multi-2level/Slash/=20
Install.pm:175:DB=3D'slash' -- hostinfo=3D'Localhost via UNIX socket' -- =
=20
The used table type doesn't support FULLTEXT indexes -- ALTER TABLE =20
comment_text add fulltext (comment)
=3D=3D=3D (Search) Failed on :ALTER TABLE comment_text add fulltext =
(comment):
Error:Slash::Install:/Library/Perl/5.8.1/darwin-thread-multi-2level/=20
Slash/Install.pm:578:DB=3D'slash' -- hostinfo=3D'Localhost via UNIX =
socket' =20
-- The used table type doesn't support FULLTEXT indexes -- ALTER TABLE =20
users add fulltext (nickname)
Which was called =20
by:Slash::Install:/Library/Perl/5.8.1/darwin-thread-multi-2level/Slash/=20
Install.pm:175:DB=3D'slash' -- hostinfo=3D'Localhost via UNIX socket' -- =
=20
The used table type doesn't support FULLTEXT indexes -- ALTER TABLE =20
users add fulltext (nickname)
=3D=3D=3D (Search) Failed on :ALTER TABLE users add fulltext (nickname):
Error:Slash::Install:/Library/Perl/5.8.1/darwin-thread-multi-2level/=20
Slash/Install.pm:578:DB=3D'slash' -- hostinfo=3D'Localhost via UNIX =
socket' =20
-- The used table type doesn't support FULLTEXT indexes -- ALTER TABLE =20
pollquestions add fulltext (question)
Which was called =20
by:Slash::Install:/Library/Perl/5.8.1/darwin-thread-multi-2level/Slash/=20
Install.pm:175:DB=3D'slash' -- hostinfo=3D'Localhost via UNIX socket' -- =
=20
The used table type doesn't support FULLTEXT indexes -- ALTER TABLE =20
pollquestions add fulltext (question)
=3D=3D=3D (Search) Failed on :ALTER TABLE pollquestions add fulltext =20
(question):

[coolio:src/slash/slash.new] shane# mysql -V
mysql  Ver 12.22 Distrib 4.0.17, for apple-darwin7.3.0 (powerpc)

  Shane


On Dec 10, 2004, at 10:42 AM, Gaulin, Mark wrote:

> Hi Folks
> All of the "ALTER TABLE x ADD FULLTEXT" lines in the =20
> plugins\Search\mysql_prep fail when the plugin is installed, and it =20
> sure looks like it's because FULLTEXT isn't supported for InnoDB =20
> tables.  (It's a new MySQL installation on fedora, version =20
> 4.1.7-standard.)
>
> Is FULLTEXT really needed?  What do other people do?
>
> Thanks
> 	Mark
>
>
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real =20
> users.
> Discover which products truly live up to the hype. Start reading now.
> http://productguide.itmanagersjournal.com/
> _______________________________________________
> Slashcode-general mailing list
> Sla...@li...
> https://lists.sourceforge.net/lists/listinfo/slashcode-general
>