Adding a subforum results in 'A configuration or server error has occurred'.

[CP_User]

We're receiving this error, we had something similar which was caused by an outdated application which has since been removed.

Error:
INSERT INTO `ibf_forums_forums` ( `parent_id`, `forums_bitoptions`, `position` ) VALUES ( '73', 0, 178 )
IPS\Db\Exception: Field 'topicrules_texto' doesn't have a default value (1364)
#0 /home2/<removed>/public_html/system/Db/Db.php(938): IPS\_Db->preparedQuery('/*<removed>_foru...', Array)
#1 /home2/<removed>/public_html/system/Patterns/ActiveRecord.php(487): IPS\_Db->insert('forums_forums', Array)
#2 /home2/<removed>/public_html/system/Node/Model.php(2494): IPS\Patterns\_ActiveRecord->save()
#3 /home2/<removed>/public_html/applications/forums/sources/Forum/Forum.php(1265): IPS\Node\_Model->save()
#4 /home2/<removed>/public_html/system/Node/Controller.php(419): IPS\forums\_Forum->formatFormValues(Array)
#5 /home2/<removed>/public_html/applications/forums/modules/admin/forums/forums.php(132): IPS\Node\_Controller->form()
#6 /home2/<removed>/public_html/system/Dispatcher/Controller.php(90): IPS\forums\modules\admin\forums\_forums->form()
#7 /home2/<removed>/public_html/system/Node/Controller.php(69): IPS\Dispatcher\_Controller->execute()
#8 /home2/<removed>/public_html/applications/forums/modules/admin/forums/forums.php(44): IPS\Node\_Controller->execute()
#9 /home2/<removed>/public_html/system/Dispatcher/Dispatcher.php(153): IPS\forums\modules\admin\forums\_forums->execute()
#10 /home2/<removed>/public_html/admin/index.php(13): IPS\_Dispatcher->run()
#11 {main}

Backtrace:
#0 /home2/<removed>/public_html/init.php(1015): IPS\_Log::log('INSERT INTO `ib...', 'uncaught_except...')
#1 [internal function]: IPS\IPS::exceptionHandler(Object(IPS\Db\Exception))
#2 {main}

We now have this error. I believe this relates to another old app, which was topic rules going by the error? Unless, this is the topic rules that can be added to a sub-forum creation.

[Daniel F]

Yea, that's a 3rd party app column! If you're not using the app anymore, just remove the column from your ibf_forums_forums database table, otherwise please contact the 3rd party author.

[CP_User]

20 minutes ago, Daniel F said:

Yea, that's a 3rd party app column! If you're not using the app anymore, just remove the column from your ibf_forums_forums database table, otherwise please contact the 3rd party author.

Deleted them, and now left with this?
INSERT INTO `ibf_forums_forums` ( `parent_id`, `forums_bitoptions`, `position` ) VALUES ( '73', 0, 178 )
IPS\Db\Exception: Unknown column 'forums_bitoptions' in 'field list' (1054)

[Daniel F]

I hope you deleted only topicrules_texto if not, import your recent backup and remove only this one. 

[CP_User]

3 minutes ago, Daniel F said:

I hope you deleted only topicrules_texto

I deleted that. And not I cannot remember what other topicrules_ I deleted.

 

Currently, have these:

topicrules_onoff

topicrules_tipo

topicrules_grupos

Crap... I realised also deleted - Forums_bitoptions - by mistake.

Edited February 22, 2022 by CP_User

[CP_User]

I managed to remake the forum structure and re-add forums_bitoptions... Crisis averted! Rookie mistake!

However, no more error.

I now need to clean my chair...

[Mark H]

You should be safe to restore just that one table from a very recent backup, then delete the one column in question, 'topicrules_texto'

Make sure not to remove any other columns.

 

EDIT: Replied too soon.

Glad to hear you got the problem sorted out.

[CP_User]

Just now, Mark H said:

You should be safe to restore just that one table from a very recent backup, then delete the one column in question, 'topicrules_texto'

Make sure not to remove any other columns.

Just done that very thing..

Thanks for the help, guys. (Still learning)

[Marc]

Glad to hear you got it sorted 😄 Best lesson you can ever learn on these things is backup regularly and any time you make a change that could break things