• Callum

    (@aic_technologies)


    Hi, Hoping this is the right place to post this.

    So I moved a website from one server to another server like I have done in the past with success. Only this time I get this above each page https://justpaste.it/hr2v

    Interestingly I moved another site, the blog for the same website across, which has its own WordPress install and it works completely fine.

    When I moved the sites across I moved the databases across but had to create a new user to access them. the same user accesses both databases. So it seems a bit odd to me.

    I really would appreciate any help with this. I had a look on Google but with no success.

Viewing 8 replies - 1 through 8 (of 8 total)
  • Thread Starter Callum

    (@aic_technologies)

    hmmm my lazyness may have made me miss the closeness of the errors in terms of only 2 lines on the 1 file.

    catacaustic

    (@catacaustic)

    The first line of that whole error is all that you need to worry about:

    Access denied for user 'wwwp1designcoma'@'localhost' (using password: NO)

    Fix that, and the rest should fall into place.

    What the error is telling you is that the database user that you’ve set up has the wrong password saved, so I’d advise you to go and double-check what you’ve got in your wp-config.php file and make sure that the database connection details in there are correct. Just remember that on a new server, there can be different settings needed, so if you are having a problem with it the first place to ask is your hosting comapny as they’ll be able to tell you exactly what you need to use for those settings.

    Thread Starter Callum

    (@aic_technologies)

    Thank you so much for that information.

    I have checked the config file and that all seems to be fine.

    This is the actual code it is referring to, which makes me think its something to do with some code somewhere referencing the ‘old’ datebase with a different cpanel username at its front.

    “//CHECK FUNCTION
    function check_db_existance($table) {
    global $wpdb;
    $tables = mysql_list_tables(DB_NAME);
    while (list ($temp) = mysql_fetch_array ($tables)) {
    if ($temp == $table) {
    return TRUE;
    }
    }
    return FALSE;

    }

    Thread Starter Callum

    (@aic_technologies)

    Looking at the database files its odd (at least to me) that the website/WordPress can get access to all the other ‘mysql stuff’ and is able to show posts, pages etc but not others, all of which seem to relate to the styling of the website.

    catacaustic

    (@catacaustic)

    The “old database name” is probably still set in your wp-config.php file unless you’ve changed it. If it’s been changed then I don’t know what’s happened because WordPress only takes the connection details from that one fle and nowhere else.

    It also sounds strange to me that it’s getting something from the databae, but not other info. Can you tell me exactly what it is and isn’t getting from the database?

    Thread Starter Callum

    (@aic_technologies)

    Its all style related minus the font and custom css. The other WordPress instance using the same user name works fine and has full access to both MySQLs.

    I cannot find any exact reference to any single DB that it might create but within MYSQL it looks like it has created “wp_dt-frontpages” “wp_dt-sidebars” “wp_dt-styles” and others like it.

    DT is short handed for the theme name.

    It looks like all the actual WordPress DBs are working fine.

    catacaustic

    (@catacaustic)

    When you moved servers, did you change the domain name, or folder, for the site? If you did, you’ll need to have to update the URL’s to the new site as it’s not as easy as just changing the site around. A lot of info needs to be changed in the database. when I do that, I use this tool.

    Just for reference, there’s pretty much nothing related to styles or CSS in the database unless your theme specifically stores some data there.

    Thread Starter Callum

    (@aic_technologies)

    No same site structure and URL.

    And yes you would not think that! I have never seen the theme designer’s approach before.

    Apparently the problem is caused by a completely unrelated issue, where the host provider has changed PHP versions from 5.3 to 5.5, and now I apparently am expected to fix the incompatibles ??

    I suspect its near pointless trying to get that kind of help on here givin it could be a big task not really in the realm of WordPress, so thank you so much for your help Catacaustic I really appreciate it.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Server Change Issue’ is closed to new replies.