Dear All,
I was upgrading Evo 1.0.0 to 1.0.2, but I got the following error on the last step. After the install the path/modx/manager administrator looks very wired. Help! By the way , I follow the upgrade steps in the MODx wiki.
Here is the error message. Also, I did not alter modx_site_content table before/after the install 1.0.0
Install results
Setup will now attempt to setup the database:
Creating connection to the database: OK!
Selecting database `frmm_modx`: OK!
Creating database tables: Database Alerts!
MODx setup couldn’t install/alter some tables inside the selected database.
The following errors had occurred during installation
Column ’description’ cannot be part of FULLTEXT index during the execution of SQL statement ALTER TABLE `modx_site_content` MODIFY COLUMN `pagetitle` varchar(255) NOT NULL default ’’, MODIFY COLUMN `alias` varchar(255) default ’’, MODIFY COLUMN `menutitle` varchar(255) NOT NULL DEFAULT ’’ COMMENT ’Menu title’.
Ok. I think I have followed someone replied by dropping this line in the site_content table
FULLTEXT KEY `content_ft_idx` (`pagetitle`,`description`,`content`)
Our site is in Chinese and MySQL is in utf-8 encoding. I don’t know if there is any side effect by remove the FULLTEXT KEY. Anyway, it it now functioning in Evo 1.0.2
