[TYPO3-dam] SOLVED unable to use previously saved dam selections after moving to a new server

[Mathieu Kessler]

Dear list,
I have found the reason for my previously saved DAM selections not working
after migrating the server despite the correct change of the absolute path
in the tx_dam_selection table. I therefore post it in case it may be of some
help to others:
In the definition field of tx_dam_selection,
a:1:{s:6:"SELECT";a:1:{s:11:"txdamFolder";a:1:{s:88:"/home/sandieg4/public_html/sandiegotypo3/fileadmin/imagenes/viernes/temporada2008/02_05/";s:1:"1";}}}
the number after s: corresponds to the number of characters in the string
that follows. If I only change the path in my sql dump file, it is likely
that the number of characters in the string containing the new path has
changed. In my case, the new path has 2 characters less. In the example
above If I change s:88 to s:86 my selection works perfectly....
Now a question for the developers: Would it be possible that the definition
field of tx_dam_selection contain the relative path with respect to the
typo3 installation install instead of the absolute path on the server? That
would avoid the problem I met (which I agree is pretty specific...)
Anyway, I have found DAM to be a wonderful tool, thanks to the people that
made it possible...
Mathieu


2008/12/9 Mathieu Kessler <mathieu.kessler at upct.es>

> Dear list,
> I want to move a working typo3 website with Dam to a new server. I
> made the sql dumps etc...imported the database etc... and everything
> works fine on the new server, exept for the dam selections.:-(
> The selections that I had defined in my old server don't work in the
> new....
> I have checked the database and could see that in the table
> tx_dam_selection, the definition field contained the absolute path to
> the directory on the old server, e.g
>
> a:1:{s:6:"SELECT";a:1:{s:11:"txdamFolder";a:1:{s:88:"/home/sandieg4/public_html/sandiegotypo3/fileadmin/imagenes/viernes/temporada2008/02_05/";s:1:"1";}}}
> I therefore thought that I had found the problem since the typo3
> installation is not in the same folder in the new server as in the old
> one.
> I then changed with sed all the ocurrences of
> "/home/sandieg4/public_html" to the new base path:
> "/var/www-data/apache2-default/" in the sql dumps files
> and reconstructed again the database. The path that appears in the
> definition field of table tx_dam_selection is now correct, but the
> selections still don't work!
> What is even more puzzling is that I can define a new selection in the
> new server selecting the same directory and this one works!
> If I compare the selections rule of the old selection (that does not
> work) and the new selection (that works) they are almost the same:
> old selection:
>
> a:1:{s:6:"SELECT";a:1:{s:11:"txdamFolder";a:1:{s:88:"/var/www/apache2-default/sandiegotypo3/fileadmin/imagenes/viernes/temporada2008/02_05/";s:1:"1";}}}
> new selection
>
> a:1:{s:6:"SELECT";a:1:{s:11:"txdamFolder";a:1:{s:86:"/var/www/apache2-default/sandiegotypo3/fileadmin/imagenes/viernes/temporada2008/02_05/";s:1:"1";}}}
> What am I missing?
> It seems to me an  important issue when making backup copies of an
> existing typo3 site with many dam selections...
> Many thanks in advance for any hint...
> --
> Mathieu
> _______________________________________________
> TYPO3-project-dam mailing list
> TYPO3-project-dam at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-project-dam
>