Forums

Critical error - exception while executing 'INSERT INTO FileImageThumbnailPaths..

Permalink 1 user found helpful
Hi,

Recently my concrete5 v8.0.3 website has stopped working. I am running the Stucco theme v2.0.0.

Whenever I visit it, I get this error: 

An exception occurred while executing 'INSERT INTO FileImageThumbnailPaths (path, fileID, fileVersionID, storageLocationID, thumbnailTypeHandle) VALUES (?, ?, ?, ?, ?)' with params ["\/4014\/7925\/5458\/work_icon.svg", 38, 1, 1, "large"]: SQLSTATE[HY000]: General error: 1364 Field 'isBuilt' doesn't have a default value


My website URL ishttp://zaneweb.org, and I am not running any custom code, except changing the footer text.

Any help is appreciated, so thanks for contributing!
zaneweb
 
CMSDeveloper replied on at Permalink Best Answer Reply
CMSDeveloper
Hello,

The: mysql 1364 error..., is a sql strict mode error.
https://www.euperia.com/development/mysql-fix-field-doesnt-default-v...

The default mysql strict mode setting for version 5.7 has changed.
https://www.percona.com/blog/2016/10/18/upgrading-to-mysql-5-7-bewar...

It is a my.ini (or my.cnf) setting:

[mysqld]
#Example: sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 
#Change to:
sql_mode=""


Kind Regards,

Peter
zaneweb replied on at Permalink Reply
zaneweb
Thank you so much! That fixed my issue. If people have the same issue, please note to restart MySQL after like this:

sudo service mysql restart


And if you can't find your my.ini/my.cnf, do

find / -name my.cnf


(and replace with ini if that doesn't work).

Anyway, thank you so much!
Ta2Ta2 replied on at Permalink Reply
thanks alot man!