?
Solved

wordpress site and https

Posted on 2016-09-15
10
Medium Priority
?
33 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 3
10 Comments
 
LVL 36

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 29

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 36

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
WordPress Tutorial 1: Installation & Setup

WordPress is a very popular option for running your web site and can be used to get your content online quickly for the world to see. This guide will walk you through installing the WordPress server software and the initial setup process.

 
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 29

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 36

Assisted Solution

by:Kimputer
Kimputer earned 2000 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 29

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 29

Accepted Solution

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

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 29

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

WordPress Tutorial 1: Installation & Setup

WordPress is a very popular option for running your web site and can be used to get your content online quickly for the world to see. This guide will walk you through installing the WordPress server software and the initial setup process.

Question has a verified solution.

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

Microservice architecture adoption brings many advantages, but can add intricacy. Selecting the right orchestration tool is most important for business specific needs.
This article discusses how to implement server side field validation and display customized error messages to the client.
The purpose of this video is to demonstrate how to reset a WordPress password if you are locked out and cannot reset the password. A typical use would be if you cannot access the email to which WordPress would send the password recovery email to…
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
Suggested Courses

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