Проводим эксперимент.
Ставим чистую INSTANTCMS2.11.0 на опенсервер. Модуль mysql — mysql5.8 (8.0.12).
Смотрим енджайн таблиц:
Таблица cms_photos тоже.
Далее конвертим cms_photos в InnoDB.
Тут же получаем характерную ошибку:
Ошибка в запросе БД:
Невозможно отыскать полнотекстовый (FULLTEXT) индекс, соответствующий списку столбцов SELECT i.*, MATCH(i.title) AGAINST ('\"98176037\"' IN BOOLEAN MODE) AS `fsort`, u.nickname AS `user_nickname`, u.is_deleted AS `user_is_deleted`, u.avatar AS `user_avatar` FROM cms_photos i INNER JOIN cms_users AS u ON u.id = i.user_id INNER JOIN cms_con_albums AS al ON al.id = i.album_id WHERE (i.id <> '1') AND (MATCH(i.title) AGAINST ('\"98176037\"' IN BOOLEAN MODE)) AND (al.is_approved = '1') ORDER BY fsort DESC LIMIT 20 Последние вызовы: cmsModel->GET() @ /system\controllers\photos\model.php : 123 modelPhotos->getPhotos() @ /system\controllers\photos\frontend.php : 45 photos->getPhotosList() @ /system\core\action.php : 29 cmsAction->__call() @ /system\controllers\photos\actions\VIEW.php : 382 actionPhotosView->getRelatedPhoto() @ /system\controllers\photos\actions\VIEW.php : 235 actionPhotosView->run() @ /system\core\controller.php : 536 cmsController->runExternalAction() @ /system\core\controller.php : 449 cmsController->executeAction() @ /system\core\controller.php : 425 cmsController->runAction() @ /system\controllers\photos\frontend.php : 15 photos->route() @ /system\core\controller.php : 474 cmsController->executeAction() @ /system\core\controller.php : 425