Solved

wordpress site and https

Posted on 2016-09-15
10
21 Views
Last Modified: 2016-09-20
This must be the 5th question I have asked in september, versus an average of 2 questions a year previously.  I have just changed the url settings in my wordpress site to https from http and now have lost access (can still ftp).  Is there an easy way to change the url back using ftp?

Some things I have already tried:

I turned wp_debug on
I can't find http settings in the wp--config.php file
I don't see an https setting in the functions.php or vars.php files
0
Comment
Question by:Thomas Zucker-Scharff
  • 6
  • 3
10 Comments
 
LVL 35

Expert Comment

by:Kimputer
ID: 41799921
it's in the database. FTP phpmyadmin files, and login through there (or your ISP already has phpmyadmin).
Should be in the options database, option_id = 1 and option_name = siteurl
0
 
LVL 27

Author Comment

by:Thomas Zucker-Scharff
ID: 41799932
I don't believe I have phpmyadmin, do I?  How would I tell?  I don't believe I have ever seen it (I have seen this when I set up my own wordpress on my local machine).

BTW, I get an error of:"threatswidget_Widget is deprecated since version 4.3.0! Use __construct() instead. in /home1/chronoto/public_html/tom/wp-includes/functions.php on line 3767"
0
 
LVL 35

Expert Comment

by:Kimputer
ID: 41799936
PHPMyAdmin should be available in one of the portal / control panel sites provided by your ISP.
Otherwise, do it yourself, download it from here: https://www.phpmyadmin.net/downloads/
Put it in a folder with a unique name (don't use the standard name, malware/crackers/crawlers just love it).
Point your browser to that url, and it will present you with a login screen, use your mysql credentials to access your WP database.
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
LVL 31

Expert Comment

by:Marco Gasi
ID: 41799938
No points for this, thanks.
You can download HeidiSQL and establish a connection to your remote database through this light, effective and free software :)
0
 
LVL 27

Author Comment

by:Thomas Zucker-Scharff
ID: 41800004
I am a user when it comes to wordpress.  I have had some success in somethings, but I don't know php or much about the wp core.  So keeping that in mind, How exactly am I suppposed to do this.  Do I upload the phpadmin download?  HeidiSQL seems like a great tool if I can get it to work, no luck so far.  I am not sure of the settings it wants and even if I get them correct will it allow me to access the site files when I have 2fa turned on?
0
 
LVL 35

Assisted Solution

by:Kimputer
Kimputer earned 500 total points
ID: 41800051
Download the newest zip file from phpMyAdmin, create a a new folder on the FTP server just under the root folder of where your web files are give it a somewhat random name, like phpmyadmin00111--
Unzip or transfer it with the folder structure intact.

create a new config subfolder
move config.sample.inc.php to the config folder and rename it config.inc.php

Now point your browser to:

yourwebsite.com/phpmyadmin00111--

Login with your mysql credentials

If the MySQL server is not the same server as the webserver (for bigger hosting companies), adjust it in the config.inc.php file:

$cfg['Servers'][$i]['host'] = 'othermysqlserver.com';
0
 
LVL 27

Author Comment

by:Thomas Zucker-Scharff
ID: 41800093
I believe I need more help.  I don't know if my webserver and mysql server are different or the same.  My son created this wp subsite on his server. He is very literate when it comes to wordpress, and I have asked him for help as well.  Unfortunately he is at a online journalism meeting for the next couple of days.  Even so I have been communicating with him via google hangouts, but so far, no luck.
0
 
LVL 27

Accepted Solution

by:
Thomas Zucker-Scharff earned 0 total points
ID: 41800108
I have backups, is a restore easier?
0
 
LVL 27

Author Comment

by:Thomas Zucker-Scharff
ID: 41800109
The only error I see in the error logs recently is

[14-Sep-2016 22:01:53 UTC] WPHP-> called: wphp_query_posts_where
[14-Sep-2016 22:01:53 UTC] WPHP-> called: wphp_query_posts_join
0
 
LVL 27

Author Closing Comment

by:Thomas Zucker-Scharff
ID: 41806217
I have decided to go the restore route.  I intend to install the phpmyadmin again after the restore id finished - so thanks Kimputer.  As far as HeidiSQL goes, it looks great, but I, for one, don't know the settings to put in.  If I find this to be the tool of choice - as it looks like it could be -, I will post a comment here regarding that.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
PHP and google maps 13 44
Need to disable SSL Cipher 7 61
Can't find PHP files on account that has WordPress 3 26
URGENT - Wordpress site missing  theme 9 41
SSL stands for “Secure Sockets Layer” and an SSL certificate is a critical component to keeping your website safe, secured, and compliant. Any ecommerce website must have an SSL certificate to ensure the safe handling of sensitive information like…
3 proven steps to speed up Magento powered sites. The article focus is on optimizing time to first byte (TTFB), full page caching and configuring server for optimal performance.
This video teaches users how to migrate an existing Wordpress website to a new domain.
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question