Help needed with WP Database

Discussion in 'MySQL' started by gianniweb, Mar 29, 2009.

  1. #1
    I'm so frustrated since a couple of days I can't update my WP blog: no new posts, no new pages, no new users are allowed.

    I tried different ways to fix it as checking the database, a fresh WP installation and many other tips suggested here as changing theme, deactivating all plugins etc.but there is still no solution.

    I also changed the hosting provider and as in Dreamhost the only results were to get a not found page, with hostgator it shows a fatal error in the plugin.php page line 302 (more than 30 seconds passed)

    I definitely think that the problem is in the MySQL Database as it seems it couldn't be overwritten.

    Did someone experienced the same or a similar issue? I'd really appreciate any idea or suggestion as I'm afraid I'll have to rewrite my blog.

    Thanks to all
     
    gianniweb, Mar 29, 2009 IP
  2. Boulder

    Boulder Well-Known Member

    Messages:
    806
    Likes Received:
    46
    Best Answers:
    0
    Trophy Points:
    118
    #2
    What is the blog site URL? And what is the EXACT words (all of them) in errors you are getting?


    Can you login to the wordpress admin panel on this corrupted site?


    Boulder
     
    Boulder, Mar 29, 2009 IP
  3. gianniweb

    gianniweb Well-Known Member

    Messages:
    284
    Likes Received:
    12
    Best Answers:
    0
    Trophy Points:
    110
    #3
    Blog URL is here. Right now it's hosted with Dreamhost and the error is always redirected to a 404 not found page. I can access both the blog admin and the SQL server php Myadmin wherein I already repaired overhead tables.

    Thanks for your help
     
    gianniweb, Mar 29, 2009 IP
  4. Boulder

    Boulder Well-Known Member

    Messages:
    806
    Likes Received:
    46
    Best Answers:
    0
    Trophy Points:
    118
    #4
    So the error is just happen in admin when you try to save a post? And this happens with no plugins activated? Are you sure no plugins are activated? Like do you maybe have a sitemap plugin?

    Also does this host allow to have a php.ini file in the web http directories?

    Need to maybe see what these settings are set in your php.ini:

    max_execution_time = 30 ; Maximum execution time of each script, in seconds
    memory_limit = 32 ; Maximum amount of memory a script may consume



    Boulder
     
    Boulder, Mar 29, 2009 IP
  5. gianniweb

    gianniweb Well-Known Member

    Messages:
    284
    Likes Received:
    12
    Best Answers:
    0
    Trophy Points:
    110
    #5
    Error appears when I try to save a new post or adding a new page/user. Yes, this happens also with no plugin activated .I really doubt that DH allows you to have and set a php.ini file but it's possible with HG to configure that file easily. I have those settings but memory limit is 64M. Do you suggest trying to re transfer to HG and see what happens if I configure the max_execution_time to 60 or more?
     
    gianniweb, Mar 29, 2009 IP
  6. Boulder

    Boulder Well-Known Member

    Messages:
    806
    Likes Received:
    46
    Best Answers:
    0
    Trophy Points:
    118
    #6
    Ah maybe could try doing that... It does kind of sound like from your error that a function or action in your blog set up is needing more than 30 seconds to complete and it is not being allowed enough time to complete.

    But I am not yet sure why this is happening? It is a weird and rather rare error?


    Boulder
     
    Boulder, Mar 29, 2009 IP
  7. gianniweb

    gianniweb Well-Known Member

    Messages:
    284
    Likes Received:
    12
    Best Answers:
    0
    Trophy Points:
    110
    #7
    I manage many blogs and I've still not experienced an error like this. Also there is very poor documentation about it. Well, I will try to transfer again crossing my fingers.
    Thanks again
     
    gianniweb, Mar 29, 2009 IP
  8. gianniweb

    gianniweb Well-Known Member

    Messages:
    284
    Likes Received:
    12
    Best Answers:
    0
    Trophy Points:
    110
    #8
    I've also changed that values but still can't add nothing new. The new is that now wp admin board does not recognize the actual theme I'm using. It seems that the database couldn't be updated from any source.
     
    gianniweb, Mar 29, 2009 IP
  9. Boulder

    Boulder Well-Known Member

    Messages:
    806
    Likes Received:
    46
    Best Answers:
    0
    Trophy Points:
    118
    #9
    Humm.. okay wp admin board does not recognize the theme? This could be some of the issue right there.. Did you try different theme?


    Also can try this if you have not yet? Get (download) a brand new wordpress packages from wordpress and get the wp-admin and wp-includes folders from those and re upload those to your site..

    Do not just over right the old ones, but upload them complete... Just rename the old folders to like wp-admin_extra and wp-includes_extra and upload all new those two folders.


    Boulder
     
    Boulder, Mar 29, 2009 IP
  10. gianniweb

    gianniweb Well-Known Member

    Messages:
    284
    Likes Received:
    12
    Best Answers:
    0
    Trophy Points:
    110
    #10
    Ok, I'll try to change those folders. What about SEO if I definitely have to re write the entire blog?
     
    gianniweb, Mar 29, 2009 IP
  11. Boulder

    Boulder Well-Known Member

    Messages:
    806
    Likes Received:
    46
    Best Answers:
    0
    Trophy Points:
    118
    #11
    If you have to rewrite the whole blog just setup the link structure the exact same way it was and you will not lose any built links or SEO.

    You could also just import all the posts to the new install..

    Could maybe try two ways 1) Export the xml file from your old site and do the new install and import the xml file. 2) Make .sql dump file of your corrupt install via phpmyadmin and than make the new install.. Than go in phpmyadmin to new site database and drop the wp_posts table and than import just the wp_posts table section from the .sql file you previously made.

    See how that works?

    Just make a copy of the .sql file and open it and strip out all parts but the wp_posts table and import it to new install.


    Boulder
     
    Boulder, Mar 29, 2009 IP
  12. Codeworks

    Codeworks Peon

    Messages:
    103
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #12
    Codeworks, Mar 29, 2009 IP