Simone,<br><br>I support Will's suggestion about using that update and replace sql.<br><br>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.<br>
<br>Shai<br><br><div class="gmail_quote">On Wed, Mar 11, 2009 at 8:23 PM, William Smith <span dir="ltr"><<a href="mailto:william.darren@gmail.com">william.darren@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
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:<br>UPDATE `table_name` set columnname = replace(columnname, 'search', 'replace‘')<br>
<br>Where table_name, columnname, 'search' and 'replace' are the values appropriate for your situation.<br><br>But don't forget to backup first! ;)<div><div></div><div class="h5"><br><br><div class="gmail_quote">
On Wed, Mar 11, 2009 at 7:52 PM, <a href="http://simone-www.io-lab.org" target="_blank">simone-www.io-lab.org</a> <span dir="ltr"><<a href="mailto:cimo75@gmail.com" target="_blank">cimo75@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">hi<br>
seems to me very reasonable.The only work i did on databases before<br>
was only changing some prefixeson tables, i never changed any data as<br>
values in a table.<br>
What i would do is downloading the "files" table, open it on a text<br>
editor and do a search for that string and eventually replace the<br>
values (links).<br>
Is there a smarter way to work with tables? For example: i am sure<br>
that phpmyadmins has got some useful tool.<br>
<font color="#888888">Simone<br>
</font><div><div></div><div><br>
On Wed, Mar 11, 2009 at 11:34 PM, Cog Rusty <<a href="mailto:cog.rusty@gmail.com" target="_blank">cog.rusty@gmail.com</a>> wrote:<br>
> On Wed, Mar 11, 2009 at 5:00 PM, <a href="http://simone-www.io-lab.org" target="_blank">simone-www.io-lab.org</a> <<a href="mailto:cimo75@gmail.com" target="_blank">cimo75@gmail.com</a>> wrote:<br>
>> Hi<br>
>> i ve changed the download mode from private to public and, as supposed<br>
>> to be, i experience some weirdness on my site s images<br>
>> For example the avatar on forum sometime will disappear and the RSS<br>
>> feed image has disappeared.<br>
>> Is there a common way to get back to normality?<br>
>> Simone<br>
>><br>
>> --<br>
>> .wmv , .wma , .pps along with all proprietary Windows formats won t be<br>
>> accepted and/or viewed....<br>
><br>
><br>
> A good start for solving the problem in the database would be:<br>
> - check the file paths in the "files" table.<br>
> - make a general string search in all your database, including the<br>
> content, for "system/files" and fix it.<br>
> - clear all caches.<br>
><br>
>> --<br>
>> [ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
>><br>
> --<br>
> [ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
><br>
<br>
<br>
<br>
</div></div>--<br>
<div>.wmv , .wma , .pps along with all proprietary Windows formats won t be<br>
accepted and/or viewed....<br>
</div><div><div></div><div>--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
</div></div></blockquote></div><br>
</div></div><br>--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br></blockquote></div><br>