no dashboard

unsureifwant
(@unsureifwant)

3 months ago

A small issue has turned into a huge one. A small section of one page was not present. Was turning on debugging, and instead I locked myself out of the server because I assumed my local and production wp-config were the same, and I overwrote my server’s user and password with my local version. I tried to fix it myself, and by the time I was informed of the backups that exist on my host, they’d overwritten and none were old enough to fix the issue.

I go to phpmyadmin, and there are only 4 users in there. I reset passwords for all of them, and try them all one by one. None of them appear to be the db user I created the site with. I don’t understand how that can be, because I definitely didn’t delete a user, just unknowingly changed to invalid credentials.

I’m allowed in with one user, but have missing posts and functionality. I backup my perfectly working local site and restore it – db, uploads, and theme. This resulted in the error messages at the link now. It mentions errors on line 6000 of functions php. Functions php is less than 100 lines. I’ve encountered errors similar to this when using react. In the case of react, it’s always something that saves without an error, but is somehow an unacceptable input for the underlying JS.

I tried using filezilla to just copy over the entire theme folder, but that made no difference. I’m at a loss. Any help would be appreciated.

The page I need help with: [log in to see the link]

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

r1k0
(@r1k0)

2 months, 4 weeks ago

Hey @unsureifwant,

I understand this a frustrating situation, but no need to worry, it is fixable.

When restoring the database from the local site, did you change the site_url and home values in your database to match your site’s URL? If not, change them to the correct values, as a mismatch can lead to your site breaking.

Currently, on the frontend of your site, those are warnings and notices and not fatal errors. You can stop showing them in the frontend by changing this line in your wp-config define('WP_DEBUG_DISPLAY', false);

After everything is stable, you can use a plugin like “Better Search Replace” to replace all the URLs from the local one to the live site one.

Give this a try.

Thread Starter unsureifwant
(@unsureifwant)

2 months, 4 weeks ago

If not, change them to the correct values, as a mismatch can lead to your site breaking.
r1k0

so how do I change the values and then back up the db so that I can fix my host? cause I changed the value and now I have no dashboard on my local site.

r1k0
(@r1k0)

2 months, 4 weeks ago

The values should be under wp_optionsunder the option_name siteurl and home. Click the edit button for each these rows, enter the values in the option_value field, then click Go button at the bottom.

Example: If you are on your local site database, the siteurl and home value should be something like http://localhost/… and not http://roland.lazenby.media.
If you are on your live site database, they should be http://roland.lazenby.media and not http://localhost/….

To back up your database, navigate to phpMyAdmin and select your WordPress database. Click the “export” tab, select the “Quick” option, and click Go. This should back up your entire database. This guide should also help: https://developer.wordpress.org/advanced-administration/security/backup/database/

However, there is one thing I need clarification about. Are you not able to access the local site’s dashboard or the live site’s dashboard, or both?

Thread Starter unsureifwant
(@unsureifwant)

2 months, 4 weeks ago

@r1k0

I am currently locked out of both my local and my production sites, both with no dashboard.

When I first posted, my local site was working perfectly. I applied your advice, but I thought I would have to change the values in general settings, then backup and somehow make those changes on production. Instead, I broke my local site (which is run on Local. Perfectly not confusing!).

After you clarified I need to make these changes by changing the db, I found what you were talking about for my production site in phpmyadmin. The values you spoke of were both already https://roland.lazenby.media, I forget their exact names, but they were the first two listed in wp_options.

I have not fixed my local site yet, I’m much less familiar with Local’s db interface. I’ll start digging.

Thread Starter unsureifwant
(@unsureifwant)

2 months, 4 weeks ago

Got my local site working…sort of. It has no styling and half a dozen warnings at the top. It worked without any problems at all prior to going into the admin panel and changing the general settings…the same values that correspond to the two you mentioned. I restored them to localhost:3000 (prefixing http:// did not work). I thought restoring the two values to what they were before would completely fix the issue. It did not.

These are my local errors that appear with an unstyled homepage.

Warning: Undefined array key “scheme” in C:\Users\sprit\Local Sites\newlazenby\app\public\wp-includes\canonical.php on line 752

Warning: Undefined array key “host” in C:\Users\sprit\Local Sites\newlazenby\app\public\wp-includes\canonical.php on line 717

Deprecated: strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in C:\Users\sprit\Local Sites\newlazenby\app\public\wp-includes\canonical.php on line 717

Warning: Undefined array key “host” in C:\Users\sprit\Local Sites\newlazenby\app\public\wp-includes\canonical.php on line 728

Warning: Undefined array key “host” in C:\Users\sprit\Local Sites\newlazenby\app\public\wp-includes\canonical.php on line 731

Warning: Undefined array key “scheme” in C:\Users\sprit\Local Sites\newlazenby\app\public\wp-includes\canonical.php on line 752

Lucian Padureanu
(@lucianwpwhite)

2 months, 4 weeks ago

@unsureifwant this is related to your local not production – and assuming you are using the latest WP core version – can you please check in the WP_OPTIONS table and make sure these two exist and are valid?

siteurl = http://localhost:3000
home = http://localhost:3000

Might also worth trying (but make sure you backup the site first) adding this to your wp-config.php file (just above the line that says “That’s all, stop editing”):

define(‘WP_HOME’, ‘http://localhost:3000’);
define(‘WP_SITEURL’, ‘http://localhost:3000’);

I hope this helps

Thread Starter unsureifwant
(@unsureifwant)

2 months, 4 weeks ago

@lucianwpwhite

can you please check in the WP_OPTIONS table and make sure these two exist and are valid?

I restored them to localhost:3000 (prefixing http:// did not work).

Local somewhat works when siteurl and home are localhost:3000, but has no styling, the links aren’t functional, and there is no dashboard.

Placing these in the wp-config

define(‘WP_HOME’, ‘http://localhost:3000’);
define(‘WP_SITEURL’, ‘http://localhost:3000’);

resulted in bad syntax warnings. The discussion board must use different quotations. Had to change it to standard single quotes.

define(‘WP_HOME’, ‘http://localhost:3000&#8217’);
define(‘WP_SITEURL’, ‘http://localhost:3000&#8217’);
like so. However, it results in the same partially functioning site with no styling.

r1k0
(@r1k0)

2 months, 3 weeks ago

Hello again @unsureifwant,

Were you able to get the issue fixed on your local site?

Your production site still has an error. There is a fatal error on your live site related to the theme you are currently using. I believe it’s a custom theme. I also noticed that when trying to access the wp-admin page, it redirects to: https://localhost:3000/wp-admin/upgrade.php?_wp_http_referer=%2Fwp-admin%2F

I would love to hear any progress that you have made and any other updates, so I might be able to assist you further.

Thread Starter unsureifwant
(@unsureifwant)

2 months, 3 weeks ago

@r1k0

Yes it’s a custom theme. Production is now fixed. The whole process even fixed the error I originally had.

My local is still borked. I don’t remember whether home & siteurl was localhost:3000 or http://localhost:3000. However, the site partially loads without the http:// prefix, and does not load at all with the full url. It is loading an unstyled site with non-functional links that all lead back to the same page. I’m puzzled.
Thread Starter unsureifwant
(@unsureifwant)

2 months, 3 weeks ago
@r1k0

Couldn’t fix the problem, so I just made another Local site. I had db/uploads/plugins/themes, so it took 20 minutes. Thanks for the help.
- This reply was modified 2 months, 3 weeks ago by unsureifwant.
r1k0
(@r1k0)

2 months, 3 weeks ago

Hello again,

I’m glad that you were able to get everything running again.

I found out why your local site wasn’t functional. I believe the correct home and siteurl value should have been: http://newlazenby.local

Best of luck

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

You must be logged in to reply to this topic.

no dashboard

Topics

Topics with no replies

Non-support topics

Resolved topics

Unresolved topics

All topics