Support ⇒ New installations ⇒ [solved] Column 'filename' cannot be part of FULLTEXT index ⇒ Community Forums ⇒ CPG Dragonfly™ CMS
Forum IndexNew installations

[solved] Column 'filename' cannot be part of FULLTEXT index Reply to topic


While updgrading a site from 9.1.2 to 9.2.1, I got this error message:

On /install.php
While executing query "ALTER TABLE cms_cpg_pictures CHANGE caption caption TEXT NOT NULL"

the following error occured: Column 'filename' cannot be part of FULLTEXT index

In: /home/account/public_html/domain.info/includes/classes/installer.php on line: 115


I guess the "Fulltext index" is what I don't understand.

The sql server is version 5.x and the storage engine is MyISAM as referenced by this thread.

Ideas anyone? I have updated a couple of 9.2.1 sites before and never saw this error message. Thanks for any replies, ideas, or suggestions.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Devuan jessie / Apache 2.4x / MariaDB 10.x / PHP 5.6x / DF 9.4


It means you have mixed collations in your table(s) and may also encounter further issues.

"fulltext" is the type used by the "search" index.

DonationsPro for DragonflyCMS & SMF

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):


Thanks Phoenix.

Is there any way to repair the db or work around this? I noticed that the colums are latin1_swedish and the table collations are ut8f_general_ci. Does this have anything to do with the issue?

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Devuan jessie / Apache 2.4x / MariaDB 10.x / PHP 5.6x / DF 9.4


I did not solve it, but I did find a workaround.

I have a virtual machine (virtualbox) with a LAMP stack configured. I exported the same DF v.9.1.2 database into the vm phpmyadmin, then went through the db upgrade. Once exported from the vm phpmyadmin, it imported fine within the commercial phpmyadmin on a shared hosting server.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Devuan jessie / Apache 2.4x / MariaDB 10.x / PHP 5.6x / DF 9.4


Sooner or later you will have to fix it, as it will keep comimg back to bite you.

The collations need to be set to ut8f_general_ci (the actual data is already utf8).

Do a search on collations for lots of help. It's in the wiki too.

Pro_News CM™ - Content Management for Dragonfly CMS™

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux / 1.3.39 - 2.4.9 / 5.5.42 - 5.6.16 / 5.4.37 - 5.5.11 / 9.4


the export/import/export/import Warden did may have straightened up the collation issue. What I normally do for that problem is export the db, open the sql export file in a good text editor and do a find/replace for the collation (changing latin1_swedish to ut8f_general_ci), then re-import the data into a clean db (with default collation set to ut8f_general_ci).

Sounds like a lot of work, but it's actually pretty quick...

Admin - Great Lakes Web Designs
Theme Designer - WebSite Guru Designs
Site Admin - Families with Food Allergies

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux 2.6.27-grsec/Apache 2.2.11/MySQL 5.0.67-community-log/PHP 5.2.8/DF 9.2.1


Good thought!

Pro_News CM™ - Content Management for Dragonfly CMS™

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux / 1.3.39 - 2.4.9 / 5.5.42 - 5.6.16 / 5.4.37 - 5.5.11 / 9.4


Thanks for the info guys. I know the collation stuff is not easy to grasp, but I will be a tester to see how it works out. This is an older db that was originally created in 8.2c, then upgraded to 9.0.6.1 and then 9.1.2. There was a big collation issue between 9061 and 912, and I used rlgura's method above to straighten it out so that it would upgrade. I had forgotten about that method. It is a time saver!

Thanks again.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Devuan jessie / Apache 2.4x / MariaDB 10.x / PHP 5.6x / DF 9.4


there any way to repair the db or work around this? Do a search on collations for lots of help. It's in the wiki too.

*sofiazoe*

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
MySQL


I have an easy to use file. I have Used on many Live dragonfly sites
Changes database collation (DATABASE, TABLES, COLUMNS)
Only takes a couple of minutes depending on how many tables are in your db.

You can contact me on my site tgesf.com bulldog500
I will get you a download for it.

Developer of Sports Handicapping Websites.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
9.21

All times are UTC


Jump to: