
02-27-2005, 10:47 AM
|
|
|
Join Date: Jul 2002
Location: Scotland
Posts: 3,486
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
Quote:
Originally Posted by Dep
get a small problem when i tried to install
Error
SQL-query:
--
-- Table structure for table `local_linkslink`
--
CREATE TABLE `local_linkslink` (
`linkid` int( 11 ) NOT NULL AUTO_INCREMENT ,
`linkname` varchar( 255 ) NOT NULL default '',
`linkdesc` text NOT NULL ,
`linkurl` text NOT NULL ,
`linkhits` mediumint( 8 ) unsigned NOT NULL default '0',
`linkforum` smallint( 5 ) NOT NULL default '0',
`linkcheck` int( 10 ) unsigned NOT NULL default '0',
`linkstatus` int( 10 ) NOT NULL default '0',
`linkdate` int( 10 ) NOT NULL default '0',
`linkusername` text NOT NULL ,
`linkuserid` int( 10 ) NOT NULL default '0',
`linkmoderate` int( 2 ) NOT NULL default '0',
`linkmoddate` int( 10 ) NOT NULL default '0',
`linkreviewfreq` smallint( 5 ) NOT NULL default '0',
PRIMARY KEY ( `linkid` ) ,
FULLTEXT KEY `namedesc` ( `linkname` , `linkdesc` )
) TYPE = MYISAM AUTO_INCREMENT =1
MySQL said: Documentation
#1283 - Column 'linkname' cannot be part of FULLTEXT index
any ideas how to fix it plz
|
Hello, what version of MySQL are you using?
|