dolphin 的mysql意外down机后,database query error解决

Posted On 2013年6月16日

dolphin是一个开源的sns 软件. 最近由于搭建的虚拟机意外crash,导致dolphin也无法启动了. 报如下错误. 让人一头雾水. 莫非mysql 这么脆弱.

Error

Database query error

这样的错误信息太少了, 所以不足以让我们找到病因.

在 inc/classes/BxDolDb.php 这个文件的26行, 不同的版本可能行数不同,找到如下这行内容就行.

define( ‘DB_FULL_DEBUG_MODE’, false );

把false改为true.

define( ‘DB_FULL_DEBUG_MODE’, true );

再刷新一遍页面, 错误就详细多了. 接下来,我们根据具体错误修复即可.

Error

Database query error

Query:
SELECT `l`.`Name` FROM `sys_localization_languages` AS `l` INNER JOIN `Profiles` AS `p` ON (`p`.`LangID` = `l`.`ID`) WHERE `p`.`ID` = 1

Mysql error:
Table ‘./dolphin/Profiles’ is marked as crashed and should be repaired

Found error in the file ‘/work/dolphin/inc/languages.inc.php‘ at line 151.

Called ‘fromMemory‘ function with erroneous argument #2.

Debug backtrace:

Settings:

array (
  'enable_global_couple' => '',
  'votes' => 'on',
  'zodiac' => '',
  'anon_mode' => '',
  'reg_by_inv_only' => '',
  'enable_cmts_profile_delete' => '',
  'member_online_time' => '1',
  'search_start_age' => '18',
  'search_end_age' => '75',
  'friends_per_page' => '14',
  'featured_num' => '8',
  'top_members_max_num' => '8',
  'sys_member_info_name' => 'sys_username',
  'sys_member_info_info' => 'sys_headline',
  'sys_member_info_thumb' => 'sys_avatar',
  'sys_member_info_thumb_icon' => 'sys_avatar_icon',
  'MetaDescription' => 'hebi 交友',
  'MetaKeyWords' => '',
  'enable_tiny_in_comments' => '',
  'sys_make_album_cover_last' => 'on',
  'sys_album_default_name' => 'Hidden',
  'news_enable' => 'on',
  'feeds_enable' => 'on',
  'enable_contact_form' => 'on',
  'default_country' => 'US',
  'boonexAffID' => '',
  'enable_gd' => 'on',
  'useLikeOperator' => 'on',
  'msgs_per_start' => '20',
  'expire_notify_once' => 'on',
  'expire_notification_days' => '1',
  'enable_promotion_membership' => '',
  'promotion_membership_days' => '7',
  'autoApproval_ifJoin' => '',
  'autoApproval_ifProfile' => 'on',
  'autoApproval_ifNoConfEmail' => '',
  'newusernotify' => 'on',
  'sys_album_auto_app' => 'on',
  'site_email' => '[email protected]',
  'site_title' => 'hebi 交友',
  'site_email_notify' => '[email protected]',
  'sys_ps_enable_create_group' => '',
  'sys_ps_enable_default_values' => '',
  'sys_ps_enabled_group_1' => '',
  'sys_ps_enabled_group_2' => 'on',
  'sys_ps_enabled_group_3' => 'on',
  'sys_ps_enabled_group_4' => 'on',
  'sys_ps_enabled_group_5' => 'on',
  'sys_ps_enabled_group_6' => '',
  'sys_ps_enabled_group_7' => '',
  'db_clean_msg' => '365',
  'db_clean_profiles' => '0',
  'db_clean_members_visits' => '90',
  'db_clean_banners_info' => '60',
  'db_clean_vkiss' => '90',
  'db_clean_mem_levels' => '30',
  'enable_match' => '',
  'view_match_percent' => '',
  'match_percent' => '85',
  'template' => 'uni',
  'enable_template' => 'on',
  'nav_menu_elements_on_line_usr' => '16',
  'nav_menu_elements_on_line_gst' => '16',
  'sys_template_page_width_min' => '774',
  'sys_template_page_width_max' => '1600',
  'ext_nav_menu_enabled' => 'on',
  'ext_nav_menu_top_position' => 'bottom',
  'sys_security_impact_threshold_log' => '-1',
  'sys_security_impact_threshold_block' => '-1',
  'sys_security_form_token_enable' => '',
  'sys_security_form_token_lifetime' => '86400',
  'sys_recaptcha_key_public' => '6Lep4eISAAAAAFgIvvwz0LB5I0eY3EN_vRbBXT4U',
  'sys_recaptcha_key_private' => '6Lep4eISAAAAABN1dCzK_29t3HiIpWOGNwo7PGIo',
  'enable_watermark' => '',
  'transparent1' => '0',
  'Water_Mark' => '',
  'lang_default' => 'en',
  'sys_calendar_starts_sunday' => '',
  'time_format_php' => 'H:i',
  'short_date_format_php' => 'd.m.Y',
  'date_format_php' => 'd.m.Y H:i',
  'time_format' => '%H:%i',
  'short_date_format' => '%d.%m.%Y',
  'date_format' => '%d.%m.%Y %H:%i',
  'enable_member_store_ip' => 'on',
  'ipBlacklistMode' => '2',
  'ipListGlobalType' => '0',
  'sys_dnsbl_enable' => 'on',
  'sys_dnsbl_behaviour' => 'approval',
  'sys_uridnsbl_enable' => 'on',
  'sys_akismet_enable' => '',
  'sys_akismet_api_key' => '',
  'sys_stopforumspam_enable' => 'on',
  'sys_stopforumspam_api_key' => '',
  'sys_antispam_block' => '',
  'sys_antispam_report' => 'on',
  'sys_antispam_smart_check' => 'on',
  'sys_antispam_add_nofollow' => 'on',
  'enable_cache_system' => 'on',
  'sys_db_cache_enable' => 'on',
  'sys_db_cache_engine' => 'File',
  'sys_cache_memcache_host' => '',
  'sys_cache_memcache_port' => '11211',
  'sys_pb_cache_enable' => 'on',
  'sys_pb_cache_engine' => 'File',
  'sys_mm_cache_engine' => 'File',
  'sys_template_cache_enable' => 'on',
  'sys_template_cache_engine' => 'FileHtml',
  'sys_template_cache_css_enable' => 'on',
  'sys_template_cache_js_enable' => 'on',
  'sys_template_cache_compress_enable' => 'on',
  'tags_non_parsable' => 'hi, hey, hello, all, i, i\'m, i\'d, am, for, in, to, a, the, on, it\'s, is, my, of, are, from, i\'m, me, you, and, we, not, will, at, where, there',
  'tags_min_rating' => '2',
  'tags_perpage_browse' => '30',
  'tags_show_limit' => '50',
  'enable_modrewrite' => 'on',
  'permalinks_browse' => 'on',
  'categ_perpage_browse' => '30',
  'categ_show_limit' => '50',
  'categ_show_columns' => '3',
  'sys_tmp_version' => '7.1.3',
  'license_code' => '',
  'license_expiration' => '',
  'license_checksum' => '',
  'enable_dolphin_footer' => 'on',
  'sys_ftp_login' => '',
  'sys_ftp_password' => '',
  'sys_ftp_dir' => '',
  'splash_editor' => 'on',
  'splash_code' => '<div class="bx-splash" style="position:relative; height:237px; background-repeat:no-repeat; background-position:0px 0px; background-image:url(templates/base/images/bx_splash_image.jpg)">
    <div class="bx-splash-txt-bg" style="position:absolute; z-index:1; bottom:0px; width:100%; height:96px; background-color:#ffffff; opacity:0.7;">
        <img src="templates/base/images/spacer.gif" />
    </div>
    <div class="bx-splash-txt" style="position:absolute; z-index:2; bottom:0px; width:100%; height:96px;">
        <div class="bx-splash-txt-cnt bx-def-margin" style="position:relative; opacity:1.0;">
            <div class="bx-splash-txt-l1" style="font-size: 36px;">Welcome to the community!</div>
            <div class="bx-splash-txt-l2 bx-def-font-grayed" style="font-size:14px;">This social networking site is powered by <a href="http://www.boonex.com/dolphin">Dolphin Community Software</a> from BoonEx.</div>
            <div class="bx-splash-action bx-def-padding-sec-topbottom" style="position:absolute; top:0px; right:0px;">
                <button class="bx-btn bx-btn-primary" onclick="window.open (\'join.php\',\'_self\');">Join</button>
                <button class="bx-btn" style="margin-left:10px;" onclick="showPopupLoginForm(); return false;">Login</button>
            </div>
        </div>
    </div>
</div>',
  'splash_visibility' => 'index',
  'splash_logged' => 'on',
  'sys_html_fields' => 'a:4:{s:6:"system";a:4:{i:0;s:12:"POST.message";i:1;s:15:"REQUEST.message";i:2;s:12:"POST.CmtText";i:3;s:15:"REQUEST.CmtText";}s:19:"system_profile_html";a:4:{i:0;s:20:"POST.DescriptionMe.0";i:1;s:20:"POST.DescriptionMe.1";i:2;s:23:"REQUEST.DescriptionMe.0";i:3;s:23:"REQUEST.DescriptionMe.1";}s:6:"events";a:2:{i:0;s:16:"POST.Description";i:1;s:19:"REQUEST.Description";}s:6:"groups";a:2:{i:0;s:9:"POST.desc";i:1;s:12:"REQUEST.desc";}}',
  'sys_json_fields' => '',
  'sys_exceptions_fields' => 'a:2:{s:6:"system";a:1:{i:0;s:20:"COOKIE.memberSession";}s:22:"system_email_templates";a:172:{i:0;s:36:"POST.bx_events_admin_become_fan_Body";i:1;s:39:"REQUEST.bx_events_admin_become_fan_Body";i:2;s:39:"POST.bx_events_admin_become_fan_Subject";i:3;s:42:"REQUEST.bx_events_admin_become_fan_Subject";i:4;s:29:"POST.bx_events_broadcast_Body";i:5;s:32:"REQUEST.bx_events_broadcast_Body";i:6;s:32:"POST.bx_events_broadcast_Subject";i:7;s:35:"REQUEST.bx_events_broadcast_Subject";i:8;s:36:"POST.bx_events_fan_become_admin_Body";i:9;s:39:"REQUEST.bx_events_fan_become_admin_Body";i:10;s:39:"POST.bx_events_fan_become_admin_Subject";i:11;s:42:"REQUEST.bx_events_fan_become_admin_Subject";i:12;s:30:"POST.bx_events_fan_remove_Body";i:13;s:33:"REQUEST.bx_events_fan_remove_Body";i:14;s:33:"POST.bx_events_fan_remove_Subject";i:15;s:36:"REQUEST.bx_events_fan_remove_Subject";i:16;s:30:"POST.bx_events_invitation_Body";i:17;s:33:"REQUEST.bx_events_invitation_Body";i:18;s:33:"POST.bx_events_invitation_Subject";i:19;s:36:"REQUEST.bx_events_invitation_Subject";i:20;s:32:"POST.bx_events_join_confirm_Body";i:21;s:35:"REQUEST.bx_events_join_confirm_Body";i:22;s:35:"POST.bx_events_join_confirm_Subject";i:23;s:38:"REQUEST.bx_events_join_confirm_Subject";i:24;s:31:"POST.bx_events_join_reject_Body";i:25;s:34:"REQUEST.bx_events_join_reject_Body";i:26;s:34:"POST.bx_events_join_reject_Subject";i:27;s:37:"REQUEST.bx_events_join_reject_Subject";i:28;s:32:"POST.bx_events_join_request_Body";i:29;s:35:"REQUEST.bx_events_join_request_Body";i:30;s:35:"POST.bx_events_join_request_Subject";i:31;s:38:"REQUEST.bx_events_join_request_Subject";i:32;s:23:"POST.bx_events_sbs_Body";i:33;s:26:"REQUEST.bx_events_sbs_Body";i:34;s:26:"POST.bx_events_sbs_Subject";i:35;s:29:"REQUEST.bx_events_sbs_Subject";i:36;s:36:"POST.bx_groups_admin_become_fan_Body";i:37;s:39:"REQUEST.bx_groups_admin_become_fan_Body";i:38;s:39:"POST.bx_groups_admin_become_fan_Subject";i:39;s:42:"REQUEST.bx_groups_admin_become_fan_Subject";i:40;s:29:"POST.bx_groups_broadcast_Body";i:41;s:32:"REQUEST.bx_groups_broadcast_Body";i:42;s:32:"POST.bx_groups_broadcast_Subject";i:43;s:35:"REQUEST.bx_groups_broadcast_Subject";i:44;s:36:"POST.bx_groups_fan_become_admin_Body";i:45;s:39:"REQUEST.bx_groups_fan_become_admin_Body";i:46;s:39:"POST.bx_groups_fan_become_admin_Subject";i:47;s:42:"REQUEST.bx_groups_fan_become_admin_Subject";i:48;s:30:"POST.bx_groups_fan_remove_Body";i:49;s:33:"REQUEST.bx_groups_fan_remove_Body";i:50;s:33:"POST.bx_groups_fan_remove_Subject";i:51;s:36:"REQUEST.bx_groups_fan_remove_Subject";i:52;s:30:"POST.bx_groups_invitation_Body";i:53;s:33:"REQUEST.bx_groups_invitation_Body";i:54;s:33:"POST.bx_groups_invitation_Subject";i:55;s:36:"REQUEST.bx_groups_invitation_Subject";i:56;s:32:"POST.bx_groups_join_confirm_Body";i:57;s:35:"REQUEST.bx_groups_join_confirm_Body";i:58;s:35:"POST.bx_groups_join_confirm_Subject";i:59;s:38:"REQUEST.bx_groups_join_confirm_Subject";i:60;s:31:"POST.bx_groups_join_reject_Body";i:61;s:34:"REQUEST.bx_groups_join_reject_Body";i:62;s:34:"POST.bx_groups_join_reject_Subject";i:63;s:37:"REQUEST.bx_groups_join_reject_Subject";i:64;s:32:"POST.bx_groups_join_request_Body";i:65;s:35:"REQUEST.bx_groups_join_request_Body";i:66;s:35:"POST.bx_groups_join_request_Subject";i:67;s:38:"REQUEST.bx_groups_join_request_Subject";i:68;s:23:"POST.bx_groups_sbs_Body";i:69;s:26:"REQUEST.bx_groups_sbs_Body";i:70;s:26:"POST.bx_groups_sbs_Subject";i:71;s:29:"REQUEST.bx_groups_sbs_Subject";i:72;s:22:"POST.t_Activation_Body";i:73;s:25:"REQUEST.t_Activation_Body";i:74;s:25:"POST.t_Activation_Subject";i:75;s:28:"REQUEST.t_Activation_Subject";i:76;s:22:"POST.t_AdminEmail_Body";i:77;s:25:"REQUEST.t_AdminEmail_Body";i:78;s:25:"POST.t_AdminEmail_Subject";i:79;s:28:"REQUEST.t_AdminEmail_Subject";i:80;s:22:"POST.t_AdminStats_Body";i:81;s:25:"REQUEST.t_AdminStats_Body";i:82;s:25:"POST.t_AdminStats_Subject";i:83;s:28:"REQUEST.t_AdminStats_Subject";i:84;s:19:"POST.t_Compose_Body";i:85;s:22:"REQUEST.t_Compose_Body";i:86;s:22:"POST.t_Compose_Subject";i:87;s:25:"REQUEST.t_Compose_Subject";i:88;s:24:"POST.t_Confirmation_Body";i:89;s:27:"REQUEST.t_Confirmation_Body";i:90;s:27:"POST.t_Confirmation_Subject";i:91;s:30:"REQUEST.t_Confirmation_Subject";i:92;s:21:"POST.t_CupidMail_Body";i:93;s:24:"REQUEST.t_CupidMail_Body";i:94;s:24:"POST.t_CupidMail_Subject";i:95;s:27:"REQUEST.t_CupidMail_Subject";i:96;s:18:"POST.t_Forgot_Body";i:97;s:21:"REQUEST.t_Forgot_Body";i:98;s:21:"POST.t_Forgot_Subject";i:99;s:24:"REQUEST.t_Forgot_Subject";i:100;s:21:"POST.t_FreeEmail_Body";i:101;s:24:"REQUEST.t_FreeEmail_Body";i:102;s:24:"POST.t_FreeEmail_Subject";i:103;s:27:"REQUEST.t_FreeEmail_Subject";i:104;s:25:"POST.t_FriendRequest_Body";i:105;s:28:"REQUEST.t_FriendRequest_Body";i:106;s:28:"POST.t_FriendRequest_Subject";i:107;s:31:"REQUEST.t_FriendRequest_Subject";i:108;s:33:"POST.t_FriendRequestAccepted_Body";i:109;s:36:"REQUEST.t_FriendRequestAccepted_Body";i:110;s:36:"POST.t_FriendRequestAccepted_Subject";i:111;s:39:"REQUEST.t_FriendRequestAccepted_Subject";i:112;s:22:"POST.t_MemChanged_Body";i:113;s:25:"REQUEST.t_MemChanged_Body";i:114;s:25:"POST.t_MemChanged_Subject";i:115;s:28:"REQUEST.t_MemChanged_Subject";i:116;s:25:"POST.t_MemExpiration_Body";i:117;s:28:"REQUEST.t_MemExpiration_Body";i:118;s:28:"POST.t_MemExpiration_Subject";i:119;s:31:"REQUEST.t_MemExpiration_Subject";i:120;s:19:"POST.t_Message_Body";i:121;s:22:"REQUEST.t_Message_Body";i:122;s:22:"POST.t_Message_Subject";i:123;s:25:"REQUEST.t_Message_Subject";i:124;s:23:"POST.t_MessageCopy_Body";i:125;s:26:"REQUEST.t_MessageCopy_Body";i:126;s:26:"POST.t_MessageCopy_Subject";i:127;s:29:"REQUEST.t_MessageCopy_Subject";i:128;s:30:"POST.t_sbsProfileComments_Body";i:129;s:33:"REQUEST.t_sbsProfileComments_Body";i:130;s:33:"POST.t_sbsProfileComments_Subject";i:131;s:36:"REQUEST.t_sbsProfileComments_Subject";i:132;s:26:"POST.t_sbsProfileEdit_Body";i:133;s:29:"REQUEST.t_sbsProfileEdit_Body";i:134;s:29:"POST.t_sbsProfileEdit_Subject";i:135;s:32:"REQUEST.t_sbsProfileEdit_Subject";i:136;s:22:"POST.t_SpamReport_Body";i:137;s:25:"REQUEST.t_SpamReport_Body";i:138;s:25:"POST.t_SpamReport_Subject";i:139;s:28:"REQUEST.t_SpamReport_Subject";i:140;s:26:"POST.t_SpamReportAuto_Body";i:141;s:29:"REQUEST.t_SpamReportAuto_Body";i:142;s:29:"POST.t_SpamReportAuto_Subject";i:143;s:32:"REQUEST.t_SpamReportAuto_Subject";i:144;s:24:"POST.t_Subscription_Body";i:145;s:27:"REQUEST.t_Subscription_Body";i:146;s:27:"POST.t_Subscription_Subject";i:147;s:30:"REQUEST.t_Subscription_Subject";i:148;s:22:"POST.t_TellFriend_Body";i:149;s:25:"REQUEST.t_TellFriend_Body";i:150;s:25:"POST.t_TellFriend_Subject";i:151;s:28:"REQUEST.t_TellFriend_Subject";i:152;s:29:"POST.t_TellFriendProfile_Body";i:153;s:32:"REQUEST.t_TellFriendProfile_Body";i:154;s:32:"POST.t_TellFriendProfile_Subject";i:155;s:35:"REQUEST.t_TellFriendProfile_Subject";i:156;s:25:"POST.t_UserConfirmed_Body";i:157;s:28:"REQUEST.t_UserConfirmed_Body";i:158;s:28:"POST.t_UserConfirmed_Subject";i:159;s:31:"REQUEST.t_UserConfirmed_Subject";i:160;s:22:"POST.t_UserJoined_Body";i:161;s:25:"REQUEST.t_UserJoined_Body";i:162;s:25:"POST.t_UserJoined_Subject";i:163;s:28:"REQUEST.t_UserJoined_Subject";i:164;s:17:"POST.t_VKiss_Body";i:165;s:20:"REQUEST.t_VKiss_Body";i:166;s:20:"POST.t_VKiss_Subject";i:167;s:23:"REQUEST.t_VKiss_Subject";i:168;s:25:"POST.t_VKiss_visitor_Body";i:169;s:28:"REQUEST.t_VKiss_visitor_Body";i:170;s:28:"POST.t_VKiss_visitor_Subject";i:171;s:31:"REQUEST.t_VKiss_visitor_Subject";}}',
  'cmdDay' => '10',
  'tags_last_parse_time' => '0',
  'cupid_last_cron' => '0',
  'sys_show_admin_help' => 'on',
  'sys_main_logo' => '',
  'main_div_width' => '1140px',
  'sys_template_cache_image_enable' => '',
  'sys_template_cache_image_max_size' => '5',
  'sys_sitemap_enable' => '',
  'sys_captcha_default' => 'sys_recaptcha',
  'sys_editor_default' => 'sys_tinymce',
  'bx_groups_permalinks' => 'on',
  'bx_groups_autoapproval' => 'on',
  'category_auto_app_bx_events' => 'on',
  'bx_events_permalinks' => 'on',
  'bx_events_autoapproval' => 'on',
  'bx_events_main_upcoming_event_from_featured_only' => '',
  'bx_events_max_email_invitations' => '10',
  'bx_groups_max_rss_num' => '10',
  'bx_groups_homepage_default_tab' => 'featured',
  'bx_groups_perpage_homepage' => '5',
  'bx_groups_perpage_profile' => '4',
  'bx_groups_perpage_browse' => '14',
  'bx_events_perpage_main_upcoming' => '10',
  'bx_events_perpage_main_recent' => '4',
  'bx_events_perpage_main_past' => '6',
  'bx_events_perpage_participants' => '9',
  'bx_events_perpage_browse_participants' => '30',
  'bx_events_perpage_browse' => '14',
  'bx_events_perpage_homepage' => '5',
  'bx_events_homepage_default_tab' => 'upcoming',
  'bx_events_perpage_profile' => '5',
  'bx_events_max_rss_num' => '10',
  'bx_groups_author_comments_admin' => 'on',
  'bx_groups_max_email_invitations' => '10',
  'category_auto_app_bx_groups' => 'on',
  'bx_groups_perpage_view_fans' => '6',
  'bx_groups_perpage_browse_fans' => '30',
  'bx_groups_perpage_main_recent' => '10',
)

Called script: /dolphin/index.php
Request parameters:

Array
(
)

这样找到了,原因,我们搜索以下mysql如何repair 表. 修复一下吧.

mysql repair table 的语法.

REPAIR [NO_WRITE_TO_BINLOG | LOCAL] TABLE
    tbl_name [, tbl_name] ...
    [QUICK] [EXTENDED] [USE_FRM]

因为这里报的是profile table有错, 所以repair table profile

执行后, 会有信息提示repair修复是否成功. 成功后. dolphin 的网站又正常恢复了.

此篇文章已被阅读9212 次

Tags:dolphin, mysql

About The Author

The Tester

技术交流，生活学习

相关文章

Related Posts

javaScript data 转换成 yyyy-mm-dd hh:mm:ss 的字符串

apache httpd新版本virtualhost报403错误的解决办法

Mime type/subtype

About The Author

The Tester

Add a Comment