wclark

Forum Replies Created

Viewing 9 replies - 1 through 9 (of 9 total)
  • Forum: Hacks
    In reply to: Custom Select Query for Displaying Posts Not Working
    wclark

    (@wclark)

    15 years, 7 months ago

    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
    In reply to: Custom Select Query for Displaying Posts Not Working
    wclark

    (@wclark)

    15 years, 7 months ago

    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
    In reply to: How To Do A Complete Wipe
    wclark

    (@wclark)

    15 years, 7 months ago

    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
    In reply to: How To Do A Complete Wipe
    wclark

    (@wclark)

    15 years, 7 months ago

    Delete your WordPress directory.
    Use mysqladmin to drop the database.
    Now everything is gone.

    Forum: Networking WordPress
    In reply to: "Error establishing a database connection" adding new site
    Thread Starter wclark

    (@wclark)

    15 years, 9 months ago

    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
    In reply to: "Error establishing a database connection" adding new site
    Thread Starter wclark

    (@wclark)

    15 years, 9 months ago

    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
    In reply to: "Error establishing a database connection" adding new site
    Thread Starter wclark

    (@wclark)

    15 years, 9 months ago

    I have been deleting the site I created, then trying again after trying a few config changes, such as disabling plugins.

    Forum: Networking WordPress
    In reply to: "Error establishing a database connection" adding new site
    Thread Starter wclark

    (@wclark)

    15 years, 9 months ago

    Yes, that is correct. Also, this is a fresh install of 3.0.

    Forum: Networking WordPress
    In reply to: "Error establishing a database connection" adding new site
    wclark

    (@wclark)

    15 years, 9 months ago

    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)