Viewing: Installation error in wizard - when I install using newinstall.php it has an error
Posted on Nov 28, 2007, 8:50 am by
petermac
petermac
Newbie
Group: Members
Posts: 4
Reputation : 0
Posted on Nov 28, 2007, 8:50 am by
petermac
Installation error in wizard
I just got the nightly build and tried install.php ... didn't work... then tried "old way" with newinstall.php and get this far... any help appreciated.
Also when I run this SQL directly in MySQL I get this error : #1214 - The used table type doesn't support FULLTEXT indexes
Inserting all required data in the database.
Failure! - Reported Error:
Sorry, unable to run query:
CREATE TABLE `bb_posts` ( `post_ID` int(11) NOT NULL auto_increment, `topic` int(10) default NULL, `post_title` varchar(255) default NULL, `post_description` varchar(255) default NULL, `text` mediumtext, `post_date` int(10) default NULL, `author_id` int(10) default NULL, `author_name` varchar(100) default NULL, `author_edit` varchar(100) default NULL, `post_icon_id` int(10) default NULL, `richtext` tinyint(1) default '0', `server` int(10) default NULL, `trackbacks` int(10) default '0', `from_ip_address` varchar(16) default NULL, `picture` tinyint(1) default '0', `edit_date` int(10) default NULL, PRIMARY KEY (`post_ID`), KEY `topic` (`topic`), KEY `post_date` (`post_date`), KEY `author_id` (`author_id`), KEY `server` (`server`), KEY `trackbacks` (`trackbacks`), KEY `from_ip_address` (`from_ip_address`), KEY `server_topic` (`server`,`topic`), FULLTEXT KEY `post_title` (`post_title`), FULLTEXT KEY `post_title_2` (`post_title`,`text`)) ;
Last edit by petermac on Nov 28, 2007, 8:52 am
Commifreak
Story Teller
Group: Developers
Posts: 313
Reputation : 4
its an error in you table. sql says: The used table type doesn't support FULLTEXT indexes
how you can fix this, i domnt know
Greetings,
CF
----
http://www.commifreak-online.de
Posted on Nov 28, 2007, 12:15 pm by
petermac
petermac
Newbie
Group: Members
Posts: 4
Reputation : 0
Posted on Nov 28, 2007, 12:15 pm by
petermac
its an error in you table. sql says: The used table type doesn't support FULLTEXT indexes
how you can fix this, i domnt know
Yes, I understand it is a SQL error, but it was part of the installation process under newinstall.php its not my code its part of the secondary wizard process. So if there is any help on changing my MySQL setup or whatever to deal with this then that would be great.
Petermac
Commifreak
Story Teller
Group: Developers
Posts: 313
Reputation : 4
Posted on Nov 28, 2007, 12:30 pm by
petermac
petermac
Newbie
Group: Members
Posts: 4
Reputation : 0
Posted on Nov 28, 2007, 12:30 pm by
petermac
I don't care that much, I will just go with another BBS that works from the start... thanks for your help though...
Petermac
Commifreak
Story Teller
Group: Developers
Posts: 313
Reputation : 4
sorry, then qit of chris. i cant do here somtthing now
im only the helper by setting up the board, and the translations
Greetings,
CF
----
http://www.commifreak-online.de
Posted on Nov 28, 2007, 1:15 pm by
jice
Posted on Nov 28, 2007, 1:31 pm by
petermac
petermac
Newbie
Group: Members
Posts: 4
Reputation : 0
Posted on Nov 28, 2007, 1:31 pm by
petermac
If i have a good memory, I had this problem because my tables were innoDB type. They must be MyIsam type to support FULLTEXT indexes
Regards,
JC
Thanks, I will give that a go... cheers, Petermac
Posted on Nov 29, 2007, 4:15 am by
chris
Quick Jump:
Page generated in 0.05 seconds (Queries: 0.00) - Cpu: 0.50 Total DB [adodb:mysql] queries: 14 Total Strings Translated: 14