Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted January 22Jan 22 I have a fairly vanilla (1 application added) install running v4.7.19Have been running this site on IPS since 2008 but since the last update I am getting this error when trying to create a new group. Has anyone come across this before?EX1364 Something went wrong. Please try again.INSERT INTO hyperspi_core_groups ( g_bitoptions, g_club_allowed_nodes ) VALUES ( 0, '' )IPS\Db\Exception: Field 'g_fcontent_excludeFGroup' doesn't have a default value (1364)#0 /home/hyperspi/public_html/system/Db/Db.php(941): IPS\_Db->preparedQuery('/*hyperspi_ipb:...', Array)#1 /home/hyperspi/public_html/system/Patterns/ActiveRecord.php(487): IPS\_Db->insert('core_groups', Array)#2 /home/hyperspi/public_html/applications/core/modules/admin/members/groups.php(218): IPS\Patterns\_ActiveRecord->save()#3 /home/hyperspi/public_html/system/Dispatcher/Controller.php(107): IPS\core\modules\admin\members\_groups->form()#4 /home/hyperspi/public_html/applications/core/modules/admin/members/groups.php(39): IPS\Dispatcher\_Controller->execute()#5 /home/hyperspi/public_html/system/Dispatcher/Dispatcher.php(153): IPS\core\modules\admin\members\_groups->execute()#6 /home/hyperspi/public_html/admin/index.php(13): IPS\_Dispatcher->run()#7 {main} Edited January 22Jan 22 by Circo
January 22Jan 22 The g_fcontent_excludeFGroup column is not a default one. Based on the name, did you install a Featured Content application at some point? 🤔
January 24Jan 24 Author On 1/22/2025 at 7:47 AM, teraßyte said:The g_fcontent_excludeFGroup column is not a default one. Based on the name, did you install a Featured Content application at some point? 🤔Yes, though it has been awhile. Is there a safe way to fix this in say phpmyadmin? It was Bims featured content, I removed it after i needed an update and the marketplace closed. Edited January 24Jan 24 by Circo
January 24Jan 24 Looks like uninstalling it didn’t remove the column(s) added to the core_groups table.If you have access to phpMyAdmin or another tool to access the MySQL database, you can drop the column yourself. If you’re unsure of how to do it, you can try asking your hosting for help (some do help with this kind of thing), or you can hire a 3rd party Provider to help you clean up the database.In any case, always do a backup before editing the database directly!
January 24Jan 24 Author On 1/22/2025 at 1:57 AM, Marc said:Check if your mysql instance is in strict modeThis actually fixed it! Thank you!4 hours ago, teraßyte said:Looks like uninstalling it didn’t remove the column(s) added to the core_groups table.If you have access to phpMyAdmin or another tool to access the MySQL database, you can drop the column yourself. If you’re unsure of how to do it, you can try asking your hosting for help (some do help with this kind of thing), or you can hire a 3rd party Provider to help you clean up the database.In any case, always do a backup before editing the database directly!My host has always been awesome and I do have an sql guy I have access to. Will get that cleaned up for good measure. Thank you both!