Can't Install the Add-on - 1064 You have an error in your SQL syntax
Permalink Browser Info Environment
Hi, The add-on downloads OK, but installation fails with an SQL error. Please see the attached screenshots.
Type: | Ticket |
---|---|
Status: | Resolved |
Let me fix a mistake on your site...
hi, full error message is below.
Doctrine\DBAL\Exception\SyntaxErrorException thrown with message "An exception occurred while executing 'CREATE TABLE AosAnimations (aID INT AUTO_INCREMENT NOT NULL, animationName VARCHAR(255) NOT NULL, animation VARCHAR(255) NOT NULL, anchorPlacement VARCHAR(255) NOT NULL, easing VARCHAR(255) NOT NULL, offset INT NOT NULL, duration INT NOT NULL, delay INT NOT NULL, anchor VARCHAR(255) NOT NULL, once TINYINT(1) NOT NULL, PRIMARY KEY(aID)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB':
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 INT NOT NULL, duration INT NOT NULL, delay INT NOT NULL, anchor VARCHA...' at line 1"
Stacktrace:
#41 Doctrine\DBAL\Exception\SyntaxErrorException in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:98
#40 Doctrine\DBAL\Driver\AbstractMySQLDriver:convertException in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:182
#39 Doctrine\DBAL\DBALException:wrapException in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:159
#38 Doctrine\DBAL\DBALException:driverExceptionDuringQuery in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:2226
#37 Doctrine\DBAL\Connection:handleExceptionDuringQuery in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1313
#36 Doctrine\DBAL\Driver\PDO\Exception in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
#35 Doctrine\DBAL\Driver\PDO\Exception:new in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:143
#34 PDOException in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:141
#33 PDO:query in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:141
#32 Doctrine\DBAL\Driver\PDOConnection:doQuery in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOQueryImplementation.php:24
#31 Doctrine\DBAL\Driver\PDOConnection:query in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1309
#30 Doctrine\DBAL\Connection:executeQuery in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Database/DatabaseStructureManager.php:232
#29 Concrete\Core\Database\DatabaseStructureManager:installDatabaseFor in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Database/DatabaseStructureManager.php:170
#28 Concrete\Core\Database\DatabaseStructureManager:installDatabase in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Package/Package.php:959
#27 Concrete\Core\Package\Package:installEntitiesDatabase in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Package/Package.php:950
#26 Concrete\Core\Package\Package:installDatabase in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Package/Package.php:600
#25 Concrete\Core\Package\Package:install in /var/www/vhosts/dynaspeak.ac.nz/new_website/packages/aos/controller.php:128
#24 Concrete\Package\Aos\Controller:install in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Package/PackageService.php:243
#23 Concrete\Core\Package\PackageService:install in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/controllers/single_page/dashboard/extend/install.php:146
#22 Concrete\Controller\SinglePage\Dashboard\Extend\Install:install_package in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Controller/AbstractController.php:318
#21 call_user_func_array in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Controller/AbstractController.php:318
#20 Concrete\Core\Controller\AbstractController:runAction in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Http/ResponseFactory.php:193
#19 Concrete\Core\Http\ResponseFactory:controller in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Http/ResponseFactory.php:372
#18 Concrete\Core\Http\ResponseFactory:collection in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Http/DefaultDispatcher.php:132
#17 Concrete\Core\Http\DefaultDispatcher:handleDispatch in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Http/DefaultDispatcher.php:60
#16 Concrete\Core\Http\DefaultDispatcher:dispatch in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Http/Middleware/DispatcherDelegate.php:39
#15 Concrete\Core\Http\Middleware\DispatcherDelegate:next in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Http/Middleware/FrameOptionsMiddleware.php:39
#14 Concrete\Core\Http\Middleware\FrameOptionsMiddleware:process in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Http/Middleware/MiddlewareDelegate.php:50
#13 Concrete\Core\Http\Middleware\MiddlewareDelegate:next in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Http/Middleware/StrictTransportSecurityMiddleware.php:36
#12 Concrete\Core\Http\Middleware\StrictTransportSecurityMiddleware:process in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Http/Middleware/MiddlewareDelegate.php:50
#11 Concrete\Core\Http\Middleware\MiddlewareDelegate:next in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Http/Middleware/ContentSecurityPolicyMiddleware.php:36
#10 Concrete\Core\Http\Middleware\ContentSecurityPolicyMiddleware:process in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Http/Middleware/MiddlewareDelegate.php:50
#9 Concrete\Core\Http\Middleware\MiddlewareDelegate:next in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Http/Middleware/CookieMiddleware.php:35
#8 Concrete\Core\Http\Middleware\CookieMiddleware:process in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Http/Middleware/MiddlewareDelegate.php:50
#7 Concrete\Core\Http\Middleware\MiddlewareDelegate:next in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Http/Middleware/ApplicationMiddleware.php:29
#6 Concrete\Core\Http\Middleware\ApplicationMiddleware:process in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Http/Middleware/MiddlewareDelegate.php:50
#5 Concrete\Core\Http\Middleware\MiddlewareDelegate:next in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Http/Middleware/MiddlewareStack.php:86
#4 Concrete\Core\Http\Middleware\MiddlewareStack:process in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Http/DefaultServer.php:85
#3 Concrete\Core\Http\DefaultServer:handleRequest in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Foundation/Runtime/Run/DefaultRunner.php:125
#2 Concrete\Core\Foundation\Runtime\Run\DefaultRunner:run in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Foundation/Runtime/DefaultRuntime.php:102
#1 Concrete\Core\Foundation\Runtime\DefaultRuntime:run in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/dispatcher.php:45
#0 require in /var/www/vhosts/dynaspeak.ac.nz/new_website/index.php:2
Doctrine\DBAL\Exception\SyntaxErrorException thrown with message "An exception occurred while executing 'CREATE TABLE AosAnimations (aID INT AUTO_INCREMENT NOT NULL, animationName VARCHAR(255) NOT NULL, animation VARCHAR(255) NOT NULL, anchorPlacement VARCHAR(255) NOT NULL, easing VARCHAR(255) NOT NULL, offset INT NOT NULL, duration INT NOT NULL, delay INT NOT NULL, anchor VARCHAR(255) NOT NULL, once TINYINT(1) NOT NULL, PRIMARY KEY(aID)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB':
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 INT NOT NULL, duration INT NOT NULL, delay INT NOT NULL, anchor VARCHA...' at line 1"
Stacktrace:
#41 Doctrine\DBAL\Exception\SyntaxErrorException in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:98
#40 Doctrine\DBAL\Driver\AbstractMySQLDriver:convertException in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:182
#39 Doctrine\DBAL\DBALException:wrapException in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:159
#38 Doctrine\DBAL\DBALException:driverExceptionDuringQuery in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:2226
#37 Doctrine\DBAL\Connection:handleExceptionDuringQuery in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1313
#36 Doctrine\DBAL\Driver\PDO\Exception in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
#35 Doctrine\DBAL\Driver\PDO\Exception:new in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:143
#34 PDOException in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:141
#33 PDO:query in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:141
#32 Doctrine\DBAL\Driver\PDOConnection:doQuery in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOQueryImplementation.php:24
#31 Doctrine\DBAL\Driver\PDOConnection:query in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1309
#30 Doctrine\DBAL\Connection:executeQuery in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Database/DatabaseStructureManager.php:232
#29 Concrete\Core\Database\DatabaseStructureManager:installDatabaseFor in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Database/DatabaseStructureManager.php:170
#28 Concrete\Core\Database\DatabaseStructureManager:installDatabase in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Package/Package.php:959
#27 Concrete\Core\Package\Package:installEntitiesDatabase in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Package/Package.php:950
#26 Concrete\Core\Package\Package:installDatabase in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Package/Package.php:600
#25 Concrete\Core\Package\Package:install in /var/www/vhosts/dynaspeak.ac.nz/new_website/packages/aos/controller.php:128
#24 Concrete\Package\Aos\Controller:install in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Package/PackageService.php:243
#23 Concrete\Core\Package\PackageService:install in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/controllers/single_page/dashboard/extend/install.php:146
#22 Concrete\Controller\SinglePage\Dashboard\Extend\Install:install_package in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Controller/AbstractController.php:318
#21 call_user_func_array in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Controller/AbstractController.php:318
#20 Concrete\Core\Controller\AbstractController:runAction in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Http/ResponseFactory.php:193
#19 Concrete\Core\Http\ResponseFactory:controller in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Http/ResponseFactory.php:372
#18 Concrete\Core\Http\ResponseFactory:collection in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Http/DefaultDispatcher.php:132
#17 Concrete\Core\Http\DefaultDispatcher:handleDispatch in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Http/DefaultDispatcher.php:60
#16 Concrete\Core\Http\DefaultDispatcher:dispatch in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Http/Middleware/DispatcherDelegate.php:39
#15 Concrete\Core\Http\Middleware\DispatcherDelegate:next in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Http/Middleware/FrameOptionsMiddleware.php:39
#14 Concrete\Core\Http\Middleware\FrameOptionsMiddleware:process in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Http/Middleware/MiddlewareDelegate.php:50
#13 Concrete\Core\Http\Middleware\MiddlewareDelegate:next in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Http/Middleware/StrictTransportSecurityMiddleware.php:36
#12 Concrete\Core\Http\Middleware\StrictTransportSecurityMiddleware:process in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Http/Middleware/MiddlewareDelegate.php:50
#11 Concrete\Core\Http\Middleware\MiddlewareDelegate:next in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Http/Middleware/ContentSecurityPolicyMiddleware.php:36
#10 Concrete\Core\Http\Middleware\ContentSecurityPolicyMiddleware:process in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Http/Middleware/MiddlewareDelegate.php:50
#9 Concrete\Core\Http\Middleware\MiddlewareDelegate:next in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Http/Middleware/CookieMiddleware.php:35
#8 Concrete\Core\Http\Middleware\CookieMiddleware:process in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Http/Middleware/MiddlewareDelegate.php:50
#7 Concrete\Core\Http\Middleware\MiddlewareDelegate:next in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Http/Middleware/ApplicationMiddleware.php:29
#6 Concrete\Core\Http\Middleware\ApplicationMiddleware:process in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Http/Middleware/MiddlewareDelegate.php:50
#5 Concrete\Core\Http\Middleware\MiddlewareDelegate:next in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Http/Middleware/MiddlewareStack.php:86
#4 Concrete\Core\Http\Middleware\MiddlewareStack:process in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Http/DefaultServer.php:85
#3 Concrete\Core\Http\DefaultServer:handleRequest in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Foundation/Runtime/Run/DefaultRunner.php:125
#2 Concrete\Core\Foundation\Runtime\Run\DefaultRunner:run in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/src/Foundation/Runtime/DefaultRuntime.php:102
#1 Concrete\Core\Foundation\Runtime\DefaultRuntime:run in /var/www/vhosts/dynaspeak.ac.nz/new_website/concrete/dispatcher.php:45
#0 require in /var/www/vhosts/dynaspeak.ac.nz/new_website/index.php:2
Thank you. The error is probably related to the addition of the offset keyword in MariaDB version 10.6.0.
Please provide your email address and I will send you a link to the corrected version.
Please provide your email address and I will send you a link to the corrected version.
Thank you. Email: mufiday@hotmail.com
Version 0.9.9 fixed the issue. thanks for the support
Please send me the entire error message. Hover your mouse over the upper left corner. The whole error will unfold. Click the "copy" button. Paste the error into your message.
In the attachment you have a view with the copy button.