Search Indexing Error

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Anti-Spam Guide
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Registered User
Posts: 3
Joined: Tue Dec 18, 2007 12:53 pm

Search Indexing Error

Post by M-Winter »

I have a V2 forum, installed V3 and converted the V2 database, everything seems to be working OK.
search settings backend fulltext native

I run the maintenance search index Fulltext mysql create index and get the following error.

Also an indexing window opens and says indexing may take a few minutes to a few hours and seems to show that indexing is taking place.

General Error
SQL ERROR [ mysql4 ]

Column 'post_text' cannot be part of FULLTEXT index [1283]


ALTER TABLE phpbb_posts ADD FULLTEXT (post_subject), MODIFY post_text mediumtext COLLATE utf8_unicode_ci NOT NULL, ADD FULLTEXT (post_text), ADD FULLTEXT post_content (post_subject, post_text)


FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()

FILE: includes/search/fulltext_mysql.php
LINE: 738
CALL: dbal_mysql->sql_query()

FILE: includes/acp/acp_search.php
LINE: 343
CALL: fulltext_mysql->create_index()

FILE: includes/acp/acp_search.php
LINE: 46
CALL: acp_search->index()

FILE: includes/functions_module.php
LINE: 471
CALL: acp_search->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()
Registered User
Posts: 42
Joined: Sat May 29, 2004 10:41 pm

Re: Search Indexing Error

Post by Vv. »

I have the same problem. :( :(
Registered User
Posts: 5
Joined: Mon Jun 11, 2007 2:08 pm

Re: Search Indexing Error

Post by mistergam »

Me too :cry:

Return to “[3.0.x] Support Forum”