PDA

View Full Version : Fulltext key not working



dkon26
Mon 17th Dec '07, 1:28pm
Yay it doesnt work! lol


Database error in vBulletin :
Invalid SQL:
CREATE TABLE socialgroup (
groupid INT unsigned NOT NULL auto_increment,
name VARCHAR(255) NOT NULL DEFAULT '',
description TEXT NOT NULL DEFAULT '',
creatoruserid INT unsigned NOT NULL DEFAULT '0',
dateline INT unsigned NOT NULL DEFAULT '0',
members INT unsigned NOT NULL DEFAULT '0',
picturecount INT unsigned NOT NULL DEFAULT '0',
lastpost INT unsigned NOT NULL DEFAULT '0',
lastposter VARCHAR(255) NOT NULL DEFAULT '',
lastposterid INT UNSIGNED NOT NULL DEFAULT '0',
lastgmid INT UNSIGNED NOT NULL DEFAULT '0',
visible INT UNSIGNED NOT NULL DEFAULT '0',
deleted INT UNSIGNED NOT NULL DEFAULT '0',
moderation INT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (groupid),
KEY creatoruserid (creatoruserid),
KEY dateline (dateline),
FULLTEXT KEY name (name, description)
);
MySQL Error : The used table type doesn't support FULLTEXT indexes
Error Number : 1214
Date : Monday, December 17th 2007 @ 12:24:59 PM
Script : http://192.168.1.100/forums/install/install.php?step=3
Referrer : http://192.168.1.100/forums/install/install.php?step=2
IP Address : 192.168.1.100
Username :
Classname : vB_Database

Andy Huang
Mon 17th Dec '07, 1:34pm
Yay it doesnt work! lol

<!-- snip -->

Looks like it is trying to create a table w/ fulltext before setting it to the right table type... but I thought myisam was default.... oh well, please go to pt and report it as a bug :)


Edit: memo: I've split this from the main chat thread so it gets noticed easier. You now have the first thread in this forum, wowowow? :P

Wayne Luke
Mon 17th Dec '07, 2:17pm
This should be fixed now.. Redownload the files and let us know if you have anymore problems.