[support] recovering from private mode download

[Shai Gluskin]

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 at gmail.com>wrote:

> 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 at gmail.com>wrote:
>
>> 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 at gmail.com> wrote:
>> > On Wed, Mar 11, 2009 at 5:00 PM, simone-www.io-lab.org <
>> cimo75 at 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/ ]
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.drupal.org/pipermail/support/attachments/20090311/fa1c1fb6/attachment.htm>