"SQLSTATE[HY000]: General error: 1364 Field 'hidden' doesn't have a default value (SQL: insert into vimirlab_newsletter_news (title, slug, introductory, content, newsletter_content, category_id, image, published_date, expire_date, status, featured, tags, updated_at, created_at) values (teste, teste, <p>teset</p>, <p>teste</p>, , 1, , 2020-04-20 00:00:00, 2020-04-20 00:00:00, 2, 1, , 2020-04-20 13:48:52, 2020-04-20 13:48:52))" on line 664 of C:\WebSites\OctoberCMS\vendor\laravel\framework\src\Illuminate\Database\Connection.php

When trying to create news post. Please Advise

Somel said:

"SQLSTATE[HY000]: General error: 1364 Field 'hidden' doesn't have a default value (SQL: insert into vimirlab_newsletter_news (title, slug, introductory, content, newsletter_content, category_id, image, published_date, expire_date, status, featured, tags, updated_at, created_at) values (teste, teste, <p>teset</p>, <p>teste</p>, , 1, , 2020-04-20 00:00:00, 2020-04-20 00:00:00, 2, 1, , 2020-04-20 13:48:52, 2020-04-20 13:48:52))" on line 664 of C:\WebSites\OctoberCMS\vendor\laravel\framework\src\Illuminate\Database\Connection.php

When trying to create news post. Please Advise

Have you customize newspost table in database?

No bare install from market place. Installed Created category Try to create post... when trying to save post this shows up.

is the field set as nullable?

We updated NewsLetter plugin - Please use it and Let me know if you get the problem again

Hi Updated the plugin and the error still occurs. Uninstalled and re-installed the plugin and still got same error.

SQLSTATE[HY000]: General error: 1364 Field 'hidden' doesn't have a default value (SQL: insert into vimirlab_newsletter_news (title, slug, introductory, content, newsletter_content, category_id, tags, image, published_date, expire_date, status, featured, updated_at, created_at) values (testing, testing, <p>testing</p>, <p>testing</p>, , 1, teste, /covid-19.jpg, 2020-04-23 00:00:00, 2020-04-30 00:00:00, 1, 1, 2020-04-23 12:07:24, 2020-04-23 12:07:24))" on line 664

setting a default value on the db for each field solved the issue

Same error when create new post and subscriber

Last updated 4 years ago