EX1054 error updating Member Group

[Clover13]

Two sites running v4.7.6

One site updates fine, other errors.  Neither has the offending column in the core_groups table.

Receiving an error EX1054 when updating any group due to an unknown column 'example' existing.

UPDATE `core_groups` `core_groups`  SET `g_promote_exclude`=true,`g_view_board`=true,`g_dohtml`=false,`g_access_offline`=true,`g_hide_online_list`='0',`g_post_polls`=true,`g_vote_polls`=true,`g_close_polls`=true,`g_topic_rate_setting`=1,`g_append_edit`=true,`g_avoid_flood`=true,`g_avoid_q`=true,`g_bypass_badwords`=true,`g_edit_posts`=1,`g_hide_own_posts`=1,`g_delete_own_posts`=1,`g_lock_unlock_own`=1,`g_can_report`=1,`g_view_displaynamehistory`=true,`g_edit_profile`=true,`g_upload_animated_photos`=true,`g_can_msg_attach`=true,`g_create_albums`=true,`g_create_albums_private`=true,`g_create_albums_fo`=true,`g_download_original`=true,`g_movies`=true,`example`='' WHERE g_id=######## 
IPS\Db\Exception: Unknown column 'example' in 'field list' (1054)
#0 /home/#########/public_html/system/Db/Db.php(1159): IPS\_Db->preparedQuery()
#1 /home/#########/public_html/system/Patterns/ActiveRecord.php(520): IPS\_Db->update()
#2 /home/#########/public_html/applications/core/modules/admin/members/groups.php(229): IPS\Patterns\_ActiveRecord->save()
#3 /home/#########/public_html/system/Dispatcher/Controller.php(107): IPS\core\modules\admin\members\_groups->form()
#4 /home/#########/public_html/applications/core/modules/admin/members/groups.php(39): IPS\Dispatcher\_Controller->execute()
#5 /home/#########/public_html/system/Dispatcher/Dispatcher.php(153): IPS\core\modules\admin\members\_groups->execute()
#6 /home/#########/public_html/admin/index.php(13): IPS\_Dispatcher->run()
#7 {main}

[Miss_B]

2 minutes ago, Clover13 said:

Receiving an error EX1054 when updating any group due to an unknown column 'example' existing.

If you check the core_groups tale, does it have the example column?

[Jim M]

IPS\Db\Exception: Unknown column 'example' in 'field list' (1054)

This is not a default column so is coming from a third party add-on or something else. Please contact the author for assistance.

[Adriano Faria]

4 minutes ago, Clover13 said:

IPS\Db\Exception: Unknown column 'example' in 'field list' (1054)

That would be the app we're working on. I added the Group extension but didn't use it yet so it is using its default "field", which is "example".

Will send you a message.

    public function process( &$form, $group )
    {        
        $form->add( new \IPS\Helpers\Form\Text( 'example' ) );
    }

 

[Clover13]

OK, that explains it, thanks @Adriano Faria! 🙂

All good now, uninstalled the app we were testing and the Member Group update works as expected.  Thanks for the input as well @Jim M and @Miss_B