StopForumSpam broke my forum - help with MYSQL query

[FabioPaz]

Hello,

The plugin from stop forum spam from IPB3 broke my forum after I upgraded to IPS4, it left some fields in the db that now, when some users try to edit their profile, it gives a EX1364 error.

InvisionPower dont give support to 3rd party addons, so I'm alone on this one, since I dont find the guy who did this.

Looking at the error: it shows this:

REPLACE INTO `ibf_core_pfields_content` ( `member_id`, `field_5`, `field_6`, `field_7`, `field_11`, `field_12`, `field_13`, `field_2`, `field_9`, `field_15`, `field_16`, `field_19`, `field_20` ) VALUES ( 254472, '', '', '', '', '', '', '0', '', '', '', '', '' )
IPS\Db\Exception: Field 'sfsMemInfo' doesn't have a default value (1364)

Can I just remove sfsMemInfo from all profiles ? Since the addon is already uninstalled, this will affect my db ? I really dont understand mysql.

[FabioPaz]

Yep. It worked. Thank you anyway.

ALTER TABLE  ibf_core_pfields_content DROP COLUMN sfsMemInfo;

[Daniel F]

I'll still reply, maybe it's useful to other people

 

if the application / plugin was uninstalled, you should drop the column. If the application / plugin data should remain in the database, I would suggest to just set a default value for this field. 

[IPCommerceFan]

^ This was indeed useful for me.

I migrated my cpanel account to a new server yesterday, which also involved updating from MySQL 5.6 to 5.7 and PHP 7.2->7.3.   No changes to IPS install (4.4.10)

Everything went off without a hitch!  Site back up and running without issue, except apparently nothing was being written to the nexus_customers table when a guest would check out.   This did not affect registered members.

I managed to repro the issue and see the error, which was exactly the above!

IPS\Db\Exception: Field 'sfsMemInfo' doesn't have a default value (1364)

Its really curious this didn't show itself until I moved the server and updated mysql and php.  Its unclear which of those revealed the issue.  In any case, this was a huge help.  Thanks @FabioPaz and @Daniel F (I opted to just drop the columns)