[webteam] drupal user

[James Walker]

On 13-Feb-08, at 1:19 PM, Peter Saint-Andre wrote:
> Peter Saint-Andre wrote:
>> Robert Martinez wrote:
>>
>>> Does not seem to be fixed:
>>>
>>> http://new.jabber.org/clients/gajim
>>> http://new.jabber.org/clients
>>>
>>>
>>> the images don't show up.
>>
>> OK, further research required. :)
>
> It seems to be a database problem, not a file permissions problem,  
> since
> a dump of the DB yields information like this:
>
> \"filepath\";s:63:\"sites/stage.jabber.org/files//clients/logos/ 
> coccinella_logo.png\"
>
> I wonder if there's a way to modify all of those in one pass...

mysql> UPDATE <table> SET <field>=REPLACE(<field>, 'sites/ 
stage.jabber.org/files', 'sites/jabber.org/files'); etc...

Something like that should work :)

--
James Walker :: http://walkah.net/ :: xmpp:walkah at walkah.net