Field 'GroupModOptions' doesn't have a default value

[steverp]

When creating a new group, I get this error:

Field 'GroupModOptions' doesn't have a default value
File: /home/*****/public_html/******/Sources/ManageMembergroups.php
Line: 378

I've added *'s to hide some information.

A similar error occurs in other parts of the forum when making changes as admin. But this is just one example.

Any help is appreciated.

[steverp]

Also i'm using the latest version of smf

[Dzonny]

Hello there and welcome to SMF community!
Are you using 2.1 branch?

From what I can see, looks like this field is a leftover from an old mod:
https://mods.simplemachines.org/index.php?mod=171

Can you list us a mods that you have installed on your forum?

[live627]

Go into the database and give that field a default value. I'm guessing it's in either smf_members or smf_membergroups

[Kindred]

, please note that "latest" is not an actual version.

there is the latest released version in the 2.0.x branch (2.0.17), plus the development branch....  there is also the 2.1 RC2 released version and the RC3-prep nightly builds - neither of which is suggested to run on a production site.

So, when you say "latest" we have no idea which one you actually mean...

[steverp]

Version is 2.0.17

From what I can see, looks like this field is a leftover from an old mod:
https://mods.simplemachines.org/index.php?mod=171

I dont recognize this mod, although it could be left over from a long time ago.

Go into the database and give that field a default value.

How do I know what value to use as default?

Thanks guys

[Sir Osis of Liver]

Set it to null.

[steverp]

I tried to find "GroupModOptions" anywhere in my database, and it's nowhere.

I tried phpmyadmin to seach "GroupModOptions" as a regular expression, and exact phrase as substring. I selected all tables to search. Still it isn't found anywhere.

Any ideas??

[Kindred]

Look at the code referenced and see where the field is

[Sir Osis of Liver]

PMA search will find field content, but not a field name.  You can run a query to find it, but am not on my computer so can't post it.

[Sir Osis of Liver]

Koodi [Valitse] Laajenna



SELECT table_name,table_schema
FROM INFORMATION_SCHEMA.COLUMNS
WHERE column_name='mime_type'



[steverp]

I ended up downloading the whole database and locally searching it to know where the table was. I set it to null and its now ok. Thanks for the help.