{"id":1393,"date":"2020-02-19T11:04:56","date_gmt":"2020-02-19T10:04:56","guid":{"rendered":"https:\/\/www.wp-moon.com\/lerreur-table-doesnt-exist\/"},"modified":"2020-02-19T16:46:03","modified_gmt":"2020-02-19T15:46:03","slug":"the-error-table-doesnt-exist","status":"publish","type":"post","link":"https:\/\/www.wp-moon.com\/en\/the-error-table-doesnt-exist\/","title":{"rendered":"The error Table&#8230; doesn&#8217;t exist"},"content":{"rendered":"<div class=\"wpb-content-wrapper\"><p>[vc_row][vc_column][vc_custom_heading text=&#8221;Issue&#8221; use_theme_fonts=&#8221;yes&#8221;][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]Suddenly, for no apparent reason, errors of this type appear on your site:[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]<code>wp_users: Table \u2018wp_users\u2019 doesn\u2019t exist<br \/>\nwp_usermeta: Table \u2018wp_usermeta\u2019 doesn\u2019t exist<br \/>\nwp_posts: Table \u2018wp_posts\u2019 doesn\u2019t exist<br \/>\nwp_links: Table \u2018wp_links\u2019 doesn\u2019t exist<br \/>\nwp_options: Table \u2018wp_options\u2019 doesn\u2019t exist<br \/>\n...<\/code>[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column][vc_custom_heading text=&#8221;Where does this error come from?&#8221; use_theme_fonts=&#8221;yes&#8221;][vc_column_text]<span class=\"tlid-translation translation\" lang=\"en\"><span class=\"\" title=\"\">This error can occur following:<\/span><\/span><\/p>\n<ul>\n<li>Has a failed update of WordPress<\/li>\n<li>In case of accidental <a href=\"https:\/\/www.wp-moon.com\/fr\/woocommerce-supprime-automatiquement-des-donnees\/\" title=\"WooCommerce supprime automatiquement des donn\u00e9es\">deletion of data<\/a><\/li>\n<li>In case of malicious damage to your site<\/li>\n<li>In case of a problem with your database<\/li>\n<\/ul>\n<p>[\/vc_column_text][\/vc_column][vc_column][vc_custom_heading text=&#8221;What can be done to solve this problem?&#8221; use_theme_fonts=&#8221;yes&#8221;][vc_column_text]Depending on the access and what you have at hand, different possibilities are available to you:<\/p>\n<ul>\n<li>If this is a problem with an update, please try again.<\/li>\n<li>If you don&#8217;t have access to your database, ask your web host if they have a recent backup that they can give you.<\/li>\n<li>If you have access to your database :\n<ul>\n<li>If you have a recent backup that does not involve a major loss of data or your work, you can try to restore it.<\/li>\n<li>The easiest way to do this is to access your database via a web interface provided by your host, or to upload phpMyAdmin to your site via (S)FTP : <a href=\"https:\/\/www.phpmyadmin.net\/downloads\/\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/www.phpmyadmin.net\/downloads\/<\/a><\/li>\n<li>If you don&#8217;t have a recent data backup, you can try to repair the tables in your database :\n<ul>\n<li>Select the default table(s) then click on &#8220;With the selection&#8221;<br \/>\n<img decoding=\"async\" class=\"alignnone size-full wp-image-1379\" src=\"https:\/\/www.wp-moon.com\/wp-content\/uploads\/2020\/02\/selection-en.jpg\" alt=\"\" width=\"554\" height=\"55\" srcset=\"https:\/\/www.wp-moon.com\/wp-content\/uploads\/2020\/02\/selection-en.jpg 554w, https:\/\/www.wp-moon.com\/wp-content\/uploads\/2020\/02\/selection-en-300x30.jpg 300w\" sizes=\"(max-width: 554px) 100vw, 554px\" \/><\/li>\n<li>Choose &#8220;Fix the table&#8221;. phpMyAdmin will then inform you whether or not the operation was successful.<\/li>\n<li><img decoding=\"async\" class=\"alignnone size-full wp-image-1378\" src=\"https:\/\/www.wp-moon.com\/wp-content\/uploads\/2020\/02\/repair-en.jpg\" alt=\"Repair SQL table \" width=\"159\" height=\"40\" \/><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>The best thing is to have regular backups of your database to avoid stress and limit any data loss. To do this, you can ask your hosting provider whether they offer such an option or you can set up an automatic backup strategy yourself. You don&#8217;t know how to do this? WordPress experts can offer you different backup scenarios depending on the criticality of your data.[\/vc_column_text][\/vc_column][\/vc_row]<\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Problems with your database tables? Here are some tips (don&#8217;t forget to backup your database)<\/p>\n","protected":false},"author":2,"featured_media":1370,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"link","meta":{"footnotes":""},"categories":[37],"tags":[70],"class_list":["post-1393","post","type-post","status-publish","format-link","has-post-thumbnail","hentry","category-fix-errors","tag-table-2","post_format-post-format-link"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>The error Table... doesn&#039;t exist - WP Moon<\/title>\n<meta name=\"description\" content=\"Problems with your database tables? Here are some tips (don&#039;t forget to backup your database)\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wp-moon.com\/en\/the-error-table-doesnt-exist\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The error Table... doesn&#039;t exist - WP Moon\" \/>\n<meta property=\"og:description\" content=\"Problems with your database tables? Here are some tips (don&#039;t forget to backup your database)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wp-moon.com\/en\/the-error-table-doesnt-exist\/\" \/>\n<meta property=\"og:site_name\" content=\"WP Moon\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/wpmoonwebsite\" \/>\n<meta property=\"article:published_time\" content=\"2020-02-19T10:04:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-02-19T15:46:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wp-moon.com\/wp-content\/uploads\/2020\/02\/data-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"490\" \/>\n\t<meta property=\"og:image:height\" content=\"280\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Alexandre G\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@alexgaboriau\" \/>\n<meta name=\"twitter:site\" content=\"@WPMoon4\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Alexandre G\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"The error Table... doesn't exist - WP Moon","description":"Problems with your database tables? Here are some tips (don't forget to backup your database)","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wp-moon.com\/en\/the-error-table-doesnt-exist\/","og_locale":"en_US","og_type":"article","og_title":"The error Table... doesn't exist - WP Moon","og_description":"Problems with your database tables? Here are some tips (don't forget to backup your database)","og_url":"https:\/\/www.wp-moon.com\/en\/the-error-table-doesnt-exist\/","og_site_name":"WP Moon","article_publisher":"https:\/\/www.facebook.com\/wpmoonwebsite","article_published_time":"2020-02-19T10:04:56+00:00","article_modified_time":"2020-02-19T15:46:03+00:00","og_image":[{"width":490,"height":280,"url":"https:\/\/www.wp-moon.com\/wp-content\/uploads\/2020\/02\/data-1.jpg","type":"image\/jpeg"}],"author":"Alexandre G","twitter_card":"summary_large_image","twitter_creator":"@alexgaboriau","twitter_site":"@WPMoon4","twitter_misc":{"Written by":"Alexandre G","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.wp-moon.com\/en\/the-error-table-doesnt-exist\/#article","isPartOf":{"@id":"https:\/\/www.wp-moon.com\/en\/the-error-table-doesnt-exist\/"},"author":{"name":"Alexandre G","@id":"https:\/\/www.wp-moon.com\/en\/#\/schema\/person\/72a64e6910977ec9e4b32fd8da54369d"},"headline":"The error Table&#8230; doesn&#8217;t exist","datePublished":"2020-02-19T10:04:56+00:00","dateModified":"2020-02-19T15:46:03+00:00","mainEntityOfPage":{"@id":"https:\/\/www.wp-moon.com\/en\/the-error-table-doesnt-exist\/"},"wordCount":381,"commentCount":0,"publisher":{"@id":"https:\/\/www.wp-moon.com\/en\/#organization"},"image":{"@id":"https:\/\/www.wp-moon.com\/en\/the-error-table-doesnt-exist\/#primaryimage"},"thumbnailUrl":"https:\/\/www.wp-moon.com\/wp-content\/uploads\/2020\/02\/data-1.jpg","keywords":["table"],"articleSection":["Fix Errors"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.wp-moon.com\/en\/the-error-table-doesnt-exist\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.wp-moon.com\/en\/the-error-table-doesnt-exist\/","url":"https:\/\/www.wp-moon.com\/en\/the-error-table-doesnt-exist\/","name":"The error Table... doesn't exist - WP Moon","isPartOf":{"@id":"https:\/\/www.wp-moon.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.wp-moon.com\/en\/the-error-table-doesnt-exist\/#primaryimage"},"image":{"@id":"https:\/\/www.wp-moon.com\/en\/the-error-table-doesnt-exist\/#primaryimage"},"thumbnailUrl":"https:\/\/www.wp-moon.com\/wp-content\/uploads\/2020\/02\/data-1.jpg","datePublished":"2020-02-19T10:04:56+00:00","dateModified":"2020-02-19T15:46:03+00:00","description":"Problems with your database tables? Here are some tips (don't forget to backup your database)","breadcrumb":{"@id":"https:\/\/www.wp-moon.com\/en\/the-error-table-doesnt-exist\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wp-moon.com\/en\/the-error-table-doesnt-exist\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.wp-moon.com\/en\/the-error-table-doesnt-exist\/#primaryimage","url":"https:\/\/www.wp-moon.com\/wp-content\/uploads\/2020\/02\/data-1.jpg","contentUrl":"https:\/\/www.wp-moon.com\/wp-content\/uploads\/2020\/02\/data-1.jpg","width":490,"height":280,"caption":"data"},{"@type":"BreadcrumbList","@id":"https:\/\/www.wp-moon.com\/en\/the-error-table-doesnt-exist\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.wp-moon.com\/en\/"},{"@type":"ListItem","position":2,"name":"Fix Errors","item":"https:\/\/www.wp-moon.com\/en\/category\/fix-errors\/"},{"@type":"ListItem","position":3,"name":"The error Table&#8230; doesn&#8217;t exist"}]},{"@type":"WebSite","@id":"https:\/\/www.wp-moon.com\/en\/#website","url":"https:\/\/www.wp-moon.com\/en\/","name":"WP Moon","description":"","publisher":{"@id":"https:\/\/www.wp-moon.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wp-moon.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.wp-moon.com\/en\/#organization","name":"WP Moon","url":"https:\/\/www.wp-moon.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.wp-moon.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/www.wp-moon.com\/wp-content\/uploads\/2020\/02\/logo.png","contentUrl":"https:\/\/www.wp-moon.com\/wp-content\/uploads\/2020\/02\/logo.png","width":290,"height":95,"caption":"WP Moon"},"image":{"@id":"https:\/\/www.wp-moon.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/wpmoonwebsite","https:\/\/x.com\/WPMoon4"]},{"@type":"Person","@id":"https:\/\/www.wp-moon.com\/en\/#\/schema\/person\/72a64e6910977ec9e4b32fd8da54369d","name":"Alexandre G","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.wp-moon.com\/wp-content\/uploads\/2023\/09\/312419460_10229483707296045_2919774527885824513_n-100x100.jpg","url":"https:\/\/www.wp-moon.com\/wp-content\/uploads\/2023\/09\/312419460_10229483707296045_2919774527885824513_n-100x100.jpg","contentUrl":"https:\/\/www.wp-moon.com\/wp-content\/uploads\/2023\/09\/312419460_10229483707296045_2919774527885824513_n-100x100.jpg","caption":"Alexandre G"},"description":"Alexandre, Web Developer &amp; Website Editor. I've been using WordPress for over 10 years in my professional environment and on personal projects. I created WP Moon to teach you how to use this CMS, solve your problems and show you all the tricks.","sameAs":["https:\/\/www.croque-pixel.com\/","https:\/\/x.com\/alexgaboriau","https:\/\/www.youtube.com\/@wp_moon\/videos"],"url":"https:\/\/www.wp-moon.com\/en\/author\/wp-moon\/"}]}},"_links":{"self":[{"href":"https:\/\/www.wp-moon.com\/en\/wp-json\/wp\/v2\/posts\/1393","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wp-moon.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wp-moon.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wp-moon.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wp-moon.com\/en\/wp-json\/wp\/v2\/comments?post=1393"}],"version-history":[{"count":0,"href":"https:\/\/www.wp-moon.com\/en\/wp-json\/wp\/v2\/posts\/1393\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.wp-moon.com\/en\/wp-json\/wp\/v2\/media\/1370"}],"wp:attachment":[{"href":"https:\/\/www.wp-moon.com\/en\/wp-json\/wp\/v2\/media?parent=1393"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wp-moon.com\/en\/wp-json\/wp\/v2\/categories?post=1393"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wp-moon.com\/en\/wp-json\/wp\/v2\/tags?post=1393"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}