Maxthon_Fr Posted August 18, 2022 Share Posted August 18, 2022 Since 19/07/2022, when a new user creates an account on my forum, an error page is displayed with the error code EX1364. No mail is sent and the account is still validated. Here are the details of the corresponding system log: INSERT INTO `ibf_core_pfields_content` ( `member_id` ) VALUES ( 7846 ) ON DUPLICATE KEY UPDATE `member_id`=VALUES(`member_id`) IPS\Db\Exception: Field 'sfsNextCheck' doesn't have a default value (1364) #0 /var/www/forum/system/Db/Db.php(941): IPS\_Db->preparedQuery() #1 /var/www/forum/system/Member/Member.php(427): IPS\_Db->insert() #2 /var/www/forum/applications/core/modules/front/system/register.php(566): IPS\_Member->save() #3 /var/www/forum/applications/core/modules/front/system/register.php(242): IPS\core\modules\front\system\_register::_createMember() #4 /var/www/forum/applications/core/modules/front/system/register.php(105): IPS\core\modules\front\system\_register->_registrationForm() #5 /var/www/forum/system/Dispatcher/Controller.php(118): IPS\core\modules\front\system\_register->manage() #6 /var/www/forum/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute() #7 /var/www/forum/index.php(13): IPS\_Dispatcher->run() #8 {main} Link to comment Share on other sites More sharing options...
Solution Jim M Posted August 18, 2022 Solution Share Posted August 18, 2022 3 minutes ago, Maxthon_Fr said: Field 'sfsNextCheck' doesn't have a default value (1364 Sounds like the field above in your database is from a third party application and missing a default value. You can disable strict mode on your MySQL server to disable these checks. Please check with your hosting provider with performing it. SeNioR- and Maxthon_Fr 1 1 Link to comment Share on other sites More sharing options...
teraßyte Posted August 18, 2022 Share Posted August 18, 2022 That sfs prefix calls to mind Stop Forum Spam. I've seen that column recently on a forum I upgraded from 3.4 to 4.6. Do you have an application like that installed? If you do try contacting its developer. Maxthon_Fr 1 Link to comment Share on other sites More sharing options...
Maxthon_Fr Posted August 18, 2022 Author Share Posted August 18, 2022 1 hour ago, teraßyte said: That sfs prefix calls to mind Stop Forum Spam. I've seen that column recently on a forum I upgraded from 3.4 to 4.6. Do you have an application like that installed? If you do try contacting its developer. Yes, I have installed Stop Forum Spam. Link to comment Share on other sites More sharing options...
Maxthon_Fr Posted August 18, 2022 Author Share Posted August 18, 2022 (edited) Thanks @Jim M, I disable strict mode on my MySQL server and now it works perfectly.😉 Edited August 18, 2022 by Maxthon_Fr Link to comment Share on other sites More sharing options...
Marc Posted August 19, 2022 Share Posted August 19, 2022 Glad to hear that has now resolved your issue Link to comment Share on other sites More sharing options...
Recommended Posts