XF\Db\Exception: MySQL query error [1265]: Data truncated for column 'blog_post_state' at row 1 src/XF/Db/AbstractStatement.php:230
Generated by: Pete Thomas Aug 29, 2024 at 1:41 PM
Stack trace
INSERT INTO `xf_taylorj_blogs_blog_post` (`blog_id`, `blog_post_title`, `blog_post_content`, `scheduled_post_date_time`, `blog_post_state`, `user_id`, `blog_post_date`, `blog_post_last_edit_date`, `attach_count`, `embed_metadata`, `view_count`, `reaction_score`, `reactions`, `reaction_users`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
------------
#0 src/XF/Db/Mysqli/Statement.php(207): XF\Db\AbstractStatement->getException('MySQL query err...', 1265, '01000')
#1 src/XF/Db/Mysqli/Statement.php(83): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1265, '01000')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(219): XF\Db\AbstractAdapter->query('INSERT INTO `x...', Array)
#4 src/XF/Mvc/Entity/Entity.php(1570): XF\Db\AbstractAdapter->insert('xf_taylorj_blog...', Array, false)
#5 src/XF/Mvc/Entity/Entity.php(1300): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/addons/TaylorJ/Blogs/Service/BlogPost/Create.php(91): XF\Mvc\Entity\Entity->save(true, false)
#7 src/XF/Service/ValidateAndSavableTrait.php(42): TaylorJ\Blogs\Service\BlogPost\Create->_save()
#8 src/addons/TaylorJ/Blogs/Pub/Controller/Blog.php(173): TaylorJ\Blogs\Service\BlogPost\Create->save()
#9 src/addons/TaylorJ/Blogs/Pub/Controller/Blog.php(143): TaylorJ\Blogs\Pub\Controller\Blog->blogPostSaveProcess(Object(XF\Mvc\ParameterBag))
#10 src/XF/Mvc/Dispatcher.php(362): TaylorJ\Blogs\Pub\Controller\Blog->actionPostSave(Object(XF\Mvc\ParameterBag))
#11 src/XF/Mvc/Dispatcher.php(264): XF\Mvc\Dispatcher->dispatchClass('TaylorJ\\Blogs:B...', 'PostSave', Object(XF\Mvc\RouteMatch), Object(TaylorJ\Blogs\Pub\Controller\Blog), NULL)
#12 src/XF/Mvc/Dispatcher.php(121): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(TaylorJ\Blogs\Pub\Controller\Blog), NULL)
#13 src/XF/Mvc/Dispatcher.php(63): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#14 src/XF/App.php(2813): XF\Mvc\Dispatcher->run()
#15 src/XF.php(802): XF\App->run()
#16 index.php(23): XF::runApp('XF\\Pub\\App')
#17 {main}
Request state
array(4) {
["url"] => string(23) "/blogs/blog/0/post-save"
["referrer"] => string(62) "https://xf2.cafesaxophone.com/blogs/blog/petes-blog.1/add-post"
["_GET"] => array(0) {
}
["_POST"] => array(13) {
["_xfToken"] => string(8) "********"
["blog_post_title"] => string(6) "Post 1"
["message_html"] => string(12) "<p>Stuff</p>"
["attachment_hash"] => string(32) "4844ce82a2a0eafbf8d43ea7aec924b9"
["attachment_hash_combined"] => string(108) "{"type":"taylorj_blogs_blog_post","context":{"blog_post_id":null},"hash":"4844ce82a2a0eafbf8d43ea7aec924b9"}"
["blog_post_schedule"] => string(1) "0"
["dd"] => string(10) "2024-08-29"
["hh"] => string(2) "13"
["mm"] => string(2) "00"
["blog_id"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
["_xfWithData"] => string(1) "1"
["_xfRequestUri"] => string(33) "/blogs/blog/petes-blog.1/add-post"
}
}