Setup and Config seems off

  • Hi,

    I recently moved my website from a subdomain dev.example.com/wp to the main domain example.com, overwriting the old website that used to be on the main domain.

    I got a big assist from my hosting company who essentially did this for me, as when I tried and starting deleting files, I was met with a blank screen of death. (they said an htaccess file was missing which is strange since I know I had one there).

    Anyway, since they helped with the move, the site has been pretty unstable.

    I have found the site appearing like this: https://snag.gy/cF3qU.jpg

    And today have found the url pointing to the OLD website with an error message about a Deprecated: mysql_connect.

    https://snag.gy/v5ooK.jpg

    I no longer have confidence in my hosting company to resolve these issues. Any advice on what could be wrong and how I could easily fix on my own? Please keep in mind that I am a huge beginner so be gentle and detailed and kind with any explanation.

    Thank you

Viewing 2 replies - 1 through 2 (of 2 total)

  • I see you have been working at this for a while, and I think your solution might be relatively simple.

    moved my website from…dev.example.com/wp to…main domain example.com

    That changed the server path leading to it.

    my hosting company…essentially did this for me…said an htaccess file was missing…

    Dashboard > Settings > Permalinks should ultimately take care of that.

    since they helped with the move, the site has been pretty unstable.

    It sounds like your database did not get updated with the new URL and path.

    I no longer have confidence in my hosting company to resolve these issues.

    Being fair to them, they are not actually required to even know how to move WordPress in every kind of manner possible.

    Here is some SQL that should work at cPanel > phpMyAdmin to tell your database to recognize https://example.com or https://www.example.com (you choose) as incoming and to then tell WordPress to use that while looking for all of its related wp-folders and wp-files.php…

    cPanel > phpMyAdmin SQL
    note: Edit ‘pref’ (three places below) to your own table_prefix and change ‘https://www.olddomain.com’ and ‘https://www.newdomain.com’ as required (three places each and with no trailing slashes)

    UPDATE pref_options SET option_value = replace(option_value, 'https://www.olddomain.com', 'https://www.newdomain.com') WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE pref_posts SET guid = replace(guid, 'https://www.olddomain.com', 'https://www.newdomain.com');
UPDATE pref_posts SET post_content = replace(post_content, 'https://www.olddomain.com', 'https://www.newdomain.com');

    A full backup of the existing tables should be made before using that code, and we can either walk you through from here or you can show that to your host and ask them to edit and run it.

    Thread Starter csigabiga83

    (@csigabiga83)

    Thank you for your reply. My host company seems to have dealt with the issue. If it returns however I will be sure to follow this guide and may need help / walkthrough backing up existing tables

    Thank you again for your assistance

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Setup and Config seems off’ is closed to new replies.