Search index creation after conversion?

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Ideas Centre
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
Ironhide
Registered User
Posts: 18
Joined: Mon Oct 27, 2003 1:43 pm

Search index creation after conversion?

Post by Ironhide »

I just converted over to 3.0 and when I try to create my new search index I get these errors:
General Error
SQL ERROR [ mysql4 ]

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

SQL

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)

BACKTRACE


FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->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()

Does anyone know how to fix these?
Ironhide
Registered User
Posts: 18
Joined: Mon Oct 27, 2003 1:43 pm

Re: Search index creation after conversion?

Post by Ironhide »

I have searched the forum and I am not the only person with this question that have received no answers. Does anyone have any Ideas.


Below are links to other posts with the same unanswered question:

http://www.phpbb.com/community/viewtopi ... arch+index

and,

http://www.phpbb.com/community/viewtopi ... eral+Error

and also,

http://www.phpbb.com/community/viewtopi ... 5#p4819805

and also,

http://www.phpbb.com/community/viewtopi ... eral+Error

and also,

http://www.phpbb.com/community/viewtopi ... eral+Error
Ironhide
Registered User
Posts: 18
Joined: Mon Oct 27, 2003 1:43 pm

Re: Search index creation after conversion?

Post by Ironhide »

I have been playing with the tables and I have managed to get it down to this error:
General Error
SQL ERROR [ mysql4 ]

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

SQL

ALTER TABLE phpbb_posts ADD FULLTEXT post_content (post_subject, post_text)


BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->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()
I cannot seem to find post_content though. Should I create this field?
mandolinaes
Registered User
Posts: 15
Joined: Tue Jul 24, 2007 8:48 pm

Re: Search index creation after conversion?

Post by mandolinaes »

Anyone, please?
I've got the same error. :?
Locked

Return to “[3.0.x] Support Forum”