WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] WP transfered - DB broken, help :) (19 posts)

  1. theserpent
    Member
    Posted 3 years ago #

    Hello,
    as the title says i just transfered my wp site to a new host and its all wrong...

    * First, I FTPed everything in public_html folder (kind of drag'n'drop) from old host to new host.

    * I created an empty MySQL database and username on the new host and they uploaded for me the old database (56meg but was too heavy) that I exported from the old host using PHPMyAdmin (with drop old table option) and put it into the new empty database.

    * Finally I changed in wp-config.php the db and username/pw to suit the new database and.... nothing works... :'(

    what am I doing wrong?

    - My website have 2 WP sites one in english and same in french) in 2 different folders (en & fr) using the same database.

    - I cant login to WP on neither of them, and the en one shows a white page with this

    Deprecated: Assigning the return value of new by reference is deprecated in /home/paint549/public_html/xclone-en/wp-includes/cache.php on line 103

    Deprecated: Assigning the return value of new by reference is deprecated in /home/paint549/public_html/xclone-en/wp-includes/query.php on line 61

    Deprecated: Assigning the return value of new by reference is deprecated in /home/paint549/public_html/xclone-en/wp-includes/theme.php on line 1109

    Parse error: syntax error, unexpected $end in /home/paint549/public_html/xclone-en/wp-includes/rewrite.php on line 1653

    The french site displays ( but is lame) and shows those lines on top

    Deprecated: Assigning the return value of new by reference is deprecated in /home/paint549/public_html/fr/wp-includes/cache.php on line 103

    Deprecated: Assigning the return value of new by reference is deprecated in /home/paint549/public_html/fr/wp-includes/query.php on line 61

    Deprecated: Assigning the return value of new by reference is deprecated in /home/paint549/public_html/fr/wp-includes/theme.php on line 1109

    I have no longer access to the old host data and cant export anymore.

    Can someone help me?
    Is it possible to unscrew it or to get back acces to data in there?

    Thank you so much,

    Max

  2. esmi
    Forum Moderator
    Posted 3 years ago #

  3. theserpent
    Member
    Posted 3 years ago #

    of course, i forgot to say I followed http://codex.wordpress.org/Moving_WordPress but no suitable help for me on there, idem for other "database transfer" related posts on this forum. (tried to remove error reporting etc...)

    I also used Xcloner plugin but the same happens. DB is broken.

    My website is mostly pages and not a blog, can I save their html code some how? or import them from a new WP install?

    The thing is I cannot log in to the old wp to do any edit or proper export, know what i mean?

    So can I do anything either to fix the DB or to recover some pages, stats from an import? any sugestions please

  4. esmi
    Forum Moderator
    Posted 3 years ago #

    Perhaps it's an issue with the xcloner plugin - in which case, you could try posting something in the Plugins forum.

  5. theserpent
    Member
    Posted 3 years ago #

    sure, but it doesnt work even without the xcloner, which is just a faulty optional solution.
    so,
    same db - same site - same url - new host....

    php version problem maybe? now its php 5.36, the old one was prolly
    How can i fix this?

    can I tap into the code ? export some part of the db only?
    help!!!!
    thanks :)

  6. esmi
    Forum Moderator
    Posted 3 years ago #

    It won't be the same db as you've moved hosts, so you're looking at new MySQL and web servers. I doubt it's a PHP version issue. Anything running PHP 5x should be fine.

    Your old site was WP 2.7.1, yes? Did you install 2.7.1 on the new host? If not, that's where the problem is. You can't restore a 2.7.1 db into a 3.1x WordPress install. You'll need to install 2.7.1 first, restore the db and then carry out a series of upgrade steps:

    2.7 -> 2.9 -> 3.0.4 -> 3.1.3

    to get back up to date.

  7. theserpent
    Member
    Posted 3 years ago #

    you sussed it out! very clever!
    cheers :)

    the thing is i didnt install wordpress on my new server, but just drag n drop the one from the old server.
    and it doesnt work, I cannot log in.
    so i install 2.7.1 and how do i set the db to the one existing already?
    Huge thanks esmi for this lead :)

  8. theserpent
    Member
    Posted 3 years ago #

    er, right

    I cant instal 2.7.1 because it says its already installed

    Already Installed

    You appear to have already installed WordPress. To reinstall please clear your old database tables first.

    The database it wants me to remove was a pain to upload cause too big,
    i had to finally have my host put it up for me cause its 56 meg, not much, but apparently much more than sql upload limits, so i'm not erasing it.

    if WP is already installed, how come I cant access it or login?
    im v confused and would aprreciate your help
    thanks

  9. theserpent
    Member
    Posted 3 years ago #

    I removed every folder in my public_html, except the original DB my host did put online for me (i dont know where this files is on the server) followed the 5 steps instal,) uploaded the 2.7.1 version in a folder called new.
    When I run the install, I set up the wp-congig.php to the DB, and install says

    Deprecated: Assigning the return value of new by reference is deprecated in /home/paint549/public_html/new/wp-includes/cache.php on line 103

    Deprecated: Assigning the return value of new by reference is deprecated in /home/paint549/public_html/new/wp-includes/query.php on line 61

    Deprecated: Assigning the return value of new by reference is deprecated in /home/paint549/public_html/new/wp-includes/theme.php on line 1109

    Warning: Cannot modify header information - headers already sent by (output started at /home/paint549/public_html/new/wp-includes/cache.php:103) in /home/paint549/public_html/new/wp-admin/install.php on line 36
    WordPress
    Already Installed

    You appear to have already installed WordPress. To reinstall please clear your old database tables first.

    :'(

    How can I do??

  10. esmi
    Forum Moderator
    Posted 3 years ago #

    Set up a new database and install WP 2.7.1 using the new db for now.

  11. theserpent
    Member
    Posted 3 years ago #

    Ok I installed a new WP v3.0 and downgraded step by step using more or less this trick btw to 3.0 then to 2.9 to 2.8 to my good ole 2.7.1 and this 2.7.1 refused to vurk!! so i downged to 2.7 to reup to 2.7.1 and it stills vurks as 2.7. (without the one) but fine.
    Now when i change the wp-config.php of this WP version to connect to the old DB, it crashes and shows

    Fatal error: Call to undefined function plugin_dir_url() in /home/paint549/public_html/automatic/wp-content/plugins/akismet/akismet.php on line 32

    Probably the plugins who were not deactivated are messing around.

    Anything I can do? deactivate them in the DB directly using phpmyadmin? im not too confident in php tho...

    I copied a new WP v2.7.1 in a folder as you said and will see what it does, to what db i should connect? create a new one?

    huge thanks

  12. esmi
    Forum Moderator
    Posted 3 years ago #

    I'd create a new one.

  13. theserpent
    Member
    Posted 3 years ago #

    So
    I installed this separate 2.7.1 version and I enter my old db details and it doesnt work.... How come? the bd is not broken. could it be the plugs ? i can read all the DB tables in phpmyadmin, there fine, they are there, how can i connect WP to it? argh

    Deprecated: Assigning the return value of new by reference is deprecated in /home/paint549/public_html/wordpress271/wp-includes/cache.php on line 103

    Deprecated: Assigning the return value of new by reference is deprecated in /home/paint549/public_html/wordpress271/wp-includes/query.php on line 61

    Deprecated: Assigning the return value of new by reference is deprecated in /home/paint549/public_html/wordpress271/wp-includes/theme.php on line 1109

    Warning: Cannot modify header information - headers already sent by (output started at /home/paint549/public_html/wordpress271/wp-includes/cache.php:103) in /home/paint549/public_html/wordpress271/wp-admin/install.php on line 36
    WordPress
    Already Installed

    You appear to have already installed WordPress. To reinstall please clear your old database tables first.

  14. esmi
    Forum Moderator
    Posted 3 years ago #

    Try resetting the plugins by phpMyAdmin.

  15. theserpent
    Member
    Posted 3 years ago #

    Thanks for your precious help!
    I desactivated the plugin in phpmyadmin, and changed the db connection and it worked, i could log in with all in there hurray!! but the website didnt display....
    any ideas what it could be?

    same WP version, same database, plug frees (btw they dropped somewhere while deactivating), should work? some more tweak in phpMyadmin?

    THANK YOU!

  16. esmi
    Forum Moderator
    Posted 3 years ago #

    Try renaming all themes in the wp-content/themes - except twentyten or default - to force the default theme to activate (just in case you have a theme problem).

  17. theserpent
    Member
    Posted 3 years ago #

    esmi you rock!
    it was the theme indeed, what a crazy mess its all been!
    now I still have to retune everything but the site works again!
    and dude, i made it with your help
    thank you very much
    rock on!

    :)

  18. esmi
    Forum Moderator
    Posted 3 years ago #

    Yay! Really glad to hear that you're back up & running again :-))

  19. theserpent
    Member
    Posted 3 years ago #

    Thanks again!!! :)

Topic Closed

This topic has been closed to new replies.

About this Topic