Skip to content

Instantly share code, notes, and snippets.

@leek

leek/magento_urls.sql

Created July 8, 2013 21:53
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save leek/5952818 to your computer and use it in GitHub Desktop.
Save leek/5952818 to your computer and use it in GitHub Desktop.
Download ZIP
Magento: Fix Hardcoded URL's in Database
Raw
magento_urls.sql
UPDATE cms_block SET content = REPLACE(content, "http://www.example.com/", "{{store url=''}}");
UPDATE cms_page SET content = REPLACE(content, "http://www.example.com/", "{{store url=''}}");
--
-- AW_Blog Only
--
UPDATE aw_blog SET post_content = REPLACE(post_content, 'http://www.example.com/', "{{store url=''}}");
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment