Electric_Sheep8787 Posted October 30, 2022 Posted October 30, 2022 (edited) Hey all, I migrated to a new server and also updated to the newest version. However i'm unable to create new topics. New posts work fine - just cannot create new topics. INSERT INTO `ibf_forums_topics` ( `start_date`, `last_post`, `starter_id`, `starter_name`, `last_real_post`, `last_poster_id`, `last_poster_name`, `forum_id`, `approved`, `state`, `views`, `pinned`, `featured`, `is_future_entry`, `posts`, `topic_queuedposts`, `topic_hiddenposts`, `publish_date`, `title`, `title_seo`, `poll_state`, `topic_open_time`, `topic_close_time` ) VALUES ( 1667167221, 1667167221, 3350, 'Admin', 1667167221, 3350, 'Admin', 41, 1, 'open', 0, 0, 0, 0, 0, 0, 0, 1667167221, 'Admin', 'test', NULL, 0, 0 ) IPS\Db\Exception: Field 'who_viewed' doesn't have a default value (1364) #0 /home/site/public_html/forums/system/Db/Db.php(941): IPS\_Db->preparedQuery('/*siteadmin_foru...', Array) #1 /home/site/public_html/forums/system/Patterns/ActiveRecord.php(487): IPS\_Db->insert('forums_topics', Array) #2 /home/site/public_html/forums/applications/forums/sources/Topic/Topic.php(1557): IPS\Patterns\_ActiveRecord->save() #3 /home/site/public_html/forums/system/Content/Item.php(414): IPS\forums\_Topic->save() #4 /home/site/public_html/forums/system/Content/Item.php(143): IPS\Content\_Item::createFromForm(Array, Object(IPS\forums\Forum)) #5 /home/site/public_html/forums/applications/forums/modules/front/forums/forums.php(639): IPS\Content\_Item::create(Object(IPS\forums\Forum)) #6 /home/site/public_html/forums/system/Dispatcher/Controller.php(107): IPS\forums\modules\front\forums\_forums->add() #7 /home/site/public_html/forums/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute() #8 /home/site/public_html/forums/index.php(13): IPS\_Dispatcher->run() #9 {main} Edited October 30, 2022 by Electric_Sheep8787
Solution teraßyte Posted October 30, 2022 Solution Posted October 30, 2022 (edited) Based on the error it looks like your new server has STRICT MODE enabled for MySQL while the old server didn't. You can try asking your hosting to disable it to solve the problem. That said, the error comes from a third party modification. Based on the name I'd say it's a modification that keeps track of who has viewed a topic. You should contact the modification's developer and report the bug. Edited October 30, 2022 by teraßyte
Marc Posted October 31, 2022 Posted October 31, 2022 If this is a 3rd party item you no longer use, you could remove that column if needed also. But before attempting that, you should completely backup all your site, in case of issues
Recommended Posts