Support

Admin Tools for WordPress

#38941 Akeeba Backup Creating 404 error after site restoration from localhost.

Posted in ‘Admin Tools for WordPress’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

WordPress version
6.2
PHP version
8.1
Admin Tools version
7.8.1.1

Latest post by tampe125 on Monday, 08 May 2023 02:05 CDT

tmichel

I have tried three times to migrate the website from http://localhost/vnalexander.com to https://vnalexander.com and though the site looks good at first glance, when attempting to access links on the site I get 404 Page Not Found errors. In other words I tried several different path replacement values including the default in an attempt to get the links to work, but was not successful.

Currently I am redirecting the site to https://victorianalexander.wordpress.com/ so visitors are not presented with the 404 Page Not found errors until I get this resolved.

Curiously the Akeeba Backup installer adds a redirect of https://victorianalexander.wordpress.com/ to .htaccess, and I am not sure why this is happening, though we have had the domain pointed to https://victorianalexander.wordpress.com/ for a couple of months now.

I can provide back-end access if you notify me that you would want back end access and I will take the redirect to https://victorianalexander.wordpress.com/ out of .htaccess for that purpose.

I would assume that the links are being corrupted in the database, but can't imagine how to resolve this issue which is why I turn to you.

tampe125
Akeeba Staff

Hello,

I suspect that creating a local site with the same domain is breaking the replacement step. Can you please do a quick test?

Please backup your local website and restore it locally to a different folder (ie localhost/justatest ). Then on the new restored website take another backup and then restore that backup to https://vnalexander.com

That should do the trick

Davide Tampellini

Developer and Support Staff

🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

tmichel

Thanks, a lot, will try that and let you know the results.

tmichel

I had to uninstall and reinstall XAMPP to get it working again. One of my memory banks on my computer is dead, I have 64 GB installed but on 48 GB are recognized. MySQL in XAMPP started aborting after loading for no apparent reason, I had done nothing to settings. Everything worked fine yesterday, and today nothing works and I made no changes to the system,

I tried all the trouble shooting techniques and read the error messages checked to make sure port 3306 wasn't being blocked by the fire fall backed up the database files and copied the backup back to the data folder in mysql. But nothing worked. PHP version of the XAMPP install is  8.1.12  and the PHP version of the archive is  8.2.4; not sure how to update the XAMPP version of PHP.

Now I am getting the following warnings and errors:

Deprecated: Creation of dynamic property AngieDispatcher::$component is deprecated in C:\xampp\htdocs\torissite\installation\framework\dispatcher\dispatcher.php on line 191

Deprecated: Creation of dynamic property AngieDispatcher::$view is deprecated in C:\xampp\htdocs\torissite\installation\framework\dispatcher\dispatcher.php on line 192

Deprecated: Creation of dynamic property AngieDispatcher::$layout is deprecated in C:\xampp\htdocs\torissite\installation\framework\dispatcher\dispatcher.php on line 193

Deprecated: Creation of dynamic property AngieControllerWordpressMain::$default_view is deprecated in C:\xampp\htdocs\torissite\installation\framework\controller\controller.php on line 436

Deprecated: Creation of dynamic property AngieViewMain::$baseurl is deprecated in C:\xampp\htdocs\torissite\installation\framework\view\view.php on line 217

Deprecated: Creation of dynamic property AngieViewMain::$task is deprecated in C:\xampp\htdocs\torissite\installation\framework\controller\controller.php on line 534

Deprecated: Creation of dynamic property AngieViewMain::$doTask is deprecated in C:\xampp\htdocs\torissite\installation\framework\controller\controller.php on line 535

Deprecated: Creation of dynamic property AObject::$task is deprecated in C:\xampp\htdocs\torissite\installation\framework\object\object.php on line 106

Deprecated: Creation of dynamic property AngieViewMain::$restoringToDifferentHost is deprecated in C:\xampp\htdocs\torissite\installation\angie\views\main\view.raw.php on line 54

Deprecated: Creation of dynamic property AngieViewMain::$_tempFilePath is deprecated in C:\xampp\htdocs\torissite\installation\framework\view\view.php on line 475

 

Database restoration An error occurred while restoring the database. The error message can be found below. Click on the × button at the top right of this dialog message to close it and return to the database restoration page.
Deprecated: Creation of dynamic property AView::$baseurl is deprecated in C:\xampp\htdocs\torissite\installation\framework\view\view.php on line 217

Deprecated: Creation of dynamic property AView::$task is deprecated in C:\xampp\htdocs\torissite\installation\angie\controllers\dbrestore.php on line 137

Deprecated: Creation of dynamic property AView::$doTask is deprecated in C:\xampp\htdocs\torissite\installation\angie\controllers\dbrestore.php on line 138

Deprecated: Creation of dynamic property AView::$exception is deprecated in C:\xampp\htdocs\torissite\installation\angie\controllers\dbrestore.php on line 140

Deprecated: Creation of dynamic property AView::$_tempFilePath is deprecated in C:\xampp\htdocs\torissite\installation\framework\view\view.php on line 475
Wrong database connection information

We were unable to connect to your database server using the server host name, username and password you provided.

The error received was:

Cannot connect to the database: one or more of the database host name, user name and password you have provided is incorrect.

Unable to connect to the Database: Access denied for user 'kuxxvnzb_wp692'@'localhost' (using password: YES)

tmichel

Never mind, I am getting too tired working on this site. I need to create the database in phpMyAdmin first.

tmichel

The warnings aside, I do have a working copy of the website now and will make a new backup so that I can copy that over to rochen.com

tmichel

Got everything copied over and installed, and the installation completed without so much as a warning. Still getting a 404 error when clicking links like "View Older Posts." https://vnalexander.com/page/2/ or https://vnalexander.com/privacy-policy/ or clicking on any link that refers to internal documents: https://vnalexander.com/the-perils-of-coding-humanity-a-response-to-transhumanism/

 

I am going to have to redirect back to WordPress.com in a couple of hours so if you want to take a look do so before then. The links look good to me but they don't work. Actually I am going to have to point the site back to WordPress.com. If you want login credential or my phone number, PM me and I will give that to you.

tmichel

Deleted everything inside of public_html and dropped all the tables in the database and then copied the archive over along with kickstart and everything went as smooth as butter. Site is up and everything is working fine except where I manually added links that lad localhost in then, but those were only two links and I corrected those.

Sorry to be so verbose, I thought I was looking at 15 minutes and ended up spending more than a day before I finally started reasoning things out.

Thank you for helping me out, your comments were well placed, but I had a pretty screwed up installation that required it to be completely deleted so I could start fresh

tampe125
Akeeba Staff

Hello,

as you can see, timezones are the worst. I'm sad you had to do all this stuff when we were closed :/

Anyway, it seems you fixed your (original) issue, let me know how it goes.

Davide Tampellini

Developer and Support Staff

🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

tmichel

No worries, but I am not quite finished yet, The client reports this this morning:

When I click  a link to some internal pages (for example, from https://vnalexander.com/locus-amoenus-2015/audiobook-by-ben-jorgensen/, I get this message:

This site can't be found

locus-amoewnus-2015 DNS address could not be found. Diagnosing the problem

DNS_PROBE_POSSIBLE

Why is locus-amoenus-2015 being treated as a domain name?

Could this can be an artifact from wordpress.com?

see https://vnalexander.com

However, when I try to duplicate the behavior my client is having, everything works fine for me.

tmichel

I found the problem, these internal links still point to  and not https://vnalexander.com

Know of a good script I could use to go through the database and replace every instance of https://victorianalexander.wordpress.com with https://vnalexander.com??

tmichel

That message should be:

I found the problem, these internal links still point to https://victorianalexander.wordpress.com and not https://vnalexander.com

Know of a good script I could use to go through the database and replace every instance of https://victorianalexander.wordpress.com with https://vnalexander.com??

tmichel

The problem was this, my client was using tiny URLs on wordpress.com and there is no way I can use a script to replace those values with fully qualified URLs

She was using https://wp.me/P2q3AU-8Uj; which got replaced with https://victorianalexander.wordpress.com/audiobook-by-ben-jorgensen/ on wordpress.com. Since there is no name associated with the tiny URL these is no way I would know what to replace those values with in the database, so as far as I can tell it can only be done by hand.

This is why wordpress.com is a bad idea. If they ever start doing something you don't like, there will be no way to transfer away from them outside of creating a new site and then adding the content back in piece by piece by hand. that could take weeks or months depending on the size of the site.

Akeeba Backup works fine, There is no way that Akeeba Backup could ever replace something like  https://wp.me/P2q3AU-8Uj with https://vnalexander.com/locus-amoenus-2015/audiobook-by-ben-jorgensen/, how would a script be able to derive the name of the page from the hash used by wordpress.com. It couldn't without visiting the link.and doing a cleaver search to derive the title of that page and then going to the new site searching for that name/title and using that get the associated URL on the new site and replacing that with the https://wp.me value in the database. And all this would have to be done without raising cross site scripting restrictions.

tampe125
Akeeba Staff

Thank you very much for sharing your findings, I wasn't aware of that behavior about tiny URLs. If this is the case, it's indeed almost impossible to perform an efficient search and replace on a website...

Thanks again for your report.

Davide Tampellini

Developer and Support Staff

🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

tmichel

wordpress.com is a piece of work. People do not know what they are getting into when they decide to let wordpress.com do everything for them. Ultimately they will not be the owners of their own data.

Thank you oh so much for the work you guys do.

tampe125
Akeeba Staff

You're welcome!

Thank you for the update!

Davide Tampellini

Developer and Support Staff

🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!