Column 'member_name' cannot be part of FULLTEXT index

[teamvtec]

I get this:

Column 'member_name' cannot be part of FULLTEXT index
File: /usr/home/deb9479/domains/civicvtec.org/public_html/forums/Sources/ManageMaintenance.php
Line: 677

Code Select Expand

670 // Change the columns to binary form.
$smcFunc['db_query']('', '
ALTER TABLE {raw:table_name}{raw:updates_blob}',
array(
'table_name' => $table_info['Name'],
'updates_blob' => substr($updates_blob, 0, -1),
)
677 );


when trying to convert the database and data to UTF8


SMF 2.0RC5 with mods

1.    RSS Feed Poster    3.0.1
2.    'Read the Rules' Link Above Post Button    2.0    
3.    AvatarSelect    1.2.1    
4.    Default Avatar    2.0
5.    Google Member Map    2.0.7    
6.    Highslide 4 SMF    0.6    
7.    Share This Topic    2.8    
8.    Simple Audio Video Embedder    1.1
9.    Treasury    2.09    
10.    Activity_Bar    1.0.1.2    
11.    SimpleAds    1.0.1    
12.    SMF Trader System    1.6    
13.    Tapatalk SMF 2.0 RC4 Plugin    1.3.0    
14.    Karma Buttons    1.1    
15.    Guest Registration Notification    1.2
16.    Stop Spammer    2.3.9    
17.    Add Join Date to Post    1.0

[Ashley S]

Have you been editing any files?.

[teamvtec]

Thanks for replying, do you mean in the database or induvidual smf files?

[teamvtec]

Any help would be greatly appreciated here...

[teamvtec]

again, i'm still having this problem. I can't convert my database to UTF8.
it gives me this error:

Database Error
Column 'member_name' cannot be part of FULLTEXT index
File: /usr/home/deb9479/domains/civicvtec.org/public_html/forums/Sources/ManageMaintenance.php
Line: 677

[Joker™]

By any chance is your search method is "Fulltext index"?

[kallemac]

i got the same error,

Column 'file' cannot be part of FULLTEXT index
Fil: /mounted-storage/home123b/sub007/sc68976-UAMP/www/gamle2011/Sources/ManageMaintenance.php
Rad: 666

How can we fix this?

[Illori]

please open a separate thread for each issue, this thread belongs to someone else.

[teamvtec]

Still having the same issue... people are complaining about missing posts...

please help

[Joker™]

Umm as the reply came a bit late so going to start again

SMF version?
Database and forum type (UTF-8)?
Mods install?
Exact recent error?

[teamvtec]

SMF version 2RC5

Forum: I have language files set to UTF8 but the core stays on ISO-8859-1 since i can't seem to update the database to UTF8

Mods:

1.    RSS Feed Poster    3.0.1    
2.    'Read the Rules' Link Above Post Button    2.0    
3.    AvatarSelect    1.2.1    
4.    Default Avatar    2.0    
5.    Google Member Map    2.0.7    
6.    Highslide 4 SMF    0.6    
7.    Share This Topic    2.8
8.    Simple Audio Video Embedder    1.1
9.    Treasury    2.09    
10.    Activity_Bar    1.0.1.2
11.    SimpleAds    1.0.1    
12.    SMF Trader System    1.6    
13.    Tapatalk SMF 2.0 RC4 Plugin    1.3.0    
14.    Karma Buttons    1.1    
15.    Guest Registration Notification    1.2    
16.    Stop Spammer    2.3.9    
17.    Add Join Date to Post    1.0
18.    SMF Garage    2.0    
19.    Enhancements to purge inactive members    1.2    
20.    Simple Imageshack Upload Box    1.0

Error:

Database Error
Column 'member_name' cannot be part of FULLTEXT index
File: /usr/home/deb9479/domains/civicvtec.org/public_html/forums/Sources/ManageMaintenance.php
Line: 677

[Oldiesmann]

One of your mods is creating a FULLTEXT index on the member_name column. UTF8 conversion doesn't work on fulltext indexes. You will have to go in to phpMyAdmin and drop the index, then add it back after converting.

Go into phpMyAdmin, click on the "smf_members" table in the left column, then click on the "Structure" tab.
Scroll down to the bottom where you see the "Indexes" section
Look for the index on the "member_name" column with a type of "FULLTEXT" and make a note of the name and whether or not there's anything in parentheses next to "member_name" under "column" in the index list.
Once you've done that, click "Drop" next to the index name. On the next page, confirm that you do wish to drop it.

After that, you should be able to successfully convert to UTF-8.

Finally, recreate the index. If there was anything in parentheses next to member_name, this is the size of the index, and you'll want to run this query:

Code Select Expand

ALTER TABLE smf_members ADD FULLTEXT index_name (member_name (size));

Otherwise, just do this:

Code Select Expand

ALTER TABLE smf_members ADD FULLTEXT index_name (member_name);

[teamvtec]

Thank you so much Oldiesmann, that solved it.

However it was member_name_2 that had the FULLTEXT index with a 1 on next to it, is it neccesary to run the query as there are no things missing?

Thanks again

[Oldiesmann]

It should be safe to leave it as is. I don't know why anyone would have a FULLTEXT index on only the first character of a column anyway.

[teamvtec]

Ok thanks again!