User login

Home ›
 Fixing file paths after a change in location of a site's files directory

Fixing file paths after a change in location of a site's files directory

Submitted by Benjamin Melançon on October 16, 2008 - 3:10pm
in
Searched words: 
files location files sites default fix broken file paths Drupal module files uploaded file paths drupal MySQL replacing part of filepath text stored

If, like Agaric, you're moving from multisite to separate installations for each site (or vice versa) you may find your user-uploaded file paths changing. Drag.

The solution is updating your database, and you can replace part of the file path with straight SQL:

UPDATE files SET filepath = REPLACE(filepath, "sites/help4computers.com/files/", "sites/default/files/")

To do this using the command line, you simply need your database information:

You can get your database username and password from your Drupal site's settings.php

It's the part in the $db_url = line that looks like:
example:EvC.aRxhbmPnrLd3
@localhost/help4computers

help4computers:BvC.aRxdbmBnrad3@localhost/help4computers

Agaric Asides

I thought Pathologic might be a fix to my problems here, but it most certainly is not: it is an input filter and acts on links in content, and not on attached files.

Also of (potential) interest:

http://drupal.org/project/uploadpath

http://agaricdesign.com/note/drupal-function-give-path-files-directory

Resolution

Comments

improved version

Submitted by scor (not verified) on December 17, 2009 - 12:08pm.

I've written an improved version of this tip at http://openspring.net/tip/filepath-fix-for-drupal-multisite-installation

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Internal paths in single or double quotes, written as "internal:node/99", for example, are replaced with the appropriate absolute URL or path. Paths to files in single or double quotes, written as "files:somefile.ext", for example, are replaced with the appropriate URL that can be used to download the file.
  • You may post code using <code>...</code> (generic) or <?php ... ?> (highlighted PHP) tags.
  • You can use Markdown syntax to format and style the text. Also see Markdown Extra for tables, footnotes, and more.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <img> <blockquote> <small> <h2> <h3> <h4> <h5> <h6> <sub> <sup> <p> <br> <strike> <table> <tr> <td> <thead> <th> <tbody> <tt> <output>
  • Syntax highlight code surrounded by the {syntaxhighlighter SPEC}...{/syntaxhighlighter} tags, where SPEC is a Syntaxhighlighter options string or "class="OPTIONS" title="the title".
  • Lines and paragraphs break automatically.

More information about formatting options

By submitting this form, you accept the Mollom privacy policy.