{"id":1750,"date":"2020-06-29T09:54:48","date_gmt":"2020-06-29T07:54:48","guid":{"rendered":"https:\/\/www.wp-moon.com\/?p=1750"},"modified":"2020-06-29T09:57:16","modified_gmt":"2020-06-29T07:57:16","slug":"wordpress-database-error-wp_users-doesnt-exist","status":"publish","type":"post","link":"https:\/\/www.wp-moon.com\/en\/wordpress-database-error-wp_users-doesnt-exist\/","title":{"rendered":"WordPress database error : wp_users\u2019 doesn\u2019t exist"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">You are developping your WordPress website and suddently, you have a database error. Errors can be listed below : <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>wpta_users: Table \u2018wp_users\u2019 doesn\u2019t exist\nwpta_usermeta: Table \u2018wp_usermeta\u2019 doesn\u2019t exist\nwpta_posts: Table \u2018wp_posts\u2019 doesn\u2019t exist\nwpta_links: Table \u2018wp_links\u2019 doesn\u2019t exist\nwpta_options: Table \u2018wp_options\u2019 doesn\u2019t exist\nwpta_postmeta: Table \u2018wp_postmeta\u2019 doesn\u2019t exist\nwpta_terms: Table \u2018wp_terms\u2019 doesn\u2019t exist\nwpta_term_taxonomy: Table \u2018wp_term_taxonomy\u2019 doesn\u2019t exist\nwpta_term_relationships: Table \u2018wp_term_relationships\u2019 doesn\u2019t exist\nwpta_termmeta: Table \u2018wp_termmeta\u2019 doesn\u2019t exist<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Or : <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>wp_users: Table \u2018wp_users\u2019 doesn\u2019t exist in engine\nwp_usermeta: Table \u2018wp_usermeta\u2019 doesn\u2019t exist in engine\nwp_posts: Table \u2018wp_posts\u2019 doesn\u2019t exist in engine\nwp_comments: Table \u2018wp_comments\u2019 doesn\u2019t exist in engine\nwp_links: Table \u2018wp_links\u2019 doesn\u2019t exist in engine\nwp_options: Table \u2018wp_options\u2019 doesn\u2019t exist in engine\nwp_postmeta: Table \u2018wp_postmeta\u2019 doesn\u2019t exist in engine\nwp_terms: Table \u2018wp_terms\u2019 doesn\u2019t exist in engine\nwp_term_taxonomy: Table \u2018wp_term_taxonomy\u2019 doesn\u2019t exist in engine\nwp_term_relationships: Table \u2018wp_term_relationships\u2019 doesn\u2019t exist in engine\nwp_termmeta: Table \u2018wp_termmeta\u2019 doesn\u2019t exist in engine\nwp_commentmeta: Table \u2018wp_commentmeta\u2019 doesn\u2019t exist in engine<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Or :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>WordPress database error: &#91;Table \u2018wordpress.wp_users\u2019 doesn\u2019t exist]\nSELECT * FROM wp_users WHERE user_login = login\nWordPress database error: &#91;Table \u2018wordpress.wp_users\u2019 doesn\u2019t exist]\nSELECT * FROM wp_users WHERE user_login = login\nWordPress database error: &#91;Table \u2018wordpress.wp_users\u2019 doesn\u2019t exist]\nSELECT * FROM wp_users WHERE user_email = \u2018mon_mail@hebergeur.fr\u2019\nWordPress database error: &#91;Table \u2018wordpress.wp_users\u2019 doesn\u2019t exist]\nSELECT ID FROM wp_users WHERE user_nicename = login AND user_login != login LIMIT 1\nWordPress database error: &#91;Table \u2018wordpress.wp_users\u2019 doesn\u2019t exist]\nSHOW FULL COLUMNS FROM wp_users<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">New install<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">If this is your first setup of WordPress and you have this kind of error, you should ensure that your mysql database charsets is <strong>utf8mb4<\/strong>. If your database is under <strong>utf8_unicode_ci<\/strong> or another charsets, then you should change it, with <em>phpmyadmin <\/em>for example.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Error appear suddently<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">If your website worked well before and this kind of <a href=\"https:\/\/www.wp-moon.com\/what-can-you-do-when-the-error-err_too_many_redirects-appears-on-your-site\/\" title=\"What can you do when the error ERR_TOO_MANY_REDIRECTS appears on your site\">error appeared<\/a> suddenly, then your database has a problem. It seems that your WordPress tables are no longer there.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The best solution here is to <strong>apply a backup<\/strong> from your website. If you have a full backup, <strong>remove your current tables<\/strong> from your database and <strong>add your backup<\/strong>. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Do it carefully. If you are not sure about what you are doing, you should contact an expert.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>You are developping your WordPress website and suddently, you have a database error. Errors can be listed below : Or : Or : New install If this is your first setup of WordPress and you have this kind of error, you should ensure that your mysql database charsets is utf8mb4. If your database is under &hellip; <a href=\"https:\/\/www.wp-moon.com\/en\/wordpress-database-error-wp_users-doesnt-exist\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">WordPress database error : wp_users\u2019 doesn\u2019t exist<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":1751,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[37],"tags":[],"class_list":["post-1750","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-fix-errors"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>WordPress database error : wp_users\u2019 doesn\u2019t exist - WP Moon<\/title>\n<meta name=\"description\" content=\"You are developping your WordPress website and suddently, you have a database error. Errors can be listed below : wpta_users: Table \u2018wp_users\u2019 doesn\u2019t\" \/>\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\/wordpress-database-error-wp_users-doesnt-exist\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"WordPress database error : wp_users\u2019 doesn\u2019t exist - WP Moon\" \/>\n<meta property=\"og:description\" content=\"You are developping your WordPress website and suddently, you have a database error. Errors can be listed below : wpta_users: Table \u2018wp_users\u2019 doesn\u2019t\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wp-moon.com\/en\/wordpress-database-error-wp_users-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-06-29T07:54:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-06-29T07:57:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wp-moon.com\/wp-content\/uploads\/2020\/06\/0uPNK-min.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2074\" \/>\n\t<meta property=\"og:image:height\" content=\"1542\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\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=\"1 minute\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"WordPress database error : wp_users\u2019 doesn\u2019t exist - WP Moon","description":"You are developping your WordPress website and suddently, you have a database error. Errors can be listed below : wpta_users: Table \u2018wp_users\u2019 doesn\u2019t","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\/wordpress-database-error-wp_users-doesnt-exist\/","og_locale":"en_US","og_type":"article","og_title":"WordPress database error : wp_users\u2019 doesn\u2019t exist - WP Moon","og_description":"You are developping your WordPress website and suddently, you have a database error. Errors can be listed below : wpta_users: Table \u2018wp_users\u2019 doesn\u2019t","og_url":"https:\/\/www.wp-moon.com\/en\/wordpress-database-error-wp_users-doesnt-exist\/","og_site_name":"WP Moon","article_publisher":"https:\/\/www.facebook.com\/wpmoonwebsite","article_published_time":"2020-06-29T07:54:48+00:00","article_modified_time":"2020-06-29T07:57:16+00:00","og_image":[{"width":2074,"height":1542,"url":"https:\/\/www.wp-moon.com\/wp-content\/uploads\/2020\/06\/0uPNK-min.png","type":"image\/png"}],"author":"Alexandre G","twitter_card":"summary_large_image","twitter_creator":"@alexgaboriau","twitter_site":"@WPMoon4","twitter_misc":{"Written by":"Alexandre G","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.wp-moon.com\/en\/wordpress-database-error-wp_users-doesnt-exist\/#article","isPartOf":{"@id":"https:\/\/www.wp-moon.com\/en\/wordpress-database-error-wp_users-doesnt-exist\/"},"author":{"name":"Alexandre G","@id":"https:\/\/www.wp-moon.com\/en\/#\/schema\/person\/72a64e6910977ec9e4b32fd8da54369d"},"headline":"WordPress database error : wp_users\u2019 doesn\u2019t exist","datePublished":"2020-06-29T07:54:48+00:00","dateModified":"2020-06-29T07:57:16+00:00","mainEntityOfPage":{"@id":"https:\/\/www.wp-moon.com\/en\/wordpress-database-error-wp_users-doesnt-exist\/"},"wordCount":155,"commentCount":0,"publisher":{"@id":"https:\/\/www.wp-moon.com\/en\/#organization"},"image":{"@id":"https:\/\/www.wp-moon.com\/en\/wordpress-database-error-wp_users-doesnt-exist\/#primaryimage"},"thumbnailUrl":"https:\/\/www.wp-moon.com\/wp-content\/uploads\/2020\/06\/0uPNK-min.png","articleSection":["Fix Errors"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.wp-moon.com\/en\/wordpress-database-error-wp_users-doesnt-exist\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.wp-moon.com\/en\/wordpress-database-error-wp_users-doesnt-exist\/","url":"https:\/\/www.wp-moon.com\/en\/wordpress-database-error-wp_users-doesnt-exist\/","name":"WordPress database error : wp_users\u2019 doesn\u2019t exist - WP Moon","isPartOf":{"@id":"https:\/\/www.wp-moon.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.wp-moon.com\/en\/wordpress-database-error-wp_users-doesnt-exist\/#primaryimage"},"image":{"@id":"https:\/\/www.wp-moon.com\/en\/wordpress-database-error-wp_users-doesnt-exist\/#primaryimage"},"thumbnailUrl":"https:\/\/www.wp-moon.com\/wp-content\/uploads\/2020\/06\/0uPNK-min.png","datePublished":"2020-06-29T07:54:48+00:00","dateModified":"2020-06-29T07:57:16+00:00","description":"You are developping your WordPress website and suddently, you have a database error. Errors can be listed below : wpta_users: Table \u2018wp_users\u2019 doesn\u2019t","breadcrumb":{"@id":"https:\/\/www.wp-moon.com\/en\/wordpress-database-error-wp_users-doesnt-exist\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wp-moon.com\/en\/wordpress-database-error-wp_users-doesnt-exist\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.wp-moon.com\/en\/wordpress-database-error-wp_users-doesnt-exist\/#primaryimage","url":"https:\/\/www.wp-moon.com\/wp-content\/uploads\/2020\/06\/0uPNK-min.png","contentUrl":"https:\/\/www.wp-moon.com\/wp-content\/uploads\/2020\/06\/0uPNK-min.png","width":2074,"height":1542},{"@type":"BreadcrumbList","@id":"https:\/\/www.wp-moon.com\/en\/wordpress-database-error-wp_users-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":"WordPress database error : wp_users\u2019 doesn\u2019t 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\/1750","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=1750"}],"version-history":[{"count":0,"href":"https:\/\/www.wp-moon.com\/en\/wp-json\/wp\/v2\/posts\/1750\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.wp-moon.com\/en\/wp-json\/wp\/v2\/media\/1751"}],"wp:attachment":[{"href":"https:\/\/www.wp-moon.com\/en\/wp-json\/wp\/v2\/media?parent=1750"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wp-moon.com\/en\/wp-json\/wp\/v2\/categories?post=1750"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wp-moon.com\/en\/wp-json\/wp\/v2\/tags?post=1750"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}