Title: wclark's Replies | WordPress.org --- # wclark [ ](https://wordpress.org/support/users/wclark/) * [Profile](https://wordpress.org/support/users/wclark/) * [Topics Started](https://wordpress.org/support/users/wclark/topics/) * [Replies Created](https://wordpress.org/support/users/wclark/replies/) * [Reviews Written](https://wordpress.org/support/users/wclark/reviews/) * [Topics Replied To](https://wordpress.org/support/users/wclark/replied-to/) * [Engagements](https://wordpress.org/support/users/wclark/engagements/) * [Favorites](https://wordpress.org/support/users/wclark/favorites/) Search replies: ## Forum Replies Created Viewing 9 replies - 1 through 9 (of 9 total) * Forum: [Hacks](https://wordpress.org/support/forum/plugins-and-hacks/hacks/) In reply to: [Custom Select Query for Displaying Posts Not Working](https://wordpress.org/support/topic/custom-select-query-for-displaying-posts-not-working/) * [wclark](https://wordpress.org/support/users/wclark/) * (@wclark) * [15 years, 7 months ago](https://wordpress.org/support/topic/custom-select-query-for-displaying-posts-not-working/#post-1703815) * Remove these lines: $sql .= “AND post_type = ‘post’ “; $sql .= “AND post_status = ‘publish’ AND dp_date >= ‘$current_date’ “; * That will leave you with just one constraint: postnumber=ID * Forum: [Hacks](https://wordpress.org/support/forum/plugins-and-hacks/hacks/) In reply to: [Custom Select Query for Displaying Posts Not Working](https://wordpress.org/support/topic/custom-select-query-for-displaying-posts-not-working/) * [wclark](https://wordpress.org/support/users/wclark/) * (@wclark) * [15 years, 7 months ago](https://wordpress.org/support/topic/custom-select-query-for-displaying-posts-not-working/#post-1703782) * I would remove the constraints and run the query. If you get results, then add the constraints back one by one until you find the one that choked. * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [How To Do A Complete Wipe](https://wordpress.org/support/topic/how-to-do-a-complete-wipe/) * [wclark](https://wordpress.org/support/users/wclark/) * (@wclark) * [15 years, 7 months ago](https://wordpress.org/support/topic/how-to-do-a-complete-wipe/#post-1701310) * When you installed WordPress, you installed it into a directory on your server. Maybe that directory is public_html. public_html sounds like your root level directory. There may be other files in there you do not want to delete (I’m not sure). Is there a wordpress directory inside of public_html? If so, that is what you want to delete. * The command to drop the database from a command prompt is mysqladmin drop db, where db is the database name. * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [How To Do A Complete Wipe](https://wordpress.org/support/topic/how-to-do-a-complete-wipe/) * [wclark](https://wordpress.org/support/users/wclark/) * (@wclark) * [15 years, 7 months ago](https://wordpress.org/support/topic/how-to-do-a-complete-wipe/#post-1701299) * Delete your WordPress directory. Use mysqladmin to drop the database. Now everything is gone. * Forum: [Networking WordPress](https://wordpress.org/support/forum/multisite/) In reply to: ["Error establishing a database connection" adding new site](https://wordpress.org/support/topic/error-establishing-a-database-connection-adding-new-site-1/) * Thread Starter [wclark](https://wordpress.org/support/users/wclark/) * (@wclark) * [15 years, 9 months ago](https://wordpress.org/support/topic/error-establishing-a-database-connection-adding-new-site-1/#post-1596832) * Hi All, * After not getting a reply for two days, I had to try something else. * I deleted the WordPress install and cleared the database. * I re-installed and my problem is fixed. I can create sub-sites again. * I suspect that something in the database was not right, but I do not know what that is and I don’t know how it got corrupted. * thanks anyway! Bill * Forum: [Networking WordPress](https://wordpress.org/support/forum/multisite/) In reply to: ["Error establishing a database connection" adding new site](https://wordpress.org/support/topic/error-establishing-a-database-connection-adding-new-site-1/) * Thread Starter [wclark](https://wordpress.org/support/users/wclark/) * (@wclark) * [15 years, 9 months ago](https://wordpress.org/support/topic/error-establishing-a-database-connection-adding-new-site-1/#post-1596739) * Hi dgilmour, * Thanks for taking a look. I didn’t know of that error. This is not associated with my problem. * This site has been integrated with WordPress, and the new version of the site is partially installed. * If you go to blogs.mobilitysales.com/rapid-city-sd and click on any posts, they will work. * The main site has not been upgraded to the new site templates (nothing to do with WordPress, our own custom templates) yet. That is what is causing this error. We will be fixing this though.. * thanks again! Bill * Forum: [Networking WordPress](https://wordpress.org/support/forum/multisite/) In reply to: ["Error establishing a database connection" adding new site](https://wordpress.org/support/topic/error-establishing-a-database-connection-adding-new-site-1/) * Thread Starter [wclark](https://wordpress.org/support/users/wclark/) * (@wclark) * [15 years, 9 months ago](https://wordpress.org/support/topic/error-establishing-a-database-connection-adding-new-site-1/#post-1596711) * I have been deleting the site I created, then trying again after trying a few config changes, such as disabling plugins. * Forum: [Networking WordPress](https://wordpress.org/support/forum/multisite/) In reply to: ["Error establishing a database connection" adding new site](https://wordpress.org/support/topic/error-establishing-a-database-connection-adding-new-site-1/) * Thread Starter [wclark](https://wordpress.org/support/users/wclark/) * (@wclark) * [15 years, 9 months ago](https://wordpress.org/support/topic/error-establishing-a-database-connection-adding-new-site-1/#post-1596693) * Yes, that is correct. Also, this is a fresh install of 3.0. * Forum: [Networking WordPress](https://wordpress.org/support/forum/multisite/) In reply to: ["Error establishing a database connection" adding new site](https://wordpress.org/support/topic/error-establishing-a-database-connection-adding-new-site/) * [wclark](https://wordpress.org/support/users/wclark/) * (@wclark) * [15 years, 9 months ago](https://wordpress.org/support/topic/error-establishing-a-database-connection-adding-new-site/#post-1594044) * It seems like I am having the same error. * But I do not have any plugins activated. * I am running WordPress 3.0 * My main site works great: blogs.mobilitysales.com I have 1 secondary site that works great: blogs.mobilitysales.com/rapid-city-sd * Now when I attempt to create a 2nd secondary site, I get the same symtoms as above. * When I try a database repair for the secondary site it doesn’t work. wp_11_posts: Table ‘wordpress-mu.wp_11_posts’ doesn’t exist wp_11_comments: Table ‘wordpress- mu.wp_11_comments’ doesn’t exist wp_11_links: Table ‘wordpress-mu.wp_11_links’ doesn’t exist wp_11_options: Table ‘wordpress-mu.wp_11_options’ doesn’t exist wp_11_postmeta: Table ‘wordpress-mu.wp_11_postmeta’ doesn’t exist wp_11_terms: Table ‘wordpress-mu.wp_11_terms’ doesn’t exist wp_11_term_taxonomy: Table ‘wordpress- mu.wp_11_term_taxonomy’ doesn’t exist wp_11_term_relationships: Table ‘wordpress- mu.wp_11_term_relationships’ doesn’t exist wp_11_commentmeta: Table ‘wordpress- mu.wp_11_commentmeta’ doesn’t exist wp_sitemeta: 2 clients are using or haven’t closed the table properly * Any suggestions would be great! * Bill Viewing 9 replies - 1 through 9 (of 9 total)