Back to Newsletter Support

Somel
Somel

"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

vimirlab51752
vimirlab51752

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?

Somel
Somel

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

Somel
Somel

is the field set as nullable?

vimirlab51752
vimirlab51752

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

Somel
Somel

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

Somel
Somel

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

Sergey
Sergey

Same error when create new post and subscriber

Last updated

1-8 of 8