Search Index Error

phpBB SEO Premod for phpBB3 support forum.
This premodded version of phpBB3 includes the three different type of URL rewriting for phpBB3 by phpBB SEO. It comes with several other Search Engine Optimization mods installed.

Moderator: Moderators

Search Index Error

Postby yaashul » Sat Apr 07, 2012 4:06 pm

I'm getting following error while creating search index for Fulltext mysql

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: [ROOT]/includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()

FILE: [ROOT]/includes/search/fulltext_mysql.php
LINE: 779
CALL: dbal_mysql->sql_query()

FILE: [ROOT]/includes/acp/acp_search.php
LINE: 365
CALL: fulltext_mysql->create_index()

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

FILE: [ROOT]/includes/functions_module.php
LINE: 507
CALL: acp_search->main()

FILE: [ROOT]/adm/index.php
LINE: 74
CALL: p_master->load_active()
yaashul
PR1
PR1
 
Posts: 160
Joined: Wed Aug 29, 2007 1:21 am

Advertisement

Re: Search Index Error

Postby Stephen26 » Thu Apr 12, 2012 11:19 pm

Make a backup of your database! Delete search index, run SQL query:

Code: Select all
ALTER TABLE phpbb_posts CHANGE post_subject post_subject MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL


Create search index.

If that doesn't work I think you need to use the Support Tool Kit first.

- MySQL upgrader: A tool capable of updating the schema when MySQL has been upgraded.

Stephen26 wrote:You may still use the 1.0.4 version. You would have to change the following in /stk/common.php for it to work:

Code: Select all
// What version are we using?
define('STK_VERSION', '1.0.4');
//define('STK_QA', true);

to

Code: Select all
// What version are we using?
define('STK_VERSION', '1.0.5');
//define('STK_QA', true);
I install and configure phpBB-SEO (and other mods) for a fair price and very fast. If you are interested simply send me a private message.
Stephen26
phpBB SEO Team
phpBB SEO Team
 
Posts: 434
Joined: Mon May 03, 2010 7:06 am

Re: Search Index Error

Postby yaashul » Mon May 21, 2012 4:24 pm

I got the following error...

ALTER TABLE phpbb_posts CHANGE post_subject post_subject MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL

MySQL said:

#1283 - Column 'post_text' cannot be part of FULLTEXT index
yaashul
PR1
PR1
 
Posts: 160
Joined: Wed Aug 29, 2007 1:21 am

Re: Search Index Error

Postby yaashul » Mon May 21, 2012 6:14 pm

Ok it solved my problem
yaashul
PR1
PR1
 
Posts: 160
Joined: Wed Aug 29, 2007 1:21 am


Return to phpBB SEO Premod

 


  • Related topics
    Replies
    Views
    Last post

Who is online

Users browsing this forum: No registered users and 8 guests