|
Тема |
Re: заявката грешката [re: phpGuru] |
|
Автор |
salle (един такъв) |
|
Публикувано | 09.12.03 22:05 |
|
|
Database changed
mysql> CREATE TABLE `pics` (
-> `id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
-> `title` varchar( 255 ) NOT NULL default '',
�нр', 'история на клуба' ) NOT NULL ,аж', 'спорт', 'хумор', 'абстрактно', 'ж� обра�
-> `user_id` int( 10 ) unsigned NOT NULL default '0',
-> `from_date` datetime NOT NULL default '0000-00-00 00:00:00',
-> `pic_status` set( '', 'portfolio', 'censured' ) NOT NULL default '',
-> `tech_data` varchar( 250 ) NOT NULL default '',
-> `keywords` varchar( 100 ) default NULL ,
-> `visited` int( 11 ) NOT NULL default '0',
-> `lastvisit` datetime default NULL ,
-> PRIMARY KEY ( `id` ) ,
-> KEY `member_id` ( `user_id` ) ,
-> KEY `pic_galery` ( `gallery` ) ,
-> KEY `fromdate` ( `from_date` ) ,
-> FULLTEXT KEY `fulltext_ind` ( `title` , `gallery` , `tech_data` , `keywords` )
-> ) TYPE = MYISAM AUTO_INCREMENT =1;
ERROR 1282 (HY000): Column 'gallery' cannot be part of FULLTEXT index
mysql> SELECT VERSION();
+-----------------------+
| VERSION() |
+-----------------------+
| 4.1.1-alpha-debug-log |
+-----------------------+
|
| |
|
|
|