https://www.icyphoenix.com/viewtopic.php?f=35&t=5635
-----------------------------------
akira999
Sat 28 Mar, 2009 10:24

Problem Instalation!!
-----------------------------------
hi was installing the Icy Phoenix when I came across this message  :( 

An error occurred trying to update the database
El tipo de tabla usada no soporta índices FULLTEXT

	
How could it? Thanks.


-----------------------------------
spydie
Sat 28 Mar, 2009 11:20

Re: Problem Instalation!!
-----------------------------------
are you trying to install local or on a hosting ??


-----------------------------------
Limun
Sat 28 Mar, 2009 12:08

Re: Problem Instalation!!
-----------------------------------
[quote user="spydie" post="37707"]are you trying to install local or on a hosting ??[/quote]
and also which one you try to install stable or beta version ?

anyway if you try stable
open /install/schemas/[b]mysql_schema.sql[/b]

find
[code]  KEY `comments_id` (`comments_id`),
  FULLTEXT KEY `comment_bbcode_uid` (`comment_bbcode_uid`)[/code]

replace with

[code]KEY `comments_id` (`comments_id`)[/code]

find and delete

[code]ALTER TABLE `phpbb_topics` ADD FULLTEXT (topic_title);[/code]

than install again


-----------------------------------
akira999
Sat 28 Mar, 2009 18:02

Re: Problem Instalation!!
-----------------------------------
thanks for the help Limun. :mryellow: 

spydie if a local server in EasyPhp

But now I have this problem :( 

An error occurred trying to update the database
Campo Blob 'long_desc' no puede tener valores patron

Thanks.


-----------------------------------
spydie
Sat 28 Mar, 2009 19:31

Re: Problem Instalation!!
-----------------------------------
you need apache server or WAMP installed for running ICY.

dont know easy php


-----------------------------------
akira999
Sat 28 Mar, 2009 20:54

Re: Problem Instalation!!
-----------------------------------
thanks for your help install WAMP server and worked perfect thanks  :mryellow: 

thanks 

spydie and Limun.


-----------------------------------
novice programmer
Sun 29 Mar, 2009 15:16

Re: [SOLVED]   Problem Instalation!!
-----------------------------------
Bug explain:

The thing was caused because of the default engine is the innodb, and for the fulltext index you would need the myisam one.

You can choose to disable the similar topics (why the fulltext index is for) or set myisam engine for IP tables.


