Michael Lachney Posted January 26 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
Solution Nathan Explosion Posted January 26 Solution Posted January 26 Disable strict mode on your mySQL instance.
Nathan Explosion Posted January 26 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 1
Marc Posted January 26 Posted January 26 I cant replicate on my end at all. Please could you let me know exactly what it is you are changing?
teraßyte Posted January 26 Posted January 26 The error is thrown only when editing the GUEST GROUP with MYSQL STRICT MODE enabled.
Marc Posted January 26 Posted January 26 Thanks for the confirmation. I have added a bug report for that. The Old Man 1
Nathan Explosion Posted January 26 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.
Marc Posted January 26 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
Nathan Explosion Posted January 26 Posted January 26 1 minute ago, Marc Stridgen said: Its an incorrect null value being passed... I know.
Michael Lachney Posted January 26 Author 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. Marc and Nathan Explosion 2
Jelly Belly™ Posted February 17 Posted February 17 I'm having this problem too when trying to change guests permissions on which forums they can view
Marc Posted February 19 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
Marc Posted March 14 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.
Recommended Posts