Welcome Guest, Not a member yet? Register   Sign In
Burned by the 1.7.1 bug fix in url_title()? removing periods from the end of url_title fields
#1

[eluser]gullah[/eluser]
I use url_title for certain database fields which are used to access the pages in a safe way. Therefore I often use url_title('the end of all things...') which in 1.7 resulted in 'the-end-of-all-things...' now, in 1.7.1, the url_title function results in 'the-end-of-all-things'.

To fix this I ran this query a few times against the database to get rid of the periods at the end.

Code:
update [tableName] set [fieldName] =  substring([fieldName], 1, length([fieldName])-1) where [fieldName] like "%.";

Hope this helps someone out.

Gullah




Theme © iAndrew 2016 - Forum software by © MyBB