Re: [TYPO3-english] clear all data in alias fields

2012-05-12 Thread 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`

[TYPO3-english] clear all data in alias fields

2012-05-11 Thread Katja Lampela
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

Re: [TYPO3-english] clear all data in alias fields

2012-05-11 Thread Loek Hilgersom
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