[TYPO3-english] clear all data in alias fields

Loek Hilgersom loek at netcoop.nl
Fri May 11 23:38:28 CEST 2012


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?
>
>
>


More information about the TYPO3-english mailing list