Duplicate key preventing updates

soaringeagle
@soaringeagle
3 years ago
3,304 posts
Cant run update on any site withnthis error
I know mysql goes away but its cause of a duplicate keyninsertion


(2021-11-20T00:54:39+00:00.0.46234100 : 105.442)-(mem: 24.4MB)-(pid: 10698)-(ip: 104.28.78.126)-(sid: mnmbjlq9phh0s6fthqhrmmjof4)-(user: pete golden)-(url: https://www.freedomswings.org/marketplace/update_item/module/jrCore/id=32/__ajax=1) |jrCore_db_query: /* fwi_freedom:1637369679:pete golden:104.28.78.126:/marketplace/update_item/module/jrCore/id=32/__ajax=1 */ INSERT INTO jr_jruser_session (session_id,session_updated,session_user_id,session_user_name,session_user_group,session_profile_id,session_quota_id,session_user_ip,session_data) VALUES ('mnmbjlq9phh0s6fthqhrmmjof4',UNIX_TIMESTAMP(),'1','pete golden','master','1','5','104.28.78.126','_item_id|i:1;_created|s:10:\"1473997078\";_profile_id|i:1;_updated|s:10:\"1637369129\";_user_id|i:1;profile_active|s:1:\"1\";profile_bg_image_extension|s:3:\"jpg\";profile_bg_image_name|s:22:\"194_1spread_eagle_.jpg\";profile_bg_image_size|s:6:\"345494\";profile_bg_image_time|s:10:\"1481042148\";profile_bg_image_type|s:10:\"image/jpeg\";profile_bg_tile|s:3:\"off\";profile_bio|s:0:\"\";profile_disk_usage|s:9:\"290598152\";profile_humancheck|s:0:\"\";profile_id|s:1:\"1\";profile_image_extension|s:3:\"jpg\";profile_image_height|s:4:\"3456\";profile_image_name|s:20:\"DSCN3418 (1).JPG.jpg\";profile_image_size|s:7:\"6264662\";profile_image_time|s:10:\"1477709526\";profile_image_type|s:10:\"image/jpeg\";profile_image_width|s:4:\"4608\";profile_index_page|s:1:\"0\";profile_jrAction_item_count|s:3:\"604\";profile_jrBlog_item_count|s:1:\"2\";profile_jrComment_item_count|s:2:\"54\";profile_jrCustomForm_item_count|s:1:\"1\";profile_jrEmailCourse_item_count|s:1:\"2\";profile_jrEvent_item_count|s:2:\"30\";profile_jrFile_item_count|s:1:\"5\";profile_jrFollower_approve|s:3:\"off\";profile_jrFollower_item_count|s:1:\"2\";profile_jrForum_item_count|s:2:\"16\";profile_jrGallery_item_count|s:2:\"28\";profile_jrImage_item_count|s:1:\"1\";profile_jrLike_dislike_home_item_count|s:2:\"30\";profile_jrLike_like_home_item_count|s:2:\"48\";profile_jrNewsLetter_item_count|s:1:\"1\";profile_jrPage_item_count|s:1:\"1\";profile_jrRating_home_item_count|s:2:\"27\";profile_jrRating_item_count|s:2:\"31\";profile_jrSubscribe_item_count|s:1:\"1\";profile_jrTags_item_count|s:2:\"56\";profile_jrUpimg_item_count|s:2:\"94\";profile_jrUrlScan_item_count|s:1:\"3\";profile_jrVimeo_item_count|s:1:\"4\";profile_jrYouTube_item_count|s:3:\"235\";profile_name|s:11:\"pete golden\";profile_private|s:1:\"1\";profile_quota_change_date|s:0:\"\";profile_quota_change_id|s:1:\"0\";profile_quota_id|s:1:\"5\";profile_url|s:12:\"soaringeagle\";profile_view_count|s:6:\"139359\";profile_why|s:0:\"\";quota_jrAction_allowed|s:2:\"on\";quota_jrAction_can_post|s:2:\"on\";quota_jrAction_pending|s:1:\"0\";quota_jrAction_show_add|s:2:\"on\";quota_jrAction_show_detail|s:2:\"on\";quota_jrAkismet_allowed|s:2:\"on\";quota_jrAudio_allowed|s:2:\"on\";quota_jrAudio_allowed_audio_types|s:32:\"aac,aif,flac,m4a,mp3,ogg,wav,wma\";quota_jrAudio_audio_conversions|s:2:\"on\";quota_jrAudio_audio_tag|s:2:\"on\";quota_jrAudio_conversion_bitrate|s:3:\"320\";quota_jrAudio_max_items|s:1:\"0\";quota_jrAudio_pending|s:1:\"0\";quota_jrBlog_allowed|s:2:\"on\";quota_jrBlog_max_items|s:1:\"0\";quota_jrBlog_pending|s:1:\"0\";quota_jrCharts_allowed|s:2:\"on\";quota_jrChat_allowed|s:2:\"on\";quota_jrChat_create_chats|s:2:\"on\";quota_jrChat_create_emails|s:3:\"off\";quota_jrChat_create_rooms|s:2:\"on\";quota_jrChat_file_types|s:41:\"png,jpg,jpeg,jfif,gif,zip,mp4,mp3,doc,txt\";quota_jrChat_followers_only|s:2:\"on\";quota_jrChat_max_size|s:8:\"67108864\";quota_jrCombinedVideo_allowed|s:2:\"on\";quota_jrComment_allowed|s:2:\"on\";quota_jrComment_allowed_file_types|s:28:\"png,jpg,jpeg,gif,txt,zip,pdf\";quota_jrComment_attachments|s:2:\"on\";quota_jrComment_pending|s:1:\"0\";quota_jrComment_profile_delete|s:3:\"off\";quota_jrComment_show_detail|s:2:\"on\";quota_jrCore_active_formatters|s:226:\"jrCore_format_string_bbcode,jrCore_format_string_allowed_html,jrCore_format_string_convert_at_tags,jrUrlScan_format_string,jrSmiley_format_string_smiley,jrEmbed_format_string_embed_tags,jrAction_format_string_convert_hash_tags\";quota_jrCore_allow_all_html|s:2:\"on\";quota_jrCore_allowed_tags|s:92:\"span,strong,em,a,b,u,i,p,div,br,img,h1,h2,h3,h4,pre,hr,ul,ol,li,sub,sup,table,tbody,th,tr,td\";quota_jrCore_disk|s:1:\"0\";quota_jrCore_max_upload_size|s:8:\"13631488\";quota_jrDisqus_allowed|s:2:\"on\";quota_jrDisqus_show_detail|s:2:\"on\";quota_jrEmbed_allowed|s:2:\"on\";quota_jrEvent_allowed|s:2:\"on\";quota_jrEvent_allowed_attending|s:2:\"on\";quota_jrEvent_allowed_recurring|s:3:\"off\";quota_jrEvent_max_items|s:1:\"0\";quota_jrEvent_pending|s:1:\"0\";quota_jrFile_allowed|s:2:\"on\";quota_jrFile_allowed_file_types|s:19:\"zip,doc,txt,pdf,rar\";quota_jrFile_max_items|s:1:\"0\";quota_jrFile_pending|s:1:\"2\";quota_jrFollower_share_type|s:0:\"\";quota_jrForum_allowed|s:2:\"on\";quota_jrForum_bbcode_signature|s:2:\"on\";quota_jrForum_can_post|s:2:\"on\";quota_jrForum_file_attachments|s:2:\"on\";quota_jrForum_signature|s:2:\"on\";quota_jrFoxyCart_active|s:3:\"off\";quota_jrFoxyCart_allowed|s:3:\"off\";quota_jrFoxyCart_expire_quota|s:1:\"1\";quota_jrFoxyCart_payout_percent|s:3:\"100\";quota_jrFoxyCart_show_my_files|s:2:\"on\";quota_jrFoxyCart_show_sb|s:2:\"on\";quota_jrFoxyCart_subscription_allow|s:3:\"off\";quota_jrFoxyCart_subscription_desc|s:0:\"\";quota_jrFoxyCart_subscription_length|s:2:\"1m\";quota_jrFoxyCart_subscription_price|s:4:\"0.00\";quota_jrFoxyCart_subscription_trial|s:1:\"0\";quota_jrGallery_allowed|s:2:\"on\";quota_jrGallery_gallery_group|s:2:\"on\";quota_jrGallery_gallery_order|s:2:\"on\";quota_jrGallery_max_items|s:1:\"0\";quota_jrGallery_pending|s:1:\"0\";quota_jrImage_allowed_image_types|s:16:\"png,gif,jpg,jpeg\";quota_jrImage_max_image_size|s:8:\"10485760\";quota_jrImage_watermark|s:3:\"off\";quota_jrImage_watermark_cutoff|s:2:\"80\";quota_jrImage_watermark_sale_only|s:3:\"off\";quota_jrImage_watermark_x_offset|s:2:\"-5\";quota_jrImage_watermark_y_offset|s:2:\"-5\";quota_jrInvite_allowed|s:3:\"off\";quota_jrInvite_invitee_type|s:1:\"1\";quota_jrInvite_max_items|s:1:\"0\";quota_jrInvite_pending|s:1:\"0\";quota_jrLandingPage_allowed|s:3:\"off\";quota_jrLike_allow_self_likings|s:2:\"on\";quota_jrLike_allowed|s:2:\"on\";quota_jrLike_show_detail|s:2:\"on\";quota_jrPage_allowed|s:2:\"on\";quota_jrPage_max_items|s:1:\"0\";quota_jrPage_pending|s:1:\"0\";quota_jrPayment_allowed|s:3:\"off\";quota_jrPayment_include_shipping|s:2:\"on\";quota_jrPayment_include_tax|s:2:\"on\";quota_jrPayment_payout_percent|s:3:\"100\";quota_jrPayment_show_purchases|s:2:\"on\";quota_jrPhotoAlbum_allowed|s:2:\"on\";quota_jrPhotoAlbum_max_items|s:1:\"0\";quota_jrPhotoAlbum_pending|s:1:\"0\";quota_jrPlaylist_allowed|s:2:\"on\";quota_jrPlaylist_max_items|s:1:\"0\";quota_jrPlaylist_pending|s:1:\"0\";quota_jrPoll_allowed|s:2:\"on\";quota_jrPoll_max_items|s:1:\"0\";quota_jrPoll_pending|s:1:\"0\";quota_jrPoll_voter|s:2:\"on\";quota_jrPrivateNote_allowed|s:2:\"on\";quota_jrPrivateNote_followers_only|s:2:\"on\";quota_jrProfile_admin_note|s:0:\"\";quota_jrProfile_cap_type|s:4:\"hard\";quota_jrProfile_default_privacy|s:1:\"1\";quota_jrProfile_name|s:8:\"students\";quota_jrProfile_privacy_changes|s:2:\"on\";quota_jrProfile_profile_count|s:1:\"9\";quota_jrProfile_url_changes|s:3:\"off\";quota_jrProfileTweaks_allow_background_image|s:2:\"on\";quota_jrProfileTweaks_allow_index_redirect|s:2:\"on\";quota_jrProfileTweaks_allow_logo|s:2:\"on\";quota_jrProfileTweaks_allow_skin|s:8:\"jrNingja\";quota_jrProfileTweaks_allowed|s:2:\"on\";quota_jrProfileTweaks_default_index|s:1:\"0\";quota_jrProfileTweaks_default_skin|s:8:\"jrNingja\";quota_jrRating_allow_self_ratings|s:2:\"on\";quota_jrRating_allowed|s:2:\"on\";quota_jrShareThis_allowed|s:2:\"on\";quota_jrShareThis_show_detail|s:2:\"on\";quota_jrShareThis_show_reaction|s:3:\"off\";quota_jrSmiley_allowed|s:2:\"on\";quota_jrSmiley_show_selector|s:3:\"off\";quota_jrSoundCloud_allowed|s:2:\"on\";quota_jrSoundCloud_max_items|s:1:\"0\";quota_jrSoundCloud_pending|s:1:\"0\";quota_jrTags_allowed|s:2:\"on\";quota_jrTags_own_items_only|s:3:\"off\";quota_jrTags_show_detail|s:2:\"on\";quota_jrTOS_show_tos|s:1:\"0\";quota_jrUpimg_allowed|s:2:\"on\";quota_jrUser_add_to_timeline|s:2:\"on\";quota_jrUser_allow_signups|s:3:\"off\";quota_jrUser_device_notice|s:2:\"on\";quota_jrUser_login_page|s:7:\"profile\";quota_jrUser_power_user|s:3:\"off\";quota_jrUser_power_user_max|s:1:\"2\";quota_jrUser_power_user_quotas|s:1:\"0\";quota_jrUser_signup_method|s:5:\"admin\";quota_jrUser_signup_page|s:7:\"profile\";quota_jrVideo_allowed|s:2:\"on\";quota_jrVideo_allowed_video_types|s:52:\"3g2,3gp,avi,f4v,flv,m4v,mkv,mov,mp4,mpg,ogv,webm,wmv\";quota_jrVideo_max_items|s:1:\"0\";quota_jrVideo_pending|s:1:\"0\";quota_jrVideo_video_conversions|s:2:\"on\";quota_jrVimeo_allowed|s:2:\"on\";quota_jrVimeo_max_items|s:1:\"0\";quota_jrVimeo_pending|s:1:\"0\";quota_jrYouTube_allowed|s:2:\"on\";quota_jrYouTube_channel_sync|s:2:\"on\";quota_jrYouTube_max_items|s:1:\"0\";quota_jrYouTube_pending|s:1:\"0\";quota_jrYouTube_youtube_search|s:2:\"on\";profile_jrCombinedVideo_item_count|i:239;user_active|s:1:\"1\";user_active_room_id|i:1;user_campaign_total_sent|s:1:\"1\";user_chat_message_sound|s:2:\"on\";user_chat_notifications|s:2:\"on\";user_chat_online_status|s:4:\"auto\";user_chat_state|s:6:\"closed\";user_chat_width|s:3:\"310\";user_email|s:26:\"iriesoaringeagle@gmail.com\";user_group|s:6:\"master\";user_image_extension|s:3:\"jpg\";user_image_height|s:4:\"3456\";user_image_name|s:14:\"user_image.jpg\";user_image_size|s:7:\"6264662\";user_image_time|s:10:\"1477709526\";user_image_type|s:10:\"image/jpeg\";user_image_width|s:4:\"4608\";user_jrAction_item_count|s:3:\"621\";user_jrBlog_item_count|s:1:\"2\";user_jrComment_item_count|s:2:\"54\";user_jrCustomForm_item_count|s:1:\"1\";user_jrEmailCourse_item_count|s:1:\"2\";user_jrEvent_item_count|s:2:\"30\";user_jrFile_item_count|s:1:\"5\";user_jrFollower_share|s:2:\"on\";user_jrForum_item_count|s:2:\"16\";user_jrForum_settings|s:277:\"{\"enable_signature\":\"on\",\"signature\":\"soaringeagle\\r\\nhead dreadhead at [url=http:\\/\\/www.dreadlockssite.com]dreadlocks site[\\/url]\\r\\nglider pilot student with [url=http:\\/\\/www.freedomswings.org]freedoms wings international soaring for people with disabilities [\\/url] \\r\\n\"}\";user_jrGallery_item_count|s:4:\"3051\";user_jrGoogleAnalytics_cid|s:36:\"a249fa69-cc01-4ca0-84f4-7dd3d7296d3f\";user_jrImage_item_count|s:1:\"3\";user_jrLike_like_count|s:2:\"28\";user_jrNewsLetter_item_count|s:1:\"1\";user_jrPage_item_count|s:1:\"1\";user_jrRating_item_count|s:2:\"31\";user_jrSmiley_item_count|s:1:\"8\";user_jrSubscribe_item_count|s:1:\"1\";user_jrTags_item_count|s:2:\"66\";user_jrTips_enabled|s:3:\"off\";user_jrUpimg_item_count|s:3:\"125\";user_jrUrlScan_item_count|s:1:\"7\";user_jrVimeo_item_count|s:1:\"4\";user_jrYouTube_item_count|s:3:\"303\";user_language|s:5:\"en-US\";user_last_login|s:10:\"1637368909\";user_name|s:11:\"pete golden\";user_password|s:60:\"$2a$12$zjo.JN3EmWXwBz6gRQepAua2nasidVKb3Mncrl9VSJ2Dbjzrz/5ti\";user_validate|s:32:\"72d46366479db5a5d3a3e7346bc4f847\";user_validated|s:1:\"1\";user_why|s:0:\"\";user_linked_profile_ids|s:5:\"1,3,4\";profile_created|s:10:\"1473997078\";profile_updated|s:10:\"1637369129\";user_active_profile_id|i:1;is_logged_in|s:3:\"yes\";JRMARKET_RELEASE_SYSTEM|s:225:\"{\"system_id\":\"1\",\"system_name\":\"Jamroom Network\",\"system_url\":\"http:\\/\\/www.jamroom.net\",\"system_email\":\"iriesoaringeagle@gmail.com\",\"system_code\":\"da3d540859188e1f1c35acc86b5b8482\",\"system_active\":\"on\",\"system_default\":\"on\"}\";search_token|s:32:\"0afbd5fb073b67caffea4b3925e778de\";session_updated|i:1637369571;jrcore_url_history|a:5:{s:50:\"https://www.freedomswings.org/core/integrity_check\";s:46:\"https://www.freedomswings.org/core/admin/tools\";s:46:\"https://www.freedomswings.org/redis/admin/info\";s:50:\"https://www.freedomswings.org/core/search/ss=Redis\";s:48:\"https://www.freedomswings.org/redis/admin/global\";s:46:\"https://www.freedomswings.org/redis/admin/info\";s:49:\"https://www.freedomswings.org/redis/server_browse\";s:48:\"https://www.freedomswings.org/redis/admin/global\";s:54:\"https://www.freedomswings.org/redis/server_update/id=1\";s:49:\"https://www.freedomswings.org/redis/server_browse\";}jrcore_form_notice_last_token|s:32:\"9e78be95fb3ede3c318c38b60d6f5cc9\";') ON DUPLICATE KEY UPDATE session_updated = UNIX_TIMESTAMP(),session_user_id = '1',session_user_name = 'pete golden',session_user_group = 'master', session_profile_id = '1',session_quota_id = '5',session_user_ip = '104.28.78.126',session_sync = 0,session_data = VALUES(session_data)|  (2021-11-20T00:54:39+00:00.0.46234100 : 105.442)-(mem: 24.4MB)-(pid: 10698)-(ip: 104.28.78.126)-(sid: mnmbjlq9phh0s6fthqhrmmjof4)-(user: pete golden)-(url: https://www.freedomswings.org/marketplace/update_item/module/jrCore/id=32/__ajax=1) mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.12-dev - 20150407 - $Id: 3591daad22de08524295e1bd073aceeff11e6579 $ [client_version] => 50012 [connect_errno] => 0 [connect_error] =>  [errno] => 2006 [error] => MySQL server has gone away [error_list] => Array ( [0] => Array ( [errno] => 2006 [sqlstate] => HY000 [error] => MySQL server has gone away )  )  [field_count] => 17 [host_info] => Localhost via UNIX socket [info] =>  [insert_id] => 0 [server_info] => 5.5.5-10.1.48-MariaDB [server_version] => 100148 [stat] =>  [sqlstate] => HY000 [protocol_version] => 10 [thread_id] => 25718033 [warning_count] => 0 )




--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities

updated by @soaringeagle: 02/19/22 01:45:09PM
soaringeagle
@soaringeagle
3 years ago
3,304 posts
  (2021-11-20T00:54:39+00:00.0.46234100 : 105.442)-(mem: 24.4MB)-(pid: 10698)-(ip: 104.28.78.126)-(sid: mnmbjlq9phh0s6fthqhrmmjof4)-(user: pete golden)-(url: https://www.freedomswings.org/marketplace/update_item/module/jrCore/id=32/__ajax=1) |jrCore_db_query: /* fwi_freedom:1637369679:pete golden:104.28.78.126:/marketplace/update_item/module/jrCore/id=32/__ajax=1 */ INSERT INTO jr_jruser_session (session_id,session_updated,session_user_id,session_user_name,session_user_group,session_profile_id,session_quota_id,session_user_ip,session_data) VALUES ('mnmbjlq9phh0s6fthqhrmmjof4',UNIX_TIMESTAMP(),'1','pete golden','master','1','5','104.28.78.126','_item_id|i:1;_created|s:10:\"1473997078\";_profile_id|i:1;_updated|s:10:\"1637369129\";_user_id|i:1;profile_active|s:1:\"1\";profile_bg_image_extension|s:3:\"jpg\";profile_bg_image_name|s:22:\"194_1spread_eagle_.jpg\";profile_bg_image_size|s:6:\"345494\";profile_bg_image_time|s:10:\"1481042148\";profile_bg_image_type|s:10:\"image/jpeg\";profile_bg_tile|s:3:\"off\";profile_bio|s:0:\"\";profile_disk_usage|s:9:\"290598152\";profile_humancheck|s:0:\"\";profile_id|s:1:\"1\";profile_image_extension|s:3:\"jpg\";profile_image_height|s:4:\"3456\";profile_image_name|s:20:\"DSCN3418 (1).JPG.jpg\";profile_image_size|s:7:\"6264662\";profile_image_time|s:10:\"1477709526\";profile_image_type|s:10:\"image/jpeg\";profile_image_width|s:4:\"4608\";profile_index_page|s:1:\"0\";profile_jrAction_item_count|s:3:\"604\";profile_jrBlog_item_count|s:1:\"2\";profile_jrComment_item_count|s:2:\"54\";profile_jrCustomForm_item_count|s:1:\"1\";profile_jrEmailCourse_item_count|s:1:\"2\";profile_jrEvent_item_count|s:2:\"30\";profile_jrFile_item_count|s:1:\"5\";profile_jrFollower_approve|s:3:\"off\";profile_jrFollower_item_count|s:1:\"2\";profile_jrForum_item_count|s:2:\"16\";profile_jrGallery_item_count|s:2:\"28\";profile_jrImage_item_count|s:1:\"1\";profile_jrLike_dislike_home_item_count|s:2:\"30\";profile_jrLike_like_home_item_count|s:2:\"48\";profile_jrNewsLetter_item_count|s:1:\"1\";profile_jrPage_item_count|s:1:\"1\";profile_jrRating_home_item_count|s:2:\"27\";profile_jrRating_item_count|s:2:\"31\";profile_jrSubscribe_item_count|s:1:\"1\";profile_jrTags_item_count|s:2:\"56\";profile_jrUpimg_item_count|s:2:\"94\";profile_jrUrlScan_item_count|s:1:\"3\";profile_jrVimeo_item_count|s:1:\"4\";profile_jrYouTube_item_count|s:3:\"235\";profile_name|s:11:\"pete golden\";profile_private|s:1:\"1\";profile_quota_change_date|s:0:\"\";profile_quota_change_id|s:1:\"0\";profile_quota_id|s:1:\"5\";profile_url|s:12:\"soaringeagle\";profile_view_count|s:6:\"139359\";profile_why|s:0:\"\";quota_jrAction_allowed|s:2:\"on\";quota_jrAction_can_post|s:2:\"on\";quota_jrAction_pending|s:1:\"0\";quota_jrAction_show_add|s:2:\"on\";quota_jrAction_show_detail|s:2:\"on\";quota_jrAkismet_allowed|s:2:\"on\";quota_jrAudio_allowed|s:2:\"on\";quota_jrAudio_allowed_audio_types|s:32:\"aac,aif,flac,m4a,mp3,ogg,wav,wma\";quota_jrAudio_audio_conversions|s:2:\"on\";quota_jrAudio_audio_tag|s:2:\"on\";quota_jrAudio_conversion_bitrate|s:3:\"320\";quota_jrAudio_max_items|s:1:\"0\";quota_jrAudio_pending|s:1:\"0\";quota_jrBlog_allowed|s:2:\"on\";quota_jrBlog_max_items|s:1:\"0\";quota_jrBlog_pending|s:1:\"0\";quota_jrCharts_allowed|s:2:\"on\";quota_jrChat_allowed|s:2:\"on\";quota_jrChat_create_chats|s:2:\"on\";quota_jrChat_create_emails|s:3:\"off\";quota_jrChat_create_rooms|s:2:\"on\";quota_jrChat_file_types|s:41:\"png,jpg,jpeg,jfif,gif,zip,mp4,mp3,doc,txt\";quota_jrChat_followers_only|s:2:\"on\";quota_jrChat_max_size|s:8:\"67108864\";quota_jrCombinedVideo_allowed|s:2:\"on\";quota_jrComment_allowed|s:2:\"on\";quota_jrComment_allowed_file_types|s:28:\"png,jpg,jpeg,gif,txt,zip,pdf\";quota_jrComment_attachments|s:2:\"on\";quota_jrComment_pending|s:1:\"0\";quota_jrComment_profile_delete|s:3:\"off\";quota_jrComment_show_detail|s:2:\"on\";quota_jrCore_active_formatters|s:226:\"jrCore_format_string_bbcode,jrCore_format_string_allowed_html,jrCore_format_string_convert_at_tags,jrUrlScan_format_string,jrSmiley_format_string_smiley,jrEmbed_format_string_embed_tags,jrAction_format_string_convert_hash_tags\";quota_jrCore_allow_all_html|s:2:\"on\";quota_jrCore_allowed_tags|s:92:\"span,strong,em,a,b,u,i,p,div,br,img,h1,h2,h3,h4,pre,hr,ul,ol,li,sub,sup,table,tbody,th,tr,td\";quota_jrCore_disk|s:1:\"0\";quota_jrCore_max_upload_size|s:8:\"13631488\";quota_jrDisqus_allowed|s:2:\"on\";quota_jrDisqus_show_detail|s:2:\"on\";quota_jrEmbed_allowed|s:2:\"on\";quota_jrEvent_allowed|s:2:\"on\";quota_jrEvent_allowed_attending|s:2:\"on\";quota_jrEvent_allowed_recurring|s:3:\"off\";quota_jrEvent_max_items|s:1:\"0\";quota_jrEvent_pending|s:1:\"0\";quota_jrFile_allowed|s:2:\"on\";quota_jrFile_allowed_file_types|s:19:\"zip,doc,txt,pdf,rar\";quota_jrFile_max_items|s:1:\"0\";quota_jrFile_pending|s:1:\"2\";quota_jrFollower_share_type|s:0:\"\";quota_jrForum_allowed|s:2:\"on\";quota_jrForum_bbcode_signature|s:2:\"on\";quota_jrForum_can_post|s:2:\"on\";quota_jrForum_file_attachments|s:2:\"on\";quota_jrForum_signature|s:2:\"on\";quota_jrFoxyCart_active|s:3:\"off\";quota_jrFoxyCart_allowed|s:3:\"off\";quota_jrFoxyCart_expire_quota|s:1:\"1\";quota_jrFoxyCart_payout_percent|s:3:\"100\";quota_jrFoxyCart_show_my_files|s:2:\"on\";quota_jrFoxyCart_show_sb|s:2:\"on\";quota_jrFoxyCart_subscription_allow|s:3:\"off\";quota_jrFoxyCart_subscription_desc|s:0:\"\";quota_jrFoxyCart_subscription_length|s:2:\"1m\";quota_jrFoxyCart_subscription_price|s:4:\"0.00\";quota_jrFoxyCart_subscription_trial|s:1:\"0\";quota_jrGallery_allowed|s:2:\"on\";quota_jrGallery_gallery_group|s:2:\"on\";quota_jrGallery_gallery_order|s:2:\"on\";quota_jrGallery_max_items|s:1:\"0\";quota_jrGallery_pending|s:1:\"0\";quota_jrImage_allowed_image_types|s:16:\"png,gif,jpg,jpeg\";quota_jrImage_max_image_size|s:8:\"10485760\";quota_jrImage_watermark|s:3:\"off\";quota_jrImage_watermark_cutoff|s:2:\"80\";quota_jrImage_watermark_sale_only|s:3:\"off\";quota_jrImage_watermark_x_offset|s:2:\"-5\";quota_jrImage_watermark_y_offset|s:2:\"-5\";quota_jrInvite_allowed|s:3:\"off\";quota_jrInvite_invitee_type|s:1:\"1\";quota_jrInvite_max_items|s:1:\"0\";quota_jrInvite_pending|s:1:\"0\";quota_jrLandingPage_allowed|s:3:\"off\";quota_jrLike_allow_self_likings|s:2:\"on\";quota_jrLike_allowed|s:2:\"on\";quota_jrLike_show_detail|s:2:\"on\";quota_jrPage_allowed|s:2:\"on\";quota_jrPage_max_items|s:1:\"0\";quota_jrPage_pending|s:1:\"0\";quota_jrPayment_allowed|s:3:\"off\";quota_jrPayment_include_shipping|s:2:\"on\";quota_jrPayment_include_tax|s:2:\"on\";quota_jrPayment_payout_percent|s:3:\"100\";quota_jrPayment_show_purchases|s:2:\"on\";quota_jrPhotoAlbum_allowed|s:2:\"on\";quota_jrPhotoAlbum_max_items|s:1:\"0\";quota_jrPhotoAlbum_pending|s:1:\"0\";quota_jrPlaylist_allowed|s:2:\"on\";quota_jrPlaylist_max_items|s:1:\"0\";quota_jrPlaylist_pending|s:1:\"0\";quota_jrPoll_allowed|s:2:\"on\";quota_jrPoll_max_items|s:1:\"0\";quota_jrPoll_pending|s:1:\"0\";quota_jrPoll_voter|s:2:\"on\";quota_jrPrivateNote_allowed|s:2:\"on\";quota_jrPrivateNote_followers_only|s:2:\"on\";quota_jrProfile_admin_note|s:0:\"\";quota_jrProfile_cap_type|s:4:\"hard\";quota_jrProfile_default_privacy|s:1:\"1\";quota_jrProfile_name|s:8:\"students\";quota_jrProfile_privacy_changes|s:2:\"on\";quota_jrProfile_profile_count|s:1:\"9\";quota_jrProfile_url_changes|s:3:\"off\";quota_jrProfileTweaks_allow_background_image|s:2:\"on\";quota_jrProfileTweaks_allow_index_redirect|s:2:\"on\";quota_jrProfileTweaks_allow_logo|s:2:\"on\";quota_jrProfileTweaks_allow_skin|s:8:\"jrNingja\";quota_jrProfileTweaks_allowed|s:2:\"on\";quota_jrProfileTweaks_default_index|s:1:\"0\";quota_jrProfileTweaks_default_skin|s:8:\"jrNingja\";quota_jrRating_allow_self_ratings|s:2:\"on\";quota_jrRating_allowed|s:2:\"on\";quota_jrShareThis_allowed|s:2:\"on\";quota_jrShareThis_show_detail|s:2:\"on\";quota_jrShareThis_show_reaction|s:3:\"off\";quota_jrSmiley_allowed|s:2:\"on\";quota_jrSmiley_show_selector|s:3:\"off\";quota_jrSoundCloud_allowed|s:2:\"on\";quota_jrSoundCloud_max_items|s:1:\"0\";quota_jrSoundCloud_pending|s:1:\"0\";quota_jrTags_allowed|s:2:\"on\";quota_jrTags_own_items_only|s:3:\"off\";quota_jrTags_show_detail|s:2:\"on\";quota_jrTOS_show_tos|s:1:\"0\";quota_jrUpimg_allowed|s:2:\"on\";quota_jrUser_add_to_timeline|s:2:\"on\";quota_jrUser_allow_signups|s:3:\"off\";quota_jrUser_device_notice|s:2:\"on\";quota_jrUser_login_page|s:7:\"profile\";quota_jrUser_power_user|s:3:\"off\";quota_jrUser_power_user_max|s:1:\"2\";quota_jrUser_power_user_quotas|s:1:\"0\";quota_jrUser_signup_method|s:5:\"admin\";quota_jrUser_signup_page|s:7:\"profile\";quota_jrVideo_allowed|s:2:\"on\";quota_jrVideo_allowed_video_types|s:52:\"3g2,3gp,avi,f4v,flv,m4v,mkv,mov,mp4,mpg,ogv,webm,wmv\";quota_jrVideo_max_items|s:1:\"0\";quota_jrVideo_pending|s:1:\"0\";quota_jrVideo_video_conversions|s:2:\"on\";quota_jrVimeo_allowed|s:2:\"on\";quota_jrVimeo_max_items|s:1:\"0\";quota_jrVimeo_pending|s:1:\"0\";quota_jrYouTube_allowed|s:2:\"on\";quota_jrYouTube_channel_sync|s:2:\"on\";quota_jrYouTube_max_items|s:1:\"0\";quota_jrYouTube_pending|s:1:\"0\";quota_jrYouTube_youtube_search|s:2:\"on\";profile_jrCombinedVideo_item_count|i:239;user_active|s:1:\"1\";user_active_room_id|i:1;user_campaign_total_sent|s:1:\"1\";user_chat_message_sound|s:2:\"on\";user_chat_notifications|s:2:\"on\";user_chat_online_status|s:4:\"auto\";user_chat_state|s:6:\"closed\";user_chat_width|s:3:\"310\";user_email|s:26:\"iriesoaringeagle@gmail.com\";user_group|s:6:\"master\";user_image_extension|s:3:\"jpg\";user_image_height|s:4:\"3456\";user_image_name|s:14:\"user_image.jpg\";user_image_size|s:7:\"6264662\";user_image_time|s:10:\"1477709526\";user_image_type|s:10:\"image/jpeg\";user_image_width|s:4:\"4608\";user_jrAction_item_count|s:3:\"621\";user_jrBlog_item_count|s:1:\"2\";user_jrComment_item_count|s:2:\"54\";user_jrCustomForm_item_count|s:1:\"1\";user_jrEmailCourse_item_count|s:1:\"2\";user_jrEvent_item_count|s:2:\"30\";user_jrFile_item_count|s:1:\"5\";user_jrFollower_share|s:2:\"on\";user_jrForum_item_count|s:2:\"16\";user_jrForum_settings|s:277:\"{\"enable_signature\":\"on\",\"signature\":\"soaringeagle\\r\\nhead dreadhead at [url=http:\\/\\/www.dreadlockssite.com]dreadlocks site[\\/url]\\r\\nglider pilot student with [url=http:\\/\\/www.freedomswings.org]freedoms wings international soaring for people with disabilities [\\/url] \\r\\n\"}\";user_jrGallery_item_count|s:4:\"3051\";user_jrGoogleAnalytics_cid|s:36:\"a249fa69-cc01-4ca0-84f4-7dd3d7296d3f\";user_jrImage_item_count|s:1:\"3\";user_jrLike_like_count|s:2:\"28\";user_jrNewsLetter_item_count|s:1:\"1\";user_jrPage_item_count|s:1:\"1\";user_jrRating_item_count|s:2:\"31\";user_jrSmiley_item_count|s:1:\"8\";user_jrSubscribe_item_count|s:1:\"1\";user_jrTags_item_count|s:2:\"66\";user_jrTips_enabled|s:3:\"off\";user_jrUpimg_item_count|s:3:\"125\";user_jrUrlScan_item_count|s:1:\"7\";user_jrVimeo_item_count|s:1:\"4\";user_jrYouTube_item_count|s:3:\"303\";user_language|s:5:\"en-US\";user_last_login|s:10:\"1637368909\";user_name|s:11:\"pete golden\";user_password|s:60:\"$2a$12$zjo.JN3EmWXwBz6gRQepAua2nasidVKb3Mncrl9VSJ2Dbjzrz/5ti\";user_validate|s:32:\"72d46366479db5a5d3a3e7346bc4f847\";user_validated|s:1:\"1\";user_why|s:0:\"\";user_linked_profile_ids|s:5:\"1,3,4\";profile_created|s:10:\"1473997078\";profile_updated|s:10:\"1637369129\";user_active_profile_id|i:1;is_logged_in|s:3:\"yes\";JRMARKET_RELEASE_SYSTEM|s:225:\"{\"system_id\":\"1\",\"system_name\":\"Jamroom Network\",\"system_url\":\"http:\\/\\/www.jamroom.net\",\"system_email\":\"iriesoaringeagle@gmail.com\",\"system_code\":\"da3d540859188e1f1c35acc86b5b8482\",\"system_active\":\"on\",\"system_default\":\"on\"}\";search_token|s:32:\"0afbd5fb073b67caffea4b3925e778de\";session_updated|i:1637369571;jrcore_url_history|a:5:{s:50:\"https://www.freedomswings.org/core/integrity_check\";s:46:\"https://www.freedomswings.org/core/admin/tools\";s:46:\"https://www.freedomswings.org/redis/admin/info\";s:50:\"https://www.freedomswings.org/core/search/ss=Redis\";s:48:\"https://www.freedomswings.org/redis/admin/global\";s:46:\"https://www.freedomswings.org/redis/admin/info\";s:49:\"https://www.freedomswings.org/redis/server_browse\";s:48:\"https://www.freedomswings.org/redis/admin/global\";s:54:\"https://www.freedomswings.org/redis/server_update/id=1\";s:49:\"https://www.freedomswings.org/redis/server_browse\";}jrcore_form_notice_last_token|s:32:\"9e78be95fb3ede3c318c38b60d6f5cc9\";') ON DUPLICATE KEY UPDATE session_updated = UNIX_TIMESTAMP(),session_user_id = '1',session_user_name = 'pete golden',session_user_group = 'master', session_profile_id = '1',session_quota_id = '5',session_user_ip = '104.28.78.126',session_sync = 0,session_data = VALUES(session_data)|  (2021-11-20T00:54:39+00:00.0.46234100 : 105.442)-(mem: 24.4MB)-(pid: 10698)-(ip: 104.28.78.126)-(sid: mnmbjlq9phh0s6fthqhrmmjof4)-(user: pete golden)-(url: https://www.freedomswings.org/marketplace/update_item/module/jrCore/id=32/__ajax=1) mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.12-dev - 20150407 - $Id: 3591daad22de08524295e1bd073aceeff11e6579 $ [client_version] => 50012 [connect_errno] => 0 [connect_error] =>  [errno] => 2006 [error] => MySQL server has gone away [error_list] => Array ( [0] => Array ( [errno] => 2006 [sqlstate] => HY000 [error] => MySQL server has gone away )  )  [field_count] => 17 [host_info] => Localhost via UNIX socket [info] =>  [insert_id] => 0 [server_info] => 5.5.5-10.1.48-MariaDB [server_version] => 100148 [stat] =>  [sqlstate] => HY000 [protocol_version] => 10 [thread_id] => 25718033 [warning_count] => 0 )



--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
michael
@michael
3 years ago
7,746 posts
The base query starts with:
INSERT INTO jr_jruser_session (session_id......
That's the active user info for the current session. Try logging out and back in again.

If that fails truncate the jr_jruser_session table. Doing that will force everyone to have to login again but there should not be duplicate sessions.

Tags