WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Updated 2.5 to 3.0.4, but 1&1.com host... (23 posts)

  1. jerrypettit
    Member
    Posted 3 years ago #

    ...apparently isn't up to date?

    Error message:

    You cannot upgrade because WordPress 3.0.4 requires MySQL version 4.1.2 or higher. You are running version 4.0.27.

    Is this possible? 1&1.com was, I thought, pretty "industry-standard".

    Did I miss something here? Is there an older update I should be doing?

  2. *sigh* Kick 1&1. Tell them you need to be upgraded. They SHOULD have done this.

    Also do this: http://faq.1and1.com/scripting_languages_supported/php/5.html

    2.5 to 3.0 is a BIG leap by the way. Make EXCELLENT backups!

  3. jerrypettit
    Member
    Posted 3 years ago #

    Yeah, I made backups.

    And actually my blog is still "visible" at jerrypettit.com/blog -- I just can't access it any more as administrator.

    I did backup (did the "to the server" option AND then downloaded to my computer--I was surprised at the small size of the downloaded file...hope I did that right.

    I'm GOOGLING in meantime. Thanks for the quick input. I hope I get through this...

  4. Well if WP is choking on the SQL version, then the fix is to ... fix that.

    The Database won't be too big for most people. Mine's like 7 megs.

  5. jerrypettit
    Member
    Posted 3 years ago #

    And you're telling me that with respect to the PHP5 I can just open my current .htaccess file and add the line

    AddType x-mapp-php5 .php

    at the end of that file and all will be well with any PHP issue?

  6. jerrypettit
    Member
    Posted 3 years ago #

    GOOGLING "1&1.com MySQL version" got me to a run through on what I apparently need to do.

  7. For PHP yes.

    For SQL ... there's a way to upgrade that too? Wow. Okay, they're slightly less annoying than I thought :)

  8. jerrypettit
    Member
    Posted 3 years ago #

  9. jerrypettit
    Member
    Posted 3 years ago #

    Sigh...

    Did all that and get this message:

    "Error establishing a database connection"

    Where do I start?

    I upgraded to a MySQL database, exporting my old 4.0 database to 5.0.

    I put the line "AddType x-mapp-php5 .php" into my .htaccess (there is supposed to be a space before the period there, right?

    I put in my blog's URL and I get that error message...

  10. jerrypettit
    Member
    Posted 3 years ago #

    I lied--I forgot I had changed password and miswrote it in my wpconfig.php file.

    I seem to be "in".

    Thanks a million for all your help.

  11. esmi
    Forum Moderator
    Posted 3 years ago #

    Check the database hostname with 1&1. From what I recall, the host names are database specific on 1&1.

  12. jerrypettit
    Member
    Posted 3 years ago #

    Ok, I'm able to log in and access my dashboard now.

    And I was able to reselect my old theme and reactivate my plugins.

    So the install is seeing some of my stuff.

    One problem: Where are my old posts? The blog is not showing them--just a new "Hello World" post.

    (At least, I'm starting to get optimistic...)

  13. esmi
    Forum Moderator
    Posted 3 years ago #

    Are your old posts in the new database?

  14. jerrypettit
    Member
    Posted 3 years ago #

    That was my assumption. If everything else moved correctly, don't the posts move also?

    How does one check whether the old posts are successfully in the new database? I DID import the old MySQL database and read it into the new one...

  15. jerrypettit
    Member
    Posted 3 years ago #

    I went back to 1&1.com and logged in to see PHPMyAdmin and the old database does look different than the new one. (I don't really know how to "read" what's happening there.

    Apparently the "conversion" of databases didn't work? How do I fix this? Repeat the steps I apparently did erroneously before?! (Again, I do have these posts backed up).

  16. jerrypettit
    Member
    Posted 3 years ago #

    In my new 5.0 PHPMyAdmin screen of the new database, it shows these files:

    wp_commentmeta
    wp_comments
    wp_links
    wp_options
    wp_postmeta
    wp_posts
    wp_terms
    wp_term_relationships
    wp_term_taxonomy
    wp_usermeta
    wp_users

    Is that good? :-)

  17. Emil Uzelac
    Theme Review Admin
    Posted 3 years ago #

    the above looks good, BTW 1&1 can be pain.

  18. jerrypettit
    Member
    Posted 3 years ago #

    Hmmm...if that looks good, why is the database of my old posts (newly converted to a MySQL 5.0 database format) not showing the old posts in my blog.

    My blog (at http://www.jerrypettit.com/blog) is just showing 1 post--that I have put there today to explain that I am having upgrade problems.

    Where are the old posts, if it is looking like the MySQL conversion worked?!

  19. Emil Uzelac
    Theme Review Admin
    Posted 3 years ago #

    You have the backup right? if so, create new database, go to phpMyAdmin and import this again.

    Emil

  20. Emil Uzelac
    Theme Review Admin
    Posted 3 years ago #

    Oh one more thing, when you are in phpMyAdmin you can click on wp_posts and check what's inside, this is for future references to know if all is in.

  21. jerrypettit
    Member
    Posted 3 years ago #

    Ah...looked in wp_posts and indeed the transfer of the old database did NOT successfully take place.

    Getting late and my mind is fuzzy. I'll try again tomorrow from scratch, I guess.

  22. ParaGate
    Member
    Posted 3 years ago #

    Jerry:

    Does 1&1 provide WP installed or did you have to install it yourself on their servers?

    Thanks so much.

    Jeannie

  23. jerrypettit
    Member
    Posted 3 years ago #

    I had to install it myself.

Topic Closed

This topic has been closed to new replies.

About this Topic