{"id":1195347,"date":"2009-08-30T19:44:05","date_gmt":"2009-08-30T19:44:05","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/database-problem-12\/"},"modified":"2016-08-19T13:50:20","modified_gmt":"2016-08-19T13:50:20","slug":"database-problem-12","status":"closed","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/database-problem-12\/","title":{"rendered":"database problem"},"content":{"rendered":"<p>I&#8217;ve had this issue several times and I DO NOT see where it is addressed anywhere within the installation procedure however, it would appear that wordpressmu attempts to query a non-existent table in the newly created MySQL database during set-up:<\/p>\n<blockquote>\n<p>\nWordPress database error Table &#8216;wordpressmu.wp_blogs&#8217; doesn&#8217;t exist for query SELECT * FROM wp_blogs WHERE domain = &#8216;foo.com&#8217; AND path = &#8216;\/wordpressmu\/&#8217; made by require, include, include_once, require_once, require_once WordPress database error Table &#8216;wordpressmu.wp_sitemeta&#8217; doesn&#8217;t exist for query SELECT meta_value FROM wp_sitemeta WHERE site_id = 1 AND meta_key = &#8216;site_name&#8217; made by require, include, include_once, require_once, require_once, get_current_site_name WordPress database error Table &#8216;wordpressmu.wp_blogs&#8217; doesn&#8217;t exist for query SELECT blog_id FROM wp_blogs LIMIT 0,1 made by require, include, include_once, require_once, require_once WordPress database error Table &#8216;wordpressmu.wp_sitemeta&#8217; doesn&#8217;t exist for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = &#8216;wpmu_sitewide_plugins&#8217; AND site_id = 1 made by require, include, include_once, require_once, get_site_option<\/p>\n<\/blockquote>\n<p>This occurs using the standard install wizard. Of course hacking into the database is needed to change the stie admin password (which you can&#8217;t receive if the server you are placing it on only supports (or you haven&#8217;t written a php mail handler for your site already) SMTP and of course the &#8220;wizard&#8221; is not set-up for this.<\/p>\n<p>Anyway, my question is this (actually two installation questions):<\/p>\n<p>1) What is the proper procedure for creating the database from the command prompt (that phpmyamin thing is bunk; doesn&#8217;t sink up properly, etc.)?<\/p>\n<p>2) What is the path or better stated where in the configuration file do I set the path for new users to create their own blogs using a file structure?<\/p>\n<p>I suppose I will get deleted again for I asked part of this question 2 hours ago and don&#8217;t see my post here anymore<\/p>\n","protected":false},"template":"","class_list":["post-1195347","topic","type-topic","status-closed","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/1195347","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\/1195347\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=1195347"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}