Exception Caught error out of the blue
News and General
one of my writers alerted me of this error that appeared out of the blue, i tried optimizing and repairing the database but it didn’t fix anything, any ideas?
it only happens while trying to make a new post, already posted articles are fine
EE 4.38
Exception Caught
SQLSTATE[HY000]: General error: 1364 Field ‘field_id_11’ doesn’t have a default value:
INSERT INTO exp_channel_data (channel_id, site_id, field_ft_4, field_ft_6, field_ft_8, field_ft_9, field_ft_10, field_ft_11, field_ft_13, field_ft_19, field_ft_23, field_ft_24, field_ft_25, field_ft_29, field_ft_65, field_ft_197, field_ft_209, field_ft_212, field_ft_278, field_ft_293, field_ft_298, field_ft_303, field_ft_310, field_ft_311, field_ft_323, field_ft_443, field_ft_446, field_id_65, field_id_303, field_id_323, field_id_6, field_id_8, field_id_278, field_id_4, field_id_443, field_id_298, field_id_19, field_id_10, field_id_9, field_id_197, field_id_209, field_id_24, field_id_23, field_id_13, field_id_29, field_id_212, entry_id) VALUES (‘3’, 1, ‘none’, ‘xhtml’, ‘xhtml’, ‘none’, ‘none’, ‘none’, ‘none’, ‘none’, ‘none’, ‘none’, ‘none’, ‘none’, ‘none’, ‘none’, ‘none’, ‘none’, ‘none’, ‘none’, ‘none’, ‘none’, ‘none’, ‘xhtml’, ‘xhtml’, ‘none’, ‘xhtml’, ”, ”, ‘sdfsf’, ‘sdfs’, ‘sdfs’, ‘sdfsdf’, ‘Adam Benavides’, ”, ”, ”, ”, ”, ”, ”, ”, ”, ”, ”, ”, ‘6163’)
ee/legacy/database/drivers/mysqli/mysqli_connection.php:116
Stack Trace: Please include when reporting this error
i also get this when i repair in EE
The storage engine for the table doesn’t support repair
now this error is on my homepage, index.php, but other pages within the site still display
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘) ORDER BY c.group_id, c.parent_id, c.cat_order’ at line 7: SELECT c.cat_name, c.cat_url_title, c.cat_id, c.cat_image, c.cat_description, c.parent_id, p.cat_id, p.entry_id, c.group_id , cg.field_html_formatting, fd.* FROM (exp_categories AS c, exp_category_posts AS p) LEFT JOIN exp_category_field_data AS fd ON fd.cat_id = c.cat_id LEFT JOIN exp_category_groups AS cg ON cg.group_id = c.group_id WHERE c.cat_id = p.cat_id AND p.entry_id IN () ORDER BY c.group_id, c.parent_id, c.cat_order mysqli_connection.php:116
ughhh.. again, there were no changes of anything admin-wise, seriously out of the blue.