Michael Lachney Posted January 26 Share Posted January 26 (edited) I'm having an issue on my LIVE forum, as well as, the new Test Install forum. I cannot edit any options in the Guest Group. The groups: Admin, Members and Moderator works fine. Screenshot of the error, and how to do a possible fix for this. Thanks. Edited to update the version: This is with v4.7.15 Edited January 26 by Michael Lachney Link to comment Share on other sites More sharing options...
Solution Nathan Explosion Posted January 26 Solution Share Posted January 26 Disable strict mode on your mySQL instance. Link to comment Share on other sites More sharing options...
Nathan Explosion Posted January 26 Share Posted January 26 (edited) Hmmm - actually, this looks like it could be reproducible without strict mode involved... Ignore that - it's only reproducible with strict mode enabled on mySQL For the guest group, the g_mod_post_unit evaluates to NULL in applications\core\extensions\core\GroupForm\Content.php because it's not present on the form: if( $group->g_id != \IPS\Settings::i()->guest_group ){ $form->add( new \IPS\Helpers\Form\Custom( 'g_mod_post_unit'...... ...but the Save function doesn't take that into account: /* Mod Queue */ $group->g_mod_post_unit = isset( $values['g_mod_post_unit'][2] ) ? 0 : $values['g_mod_post_unit'][0]; Not an issue if not using strict mode. Edited January 26 by Nathan Explosion Marc Stridgen 1 Link to comment Share on other sites More sharing options...
Marc Stridgen Posted January 26 Share Posted January 26 I cant replicate on my end at all. Please could you let me know exactly what it is you are changing? Link to comment Share on other sites More sharing options...
teraßyte Posted January 26 Share Posted January 26 The error is thrown only when editing the GUEST GROUP with MYSQL STRICT MODE enabled. Link to comment Share on other sites More sharing options...
Marc Stridgen Posted January 26 Share Posted January 26 Thanks for the confirmation. I have added a bug report for that. The Old Man 1 Link to comment Share on other sites More sharing options...
Nathan Explosion Posted January 26 Share Posted January 26 16 minutes ago, Marc Stridgen said: I cant replicate on my end at all. Please could you let me know exactly what it is you are changing? Just to answer this - nothing is being changed; just saving the group with strict mode on will trigger the error. Link to comment Share on other sites More sharing options...
Marc Stridgen Posted January 26 Share Posted January 26 1 hour ago, Nathan Explosion said: Just to answer this - nothing is being changed; just saving the group with strict mode on will trigger the error. Got there now once you mentioned it is still while on strict. I wasnt 🙂 Its not "strictly" (pun intended lol) to do with that. Its an incorrect null value being passed, but thats for the devs to sort Link to comment Share on other sites More sharing options...
Nathan Explosion Posted January 26 Share Posted January 26 1 minute ago, Marc Stridgen said: Its an incorrect null value being passed... I know. Link to comment Share on other sites More sharing options...
Michael Lachney Posted January 26 Author Share Posted January 26 8 hours ago, Nathan Explosion said: Disable strict mode on your mySQL instance. Thanks. Disabled strict mode and I was able to make the changes needed. Nathan Explosion and Marc Stridgen 2 Link to comment Share on other sites More sharing options...
Jelly Belly™ Posted February 17 Share Posted February 17 I'm having this problem too when trying to change guests permissions on which forums they can view Link to comment Share on other sites More sharing options...
Marc Stridgen Posted February 19 Share Posted February 19 On 2/17/2024 at 8:05 PM, Jelly Belly™ said: I'm having this problem too when trying to change guests permissions on which forums they can view Yes, this is an open bug report at present Jelly Belly™ 1 Link to comment Share on other sites More sharing options...
Marc Stridgen Posted March 14 Share Posted March 14 This has now been resolved in the 4.7.16 release. Please update if you are seeing this issue. If you are then still seeing the issue, please let us know. Link to comment Share on other sites More sharing options...
Recommended Posts