3

I have specific error when I'd like to add FULLTEXT INDEX to column street. My code is below.

ALTER TABLE offer_private_14 ADD FULLTEXT INDEX idx_street (street);

Error is:

"SQL Error (1062): Duplicate entry '' for key 'UNKNOWN'".

My structure table is:

CREATE `offer_private_14` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(200) NOT NULL,
  `description` text NOT NULL,
  `street` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `idx_title` (`title`),
  FULLTEXT KEY `idx_description` (`description`),
) ENGINE=InnoDB AUTO_INCREMENT=7952290 DEFAULT CHARSET=utf8;

Error is when I have records in table. When I haven't records in table I can add FULLTEXT INDEX. I don't know why. In some table I can't delete all my records to add FULLTEXT INDEX.

I can't deal with this...

Improve this question
2
Related questions
29
MySQL FULLTEXT indexes issue
2
Why FULLTEXT index is not being populated - MYSQL
3
Can't add FULLTEXT index on MyISAM table
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.