Install Error

Permalink Browser Info Environment
Doing some testing, upon installation of the package (version 1.4.1), I get this:

An exception occurred while executing 'INSERT INTO atMetaDevodaSeoSettings (akDefaultValue, akID) VALUES (?, ?)' with params ["", 140]: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'akDefaultValue' at row 1

The package shows as installed, but no dasboard area for the package. No issues with uninstallation, however.

Using Concrete 8.2.1 on a PHP 7 server.

Type: Pre-Sale
Status: Resolved
View Replies:
maar replied on at Permalink Reply
Got the exact same problem:

An exception occurred while executing 'INSERT INTO atMetaDevodaSeoSettings (akDefaultValue, akID) VALUES (?, ?)' with params ["", 109]: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '' for column `c5dk_shopdemo`.`atMetaDevodaSeoSettings`.`akDefaultValue` at row 1

And no problem uninstalling.

Concrete5 version 8.4.4
Devoda SEO version 1.5.2
Community Store version 2.0.6
Latest Pixel2 theme
maar replied on at Permalink Reply
I actually got it installed by "Refresh Entities" and Clearing Cache.

Why this was necessary, I do not know...
ramonleenders replied on at Permalink Reply
Weird, must have missed the original post.

Anyways... don't know why this happens. Did you come from version 5.7.x by any chance? Perhaps there lays some issue... not sure. But you got it resolved, right?

Kind regards,

maar replied on at Permalink Reply
Jep... Got it working...

No.. This was build in concrete5 8.4.3

A little strange this one. I have seen this "Invalid datetime format" in an other issue with one of our own packages, and it might be a core bug. But I can't put a finger on it.


concrete5 Environment Information

# concrete5 Version
Core Version - 8.2.1
Version Installed - 8.2.1
Database Version - 20170802000000

# concrete5 Packages
Afixia: Login Redirect (0.9.2), Backup Pro (3.4), Community Store (1.1.4), Devoda SEO (1.4.1), Fileset Attribute (1.0), Formidable (Full Version) (1.0.7), Honest Websites Back To Top (1.0.1), Image Link With Content (1.1), Info Box Grid (1.8), Login Page Background (0.9.1), Materialistic (0.1), MP4 Player (1.5.8), Open Graph Tags Lite (2.1.3), Page Child Redirect (0.9.2), Page Suggestions (1.0.1), Parts Block (1.0), Traffic & Statistics (1.2.1), Video Background (0.9.9), Wall Gallery Suite (1.0.1), Whale OWL Carousel (

# concrete5 Overrides

# 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.18 (Ubuntu)

# Server API

# PHP Version

# PHP Extensions
apache2handler, apcu, 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, SPL, standard, sysvmsg, sysvsem, sysvshm, tokenizer, wddx, xml, xmlreader, xmlwriter, xsl, Zend OPcache, 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 - 128M
post_max_size - 8M
sql.safe_mode - Off
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 - 2000
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/63.0.3239.84 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 have not specified a license for this support ticket. You must have a valid license assigned to a support ticket to request a refund.