hi seems to me very reasonable.The only work i did on databases before was only changing some prefixeson tables, i never changed any data as values in a table. What i would do is downloading the "files" table, open it on a text editor and do a search for that string and eventually replace the values (links). Is there a smarter way to work with tables? For example: i am sure that phpmyadmins has got some useful tool. Simone

On Wed, Mar 11, 2009 at 11:34 PM, Cog Rusty cog.rusty@gmail.com wrote:

On Wed, Mar 11, 2009 at 5:00 PM, simone-www.io-lab.org cimo75@gmail.com wrote:

...

Hi i ve changed the download mode from private to public and, as supposed to be, i experience some weirdness on my site s images For example the avatar on forum sometime will disappear and the RSS feed image has disappeared. Is there a common way to get back to normality? Simone

-- .wmv , .wma , .pps along with all proprietary Windows formats won t be accepted and/or viewed....

A good start for solving the problem in the database would be:

• check the file paths in the "files" table.
• make a general string search in all your database, including the

content, for "system/files" and fix it.

• clear all caches.

...

-- [ Drupal support list | http://lists.drupal.org/ ]

-- [ Drupal support list | http://lists.drupal.org/ ]

Simone,

I support Will's suggestion about using that update and replace sql.

Just to add a bit of verbosity to Will's instructions... In phpMyAdmin you'll see "SQL" icons in various places. As long as you have the database selected/active, pasting in the code Will provided (of course replacing the tablename, columnname, search, and replace with the actual values relevant to your situation) into a field that will appear when you click on "SQL" should do the job. That SQL would work at the command line as well as long as you were logged into the DB.

Shai

On Wed, Mar 11, 2009 at 8:23 PM, William Smith william.darren@gmail.comwrote:

Yes phpmyadmin can do a search across the entire DB. You can also do a search and replace on a table by executing the following: UPDATE `table_name` set columnname = replace(columnname, 'search', 'replace‘')

Where table_name, columnname, 'search' and 'replace' are the values appropriate for your situation.

But don't forget to backup first! ;)

On Wed, Mar 11, 2009 at 7:52 PM, simone-www.io-lab.org cimo75@gmail.comwrote:

...

hi seems to me very reasonable.The only work i did on databases before was only changing some prefixeson tables, i never changed any data as values in a table. What i would do is downloading the "files" table, open it on a text editor and do a search for that string and eventually replace the values (links). Is there a smarter way to work with tables? For example: i am sure that phpmyadmins has got some useful tool. Simone

On Wed, Mar 11, 2009 at 11:34 PM, Cog Rusty cog.rusty@gmail.com wrote:

...

On Wed, Mar 11, 2009 at 5:00 PM, simone-www.io-lab.org <

cimo75@gmail.com> wrote:

...

...

Hi i ve changed the download mode from private to public and, as supposed to be, i experience some weirdness on my site s images For example the avatar on forum sometime will disappear and the RSS feed image has disappeared. Is there a common way to get back to normality? Simone

-- .wmv , .wma , .pps along with all proprietary Windows formats won t be accepted and/or viewed....

A good start for solving the problem in the database would be:

• check the file paths in the "files" table.
• make a general string search in all your database, including the

content, for "system/files" and fix it.

• clear all caches.

...

-- [ Drupal support list | http://lists.drupal.org/ ]

-- [ Drupal support list | http://lists.drupal.org/ ]

-- .wmv , .wma , .pps along with all proprietary Windows formats won t be accepted and/or viewed.... -- [ Drupal support list | http://lists.drupal.org/ ]

-- [ Drupal support list | http://lists.drupal.org/ ]