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

Type: Ticket
Status: Resolved
nvs
View Replies:
nvs replied on at Permalink Reply
nvs
This issue has been resolved.
By removing the migration tool add-on, which had become obsolete, the installation completed successfully.
mnakalay replied on at Permalink Reply
mnakalay
Oh great. I was about to tell you the problem was coming from Entities regeneration elsewhere, so glad you figured it out.

I hope you'll like my work :)

concrete5 Environment Information

# concrete5 Version
Core Version - 8.5.12
Version Installed - 8.5.12
Database Version - 20220319043123

# Database Information
Version: 10.7.7-MariaDB-1:10.7.7+maria~ubu2004
SQL Mode: STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

# concrete5 Packages
Anti-Spammer Master (1.0.6), Mega Menu (1.6.5), Migration Tool (0.9.1), Neat (0.9.2), Vivid Carousel (1.0.1), Vivid Locations (1.0)

# concrete5 Overrides
None

# concrete5 Cache Settings
Block Cache - On
Overrides Cache - On
Full Page Caching - Off
Full Page Cache Lifetime - Every 6 hours (default setting).

# Server Software
Apache/2.4.38 (Debian)

# Server API
apache2handler

# PHP Version
7.3.4-2

# PHP Extensions
apache2handler, calendar, Core, ctype, curl, date, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, json, libxml, mbstring, mysqli, mysqlnd, openssl, pcre, PDO, pdo_mysql, Phar, posix, readline, Reflection, session, shmop, SimpleXML, sockets, sodium, SPL, standard, sysvmsg, sysvsem, sysvshm, tokenizer, wddx, xml, xmlreader, xmlwriter, xsl, Zend OPcache, zip, zlib

# PHP Settings
max_execution_time - 30
log_errors_max_len - 1024
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - 60
max_input_vars - 1000
memory_limit - 256M
post_max_size - 8M
upload_max_filesize - 2M
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
pcre.backtrack_limit - 1000000
pcre.recursion_limit - 100000
session.cache_limiter - <i>no value</i>
session.gc_maxlifetime - 7200
opcache.max_accelerated_files - 10000
opcache.max_file_size - 0
opcache.max_wasted_percentage - 5

Browser User-Agent String

Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Safari/537.36

Hide Post Content

This will replace the post content with the message: "Content has been removed by an Administrator"

Hide Content

Request Refund

You may not request a refund that is not currently owned by you.