Database Error

  • My site is down due to a database error.

    1. I have attempted to repair via wp-config process, but it was unsuccessful. The following failures;

    wp_users: Table 'scubatec_wrdp2.wp_users' doesn't exist
wp_usermeta: Table 'scubatec_wrdp2.wp_usermeta' doesn't exist
wp_posts: Table 'scubatec_wrdp2.wp_posts' doesn't exist
wp_comments: Table 'scubatec_wrdp2.wp_comments' doesn't exist
wp_links: Table 'scubatec_wrdp2.wp_links' doesn't exist
wp_options: Table 'scubatec_wrdp2.wp_options' doesn't exist
wp_postmeta: Table 'scubatec_wrdp2.wp_postmeta' doesn't exist
wp_terms: Table 'scubatec_wrdp2.wp_terms' doesn't exist
wp_term_taxonomy: Table 'scubatec_wrdp2.wp_term_taxonomy' doesn't exist
wp_term_relationships: Table 'scubatec_wrdp2.wp_term_relationships' doesn't exist
wp_commentmeta: Table 'scubatec_wrdp2.wp_commentmeta' doesn't exist

    2. I have then attempted to upload/install a backup of (what I believe is) the failed database. Restore mySQL BACKUP also failed, with the following message:

    Error: The request failed. (Error ID: t4wrut) Ask your hosting provider to research this error in cPanel & WHM’s main error log.

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter AndyDavis

    (@andydavis)

    Further: I checked the database via mySQL check. The following was reported:`[scubatec_wrdp2.wp_actionscheduler_actions] OK
    [scubatec_wrdp2.wp_actionscheduler_claims] OK
    [scubatec_wrdp2.wp_actionscheduler_groups] OK
    [scubatec_wrdp2.wp_actionscheduler_logs] OK
    [scubatec_wrdp2.wp_commentmeta] Table ‘scubatec_wrdp2.wp_commentmeta’ doesn’t exist
    [scubatec_wrdp2.wp_commentmeta] Operation failed
    [scubatec_wrdp2.wp_comments] Table ‘scubatec_wrdp2.wp_comments’ doesn’t exist
    [scubatec_wrdp2.wp_comments] Operation failed
    [scubatec_wrdp2.wp_comments_fbseo] Table ‘scubatec_wrdp2.wp_comments_fbseo’ doesn’t exist
    [scubatec_wrdp2.wp_comments_fbseo] Operation failed
    [scubatec_wrdp2.wp_edd_customermeta] OK
    [scubatec_wrdp2.wp_edd_customers] OK
    [scubatec_wrdp2.wp_em_bookings] OK
    [scubatec_wrdp2.wp_em_events] OK
    [scubatec_wrdp2.wp_em_locations] OK
    [scubatec_wrdp2.wp_em_meta] OK
    [scubatec_wrdp2.wp_em_tickets] OK
    [scubatec_wrdp2.wp_em_tickets_bookings] OK
    [scubatec_wrdp2.wp_links] Table ‘scubatec_wrdp2.wp_links’ doesn’t exist
    [scubatec_wrdp2.wp_links] Operation failed
    [scubatec_wrdp2.wp_mpsl_sliders] OK
    [scubatec_wrdp2.wp_mpsl_sliders_preview] OK
    [scubatec_wrdp2.wp_mpsl_slides] OK
    [scubatec_wrdp2.wp_mpsl_slides_preview] OK
    [scubatec_wrdp2.wp_nf3_action_meta] OK
    [scubatec_wrdp2.wp_nf3_actions] OK
    [scubatec_wrdp2.wp_nf3_field_meta] OK
    [scubatec_wrdp2.wp_nf3_fields] OK
    [scubatec_wrdp2.wp_nf3_form_meta] OK
    [scubatec_wrdp2.wp_nf3_forms] OK
    [scubatec_wrdp2.wp_nf3_object_meta] OK
    [scubatec_wrdp2.wp_nf3_objects] OK
    [scubatec_wrdp2.wp_nf3_relationships] OK
    [scubatec_wrdp2.wp_options] Table ‘scubatec_wrdp2.wp_options’ doesn’t exist
    [scubatec_wrdp2.wp_options] Operation failed
    [scubatec_wrdp2.wp_postmeta] Table ‘scubatec_wrdp2.wp_postmeta’ doesn’t exist
    [scubatec_wrdp2.wp_postmeta] Operation failed
    [scubatec_wrdp2.wp_posts] Table ‘scubatec_wrdp2.wp_posts’ doesn’t exist
    [scubatec_wrdp2.wp_posts] Operation failed
    [scubatec_wrdp2.wp_quads_stats] Table ‘scubatec_wrdp2.wp_quads_stats’ doesn’t exist
    [scubatec_wrdp2.wp_quads_stats] Operation failed
    [scubatec_wrdp2.wp_smartgoogleadwords] OK
    [scubatec_wrdp2.wp_smush_dir_images] OK
    [scubatec_wrdp2.wp_term_relationships] Table ‘scubatec_wrdp2.wp_term_relationships’ doesn’t exist
    [scubatec_wrdp2.wp_term_relationships] Operation failed
    [scubatec_wrdp2.wp_term_taxonomy] Table ‘scubatec_wrdp2.wp_term_taxonomy’ doesn’t exist
    [scubatec_wrdp2.wp_term_taxonomy] Operation failed
    [scubatec_wrdp2.wp_termmeta] OK
    [scubatec_wrdp2.wp_terms] Table ‘scubatec_wrdp2.wp_terms’ doesn’t exist
    [scubatec_wrdp2.wp_terms] Operation failed
    [scubatec_wrdp2.wp_ultimate] OK
    [scubatec_wrdp2.wp_usermeta] Table ‘scubatec_wrdp2.wp_usermeta’ doesn’t exist
    [scubatec_wrdp2.wp_usermeta] Operation failed
    [scubatec_wrdp2.wp_users] Table ‘scubatec_wrdp2.wp_users’ doesn’t exist
    [scubatec_wrdp2.wp_users] Operation failed
    [scubatec_wrdp2.wp_wdslayer] OK
    [scubatec_wrdp2.wp_wdsslide] OK
    [scubatec_wrdp2.wp_wdsslider] OK
    [scubatec_wrdp2.wp_wfBlockedIPLog] OK
    [scubatec_wrdp2.wp_wfBlocks7] OK
    [scubatec_wrdp2.wp_wfConfig] OK
    [scubatec_wrdp2.wp_wfCrawlers] OK
    [scubatec_wrdp2.wp_wfFileChanges] OK
    [scubatec_wrdp2.wp_wfFileMods] OK
    [scubatec_wrdp2.wp_wfHits] OK
    [scubatec_wrdp2.wp_wfHoover] OK
    [scubatec_wrdp2.wp_wfIssues] OK
    [scubatec_wrdp2.wp_wfKnownFileList] OK
    [scubatec_wrdp2.wp_wfLiveTrafficHuman] OK
    [scubatec_wrdp2.wp_wfLocs] OK
    [scubatec_wrdp2.wp_wfLogins] OK
    [scubatec_wrdp2.wp_wfNotifications] OK
    [scubatec_wrdp2.wp_wfPendingIssues] OK
    [scubatec_wrdp2.wp_wfReverseCache] OK
    [scubatec_wrdp2.wp_wfSNIPCache] OK
    [scubatec_wrdp2.wp_wfStatus] OK
    [scubatec_wrdp2.wp_wfTrafficRates] OK
    [scubatec_wrdp2.wp_wfls_2fa_secrets] Table ‘scubatec_wrdp2.wp_wfls_2fa_secrets’ doesn’t exist
    [scubatec_wrdp2.wp_wfls_2fa_secrets] Operation failed
    [scubatec_wrdp2.wp_wfls_settings] Table ‘scubatec_wrdp2.wp_wfls_settings’ doesn’t exist
    [scubatec_wrdp2.wp_wfls_settings] Operation failed
    [scubatec_wrdp2.wp_wpb2d_processed_dbtables] OK
    [scubatec_wrdp2.wp_wpforms_tasks_meta] OK
    [scubatec_wrdp2.wp_yoast_indexable] OK
    [scubatec_wrdp2.wp_yoast_indexable_hierarchy] OK
    [scubatec_wrdp2.wp_yoast_migrations] OK
    [scubatec_wrdp2.wp_yoast_primary_term] OK
    [scubatec_wrdp2.wp_yoast_seo_links] OK
    [scubatec_wrdp2.wp_yoast_seo_meta] OK
    [scubatec_wrdp2.wpstg0_commentmeta] Table ‘scubatec_wrdp2.wpstg0_commentmeta’ doesn’t exist
    [scubatec_wrdp2.wpstg0_commentmeta] Operation failed
    [scubatec_wrdp2.wpstg0_comments] Table ‘scubatec_wrdp2.wpstg0_comments’ doesn’t exist
    [scubatec_wrdp2.wpstg0_comments] Operation failed
    [scubatec_wrdp2.wpstg0_comments_fbseo] Table ‘scubatec_wrdp2.wpstg0_comments_fbseo’ doesn’t exist
    [scubatec_wrdp2.wpstg0_comments_fbseo] Operation failed
    [scubatec_wrdp2.wpstg0_edd_customermeta] OK
    [scubatec_wrdp2.wpstg0_edd_customers] OK
    [scubatec_wrdp2.wpstg0_em_bookings] OK
    [scubatec_wrdp2.wpstg0_em_events] OK
    [scubatec_wrdp2.wpstg0_em_locations] OK
    [scubatec_wrdp2.wpstg0_em_meta] OK
    [scubatec_wrdp2.wpstg0_em_tickets] OK
    [scubatec_wrdp2.wpstg0_em_tickets_bookings] OK
    [scubatec_wrdp2.wpstg0_links] Table ‘scubatec_wrdp2.wpstg0_links’ doesn’t exist
    [scubatec_wrdp2.wpstg0_links] Operation failed
    [scubatec_wrdp2.wpstg0_mpsl_sliders] OK
    [scubatec_wrdp2.wpstg0_mpsl_sliders_preview] OK
    [scubatec_wrdp2.wpstg0_mpsl_slides] OK
    [scubatec_wrdp2.wpstg0_mpsl_slides_preview] OK
    [scubatec_wrdp2.wpstg0_nf3_action_meta] OK
    [scubatec_wrdp2.wpstg0_nf3_actions] OK
    [scubatec_wrdp2.wpstg0_nf3_field_meta] OK
    [scubatec_wrdp2.wpstg0_nf3_fields] OK
    [scubatec_wrdp2.wpstg0_nf3_form_meta] OK
    [scubatec_wrdp2.wpstg0_nf3_forms] OK
    [scubatec_wrdp2.wpstg0_nf3_object_meta] OK
    [scubatec_wrdp2.wpstg0_nf3_objects] OK
    [scubatec_wrdp2.wpstg0_nf3_relationships] OK
    [scubatec_wrdp2.wpstg0_options] Table ‘scubatec_wrdp2.wpstg0_options’ doesn’t exist
    [scubatec_wrdp2.wpstg0_options] Operation failed
    [scubatec_wrdp2.wpstg0_postmeta] Table ‘scubatec_wrdp2.wpstg0_postmeta’ doesn’t exist
    [scubatec_wrdp2.wpstg0_postmeta] Operation failed
    [scubatec_wrdp2.wpstg0_posts] Table ‘scubatec_wrdp2.wpstg0_posts’ doesn’t exist
    [scubatec_wrdp2.wpstg0_posts] Operation failed
    [scubatec_wrdp2.wpstg0_smartgoogleadwords] OK
    [scubatec_wrdp2.wpstg0_smush_dir_images] OK
    [scubatec_wrdp2.wpstg0_term_relationships] Table ‘scubatec_wrdp2.wpstg0_term_relationships’ doesn’t exist
    [scubatec_wrdp2.wpstg0_term_relationships] Operation failed
    [scubatec_wrdp2.wpstg0_term_taxonomy] Table ‘scubatec_wrdp2.wpstg0_term_taxonomy’ doesn’t exist
    [scubatec_wrdp2.wpstg0_term_taxonomy] Operation failed
    [scubatec_wrdp2.wpstg0_termmeta] OK
    [scubatec_wrdp2.wpstg0_terms] Table ‘scubatec_wrdp2.wpstg0_terms’ doesn’t exist
    [scubatec_wrdp2.wpstg0_terms] Operation failed
    [scubatec_wrdp2.wpstg0_ultimate] OK
    [scubatec_wrdp2.wpstg0_usermeta] Table ‘scubatec_wrdp2.wpstg0_usermeta’ doesn’t exist
    [scubatec_wrdp2.wpstg0_usermeta] Operation failed
    [scubatec_wrdp2.wpstg0_users] Table ‘scubatec_wrdp2.wpstg0_users’ doesn’t exist
    [scubatec_wrdp2.wpstg0_users] Operation failed
    [scubatec_wrdp2.wpstg0_wdslayer] OK
    [scubatec_wrdp2.wpstg0_wdsslide] OK
    [scubatec_wrdp2.wpstg0_wdsslider] OK
    [scubatec_wrdp2.wpstg0_wfBlockedIPLog] OK
    [scubatec_wrdp2.wpstg0_wfBlocks7] OK
    [scubatec_wrdp2.wpstg0_wfConfig] OK
    [scubatec_wrdp2.wpstg0_wfCrawlers] OK
    [scubatec_wrdp2.wpstg0_wfFileChanges] OK
    [scubatec_wrdp2.wpstg0_wfFileMods] OK
    [scubatec_wrdp2.wpstg0_wfHits] OK
    [scubatec_wrdp2.wpstg0_wfHoover] OK
    [scubatec_wrdp2.wpstg0_wfIssues] OK
    [scubatec_wrdp2.wpstg0_wfKnownFileList] OK
    [scubatec_wrdp2.wpstg0_wfLiveTrafficHuman] OK
    [scubatec_wrdp2.wpstg0_wfLocs] OK
    [scubatec_wrdp2.wpstg0_wfLogins] OK
    [scubatec_wrdp2.wpstg0_wfNotifications] OK
    [scubatec_wrdp2.wpstg0_wfPendingIssues] OK
    [scubatec_wrdp2.wpstg0_wfReverseCache] OK
    [scubatec_wrdp2.wpstg0_wfSNIPCache] OK
    [scubatec_wrdp2.wpstg0_wfStatus] OK
    [scubatec_wrdp2.wpstg0_wfTrafficRates] OK
    [scubatec_wrdp2.wpstg0_wfls_2fa_secrets] Table ‘scubatec_wrdp2.wpstg0_wfls_2fa_secrets’ doesn’t exist
    [scubatec_wrdp2.wpstg0_wfls_2fa_secrets] Operation failed
    [scubatec_wrdp2.wpstg0_wfls_settings] Table ‘scubatec_wrdp2.wpstg0_wfls_settings’ doesn’t exist
    [scubatec_wrdp2.wpstg0_wfls_settings] Operation failed
    [scubatec_wrdp2.wpstg0_wpb2d_processed_dbtables] OK
    [scubatec_wrdp2.wpstg0_yoast_seo_links] OK
    [scubatec_wrdp2.wpstg0_yoast_seo_meta] OK`

    You seem to be missing central database tables, apparently also in the backup. If necessary, you should use an older backup. Have you also contacted your hoster about this, as described in the last-mentioned message?

    Thread Starter AndyDavis

    (@andydavis)

    The hoster has now confirmed server side problems and that my site is being migrated to a different server.

    Although the site is still down and says ACCOUNT SUSPENDED.

    Waiting for their reply on that

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Database Error’ is closed to new replies.