Jump to content

EX1054 error updating Member Group


Go to solution Solved by Jim M,

Recommended Posts

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}

Link to comment
Share on other sites

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' ) );
    }

 

Link to comment
Share on other sites

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...