Exception occurred during installation
Permalink Browser Info Environment
The following exception occurred during installation.
How can I install successfully?
Doctrine\DBAL\Exception\SyntaxErrorException thrown with message "An exception occurred while executing 'ALTER TABLE MigrationImportAreaLayoutColumns CHANGE area_layout_id area_layout_id CHAR(36) DEFAULT NULL COMMENT '(DC2Type:guid)', CHANGE width width INT DEFAULT NULL, CHANGE span span INT DEFAULT NULL, CHANGE offset offset INT DEFAULT NULL':
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'offset offset INT DEFAULT NULL' at line 1"
Stacktrace:
#35 Doctrine\DBAL\Exception\SyntaxErrorException in /var/www/html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:90
#34 Doctrine\DBAL\Driver\AbstractMySQLDriver:convertException in /var/www/html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:128
#33 Doctrine\DBAL\DBALException:driverExceptionDuringQuery in /var/www/html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:855
#32 Doctrine\DBAL\Driver\PDOException in /var/www/html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:106
#31 PDOException in /var/www/html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:104
#30 PDO:query in /var/www/html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:104
#29 Doctrine\DBAL\Driver\PDOConnection:query in /var/www/html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:852
#28 Doctrine\DBAL\Connection:executeQuery in /var/www/html/concrete/src/Database/DatabaseStructureManager.php:233
#27 Concrete\Core\Database\DatabaseStructureManager:installDatabaseFor in /var/www/html/concrete/src/Database/DatabaseStructureManager.php:170
#26 Concrete\Core\Database\DatabaseStructureManager:installDatabase in /var/www/html/concrete/src/Package/Package.php:915
#25 Concrete\Core\Package\Package:installEntitiesDatabase in /var/www/html/concrete/src/Package/Package.php:906
#24 Concrete\Core\Package\Package:installDatabase in /var/www/html/concrete/src/Package/Package.php:572
#23 Concrete\Core\Package\Package:install in /var/www/html/packages/kalmoya_anti_spammer_master/controller.php:42
#22 Concrete\Package\KalmoyaAntiSpammerMaster\Controller:install in /var/www/html/concrete/src/Package/PackageService.php:243
#21 Concrete\Core\Package\PackageService:install in /var/www/html/concrete/controllers/single_page/dashboard/extend/install.php:145
#20 Concrete\Controller\SinglePage\Dashboard\Extend\Install:install_package in /var/www/html/concrete/src/Controller/AbstractController.php:315
#19 call_user_func_array in /var/www/html/concrete/src/Controller/AbstractController.php:315
#18 Concrete\Core\Controller\AbstractController:runAction in /var/www/html/concrete/src/Http/ResponseFactory.php:193
#17 Concrete\Core\Http\ResponseFactory:controller in /var/www/html/concrete/src/Http/ResponseFactory.php:371
#16 Concrete\Core\Http\ResponseFactory:collection in /var/www/html/concrete/src/Http/DefaultDispatcher.php:131
#15 Concrete\Core\Http\DefaultDispatcher:handleDispatch in /var/www/html/concrete/src/Http/DefaultDispatcher.php:59
#14 Concrete\Core\Http\DefaultDispatcher:dispatch in /var/www/html/concrete/src/Http/Middleware/DispatcherDelegate.php:39
#13 Concrete\Core\Http\Middleware\DispatcherDelegate:next in /var/www/html/concrete/src/Http/Middleware/ThumbnailMiddleware.php:76
#12 Concrete\Core\Http\Middleware\ThumbnailMiddleware:process in /var/www/html/concrete/src/Http/Middleware/MiddlewareDelegate.php:50
#11 Concrete\Core\Http\Middleware\MiddlewareDelegate:next in /var/www/html/concrete/src/Http/Middleware/FrameOptionsMiddleware.php:39
#10 Concrete\Core\Http\Middleware\FrameOptionsMiddleware:process in /var/www/html/concrete/src/Http/Middleware/MiddlewareDelegate.php:50
#9 Concrete\Core\Http\Middleware\MiddlewareDelegate:next in /var/www/html/concrete/src/Http/Middleware/CookieMiddleware.php:35
#8 Concrete\Core\Http\Middleware\CookieMiddleware:process in /var/www/html/concrete/src/Http/Middleware/MiddlewareDelegate.php:50
#7 Concrete\Core\Http\Middleware\MiddlewareDelegate:next in /var/www/html/concrete/src/Http/Middleware/ApplicationMiddleware.php:29
#6 Concrete\Core\Http\Middleware\ApplicationMiddleware:process in /var/www/html/concrete/src/Http/Middleware/MiddlewareDelegate.php:50
#5 Concrete\Core\Http\Middleware\MiddlewareDelegate:next in /var/www/html/concrete/src/Http/Middleware/MiddlewareStack.php:86
#4 Concrete\Core\Http\Middleware\MiddlewareStack:process in /var/www/html/concrete/src/Http/DefaultServer.php:85
#3 Concrete\Core\Http\DefaultServer:handleRequest in /var/www/html/concrete/src/Foundation/Runtime/Run/DefaultRunner.php:128
#2 Concrete\Core\Foundation\Runtime\Run\DefaultRunner:run in /var/www/html/concrete/src/Foundation/Runtime/DefaultRuntime.php:102
#1 Concrete\Core\Foundation\Runtime\DefaultRuntime:run in /var/www/html/concrete/dispatcher.php:45
#0 require in /var/www/html/index.php:3
How can I install successfully?
Doctrine\DBAL\Exception\SyntaxErrorException thrown with message "An exception occurred while executing 'ALTER TABLE MigrationImportAreaLayoutColumns CHANGE area_layout_id area_layout_id CHAR(36) DEFAULT NULL COMMENT '(DC2Type:guid)', CHANGE width width INT DEFAULT NULL, CHANGE span span INT DEFAULT NULL, CHANGE offset offset INT DEFAULT NULL':
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'offset offset INT DEFAULT NULL' at line 1"
Stacktrace:
#35 Doctrine\DBAL\Exception\SyntaxErrorException in /var/www/html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:90
#34 Doctrine\DBAL\Driver\AbstractMySQLDriver:convertException in /var/www/html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:128
#33 Doctrine\DBAL\DBALException:driverExceptionDuringQuery in /var/www/html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:855
#32 Doctrine\DBAL\Driver\PDOException in /var/www/html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:106
#31 PDOException in /var/www/html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:104
#30 PDO:query in /var/www/html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:104
#29 Doctrine\DBAL\Driver\PDOConnection:query in /var/www/html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:852
#28 Doctrine\DBAL\Connection:executeQuery in /var/www/html/concrete/src/Database/DatabaseStructureManager.php:233
#27 Concrete\Core\Database\DatabaseStructureManager:installDatabaseFor in /var/www/html/concrete/src/Database/DatabaseStructureManager.php:170
#26 Concrete\Core\Database\DatabaseStructureManager:installDatabase in /var/www/html/concrete/src/Package/Package.php:915
#25 Concrete\Core\Package\Package:installEntitiesDatabase in /var/www/html/concrete/src/Package/Package.php:906
#24 Concrete\Core\Package\Package:installDatabase in /var/www/html/concrete/src/Package/Package.php:572
#23 Concrete\Core\Package\Package:install in /var/www/html/packages/kalmoya_anti_spammer_master/controller.php:42
#22 Concrete\Package\KalmoyaAntiSpammerMaster\Controller:install in /var/www/html/concrete/src/Package/PackageService.php:243
#21 Concrete\Core\Package\PackageService:install in /var/www/html/concrete/controllers/single_page/dashboard/extend/install.php:145
#20 Concrete\Controller\SinglePage\Dashboard\Extend\Install:install_package in /var/www/html/concrete/src/Controller/AbstractController.php:315
#19 call_user_func_array in /var/www/html/concrete/src/Controller/AbstractController.php:315
#18 Concrete\Core\Controller\AbstractController:runAction in /var/www/html/concrete/src/Http/ResponseFactory.php:193
#17 Concrete\Core\Http\ResponseFactory:controller in /var/www/html/concrete/src/Http/ResponseFactory.php:371
#16 Concrete\Core\Http\ResponseFactory:collection in /var/www/html/concrete/src/Http/DefaultDispatcher.php:131
#15 Concrete\Core\Http\DefaultDispatcher:handleDispatch in /var/www/html/concrete/src/Http/DefaultDispatcher.php:59
#14 Concrete\Core\Http\DefaultDispatcher:dispatch in /var/www/html/concrete/src/Http/Middleware/DispatcherDelegate.php:39
#13 Concrete\Core\Http\Middleware\DispatcherDelegate:next in /var/www/html/concrete/src/Http/Middleware/ThumbnailMiddleware.php:76
#12 Concrete\Core\Http\Middleware\ThumbnailMiddleware:process in /var/www/html/concrete/src/Http/Middleware/MiddlewareDelegate.php:50
#11 Concrete\Core\Http\Middleware\MiddlewareDelegate:next in /var/www/html/concrete/src/Http/Middleware/FrameOptionsMiddleware.php:39
#10 Concrete\Core\Http\Middleware\FrameOptionsMiddleware:process in /var/www/html/concrete/src/Http/Middleware/MiddlewareDelegate.php:50
#9 Concrete\Core\Http\Middleware\MiddlewareDelegate:next in /var/www/html/concrete/src/Http/Middleware/CookieMiddleware.php:35
#8 Concrete\Core\Http\Middleware\CookieMiddleware:process in /var/www/html/concrete/src/Http/Middleware/MiddlewareDelegate.php:50
#7 Concrete\Core\Http\Middleware\MiddlewareDelegate:next in /var/www/html/concrete/src/Http/Middleware/ApplicationMiddleware.php:29
#6 Concrete\Core\Http\Middleware\ApplicationMiddleware:process in /var/www/html/concrete/src/Http/Middleware/MiddlewareDelegate.php:50
#5 Concrete\Core\Http\Middleware\MiddlewareDelegate:next in /var/www/html/concrete/src/Http/Middleware/MiddlewareStack.php:86
#4 Concrete\Core\Http\Middleware\MiddlewareStack:process in /var/www/html/concrete/src/Http/DefaultServer.php:85
#3 Concrete\Core\Http\DefaultServer:handleRequest in /var/www/html/concrete/src/Foundation/Runtime/Run/DefaultRunner.php:128
#2 Concrete\Core\Foundation\Runtime\Run\DefaultRunner:run in /var/www/html/concrete/src/Foundation/Runtime/DefaultRuntime.php:102
#1 Concrete\Core\Foundation\Runtime\DefaultRuntime:run in /var/www/html/concrete/dispatcher.php:45
#0 require in /var/www/html/index.php:3
Type: | Ticket |
---|---|
Status: | Resolved |
By removing the migration tool add-on, which had become obsolete, the installation completed successfully.