Can't add Layout

Permalink Browser Info Environment
When I tried to add a layout to the page I get this error

An exception occurred while executing 'update AreaLayoutThemeGridColumns set arLayoutColumnSpan = ? where arLayoutColumnID = ?' with params ["-1", "52"]:

SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'arLayoutColumnSpan' at row 1

Details
/home/iowaascd/public_html/newsite/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php(128): Doctrine\DBAL\Exception\DriverException->null
/home/iowaascd/public_html/newsite/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(182): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException
/home/iowaascd/public_html/newsite/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(159): Doctrine\DBAL\DBALException->wrapException
/home/iowaascd/public_html/newsite/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(2225): Doctrine\DBAL\DBALException->driverExceptionDuringQuery
/home/iowaascd/public_html/newsite/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1312): Doctrine\DBAL\Connection->handleExceptionDuringQuery
/home/iowaascd/public_html/newsite/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php(18): Doctrine\DBAL\Driver\PDO\Exception->null
/home/iowaascd/public_html/newsite/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(119): Doctrine\DBAL\Driver\PDO\Exception->new
/home/iowaascd/public_html/newsite/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117): PDOException->null
/home/iowaascd/public_html/newsite/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117): PDOStatement->execute
/home/iowaascd/public_html/newsite/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1303): Doctrine\DBAL\Driver\PDOStatement->execute
/home/iowaascd/public_html/newsite/concrete/src/Database/Connection/Connection.php(97): Doctrine\DBAL\Connection->executeQuery
/home/iowaascd/public_html/newsite/concrete/src/Area/Layout/ThemeGridColumn.php(226): Concrete\Core\Database\Connection\Connection->Execute
/home/iowaascd/public_html/newsite/concrete/blocks/core_area_layout/controller.php(350): Concrete\Core\Area\Layout\ThemeGridColumn->setAreaLayoutColumnSpan
/home/iowaascd/public_html/newsite/concrete/blocks/core_area_layout/controller.php(243): Concrete\Block\CoreAreaLayout\Controller->addFromPost
/home/iowaascd/public_html/newsite/concrete/src/Entity/Block/BlockType/BlockType.php(675): Concrete\Block\CoreAreaLayout\Controller->save
/home/iowaascd/public_html/newsite/concrete/src/Page/Collection/Collection.php(1032): Concrete\Core\Entity\Block\BlockType\BlockType->add
/home/iowaascd/public_html/newsite/concrete/src/Page/Page.php(2641): Concrete\Core\Page\Collection\Collection->addBlock
/home/iowaascd/public_html/newsite/concrete/controllers/dialog/page/add_block.php(100): Concrete\Core\Page\Page->addBlock
/home/iowaascd/public_html/newsite/concrete/src/Controller/AbstractController.php(318): Concrete\Controller\Dialog\Page\AddBlock->submit
/home/iowaascd/public_html/newsite/concrete/src/Controller/AbstractController.php(318): null->call_user_func_array
/home/iowaascd/public_html/newsite/concrete/src/Routing/ControllerRouteAction.php(64): Concrete\Core\Controller\AbstractController->runAction
/home/iowaascd/public_html/newsite/concrete/src/Http/RouteDispatcher.php(37): Concrete\Core\Routing\ControllerRouteAction->execute
/home/iowaascd/public_html/newsite/concrete/src/Http/Middleware/DispatcherDelegate.php(39): Concrete\Core\Http\RouteDispatcher->dispatch
/home/iowaascd/public_html/newsite/concrete/src/Http/Middleware/MiddlewareStack.php(86): Concrete\Core\Http\Middleware\DispatcherDelegate->next
/home/iowaascd/public_html/newsite/concrete/src/Http/DefaultDispatcher.php(127): Concrete\Core\Http\Middleware\MiddlewareStack->process
/home/iowaascd/public_html/newsite/concrete/src/Http/DefaultDispatcher.php(60): Concrete\Core\Http\DefaultDispatcher->handleDispatch
/home/iowaascd/public_html/newsite/concrete/src/Http/Middleware/DispatcherDelegate.php(39): Concrete\Core\Http\DefaultDispatcher->dispatch
/home/iowaascd/public_html/newsite/concrete/src/Http/Middleware/FrameOptionsMiddleware.php(39): Concrete\Core\Http\Middleware\DispatcherDelegate->next
/home/iowaascd/public_html/newsite/concrete/src/Http/Middleware/MiddlewareDelegate.php(50): Concrete\Core\Http\Middleware\FrameOptionsMiddleware->process
/home/iowaascd/public_html/newsite/concrete/src/Http/Middleware/StrictTransportSecurityMiddleware.php(36): Concrete\Core\Http\Middleware\MiddlewareDelegate->next
/home/iowaascd/public_html/newsite/concrete/src/Http/Middleware/MiddlewareDelegate.php(50): Concrete\Core\Http\Middleware\StrictTransportSecurityMiddleware->process
/home/iowaascd/public_html/newsite/concrete/src/Http/Middleware/ContentSecurityPolicyMiddleware.php(36): Concrete\Core\Http\Middleware\MiddlewareDelegate->next
/home/iowaascd/public_html/newsite/concrete/src/Http/Middleware/MiddlewareDelegate.php(50): Concrete\Core\Http\Middleware\ContentSecurityPolicyMiddleware->process
/home/iowaascd/public_html/newsite/concrete/src/Http/Middleware/CookieMiddleware.php(35): Concrete\Core\Http\Middleware\MiddlewareDelegate->next
/home/iowaascd/public_html/newsite/concrete/src/Http/Middleware/MiddlewareDelegate.php(50): Concrete\Core\Http\Middleware\CookieMiddleware->process
/home/iowaascd/public_html/newsite/concrete/src/Http/Middleware/ApplicationMiddleware.php(29): Concrete\Core\Http\Middleware\MiddlewareDelegate->next
/home/iowaascd/public_html/newsite/concrete/src/Http/Middleware/MiddlewareDelegate.php(50): Concrete\Core\Http\Middleware\ApplicationMiddleware->process
/home/iowaascd/public_html/newsite/concrete/src/Http/Middleware/MiddlewareStack.php(86): Concrete\Core\Http\Middleware\MiddlewareDelegate->next
/home/iowaascd/public_html/newsite/concrete/src/Http/DefaultServer.php(85): Concrete\Core\Http\Middleware\MiddlewareStack->process
/home/iowaascd/public_html/newsite/concrete/src/Foundation/Runtime/Run/DefaultRunner.php(125): Concrete\Core\Http\DefaultServer->handleRequest
/home/iowaascd/public_html/newsite/concrete/src/Foundation/Runtime/DefaultRuntime.php(102): Concrete\Core\Foundation\Runtime\Run\DefaultRunner->run
/home/iowaascd/public_html/newsite/concrete/dispatcher.php(45): Concrete\Core\Foundation\Runtime\DefaultRuntime->run
/home/iowaascd/public_html/newsite/index.php(2): null->require

Type: Ticket
Status: Resolved
plschneide
View Replies:
Xanweb replied on at Permalink Reply
Xanweb
Could be an issue with your ConcreteCMS installation as we don't have any code in our theme that impacts Layouts.
plschneide replied on at Permalink Reply
plschneide
Weird today it is working better than ever. I'll take that as a win!

concrete5 Environment Information

# Concrete Version
Core Version - 9.0.2
Version Installed - 9.0.2
Database Version - 20220114215506

# Database Information
Version: 5.7.37
SQL Mode: STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

# Concrete Packages
2FA - Two-Factor Login Security (2.0.3), Replica Pro Theme (2.2.0)

# Concrete Overrides
authentication/concrete/controller.php, authentication/concrete/two_step_authentication.php, authentication/concrete

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

# Server Software
Apache

# Server API
fpm-fcgi

# PHP Version
7.4.28

# PHP Extensions
bcmath, calendar, cgi-fcgi, Core, ctype, curl, date, dom, fileinfo, filter, ftp, gd, hash, iconv, imap, json, libxml, mbstring, mysqli, mysqlnd, openssl, pcntl, pcre, PDO, pdo_mysql, pdo_sqlite, Phar, posix, Reflection, session, SimpleXML, sockets, SPL, sqlite3, standard, tokenizer, xml, xmlreader, xmlwriter, xsl, 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
mbstring.regex_retry_limit - 1000000
mbstring.regex_stack_limit - 100000
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
unserialize_max_depth - 4096

Browser User-Agent String

Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:99.0) Gecko/20100101 Firefox/99.0

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.