CA3LE

@teraßyte and @Stuart Silvester thank you for the quick response! I haven't had any guest reports for hours now, so as long as that doesn't return I'll just be waiting for the next production update. If it does come back, it's good to know that I can just disable STRICT. I appreciate the responses, very helpful! Great to know that Invision continues to quickly respond to topics and will open a side channel if needed. Keep up the good work!

(first, I updated to the latest patch, same issue) When I try to edit the Guest group permissions I get an error. All other groups save properly. UPDATE `ipbcore_groups` `core_groups` SET `g_view_board`=true,`g_dohtml`=false,`g_search_flood`=20.0,`g_access_offline`=false,`g_mod_post_unit`=NULL,`g_avoid_flood`=false,`g_avoid_q`=false,`g_mod_preview`=false,`g_bypass_badwords`=false,`g_can_report`=0,`g_view_displaynamehistory`=false WHERE g_id=2 IPS\Db\Exception: Column 'g_mod_post_unit' cannot be null (1048) #0 /var/www/vhosts/x/httpdocs/ipb/system/Db/Db.php(1159): IPS\_Db->preparedQuery() #1 /var/www/vhosts/x/httpdocs/ipb/system/Patterns/ActiveRecord.php(520): IPS\_Db->update() #2 /var/www/vhosts/x/httpdocs/ipb/applications/core/modules/admin/members/groups.php(229): IPS\Patterns\_ActiveRecord->save() #3 /var/www/vhosts/x/httpdocs/ipb/system/Dispatcher/Controller.php(107): IPS\core\modules\admin\members\_groups->form() #4 /var/www/vhosts/x/httpdocs/ipb/applications/core/modules/admin/members/groups.php(39): IPS\Dispatcher\_Controller->execute() #5 /var/www/vhosts/x/httpdocs/ipb/system/Dispatcher/Dispatcher.php(153): IPS\core\modules\admin\members\_groups->execute() #6 /var/www/vhosts/x/httpdocs/ipb/adm1n/index.php(13): IPS\_Dispatcher->run() #7 {main} I'm attempting to change >> "Can report content?" I tried manually inputting in the database using the value already in the DB... MariaDB [tmn_ipb]> select `g_mod_post_unit` from `ipbcore_groups` `core_groups` WHERE g_id=2; +-----------------+ | g_mod_post_unit | +-----------------+ | 0 | +-----------------+ 1 row in set (0.000 sec) # I then ran UPDATE `ipbcore_groups` `core_groups` SET `g_view_board`=true,`g_dohtml`=false,`g_search_flood`=20.0,`g_access_offline`=false,`g_mod_post_unit`=0,`g_avoid_flood`=false,`g_avoid_q`=false,`g_mod_preview`=false,`g_bypass_badwords`=false,`g_can_report`=0,`g_view_displaynamehistory`=false WHERE g_id=2; # and then queried g_can_report MariaDB [tmn_ipb]> select `g_can_report` from `ipbcore_groups` `core_groups` WHERE g_id=2; +--------------+ | g_can_report | +--------------+ | 0 | +--------------+ 1 row in set (0.000 sec) No errors in SQL, query took. I thought that would work but on the admin control panel it still shows toggled ON. I'd like to change this setting because over the past 12 hours I've had dozens of Guest reports... never happened do that degree before. I'm just trying to disable guests from reporting content. Invision needs to address this in a patch. I'd like to communicate with them on this like I always did in the past but they've removed my ability unless I want to pay more. Note to Invision, that support contact helps YOU as much as it does us. As a ultra long time Invision client I'm very disappointed to see support removed. ...right when I was considering some of your other software. If anyone knows where that toggle is controlled in the database... or maybe it's cached somewhere... please let me know. I imagine it's possible that the setting is actually changed but it just isn't reflected in the admin interface. Guess I'll find out, if the Guest reports stop abruptly.

I fixed it. Just added default values of "0" to the offending columns. use ipb_database; ALTER TABLE ipbforums_topics ALTER cache_sm SET DEFAULT 0; ALTER TABLE ipbforums_topics ALTER cache_date SET DEFAULT 0; describe ipbforums_topics; ... but maybe there are others in the database that need correcting. Can someone from Invision let me know? I'm sure you want to know about this bug I encountered too. Normally I'd post something in the client area but it looks like you've removed my ability.

INSERT INTO `ipbforums_topics` ( `start_date`, `last_post`, `starter_id`, `starter_name`, `last_real_post`, `last_poster_id`, `last_poster_name`, `forum_id`, `approved`, `state`, `views`, `pinned`, `featured`, `posts`, `topic_queuedposts`, `topic_hiddenposts`, `title`, `title_seo`, `poll_state` ) VALUES ( 1649440272, 1649440272, 2, 'CA3LE', 1649440272, 2, 'CA3LE', 10, 1, 'open', 0, 0, 0, 0, 0, 0, 'test', 'test', NULL ) IPS\Db\Exception: Field 'cache_sm' doesn't have a default value (1364) #0 /var/www/vhosts/testmy.net/httpdocs/ipb/system/Db/Db.php(938): IPS\_Db->preparedQuery() #1 /var/www/vhosts/testmy.net/httpdocs/ipb/system/Patterns/ActiveRecord.php(487): IPS\_Db->insert() #2 /var/www/vhosts/testmy.net/httpdocs/ipb/applications/forums/sources/Topic/Topic.php(1531): IPS\Patterns\_ActiveRecord->save() #3 /var/www/vhosts/testmy.net/httpdocs/ipb/system/Content/Item.php(568): IPS\forums\_Topic->save() #4 /var/www/vhosts/testmy.net/httpdocs/ipb/applications/forums/sources/Topic/Topic.php(575): IPS\Content\_Item->processForm() #5 /var/www/vhosts/testmy.net/httpdocs/ipb/system/Content/Item.php(402): IPS\forums\_Topic->processForm() #6 /var/www/vhosts/testmy.net/httpdocs/ipb/system/Content/Item.php(138): IPS\Content\_Item::createFromForm() #7 /var/www/vhosts/testmy.net/httpdocs/ipb/applications/forums/modules/front/forums/forums.php(594): IPS\Content\_Item::create() #8 /var/www/vhosts/testmy.net/httpdocs/ipb/system/Dispatcher/Controller.php(90): IPS\forums\modules\front\forums\_forums->add() #9 /var/www/vhosts/testmy.net/httpdocs/ipb/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute() #10 /var/www/vhosts/testmy.net/httpdocs/ipb/index.php(13): IPS\_Dispatcher->run() #11 {main} After the last update nobody can post in my forum. Any ideas?