Solved

wordpress site and https

Posted on 2016-09-15
10
18 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 26

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
 
LVL 30

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 26

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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
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 26

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 26

Accepted Solution

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

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 26

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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

These days socially coordinated efforts have turned into a critical requirement for enterprises.
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
The purpose of this video is to demonstrate how to manually back up a WordPress Database. This will be demonstrated using a Windows 8 PC. The Host used will be IPage.com Log into your Hosting account. IPage will be used for demonstration : Locat…
The purpose of this video is to demonstrate how to set up the permalinks on a WordPress Website. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Go t…

760 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now