Jump to content

Featured Replies

Posted

I have a fairly vanilla (1 application added) install running v4.7.19

Have 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 by Circo

Check if your mysql instance is in strict mode

The g_fcontent_excludeFGroup column is not a default one. Based on the name, did you install a Featured Content application at some point? 🤔

  • 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 by Circo

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!

  • Author
On 1/22/2025 at 1:57 AM, Marc said:

Check if your mysql instance is in strict mode

This 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!

Recently Browsing 0

  • No registered users viewing this page.