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, 20222 yr by Electric_Sheep8787

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, 20222 yr by teraßyte

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