Re: [Slashcode-general] SQL error in install-slashsite: "This command is not supported in the prepared statement protocol yet"

[shane <sh...@lo...>]

On Jan 26, 2006, at 4:47 PM, ja...@in... wrote:

> # perl -v | grep "This is perl"
> This is perl, v5.8.7 built for i686-linux-thread-multi
> # mysql -V
> mysql  Ver 14.7 Distrib 4.1.14, for pc-linux-gnu (i686) using  
> readline 5.0
> # cd /usr/local/slash
> # bin/install-slash
>
> the error is:
>
>
> DO: Something wrong while try to prepare query This command is not
> supported in the prepared statement protocol yet
> Error in library:
> Slash::Install:/usr/lib/perl5/site_perl/5.8.7/i686-linux-thread- 
> multi/Slash/Install.pm:330:ALTER
> TABLE stories add fulltext (title)
> Which was called by:
> Slash::Install:/usr/lib/perl5/site_perl/5.8.7/i686-linux-thread- 
> multi/Slash/Install.pm:153:ALTER
> TABLE stories add fulltext (title)
> Failed on :ALTER TABLE stories add fulltext (title):
>
>
> I think it might have something to do with this bug:
> http://bugs.mysql.com/bug.php?id=15665

No, I don't think that's it. The problem is the default table type  
for the table stories is MyISAM. However, with MySQL v4.x (and 5.x,  
so far) you can't do fulltext indexes on MyISAM tables. You can do  
them on InnoDB tables, however.

I thought there was mention of this in the INSTALL. If not, this  
should be explained there. Maybe in the FAQ?

Your slash installation will work, as is, even with the above errors.  
If you want the search to play nice, then you'll want to alter the  
table types for those tables and then add the fulltext indexes. Note  
the mention of fulltext limitations in the faq: http:// 
slash.lottadot.com/faqster.pl?op=view&fid=1

BTW, while you mentioned which perl and mysql you're using (which is  
great) you didn't mention what version of _slash_ you're using.

  Shane