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]
-
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?
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
- The topic ‘Database Error’ is closed to new replies.