오늘 왜인지는 모르겠으나 사이트의 MYSQL이 뻗어서 호스팅 업체에 복구요청을 했습니다.
양키들이라서 그런지 일처리 장난아니게 늦네요.
무려 5시간 만에 다시 복구는 된듯 합니다만 SQL에 추가하는 부분이 하나도 먹지 않는것 같습니다.
사이트 외견 정상/글읽기/로그인/검색/어드민 사이트 접속 모두 정상.
문제는 댓글남기기/추천하기/조회수변동/회원가입등 데이터에 추가하는 부분들만 작동 안하고 있습니다.
회원가입시에는 아래와 같은 메시지를 보여주고 있습니다.
Prepared statement failed: INSERT INTO `xe_member` (`member_srl`, `user_id`, `email_address`, `password`, `email_id`, `email_host`, `user_name`, `nick_name`, `find_account_question`, `find_account_answer`, `homepage`, `blog`, `birthday`, `allow_mailing`, `allow_message`, `denied`, `regdate`, `change_password_date`, `last_login`, `is_admin`, `extra_vars`, `list_order`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)Operation not allowed when innodb_forced_recovery > 0. Array ( [0] => mysqli_stmt Object ( [affected_rows] => -1 [insert_id] => 0 [num_rows] => 0 [param_count] => 22 [field_count] => 0 [errno] => 1881 [error] => Operation not allowed when innodb_forced_recovery > 0. [error_list] => Array ( [0] => Array ( [errno] => 1881 [sqlstate] => HY000 [error] => Operation not allowed when innodb_forced_recovery > 0. ) ) [sqlstate] => HY000 [id] => 11 ) [1] => isssssssissssssssssssi [2] => 0 [3] => t0 [4] => [email protected] [5] => sha256:0008192:Hw9z9ZUByRVc:e00cMX3tEZyele9zKpA+T4+wf0MlHGy+ [6] => asd22 [7] => asd.asd [8] => 0 [9] => asdasd [10] => 2 [11] => asdasd [12] => [13] => [14] => 0 [15] => N [16] => Y [17] => N [18] => 20161121090747 [19] => 20161121090747 [20] => 20161121090747 [21] => N [22] => O:8:"stdClass":3:{s:15:"xe_validator_id";s:20:"modules/member/skins";s:18:"success_return_url";s:56:"https://제웹사이트주소입니다/index.php?mid=main&act=dispMemberInfo";s:21:"__profile_image_exist";s:5:"false";} [23] => 0
글쓰기와 추천시에는 아래와 같은 오류를 보여주고 있습니다.
상황이라면 제가 할 수 있는 부분이 어떤 것일까요? ㅠㅠ
XE를 재설치 해야 되는지요? 아니면 호스팅 업체에 무엇을 요청해야 할까요?
답변 주시면 정말정말 큰도움이 될 것 같습니다.
부탁드리겠습니다, 고맙습니다.
PS - 참고로 MySQL 부분 조사를 해 보니깐 전부 정상으로 상태출력은 되고 있습니다.
[WEBSITExe_action_forward] status: OK
[WEBSITExe_addons] status: OK
[WEBSITExe_addons_site] status: OK
[WEBSITExe_admin_favorite] status: OK
[WEBSITExe_admin_log] status: OK
[WEBSITExe_ai_installed_packages] status: OK
[WEBSITExe_ai_remote_categories] status: OK
[WEBSITExe_autoinstall_packages] status: OK
[WEBSITExe_comment_declared] status: OK
[WEBSITExe_comment_declared_log] status: OK
[WEBSITExe_comment_voted_log] status: OK
[WEBSITExe_comments] status: OK
[WEBSITExe_comments_list] status: OK
[WEBSITExe_counter_log] status: OK
[WEBSITExe_counter_site_status] status: OK
[WEBSITExe_counter_status] status: OK
[WEBSITExe_document_aliases] status: OK
[WEBSITExe_document_categories] status: OK
[WEBSITExe_document_declared] status: OK
[WEBSITExe_document_declared_log] status: OK
[WEBSITExe_document_extra_keys] status: OK
[WEBSITExe_document_extra_vars] status: OK
[WEBSITExe_document_histories] status: OK
[WEBSITExe_document_readed_log] status: OK
[WEBSITExe_document_trash] status: OK
[WEBSITExe_document_voted_log] status: OK
[WEBSITExe_documents] status: OK
[WEBSITExe_editor_autosave] status: OK
[WEBSITExe_editor_components] status: OK
[WEBSITExe_editor_components_site] status: OK
[WEBSITExe_files] status: OK
[WEBSITExe_lang] status: OK
[WEBSITExe_layouts] status: OK
[WEBSITExe_member] status: OK
[WEBSITExe_member_auth_mail] status: OK
[WEBSITExe_member_autologin] status: OK
[WEBSITExe_member_count_history] status: OK
[WEBSITExe_member_denied_nick_name] status: OK
[WEBSITExe_member_denied_user_id] status: OK
[WEBSITExe_member_friend] status: OK
[WEBSITExe_member_friend_group] status: OK
[WEBSITExe_member_group] status: OK
[WEBSITExe_member_group_member] status: OK
[WEBSITExe_member_join_form] status: OK
[WEBSITExe_member_login_count] status: OK
[WEBSITExe_member_message] status: OK
[WEBSITExe_member_scrap] status: OK
[WEBSITExe_menu] status: OK
[WEBSITExe_menu_item] status: OK
[WEBSITExe_menu_layout] status: OK
[WEBSITExe_module_admins] status: OK
[WEBSITExe_module_categories] status: OK
[WEBSITExe_module_config] status: OK
[WEBSITExe_module_extend] status: OK
[WEBSITExe_module_extra_vars] status: OK
[WEBSITExe_module_filebox] status: OK
[WEBSITExe_module_grants] status: OK
[WEBSITExe_module_locks] status: OK
[WEBSITExe_module_mobile_skins] status: OK
[WEBSITExe_module_part_config] status: OK
[WEBSITExe_module_skins] status: OK
[WEBSITExe_module_trigger] status: OK
[WEBSITExe_modules] status: OK
[WEBSITExe_point] status: OK
[WEBSITExe_poll] status: OK
[WEBSITExe_poll_item] status: OK
[WEBSITExe_poll_log] status: OK
[WEBSITExe_poll_title] status: OK
[WEBSITExe_sequence] status: OK
[WEBSITExe_session] status: OK
[WEBSITExe_site_admin] status: OK
[WEBSITExe_sites] status: OK
[WEBSITExe_socialxe] status: OK
[WEBSITExe_socialxe_log] status: OK
[WEBSITExe_socialxe_user] status: OK
[WEBSITExe_spamfilter_denied_ip] status: OK
[WEBSITExe_spamfilter_denied_word] status: OK
[WEBSITExe_spamfilter_log] status: OK
[WEBSITExe_syndication_except_modules] status: OK
[WEBSITExe_syndication_logs] status: OK
[WEBSITExe_tags] status: OK
[WEBSITExe_trash] status: OK
innodb_force_recovery = 1이 보이면
#innodb_force_recovery = 1로 바꿔보세요.