Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
Square Wheels Posted March 8, 2022 Posted March 8, 2022 I tried to copy the Members group and got the error below. Yes, I tried again with everything disabled and got the same error. INSERT INTO `IPS_core_groups` ( `g_id`, `g_view_board`, `g_mem_info`, `g_other_topics`, `g_use_search`, `g_edit_profile`, `g_post_new_topics`, `g_reply_own_topics`, `g_reply_other_topics`, `g_edit_posts`, `g_delete_own_posts`, `g_open_close_posts`, `g_delete_own_topics`, `g_post_polls`, `g_vote_polls`, `g_use_pm`, `g_append_edit`, `g_access_offline`, `g_avoid_q`, `g_avoid_flood`, `g_icon`, `g_attach_max`, `prefix`, `suffix`, `g_max_messages`, `g_max_mass_pm`, `g_search_flood`, `g_edit_cutoff`, `g_hide_from_list`, `g_post_closed`, `g_photo_max_vars`, `g_dohtml`, `g_edit_topic`, `g_bypass_badwords`, `g_can_msg_attach`, `g_attach_per_post`, `g_topic_rate_setting`, `g_dname_changes`, `g_dname_date`, `g_mod_preview`, `g_rep_max_positive`, `g_rep_max_negative`, `g_signature_limits`, `g_hide_online_list`, `g_bitoptions`, `g_pm_perday`, `g_mod_post_unit`, `g_ppd_limit`, `g_ppd_unit`, `g_displayname_unit`, `g_sig_unit`, `g_pm_flood_mins`, `g_max_bgimg_upload`, `g_blog_attach_max`, `g_blog_attach_per_entry`, `g_blog_do_html`, `g_blog_do_commenthtml`, `g_blog_allowpoll`, `g_blog_allowprivate`, `g_blog_allowprivclub`, `g_blog_alloweditors`, `g_blog_allowskinchoose`, `g_blog_preventpublish`, `idm_restrictions`, `idm_bypass_paid`, `idm_add_paid`, `idm_view_downloads`, `idm_report_files`, `idm_bypass_revision`, `idm_throttling`, `idm_wait_period`, `g_max_diskspace`, `g_max_upload`, `g_max_transfer`, `g_max_views`, `g_create_albums`, `g_create_albums_private`, `g_create_albums_fo`, `g_album_limit`, `g_img_album_limit`, `g_edit_own`, `g_del_own`, `g_img_local`, `g_movies`, `g_movie_size`, `g_gallery_use`, `g_blog_allowlocal`, `g_blog_maxblogs`, `g_blog_allowownmod`, `g_blog_allowdelete`, `g_blog_allowcomment`, `idm_view_approvers`, `idm_bulk_submit`, `idm_linked_files`, `idm_import_files`, `idm_block_submissions`, `g_bitoptions2`, `g_upload_animated_photos`, `g_view_displaynamehistory`, `g_hide_own_posts`, `g_lock_unlock_own`, `g_can_report`, `g_create_clubs`, `g_club_allowed_nodes`, `g_close_polls`, `g_promote_exclude`, `g_question_access`, `g_question_contentcount`, `can_create_bookmarks`, `can_create_private_bookmarks`, `g_club_limit`, `g_download_original`, `idm_paid_restrictions`, `idm_max_size`, `jobs_group_id`, `jobs_access`, `jobs_dontpay` ) VALUES ( NULL, 1, 1, 1, 1, 1, 1, 1, 1, '1', '0', 0, 0, 1, 1, 1, 0, 0, 0, 0, NULL, -1, '<span style=\'color:#\'>', '</span>', -1, 5, 0, 120, 0, 0, '50:150:150', 0, 1, 0, 1, 0, 1, 1, 30, 0, -1, 1000, '1:::::', 0, 31260672, 10, 0, 0, 0, 0, 0, -1, -1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, '{"limit_sim":0,"daily_bw":0,"weekly_bw":0,"monthly_bw":0,"daily_dl":0,"weekly_dl":0,"monthly_dl":0,"min_posts":0}', 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 0, 1, 0, 0, 1, 0, 1, 0, 25, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, '0', '0', '1', 'public,open,closed,private', '*', 0, 0, 1, 0, 1, 1, NULL, 1, 0, -1, 3, 1, 0 ) IPS\Db\Exception: Unknown column 'jobs_group_id' in 'field list' (1054) #0 /home/pathlabt/public_html/forum/system/Db/Db.php(938): IPS\_Db->preparedQuery('/*pathlabt_pltd...', Array) #1 /home/pathlabt/public_html/forum/system/Patterns/ActiveRecord.php(487): IPS\_Db->insert('core_groups', Array) #2 /home/pathlabt/public_html/forum/system/Patterns/ActiveRecord.php(438): IPS\Patterns\_ActiveRecord->save() #3 /home/pathlabt/public_html/forum/system/Member/Group.php(200): IPS\Patterns\_ActiveRecord->__clone() #4 /home/pathlabt/public_html/forum/applications/core/modules/admin/members/groups.php(416): IPS\Member\_Group->__clone() #5 /home/pathlabt/public_html/forum/system/Dispatcher/Controller.php(90): IPS\core\modules\admin\members\_groups->copy() #6 /home/pathlabt/public_html/forum/applications/core/modules/admin/members/groups.php(39): IPS\Dispatcher\_Controller->execute() #7 /home/pathlabt/public_html/forum/system/Dispatcher/Dispatcher.php(153): IPS\core\modules\admin\members\_groups->execute() #8 /home/pathlabt/public_html/forum/admin/index.php(13): IPS\_Dispatcher->run() #9 {main} System Log Error INSERT INTO `IPS_core_groups` ( `g_id`, `g_view_board`, `g_mem_info`, `g_other_topics`, `g_use_search`, `g_edit_profile`, `g_post_new_topics`, `g_reply_own_topics`, `g_reply_other_topics`, `g_edit_posts`, `g_delete_own_posts`, `g_open_close_posts`, `g_delete_own_topics`, `g_post_polls`, `g_vote_polls`, `g_use_pm`, `g_append_edit`, `g_access_offline`, `g_avoid_q`, `g_avoid_flood`, `g_icon`, `g_attach_max`, `prefix`, `suffix`, `g_max_messages`, `g_max_mass_pm`, `g_search_flood`, `g_edit_cutoff`, `g_hide_from_list`, `g_post_closed`, `g_photo_max_vars`, `g_dohtml`, `g_edit_topic`, `g_bypass_badwords`, `g_can_msg_attach`, `g_attach_per_post`, `g_topic_rate_setting`, `g_dname_changes`, `g_dname_date`, `g_mod_preview`, `g_rep_max_positive`, `g_rep_max_negative`, `g_signature_limits`, `g_hide_online_list`, `g_bitoptions`, `g_pm_perday`, `g_mod_post_unit`, `g_ppd_limit`, `g_ppd_unit`, `g_displayname_unit`, `g_sig_unit`, `g_pm_flood_mins`, `g_max_bgimg_upload`, `g_blog_attach_max`, `g_blog_attach_per_entry`, `g_blog_do_html`, `g_blog_do_commenthtml`, `g_blog_allowpoll`, `g_blog_allowprivate`, `g_blog_allowprivclub`, `g_blog_alloweditors`, `g_blog_allowskinchoose`, `g_blog_preventpublish`, `idm_restrictions`, `idm_bypass_paid`, `idm_add_paid`, `idm_view_downloads`, `idm_report_files`, `idm_bypass_revision`, `idm_throttling`, `idm_wait_period`, `g_max_diskspace`, `g_max_upload`, `g_max_transfer`, `g_max_views`, `g_create_albums`, `g_create_albums_private`, `g_create_albums_fo`, `g_album_limit`, `g_img_album_limit`, `g_edit_own`, `g_del_own`, `g_img_local`, `g_movies`, `g_movie_size`, `g_gallery_use`, `g_blog_allowlocal`, `g_blog_maxblogs`, `g_blog_allowownmod`, `g_blog_allowdelete`, `g_blog_allowcomment`, `idm_view_approvers`, `idm_bulk_submit`, `idm_linked_files`, `idm_import_files`, `idm_block_submissions`, `g_bitoptions2`, `g_upload_animated_photos`, `g_view_displaynamehistory`, `g_hide_own_posts`, `g_lock_unlock_own`, `g_can_report`, `g_create_clubs`, `g_club_allowed_nodes`, `g_close_polls`, `g_promote_exclude`, `g_question_access`, `g_question_contentcount`, `can_create_bookmarks`, `can_create_private_bookmarks`, `g_club_limit`, `g_download_original`, `idm_paid_restrictions`, `idm_max_size`, `jobs_group_id`, `jobs_access`, `jobs_dontpay` ) VALUES ( NULL, 1, 1, 1, 1, 1, 1, 1, 1, '1', '0', 0, 0, 1, 1, 1, 0, 0, 0, 0, NULL, -1, '<span style=\'color:#\'>', '</span>', -1, 5, 0, 120, 0, 0, '50:150:150', 0, 1, 0, 1, 0, 1, 1, 30, 0, -1, 1000, '1:::::', 0, 31260672, 10, 0, 0, 0, 0, 0, -1, -1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, '{"limit_sim":0,"daily_bw":0,"weekly_bw":0,"monthly_bw":0,"daily_dl":0,"weekly_dl":0,"monthly_dl":0,"min_posts":0}', 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 0, 1, 0, 0, 1, 0, 1, 0, 25, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, '0', '0', '1', 'public,open,closed,private', '*', 0, 0, 1, 0, 1, 1, NULL, 1, 0, -1, 3, 1, 0 ) IPS\Db\Exception: Unknown column 'jobs_group_id' in 'field list' (1054) #0 /home/pathlabt/public_html/forum/system/Db/Db.php(938): IPS\_Db->preparedQuery('/*pathlabt_pltd...', Array) #1 /home/pathlabt/public_html/forum/system/Patterns/ActiveRecord.php(487): IPS\_Db->insert('core_groups', Array) #2 /home/pathlabt/public_html/forum/system/Patterns/ActiveRecord.php(438): IPS\Patterns\_ActiveRecord->save() #3 /home/pathlabt/public_html/forum/system/Member/Group.php(200): IPS\Patterns\_ActiveRecord->__clone() #4 /home/pathlabt/public_html/forum/applications/core/modules/admin/members/groups.php(416): IPS\Member\_Group->__clone() #5 /home/pathlabt/public_html/forum/system/Dispatcher/Controller.php(90): IPS\core\modules\admin\members\_groups->copy() #6 /home/pathlabt/public_html/forum/applications/core/modules/admin/members/groups.php(39): IPS\Dispatcher\_Controller->execute() #7 /home/pathlabt/public_html/forum/system/Dispatcher/Dispatcher.php(153): IPS\core\modules\admin\members\_groups->execute() #8 /home/pathlabt/public_html/forum/admin/index.php(13): IPS\_Dispatcher->run() #9 {main} BACKTRACE #0 /home/pathlabt/public_html/forum/init.php(1015): IPS\_Log::log('INSERT INTO `IP...', 'uncaught_except...') #1 [internal function]: IPS\IPS::exceptionHandler(Object(IPS\Db\Exception)) #2 {main}
Solution Adriano Faria Posted March 8, 2022 Solution Posted March 8, 2022 Something related to Jobs. Post in my board so I can take a look. 👍
Daniel F Posted March 8, 2022 Posted March 8, 2022 Sounds like an issue with a 3rd party app called "jobs" Square Wheels 1
Square Wheels Posted March 8, 2022 Author Posted March 8, 2022 5 minutes ago, Adriano Faria said: Something related to Jobs. Post in my board so I can take a look. 👍 Thanks, done. Adriano Faria 1
Recommended Posts