#1071 - Specified key was too long; max key length is 1000 bytes

Databases
1

I had database like picture when i try to create full text search

ALTER TABLE sachgiamgia_books_books ADD INDEX book_fulltextsearch (name,name_khongdau,content(250),content_khongdau(250))

i have error!

#1071 - Specified key was too long; max key length is 1000 bytes

please help me !

2

Welcome to the SP forums.

255+255+250+250 = 1010
1010 is bigger than 1000

Maybe you could shorten some of those fields?

3

Thank ! when i try run sql query again

ALTER TABLE sachgiamgia_books_books ADD INDEX book_fulltextsearch (name(100),name_khongdau(100),content(256),content_khongdau(256))

but i have error again. please help me !

4

was it the same error message? or a different one?

fyi, that’s not actually a fulltext index, it’s just an ordinary index

5

The same error
#1071 - Specified key was too long; max key length is 1000 bytes r937
@r937 i want to create fulltext index. please help me ! thank you

6

http://dev.mysql.com/doc/refman/5.1/en/create-index.html

:slight_smile:

7

sorry @r937 i mean "full text search ". this link that’s about "full text search " ?

8

that link is not about full text searching, however, it does give the appropriate syntax for declaring a fulltext index

9

@r937 can you help me about full text seach ?

about statement to create full text seach with tow fields (name,name_khongdau). thank you

10

i try to run sql query
ALTER TABLE sachgiamgia_books_books ADD FULLTEXT(name,name_khongdau)

and affter that i make select

select concat(name) as name, match(name_khongdau) against(‘manh’) as relevance from sachgiamgia_books_books where match(name_khongdau) against(‘manh’);

i have error .

#1191 - Can’t find FULLTEXT index matching the column list

Please tell me what wrong ? What did i do wrong

11

you created a fulltext index on two columns, but you wrote your query to match against only one column

12

Thank you! it worked. :slight_smile:

13

i have problem agian

i make a sql

SELECT concat( name ) AS name, MATCH (name, name_khongdau) AGAINST (‘dã tràng xe cát’) AS relevance FROM sachgiamgia_books_books WHERE MATCH ( name, name_khongdau ) AGAINST ( ‘dã tràng xe cát’ )

I get result like picture. Please see picture that my problem

14

i have no idea, sorry