E
E
exedis2017-03-28 19:39:45
CMS
exedis, 2017-03-28 19:39:45

Why does an error occur when updating modx evo?

Hello, I am updating modx evo to the latest version. There was an error in the result of the installation

Column 'description' cannot be part of FULLTEXT index during SQL query execution ALTER TABLE `modx_site_content` MODIFY COLUMN `pagetitle` varchar(255) NOT NULL default '', MODIFY COLUMN `alias` varchar(245) default '', MODIFY COLUMN `introtext` text COMMENT 'Used to provide quick summary of the document', MODIFY COLUMN `content` mediumtext, MODIFY COLUMN `menutitle` varchar(255) NOT NULL DEFAULT '' COMMENT 'Menu title', MODIFY COLUMN `template` int( 10) NOT NULL default '0'.
On the site, all the encoding went astray, changed the base encoding to utf8_general_ci, all the same.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Anton Denisenko, 2017-04-12
@kapioprok

Hello, if so

ALTER TABLE modx_site_content
 CONVERT TO CHARACTER SET binary,
 CONVERT TO CHARACTER SET utf8;

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question