Lost access to my wordpress site

I would like to start by saying that i had never used previously hestia, so im not really familiar with how everything works. Some weeks ago i wanted to create an online website, purchased a domain, rented a Linode VPS and then, install hestia on it (from which i downloaded wordpress). My original domain (lets call it mydomain.online) was created with an admin account. I got a notification saying that i shouldnt be creating websites with my admin account, so i went on, created a new one and went along. I forgot to delete the original domain, so on my seconds account, i created the website sr1.mydomain.online, on which i downloaded wordpress and on which i had set up everything. However, i knew that it wasnt really professional to use subdomains on these, so i saw this option on wordpress, and said oh cool, changed it to mydomain.online without giving a second thought.

Now, i obviously couldnt access my wp site throughout any way. I get an imagen saying We’re working on it! This site is currently under construction. But i still cant access.

I can see on hestia, i can see that my website is worth of 900mb, but i cant access it in any way.
I also went on to the wpconfig.php file on hestia, and added the following code to try and regain access to my website the previous way (since i no longer really care about the subdomain thing)
define( ‘WP_HOME’, ‘http://yoursiteurl.com’ );
define( ‘WP_SITEURL’, ‘http://yoursiteurl.com’ );
But this didnt work neither. Is anything i can do? I just want to regain access to my site. I spent so much time setting it up.

There are plenty of ways to do so, if you are not extremely technical the easiest way would be to access phpmyadmin from the Database page, move into the wp_options table (the db prefix might change if you have customised it) and locate the row that has home and siteurl as option_name and change their values

I would do that, but i get an error 404 after trying to access phpmyadmin. It has been like that ever since i created the site, there is any way to fix that?

You can install wpcli and then run a search and replace, alternatively, the lines you posted are correct and should work but:

  1. Be sure to use the right single quote sign, it’s ' not ’
  2. Be sure to add it before the “That’s all” line

Yes, there is.

Run these commands as root:

chown -R root:www-data /etc/phpmyadmin/
chown -R hestiamail:www-data /usr/share/phpmyadmin/tmp/

I checked it and it should be fine, since its the same syntax. Still, i cant seem to get it to work

Are you sure you are using sr1.mydomain.online as your domain when editing wp-config.php?

I ran those commands and i still cant access phpmyadmin. Same error and everything. I placed those commands using PuTTY but i got no confirmation message or anything, i dont know if that might be related?
Im sorry for asking so many things, but i really need my website to be back and i dont know what else to do

Yep, i am. And i get the We’re working on it! After trying to access the site

What if you add a query at the end of the URL like ?test, give it a try just to exclude a local cache issue

same issue. Now i am only getting the message that the url doesnt exist, and for the mydomain.online the we’re working on it message (since as i said, i didnt bother with that one. Created, but i did every configuration for the sr1 one)

Install wpcli so that we can check which is the domain currently set as primary and eventually do a search and replace

sure. would you mind letting me know what’s the command for that? i dont want to make a bigger mess

Let’s say your Hestia user is gulirecs and your domain is example.net. Replace the user and domain with the real data.

If you are not logged as root yet:

sudo su -

Once you are root:

v-add-user-wp-cli gulirecs

When executing above command, if you see this error; Error: For user name 'gulirecs' WP-CLI already available! then wp cli is already installed for your user so there is no problem, and you can continue.

v-change-user-shell gulirecs bash
su - gulirecs

Now you are logged as user gulirecs:

cd web/example.net/public_html/
export PATH="~/.wp-cli/:$PATH"

Now you can use the wp commands that @Ade will share to you.

Once finished, logout from user gulirecs.

logout

Now you are root again, so remove the shell for the user gulirecs:

v-change-user-shell gulirecs nologin

Alright, im logged as the other user, admin(i had 2 users on hestia. admin and secondary user which we will call gulirecs) gulirecs was using example.net , and admin sr1.example.net. now that im logged as admin, do i execute those commands, exactly as that? (obviously changing example to the one i created)
cd web/example.net/public_html/
export PATH=“~/.wp-cli/:$PATH”
just want to be sure

just executed the command

To view the actual options:

 wp option get home
 wp option get siteurl

To change the options:

wp option update home "https://sr1.example.net"
wp option update siteurl "https://sr1.example.net"

i used those commands and the sr1 seemed to be there already. I executed the commands incase anything was wrong, but i got the same result. Just added an image of my site. I dont even get an error, it simply says that the site doesnt exist. I have tried on many search engines and got the same result. Wouldnt it be possible to export the files or something? And use them on another subdomain. As far as i can see on Hestia, the site is supposed to be working

A while ago I sent a private message to you, take a look.

1 Like

Could you send me a new private message? just received a notification that i couldnt send more messages due to being a new user