WordPress.org

1. SavoryMedia
   Member
   Posted 6 years ago #

   Okay...here goes:

   I have a brand new install of wordpress (2.0.2) that I put together on one host. My partner and I decided to change hosts, so we signed up for the new host and migrated the site over to the new host.

   I used the backup instructions for the database (using phpMyAdmin) from the codex and copied the whole site completely over to the new host. I used the command line (shell) instead of phpMyAdmin to install the backed up database to the new host and everything seems to be working fine...until I try to make changes to any of the existing data (posts, BDPRSS plugin feed settings, etc). When I try to change anything, WP says it changed it, but the database doesn't update.

   I'm wondering if this is because I used the command line instead of phpMyAdmin to install the database. The site is supposed to launch this evening and I'm in a pickle. Any help would be greatly appreciated.

   Thanks in advance,
   MJ

2. Mark (podz)
   Support Maven
   Posted 6 years ago #

   The DNS has moved successfully?

3. SavoryMedia
   Member
   Posted 6 years ago #

   Yep. The DNS has moved fine.

   I've also noticed through some tweaking that updating posts and such works okay, but some plugins can't update the database...in my case...BDPRSS feed aggregator.

   I'm starting to think some of the files may have been messed up by the previous host or during transfer. I'm trying a few more things to see if they fix the problem.

4. Mark (podz)
   Support Maven
   Posted 6 years ago #

   Check that /wp-content/cache either does not exist or if it does, delete everything in it ?

5. SavoryMedia
   Member
   Posted 6 years ago #

   /cache is there. You mean I should delete every single file in there...even the empty index.php files and subfolders?

6. SavoryMedia
   Member
   Posted 6 years ago #

   Cleared the /wp-content/cache folder and no help. Even went into BDPRSS settings and hit the "delete everything" option (which wipes out everything for BDPRSS and even recreates the tables for the plugin) and still no help. When I poll the feeds I've entered, they just won't update. It won't put the data from the feeds into the database.

7. Chris_K
   Member
   Posted 6 years ago #

   2 questions that may or may not be helpful.

   1) What version of WP were you running before you migrated to this new host?

   2) Do you know what version of MySQL the new host is running? And, not sure if this matters, but is it in "strict" mode?

8. SavoryMedia
   Member
   Posted 6 years ago #

   HS:

   I was running 2.0.2 on the old server as well.

   About MySQL... I'm not sure. The new host is Dreamhost, if that tells you anything.

   (I don't know the shell command to show the versions of PHP or MySQL.)

9. Chris_K
   Member
   Posted 6 years ago #

   I'm not a mysql expert ... so might be talking out my hat here, but can you verify that your mysql user (as specified in wp-config.php) has full access to your database?

10. SavoryMedia
    Member
    Posted 6 years ago #

    Yep. The db user has all priviledges... and I just found out that DH is running MySQL 5.

    Do certain plugins have problems with MySQL 5?

11. SavoryMedia
    Member
    Posted 6 years ago #

    BTW, the site is running PHP 4.4.2, if that might have anything to do with it.

12. Chris_K
    Member
    Posted 6 years ago #

    Not that I'm specifically aware of. But turning off the plugins would be a good way to test that I reckon.

    I had asked about it as I had, a few months back, a rough experience with mysql 5 in strict mode. I *think* that has been resolved with 2.0.1 or .2, but older plugins might suffer similar issues.

    And yeah, I'm guessing! Turning 'em off is worth a shot and hopefully someone brighter will chime in.

13. SavoryMedia
    Member
    Posted 6 years ago #

    The problem is... turning off the plugin I'm having a problem with will kill a large chunk of functionality on the site.

    I may have to go with some other feed aggregator plugin...but I haven't found one that's as easy to use and does exactly what I want it to do like BDPRSS does.

    *bangs head against the desk*

14. SavoryMedia
    Member
    Posted 6 years ago #

    I found the problem:

    Dreamhost has allow_url_fopen disabled, but cURL works.

    Does anyone have any idea on how to replace allow_url_fopen functions with cURL functions in a plugin?

15. Chris_K
    Member
    Posted 6 years ago #

    That rings some bells. I didn't dig too deep, but I know that's been discussed a time or two. Try these search results and see if anything bubbles up:
    http://wordpress.org/search/dreamhost+curl?forums=1

16. SavoryMedia
    Member
    Posted 6 years ago #

    HS: Thanks for the link. I'm looking around but not finding much. I decided to post another thread asking for specific help on replacing allow_url_fopen with cURL in a plugin.

Topic Closed

This topic has been closed to new replies.