Tweet
Hello,
I did not apply the following upgrades. Thansk for help.
EspoCRM-upgrade-5.7.4-to-5.7.5.zip
EspoCRM-upgrade-5.7.3-to-5.7.4.zip
EspoCRM-upgrade-5.7.2-to-5.7.3.zip
EspoCRM-upgrade-5.7.1-to-5.7.2.zip
EspoCRM-upgrade-5.7.0-to-5.7.1.zip
mysql version:5.6.46
php version:7.3.10
espo version:5.6.14
Error: Error occurred while EspoCRM rebuild.
Logs:
[2019-10-24 09:04:02] Espo.ERROR: Hook class '\Espo\Hooks\Common\Webhook' does not exist. [] []
[2019-10-24 09:04:02] Espo.ERROR: Hook class '\Espo\Hooks\Common\Webhook' does not exist. [] []
[2019-10-24 09:04:02] Espo.ERROR: Hook class '\Espo\Hooks\Common\Webhook' does not exist. [] []
[2019-10-24 09:04:02] Espo.DEBUG: BPM: processPendingFlows [] []
[2019-10-24 09:04:02] Espo.DEBUG: BPM: processTriggeredSignals [] []
[2019-10-24 09:04:02] Espo.ERROR: Hook class '\Espo\Hooks\Common\Webhook' does not exist. [] []
[2019-10-24 09:04:02] Espo.ERROR: Hook class '\Espo\Hooks\Common\Webhook' does not exist. [] []
[2019-10-24 09:04:07] Espo.DEBUG: Installation process [5db169072fc9cf983]: start upload the package. [] []
[2019-10-24 09:04:08] Espo.DEBUG: Installation process [5db169072fc9cf983]: end upload the package. [] []
[2019-10-24 09:04:09] Espo.DEBUG: Installation process [5db169072fc9cf983]: start run. [] []
[2019-10-24 09:04:26] Espo.DEBUG: Schema\Converter - Start: building schema [] []
[2019-10-24 09:04:26] Espo.DEBUG: DBAL: Table [entity_team] exists. [] []
[2019-10-24 09:04:26] Espo.DEBUG: Schema\Converter - End: building schema [] []
[2019-10-24 09:04:26] Espo.INFO: SCHEMA, Execute Query: CREATE FULLTEXT INDEX IDX_SYSTEM_FULL_TEXT_SEARCH ON `teminatlar` (`name`, `aklama`, `in_ad`, `mektup_numaras`) [] []
[2019-10-24 09:04:26] Espo.ALERT: Rebuild database fault: PDOException: SQLSTATE[HY000]: General error: 1283 Column 'aklama' cannot be part of FULLTEXT index in /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:699 Stack trace: #0 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(699): PDO->query('CREATE FULLTEXT...') #1 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/application/Espo/Core/Utils/Database/Schema/Schema.php(196): Doctrine\DBAL\Connection->executeQuery('CREATE FULLTEXT...') #2 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/application/Espo/Core/DataManager.php(95): Espo\Core\Utils\Database\Schema\Schema->rebuild(NULL) #3 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/application/Espo/Core/DataManager.php(62): Espo\Core\DataManager->rebuildDatabase(NULL) #4 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/application/Espo/Core/Upgrades/Actions/Base.php(654): Espo\Core\DataManager->rebuild() #5 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/application/Espo/Core/Upgrades/Actions/Base/Install.php(99): Espo\Core\Upgrades\Actions\Base->systemRebuild() #6 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/application/Espo/Core/Upgrades/ActionManager.php(84): Espo\Core\Upgrades\Actions\Base\Install->run(Array) #7 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/application/Espo/Core/Upgrades/Base.php(85): Espo\Core\Upgrades\ActionManager->run(Array) #8 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/application/Espo/Controllers/Admin.php(96): Espo\Core\Upgrades\Base->install(Array) #9 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/application/Espo/Core/ControllerManager.php(143): Espo\Controllers\Admin->postActionRunUpgrade(Array, Object(stdClass), Object(Slim\Http\Request), Object(Slim\Http\Response)) #10 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/application/Espo/Core/ControllerManager.php(159): Espo\Core\ControllerManager->processRequest(Object(Espo\Controllers\Admin), 'runUpgrade', Array, Object(stdClass), Object(Slim\Http\Request), Object(Slim\Http\Response)) #11 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/application/Espo/Core/Application.php(298): Espo\Core\ControllerManager->process('Admin', 'runUpgrade', Array, '{"id":"5db16907...', Object(Slim\Http\Request), Object(Slim\Http\Response)) #12 [internal function]: Espo\Core\Application->Espo\Core\{closure}() #13 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/vendor/slim/slim/Slim/Slim.php(1210): call_user_func_array(Object(Closure), Array) #14 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/vendor/slim/slim/Slim/Slim.php(1356): Slim\Slim->applyHook('slim.before.dis...') #15 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/vendor/slim/slim/Slim/Middleware/Flash.php(85): Slim\Slim->call() #16 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/vendor/slim/slim/Slim/Middleware/MethodOverride.php(92): Slim\Middleware\Flash->call() #17 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/application/Espo/Core/Utils/Api/Auth.php(138): Slim\Middleware\MethodOverride->call() #18 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/application/Espo/Core/Utils/Api/Slim.php(125): Espo\Core\Utils\Api\Auth->call() #19 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/application/Espo/Core/Application.php(93): Espo\Core\Utils\Api\Slim->run() #20 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/api/v1/index.php(33): Espo\Core\Application->run() #21 {main} Next Doctrine\DBAL\DBALException: An exception occurred while executing 'CREATE FULLTEXT INDEX IDX_SYSTEM_FULL_TEXT_SEARCH ON `teminatlar` (`name`, `aklama`, `in_ad`, `mektup_numaras`)': SQLSTATE[HY000]: General error: 1283 Column 'aklama' cannot be part of FULLTEXT index in /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91 Stack trace: #0 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(702): Doctrine\DBAL\DBALException::driverExceptionDuring Query(Object(PDOException), 'CREATE FULLTEXT...', Array) #1 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/application/Espo/Core/Utils/Database/Schema/Schema.php(196): Doctrine\DBAL\Connection->executeQuery('CREATE FULLTEXT...') #2 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/application/Espo/Core/DataManager.php(95): Espo\Core\Utils\Database\Schema\Schema->rebuild(NULL) #3 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/application/Espo/Core/DataManager.php(62): Espo\Core\DataManager->rebuildDatabase(NULL) #4 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/application/Espo/Core/Upgrades/Actions/Base.php(654): Espo\Core\DataManager->rebuild() #5 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/application/Espo/Core/Upgrades/Actions/Base/Install.php(99): Espo\Core\Upgrades\Actions\Base->systemRebuild() #6 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/application/Espo/Core/Upgrades/ActionManager.php(84): Espo\Core\Upgrades\Actions\Base\Install->run(Array) #7 /var/www/... [] []
[2019-10-24 09:04:26] Espo.ERROR: Database rebuild failure, details: Error while rebuilding database. See log file for details.. [] []
[2019-10-24 09:04:26] Espo.INFO: Installer: Restore previous files. [] []
[2019-10-24 09:04:37] Espo.DEBUG: API (500) Error occurred while EspoCRM rebuild.; POST /api/v1/Admin/action/runUpgrade; Input data: {"id":"5db169072fc9cf983"}; Route pattern: /:controller/action/:action; Route params: Array ( [controller] => Admin [action] => runUpgrade ) [] []
[2019-10-24 09:04:37] Espo.ERROR: (500) Error occurred while EspoCRM rebuild.; POST /api/v1/Admin/action/runUpgrade; line: 164, file: /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/application/Espo/Core/Upgrades/Actions/Base.php [] []
[2019-10-24 09:05:02] Espo.DEBUG: BPM: processPendingFlows [] []
[2019-10-24 09:05:02] Espo.DEBUG: BPM: processTriggeredSignals [] []
I did not apply the following upgrades. Thansk for help.
EspoCRM-upgrade-5.7.4-to-5.7.5.zip
EspoCRM-upgrade-5.7.3-to-5.7.4.zip
EspoCRM-upgrade-5.7.2-to-5.7.3.zip
EspoCRM-upgrade-5.7.1-to-5.7.2.zip
EspoCRM-upgrade-5.7.0-to-5.7.1.zip
mysql version:5.6.46
php version:7.3.10
espo version:5.6.14
Error: Error occurred while EspoCRM rebuild.
Logs:
[2019-10-24 09:04:02] Espo.ERROR: Hook class '\Espo\Hooks\Common\Webhook' does not exist. [] []
[2019-10-24 09:04:02] Espo.ERROR: Hook class '\Espo\Hooks\Common\Webhook' does not exist. [] []
[2019-10-24 09:04:02] Espo.ERROR: Hook class '\Espo\Hooks\Common\Webhook' does not exist. [] []
[2019-10-24 09:04:02] Espo.DEBUG: BPM: processPendingFlows [] []
[2019-10-24 09:04:02] Espo.DEBUG: BPM: processTriggeredSignals [] []
[2019-10-24 09:04:02] Espo.ERROR: Hook class '\Espo\Hooks\Common\Webhook' does not exist. [] []
[2019-10-24 09:04:02] Espo.ERROR: Hook class '\Espo\Hooks\Common\Webhook' does not exist. [] []
[2019-10-24 09:04:07] Espo.DEBUG: Installation process [5db169072fc9cf983]: start upload the package. [] []
[2019-10-24 09:04:08] Espo.DEBUG: Installation process [5db169072fc9cf983]: end upload the package. [] []
[2019-10-24 09:04:09] Espo.DEBUG: Installation process [5db169072fc9cf983]: start run. [] []
[2019-10-24 09:04:26] Espo.DEBUG: Schema\Converter - Start: building schema [] []
[2019-10-24 09:04:26] Espo.DEBUG: DBAL: Table [entity_team] exists. [] []
[2019-10-24 09:04:26] Espo.DEBUG: Schema\Converter - End: building schema [] []
[2019-10-24 09:04:26] Espo.INFO: SCHEMA, Execute Query: CREATE FULLTEXT INDEX IDX_SYSTEM_FULL_TEXT_SEARCH ON `teminatlar` (`name`, `aklama`, `in_ad`, `mektup_numaras`) [] []
[2019-10-24 09:04:26] Espo.ALERT: Rebuild database fault: PDOException: SQLSTATE[HY000]: General error: 1283 Column 'aklama' cannot be part of FULLTEXT index in /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:699 Stack trace: #0 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(699): PDO->query('CREATE FULLTEXT...') #1 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/application/Espo/Core/Utils/Database/Schema/Schema.php(196): Doctrine\DBAL\Connection->executeQuery('CREATE FULLTEXT...') #2 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/application/Espo/Core/DataManager.php(95): Espo\Core\Utils\Database\Schema\Schema->rebuild(NULL) #3 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/application/Espo/Core/DataManager.php(62): Espo\Core\DataManager->rebuildDatabase(NULL) #4 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/application/Espo/Core/Upgrades/Actions/Base.php(654): Espo\Core\DataManager->rebuild() #5 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/application/Espo/Core/Upgrades/Actions/Base/Install.php(99): Espo\Core\Upgrades\Actions\Base->systemRebuild() #6 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/application/Espo/Core/Upgrades/ActionManager.php(84): Espo\Core\Upgrades\Actions\Base\Install->run(Array) #7 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/application/Espo/Core/Upgrades/Base.php(85): Espo\Core\Upgrades\ActionManager->run(Array) #8 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/application/Espo/Controllers/Admin.php(96): Espo\Core\Upgrades\Base->install(Array) #9 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/application/Espo/Core/ControllerManager.php(143): Espo\Controllers\Admin->postActionRunUpgrade(Array, Object(stdClass), Object(Slim\Http\Request), Object(Slim\Http\Response)) #10 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/application/Espo/Core/ControllerManager.php(159): Espo\Core\ControllerManager->processRequest(Object(Espo\Controllers\Admin), 'runUpgrade', Array, Object(stdClass), Object(Slim\Http\Request), Object(Slim\Http\Response)) #11 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/application/Espo/Core/Application.php(298): Espo\Core\ControllerManager->process('Admin', 'runUpgrade', Array, '{"id":"5db16907...', Object(Slim\Http\Request), Object(Slim\Http\Response)) #12 [internal function]: Espo\Core\Application->Espo\Core\{closure}() #13 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/vendor/slim/slim/Slim/Slim.php(1210): call_user_func_array(Object(Closure), Array) #14 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/vendor/slim/slim/Slim/Slim.php(1356): Slim\Slim->applyHook('slim.before.dis...') #15 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/vendor/slim/slim/Slim/Middleware/Flash.php(85): Slim\Slim->call() #16 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/vendor/slim/slim/Slim/Middleware/MethodOverride.php(92): Slim\Middleware\Flash->call() #17 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/application/Espo/Core/Utils/Api/Auth.php(138): Slim\Middleware\MethodOverride->call() #18 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/application/Espo/Core/Utils/Api/Slim.php(125): Espo\Core\Utils\Api\Auth->call() #19 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/application/Espo/Core/Application.php(93): Espo\Core\Utils\Api\Slim->run() #20 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/api/v1/index.php(33): Espo\Core\Application->run() #21 {main} Next Doctrine\DBAL\DBALException: An exception occurred while executing 'CREATE FULLTEXT INDEX IDX_SYSTEM_FULL_TEXT_SEARCH ON `teminatlar` (`name`, `aklama`, `in_ad`, `mektup_numaras`)': SQLSTATE[HY000]: General error: 1283 Column 'aklama' cannot be part of FULLTEXT index in /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91 Stack trace: #0 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(702): Doctrine\DBAL\DBALException::driverExceptionDuring Query(Object(PDOException), 'CREATE FULLTEXT...', Array) #1 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/application/Espo/Core/Utils/Database/Schema/Schema.php(196): Doctrine\DBAL\Connection->executeQuery('CREATE FULLTEXT...') #2 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/application/Espo/Core/DataManager.php(95): Espo\Core\Utils\Database\Schema\Schema->rebuild(NULL) #3 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/application/Espo/Core/DataManager.php(62): Espo\Core\DataManager->rebuildDatabase(NULL) #4 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/application/Espo/Core/Upgrades/Actions/Base.php(654): Espo\Core\DataManager->rebuild() #5 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/application/Espo/Core/Upgrades/Actions/Base/Install.php(99): Espo\Core\Upgrades\Actions\Base->systemRebuild() #6 /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/application/Espo/Core/Upgrades/ActionManager.php(84): Espo\Core\Upgrades\Actions\Base\Install->run(Array) #7 /var/www/... [] []
[2019-10-24 09:04:26] Espo.ERROR: Database rebuild failure, details: Error while rebuilding database. See log file for details.. [] []
[2019-10-24 09:04:26] Espo.INFO: Installer: Restore previous files. [] []
[2019-10-24 09:04:37] Espo.DEBUG: API (500) Error occurred while EspoCRM rebuild.; POST /api/v1/Admin/action/runUpgrade; Input data: {"id":"5db169072fc9cf983"}; Route pattern: /:controller/action/:action; Route params: Array ( [controller] => Admin [action] => runUpgrade ) [] []
[2019-10-24 09:04:37] Espo.ERROR: (500) Error occurred while EspoCRM rebuild.; POST /api/v1/Admin/action/runUpgrade; line: 164, file: /var/www/vhosts/***.****ra.com.tr/httpdocs/espo/application/Espo/Core/Upgrades/Actions/Base.php [] []
[2019-10-24 09:05:02] Espo.DEBUG: BPM: processPendingFlows [] []
[2019-10-24 09:05:02] Espo.DEBUG: BPM: processTriggeredSignals [] []
Comment