[TYPO3-english] clear all data in alias fields

[Katja Lampela]

Hi and thank you Loek!

12.5.2012 0:38, Loek Hilgersom kirjoitti:
> Hi Katja,
>
> If you mean clearing the alias field in the entire database, then it's easy: just open up PhpMyAdmin or something else where you can run a query (command line mysql is also possible) and run this query:
> UPDATE `pages` SET `alias`='' WHERE 1;
>
> If you want to do this only for a selected page tree then you would need to make a little script or a more complex query, or manually: in List module select the alias field, switch on the clipboard, select all and relatively quickly empty all of them. Depends on the size of the page tree if that's feasible way to go, of course.
>
> Hth,
> Loek
>
>
> On 05/11/2012 06:16 PM, Katja Lampela wrote:
>> Hi,
>>
>> Sometimes when site is updated completely (visual and data) it is convenient to
>> copy the structure and make the changes in new site.
>>
>> In these cases the alias field of page is copied too, somepagealias would be
>> somepagealias0.
>>
>> Is there a way to remove efficiently all the aliases of the new site or the
>> whole database?
>>
>>
>>

-- 
With kind regards

Katja Lampela
*Lieska-tuotanto*
www.lieska.net