Mail settings disappeared after changing site to HTTPS

  • Resolved eric3d

    (@eric3d)


    8 years, 3 months ago

    I recently changed a few sites from HTTP to HTTPS. Each time, the info in the Mail tab completely disappeared. The other tabs (Form, Messages and Additional Settings) remained.
    After having to retrieve the settings from a database backup for the first site, I copied the settings prior to the conversion so I could put them back in more easily. But it’s still a weird bug. I have a few more conversions to do and I will take a closer look to see exactly what move causes the problem.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter eric3d

    (@eric3d)

    8 years, 3 months ago

    Update: I converted 2 more sites.

    Site 1:
    The mail settings disappeared after I ran the SQL query to replace http://www.example.com with https://www.example.com

    UPDATE wp_options SET option_value = replace(option_value, 'http://www.example.com', 'https://www.example.com') WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE wp_posts SET guid = replace(guid, 'http://www.example.com', 'https://www.example.com');
UPDATE wp_posts SET post_content = replace(post_content, 'http://www.example.com', 'https://www.example.com');
UPDATE wp_postmeta SET meta_value = replace(meta_value, 'http://www.example.com', 'https://www.example.com');

    Note that the string http://www.example.com was present in Mail settings.

    Site 2:
    I edited the string http://www.example.com (added a ‘s’) in Mail settings before converting to HTTPS. I got a warning from WordFence requiring me to authorize that change. The mail settings did not disappear.

    In conclusion, I’m not sure whether the problem is caused by CF7 or by WordFence, and I don’t have any other site to convert at this time.

    Plugin Author Takayuki Miyoshi

    (@takayukister)

    8 years, 3 months ago

    UPDATE wp_postmeta SET meta_value = replace(meta_value, 'http://www.example.com', 'https://www.example.com');

    This query breaks the serialized array format in the database table so there is no wonder you can’t unserialize it to retrieve the array data for mail settings.

    Thread Starter eric3d

    (@eric3d)

    8 years, 3 months ago

    Thanks for the explanation. Problem solved.

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

The topic ‘Mail settings disappeared after changing site to HTTPS’ is closed to new replies.