MySQL Error

Permalink Browser Info Environment
We upgraded to 1.5.3 and are receiving this error if we modify any SEO fields in the attributes.

An exception occurred while executing 'INSERT INTO atMetaDevodaSeo (robots_advanced_type, robots_noodp, robots_noimageindex, robots_noarchive, robots_nosnippet, robots_notranslate, open_graph_title, open_graph_description, open_graph_image, google_plus_title, google_plus_description, google_plus_image, twitter_title, twitter_description, twitter_image, twitter_card_type, structured_data, avID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["0", 0, 0, 0, 0, 0, null, null, 0, null, null, 0, null, null, 0, "", null, 1786]:

SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'structured_data' cannot be null

Type: Discussion
Status: Resolved
edsaxmoore
View Replies:
ramonleenders replied on at Permalink Reply
ramonleenders
Hi there,

Could you execute this query?

ALTER TABLE `atMetaDevodaSeo` MODIFY COLUMN `structured_data` longtext NULL DEFAULT NULL;

This will set your column that the structured data field can be empty. It should have already been this way, but I don't know why it's not in your situation...

Let me know how that worked out for you.

Kind regards,
Ramon
edsaxmoore replied on at Permalink Reply
edsaxmoore
That worked. Thanks for the support!

concrete5 Environment Information

# concrete5 Version
Core Version - 8.5.1
Version Installed - 8.5.1
Database Version - 20190301133300

# concrete5 Packages
Abandoned Cart (0.0.9), Advanced Color Picker (1.0c), Authorize.Net Payment Method (1.0.2), Cash Payment Method (1.0), Community Store (2.1.3), Community Store Postcode Based Shipping (2.0), Community Store Product Attribute (0.5), Community Store Structured Data (0.9.1), Community Store Table Rate shipping (2.0), Community Store Toolbar Buttons (1.0), Community Store Weight Tiered Shipping (2.0), Composer Security (1.0), Devoda SEO (1.5.3), Enhanced Version List (0.9.2), Event Tracking (1.1.0), ExchangeCore reCAPTCHA (1.1.1), EZ Preview (1.0.1), Font Awesome Font Icons for CKEditor (0.9.1), Formidable (Lite Version) (1.1.8), Image Optimizer (3.2.9), Login Page Background (0.9.1), MailChimp Subscribing (1.0), Minify HTML (2.0.0), Page Activity (0.9.3), PDF Viewer (1.0.1), Rescan All Files (0.1.5), Stride Theme (1.1.7), Stripe Payment Method (1.1), Studio Testimonials Pro (2.1.0.5), Styled Maps (1.2.3), Tallacmans Copyright (1.0), Video Pro (1.0.0), Whale Grid Gallery (2.5.0), White Label (1.0.1)

# concrete5 Overrides
controllers/single_page/dashboard/addfont.php, controllers/single_page/dashboard, controllers/single_page, single_pages/dashboard/view.php, single_pages/dashboard/addfont/view.php, single_pages/dashboard/addfont, single_pages/dashboard

# concrete5 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/2.4.10 (Debian)

# Server API
fpm-fcgi

# PHP Version
7.0.33-1~dotdeb+8.1

# PHP Extensions
apc, apcu, bcmath, bz2, calendar, cgi-fcgi, Core, ctype, curl, date, dba, dom, enchant, exif, fileinfo, filter, ftp, gd, gettext, gmp, hash, iconv, igbinary, imagick, imap, interbase, intl, ionCube Loader, json, libxml, mbstring, mcrypt, memcached, msgpack, mysqli, mysqlnd, newrelic, odbc, openssl, pcre, PDO, pdo_dblib, PDO_Firebird, pdo_mysql, PDO_ODBC, pdo_pgsql, pdo_sqlite, pgsql, Phar, posix, readline, recode, redis, Reflection, session, shmop, SimpleXML, soap, sockets, SPL, sqlite3, standard, sysvmsg, sysvsem, sysvshm, tidy, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, Zend OPcache, zip, zlib

# PHP Settings
max_execution_time - 12000
log_errors_max_len - 1024
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - 60
max_input_vars - 2500
memory_limit - 1024M
post_max_size - 100M
sql.safe_mode - Off
upload_max_filesize - 100M
ibase.max_links - Unlimited
ibase.max_persistent - Unlimited
memcached.sess_lock_max_wait - not set
memcached.sess_lock_wait_max - 2000
memcached.sess_server_failure_limit - 0
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
newrelic.special.max_nesting_level - -1
odbc.max_links - Unlimited
odbc.max_persistent - Unlimited
pcre.backtrack_limit - 1000000
pcre.recursion_limit - 100000
pgsql.max_links - Unlimited
pgsql.max_persistent - Unlimited
session.cache_limiter - <i>no value</i>
session.gc_maxlifetime - 7200
soap.wsdl_cache_limit - 5
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/78.0.3904.87 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.