{"id":18312074,"date":"2025-02-17T23:14:08","date_gmt":"2025-02-17T23:14:08","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/database-table-missing-from-phpmyadmin\/"},"modified":"2025-02-17T23:14:08","modified_gmt":"2025-02-17T23:14:08","slug":"database-table-missing-from-phpmyadmin","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/database-table-missing-from-phpmyadmin\/","title":{"rendered":"Database table missing from phpMyAdmin"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Hello all,<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I am seeing in my server logs a lot of errors suggesting that it cannot find the <code>wp_geodir_post_locations<\/code> table. In looking at phpMyAdmin, I&#8217;ve discovered that table is missing. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I&#8217;ve learned that the best way to create and setup the table is to install the software. I&#8217;ve tried un-install then reinstall. This did not work. I&#8217;ve looked in settings and I do not see a way to trigger table repair. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The research I&#8217;ve conducted suggests I can delete (then reinstall) the plugin and extensions to get tables rebuilt. If I have disabled the feature that would delete data upon plugin delete, I should be good to re-install the plugin and extension(s). Do you agree? Should I try a different plan of action? <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">here&#8217;s a partial error for consideration. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code>WordPress database error Table '.. .wp_9_geodir_post_locations' doesn't exist for query SELECT * FROM wp_9_geodir_post_locations WHERE 1=1 AND ( country = 'united-states' OR country_slug = 'united-states' ) ORDER BY city LIMIT 1 made by require('wp-blog-header.php'), require_once('wp-includes\/template-loader.php'), ...<\/code><\/p>\n","protected":false},"template":"","class_list":["post-18312074","topic","type-topic","status-publish","hentry","topic-tag-database","topic-tag-database-table","topic-tag-error_log","topic-tag-phpmyadmin"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/18312074","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/18312074\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=18312074"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}