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.

1 Attachment

Type: Ticket
Status: Resolved
mufiday
View Replies:
dariuszgarus replied on at Permalink Reply 1 Attachment
dariuszgarus
Hello mufiday.
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.
dariuszgarus replied on at Permalink Reply
dariuszgarus
Let me fix a mistake on your site...
mufiday replied on at Permalink Reply
mufiday
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
dariuszgarus replied on at Permalink Reply
dariuszgarus
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.
mufiday replied on at Permalink Reply
mufiday
Thank you. Email: mufiday@hotmail.com
mufiday replied on at Permalink Reply
mufiday
Version 0.9.9 fixed the issue. thanks for the support

concrete5 Environment Information

# Concrete Version
Core Version - 9.2.0
Version Installed - 9.2.0
Database Version - 20230308163514

# Hostname
plesk-lnx03.1stdomains.net.nz

# Environment
production

# Database Information
Version: 10.6.12-MariaDB-cll-lve
SQL Mode:

# Concrete Packages
Advanced HTML Block (1.1), Block Builder (2.4.0), Code Display (1.1.1), Honest Websites Back To Top (1.1.0), Manual Nav (3.0.0)

# Concrete Overrides
mail/block_express_form_submission.php

# Concrete Cache Settings
Block Cache - On
Overrides Cache - On
Full Page Caching - On - If blocks on the particular page allow it.
Full Page Cache Lifetime - Every 6 hours (default setting).

# Server Software
Apache

# Server API
fpm-fcgi

# PHP Version
8.0.29

# PHP Extensions
bcmath, bz2, calendar, cgi-fcgi, Core, ctype, curl, date, dba, dom, enchant, exif, fileinfo, filter, ftp, gd, gettext, gmp, hash, iconv, imagick, imap, intl, json, ldap, libxml, mbstring, mysqli, mysqlnd, odbc, openssl, pcre, PDO, pdo_mysql, PDO_ODBC, pdo_pgsql, pdo_sqlite, pgsql, Phar, posix, pspell, redis, Reflection, session, SimpleXML, soap, sockets, sodium, SPL, sqlite3, standard, sysvmsg, sysvsem, sysvshm, tidy, tokenizer, 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 - 5000
max_multipart_body_parts - -1
memory_limit - 512M
post_max_size - 32M
upload_max_filesize - 32M
zend.exception_string_param_max_len - 0
ldap.max_links - Unlimited
mbstring.regex_retry_limit - 1000000
mbstring.regex_stack_limit - 100000
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
odbc.max_links - Unlimited
odbc.max_persistent - Unlimited
pcre.backtrack_limit - 1000000
pcre.recursion_limit - 100000
pgsql.max_links - Unlimited
pgsql.max_persistent - Unlimited
redis.pconnect.connection_limit - 0
session.cache_limiter - <i>no value</i>
session.gc_maxlifetime - 7200
soap.wsdl_cache_limit - 5
unserialize_max_depth - 4096
opcache.jit_bisect_limit - 0
opcache.jit_max_exit_counters - 8192
opcache.jit_max_loop_unrolls - 8
opcache.jit_max_polymorphic_calls - 2
opcache.jit_max_recursive_calls - 2
opcache.jit_max_recursive_returns - 2
opcache.jit_max_root_traces - 1024
opcache.jit_max_side_traces - 128
opcache.max_accelerated_files - 10000
opcache.max_file_size - 0
opcache.max_wasted_percentage - 5

Browser User-Agent String

Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36 Edg/117.0.2045.40

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.