Support

Akeeba Backup for WordPress

#20525 URL Not updating

Posted in ‘Akeeba Backup 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
n/a
PHP version
n/a
Akeeba Backup version
n/a

Latest post by nicholas on Thursday, 24 July 2014 01:18 CDT

veeco
Hello,
i'm doing my first restore with akeeba kickstart 3.8.1, from my local (windows) to web server (linux - hostgator).

It seem several link in database is not updated to reflect new host.. i dump the SQL and still find a lot of link point to my local

Please Help

nicholas
Akeeba Staff
Manager
You have to restore the backup using ANGIE, the restoration script included in the backup archive. If you try to restore the SQL file manually then yes, no URL is changed. When restoring you must tell ANGIE your new URL when it asks you, otherwise it can't replace the old URLs. Also note that ANGIE will only change the URLs stored in posts, pages metadata and core WordPress options. It will NOT touch the URLs you have hardcoded in your template or URLs which are stored in the options of third party plugins. You have to do this yourself.

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

veeco
I'm using akeeba kickstart (which use ANGIE).. the field is not in serialized array...
i will record a screencast for this

veeco
Please watch my 3 minutes video...
Hope this can help you solve the problem.. i haven't delete the JPA if you need to test it

Thanks

nicholas
Akeeba Staff
Manager
Can you please post a link to the video?

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

veeco
The video was in attachment,
but here's the youtube's one:
http://www.youtube.com/watch?v=0WITw_nKWhw&list=UUZ962nJDJU8ogef-4Tbwypg

nicholas
Akeeba Staff
Manager
What you show me at 2:23 is what I said in my first reply:

Also note that ANGIE will only change the URLs stored in posts, pages metadata and core WordPress options. It will NOT touch the URLs you have hardcoded in your template or URLs which are stored in the options of third party plugins. You have to do this yourself.


These URLs you show me are configured in third party plugins. ANGIE, the restoration script, cannot and will not touch them, exactly as I said and as we have documented. You prove me right at 2:40 when you show me the options of a third party plugin stored as metadata in the database.

FYI, there is a very valid reason why we don't touch serialised data (which you mistakenly called "unserialised" in your video). Serialised data in PHP cannot be edited directly. They have to be unserialised first. However, unserialising this data requires the PHP classes they are using to be already loaded, otherwise a fatal error occurs. This is why, for the last 10 years, the core PHP developers have warned AGAINST using serialised data as a form of permanent storage. Sadly, WordPress is committing a software architecture crime by not only allowing, but RECOMMENDING(!!!) its developers to use serialised data.

While we can use a workaround to change URLs in serialised data, our testing shows that it only works in 90% of the cases. In the rest 10% the serialised data is screwed up and the restoration ends up losing data on the site. I cannot possibly put my name on a piece of code that will screw my users one in ten times it's used. It's irresponsible to publish code which does that. Therefore we do not touch serialised data.

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

veeco
Hello Nicholas,
sorry my mistake... i was about to write encrypted, as i see some developer use base64_encode to save data...

i got your point now.. Thanks !

nicholas
Akeeba Staff
Manager
You're welcome!

Just out of curiosity, what is the plugin you are using that puts this serialised data in there? So far I've only worked with plugins store serialised data in the options table, none in the post meta. I want to have one of these plugins for completeness' sake.

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!