CompanyDirectory upgrade problem

[nidus]

CD upgrade from 1.23.10 to the latest 1.903
the core and all module the latest version

PHP Fatal error: Uncaught cg_sql_error 'The used table type doesn't support FULLTEXT indexes -- The used table type doesn't support FULLTEXT indexes' in /xxx/modules/CGExtensions/CGExtensions.module.php:2157
#0 [internal function]: CGExtensions->{closure}(Object(CMSMS\Database\mysqli\Connection), 'EXECUTE', 1214, 'The used table ...')
#1 /xxx/lib/classes/Database/class.Connection.php(678): call_user_func(Object(Closure), Object(CMSMS\Database\mysqli\Connection), 'EXECUTE', 1214, 'The used table ...')
#2 /xxx/lib/classes/Database/mysqli/class.Connection.php(127): CMSMS\Database\Connection->OnError('EXECUTE', 1214, 'The used table ...')
#3 /xxx/lib/classes/Database/class.Connection.php(328): CMSMS\Database\mysqli\Connection->do_sql('ALTER TABLE cms...')
#4 /xxx/lib/classes/Database/class.Connection.php(341): CMSMS\Database\Connection->SelectLimit('ALTER TABLE cms...', -1, -1, NULL)
#5 /xxx/modules/CompanyDirectory/method.upgrade.php( in /xxx/modules/CGExtensions/CGExtensions.module.php on line 2157

[Dr.CSS]

Helps if we know the full extent of your system info...

[calguy1000]

CompanyDirectory now uses InnoDB.

Only recent versions of MySQL support full text indexes with InnoDB.

i.e: You may need to upgrade your Mysql

[nidus]

first of all I was able to upgrade another website to the latest CD version on the same system although it wasn't from version from 1.23.10 to the latest 1.903 but first to 1.9.02 without that problem.
here is the system info:

Current PHP Version (phpversion) Success 7.2.16
md5 function (md5_function) Success On (True)
JSON functions (json_function) Success On (True)
GD version (gd_version) Success 2
tempnam function (tempnam_function) Success On (True)
Magic quotes in runtime (magic_quotes_runtime) Success Off (False)
Is E_ALL enabled in error_reporting (E_ALL) Success
Is E_STRICT disabled in error_reporting (E_STRICT) Caution E_STRICT is enabled in the error_reporting
Is E_DEPRECATED disabled in error_reporting (E_DEPRECATED) Success
Testing for time difference in the file system (test_file_timedifference) Success No time difference found
Testing for time difference in the database (test_db_timedifference) Success No time difference found
Checking if the HTTPD process can create a file inside of a directory it created (create_dir_and_file) Success 1
PHP Effective Memory Limit (memory_limit) Success 256M
Maximum Execution Time (max_execution_time) Success 60
PHP register_globals (register_globals) Success Off (False)
PHP output_buffering (output_buffering) Success 4096
disable_functions in PHP (disable_functions) Success
PHP Open Basedir (open_basedir) Success
Test for remote URL (test_remote_url) Success Success
fsockopen: Connection ok! Success
fopen: Connection ok! Success
File uploads (file_uploads) Success On (True)
Maximum Post Size (post_max_size) Success 20M
Maximum Upload Size (upload_max_filesize) Success 10M
Session Save Path (session_save_path) Success /var/lib/php/session (0770)
Sessions are allowed to use Cookies (session_use_cookies) Success On (True)
Basic XML (expat) support (xml_function) Success On (True)
Checking for the XMLReader class (xmlreader_class) Success On (True)
Test ini_set (check_ini_set) Success On (True)
Test for the curl library (curl) Success On
Test curl version (curlversion) Success version 7.19.7, minimum recommended version is 7.19.7

Server Information
Server Software (server_software) apache
Server API (server_api) apache2handler
Server Operating System (server_os) linux 2.6.32-696.30.1.el6.x86_64 on x86_64
Server Database (server_db_type) mysql (mysqli)
Server Database Version (server_db_version) Success 5.5.56