{"action":"created","issue":{"url":"https://api.github.com/repos/dotCMS/core/issues/9971","repository_url":"https://api.github.com/repos/dotCMS/core","labels_url":"https://api.github.com/repos/dotCMS/core/issues/9971/labels{/name}","comments_url":"https://api.github.com/repos/dotCMS/core/issues/9971/comments","events_url":"https://api.github.com/repos/dotCMS/core/issues/9971/events","html_url":"https://github.com/dotCMS/core/issues/9971","id":182862228,"number":9971,"title":"Page to Content Migration - Fix url of legacy pages to avoid issues during migration","user":{"login":"gabbydotCMS","id":1569509,"avatar_url":"https://avatars.githubusercontent.com/u/1569509?v=3","gravatar_id":"","url":"https://api.github.com/users/gabbydotCMS","html_url":"https://github.com/gabbydotCMS","followers_url":"https://api.github.com/users/gabbydotCMS/followers","following_url":"https://api.github.com/users/gabbydotCMS/following{/other_user}","gists_url":"https://api.github.com/users/gabbydotCMS/gists{/gist_id}","starred_url":"https://api.github.com/users/gabbydotCMS/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gabbydotCMS/subscriptions","organizations_url":"https://api.github.com/users/gabbydotCMS/orgs","repos_url":"https://api.github.com/users/gabbydotCMS/repos","events_url":"https://api.github.com/users/gabbydotCMS/events{/privacy}","received_events_url":"https://api.github.com/users/gabbydotCMS/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/dotCMS/core/labels/Agile%20:%20Discuss%20for%20Release","name":"Agile : Discuss for Release","color":"009800"},{"url":"https://api.github.com/repos/dotCMS/core/labels/Release%20:%203.7.0","name":"Release : 3.7.0","color":"fbca04"},{"url":"https://api.github.com/repos/dotCMS/core/labels/Severity%20:%20Support%20Requested","name":"Severity : Support Requested","color":"1d76db"},{"url":"https://api.github.com/repos/dotCMS/core/labels/Type%20:%20Enhancement","name":"Type : Enhancement","color":"006b75"}],"state":"open","locked":false,"assignee":{"login":"agomez-dotcms","id":22307536,"avatar_url":"https://avatars.githubusercontent.com/u/22307536?v=3","gravatar_id":"","url":"https://api.github.com/users/agomez-dotcms","html_url":"https://github.com/agomez-dotcms","followers_url":"https://api.github.com/users/agomez-dotcms/followers","following_url":"https://api.github.com/users/agomez-dotcms/following{/other_user}","gists_url":"https://api.github.com/users/agomez-dotcms/gists{/gist_id}","starred_url":"https://api.github.com/users/agomez-dotcms/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/agomez-dotcms/subscriptions","organizations_url":"https://api.github.com/users/agomez-dotcms/orgs","repos_url":"https://api.github.com/users/agomez-dotcms/repos","events_url":"https://api.github.com/users/agomez-dotcms/events{/privacy}","received_events_url":"https://api.github.com/users/agomez-dotcms/received_events","type":"User","site_admin":false},"assignees":[{"login":"agomez-dotcms","id":22307536,"avatar_url":"https://avatars.githubusercontent.com/u/22307536?v=3","gravatar_id":"","url":"https://api.github.com/users/agomez-dotcms","html_url":"https://github.com/agomez-dotcms","followers_url":"https://api.github.com/users/agomez-dotcms/followers","following_url":"https://api.github.com/users/agomez-dotcms/following{/other_user}","gists_url":"https://api.github.com/users/agomez-dotcms/gists{/gist_id}","starred_url":"https://api.github.com/users/agomez-dotcms/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/agomez-dotcms/subscriptions","organizations_url":"https://api.github.com/users/agomez-dotcms/orgs","repos_url":"https://api.github.com/users/agomez-dotcms/repos","events_url":"https://api.github.com/users/agomez-dotcms/events{/privacy}","received_events_url":"https://api.github.com/users/agomez-dotcms/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/dotCMS/core/milestones/45","html_url":"https://github.com/dotCMS/core/milestones/Rex%20Current","labels_url":"https://api.github.com/repos/dotCMS/core/milestones/45/labels","id":2035850,"number":45,"title":"Rex Current","description":"","creator":{"login":"dsilvam","id":1576794,"avatar_url":"https://avatars.githubusercontent.com/u/1576794?v=3","gravatar_id":"","url":"https://api.github.com/users/dsilvam","html_url":"https://github.com/dsilvam","followers_url":"https://api.github.com/users/dsilvam/followers","following_url":"https://api.github.com/users/dsilvam/following{/other_user}","gists_url":"https://api.github.com/users/dsilvam/gists{/gist_id}","starred_url":"https://api.github.com/users/dsilvam/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dsilvam/subscriptions","organizations_url":"https://api.github.com/users/dsilvam/orgs","repos_url":"https://api.github.com/users/dsilvam/repos","events_url":"https://api.github.com/users/dsilvam/events{/privacy}","received_events_url":"https://api.github.com/users/dsilvam/received_events","type":"User","site_admin":false},"open_issues":37,"closed_issues":1,"state":"open","created_at":"2016-09-28T19:40:22Z","updated_at":"2016-10-13T20:56:44Z","due_on":"2016-10-21T00:00:00Z","closed_at":null},"comments":8,"created_at":"2016-10-13T18:17:47Z","updated_at":"2016-10-14T16:36:13Z","closed_at":null,"body":"When migrating pages to content, conflicts with invalid urls usually interrupt the execution of the tool and require manipulation of database records.\r\n\r\nSome of conflicts are:\r\n\r\n1. asset_name in table identifier does not match page_url in table htmlpage (this stops the migration due to duplicated page_urls)\r\nupdate htmlpage set page_url = (select asset_name from identifier where identifier.id = htmlpage.identifier);\r\n\r\n2.  Double dots before the extension of the page\r\nupdate htmlpage set page_url = replace(page_url, '..', '.') where page_url like '%..%';\r\n\r\n3. Invalid characters in the url\r\n```\r\nupdate htmlpage set page_url = replace(page_url, ',', '') where page_url like '%,%';\r\nupdate htmlpage set page_url = replace(page_url, '*', '') where page_url like '%*%';\r\nupdate htmlpage set page_url = replace(page_url, '&', '') where page_url like '%&%';\r\n```\r\netc\r\n\r\nIt'd be great if we could have a new FixTask to rename the pages to a valid URL before executing the page to content migration."},"comment":{"url":"https://api.github.com/repos/dotCMS/core/issues/comments/253853407","html_url":"https://github.com/dotCMS/core/issues/9971#issuecomment-253853407","issue_url":"https://api.github.com/repos/dotCMS/core/issues/9971","id":253853407,"user":{"login":"agomez-dotcms","id":22307536,"avatar_url":"https://avatars.githubusercontent.com/u/22307536?v=3","gravatar_id":"","url":"https://api.github.com/users/agomez-dotcms","html_url":"https://github.com/agomez-dotcms","followers_url":"https://api.github.com/users/agomez-dotcms/followers","following_url":"https://api.github.com/users/agomez-dotcms/following{/other_user}","gists_url":"https://api.github.com/users/agomez-dotcms/gists{/gist_id}","starred_url":"https://api.github.com/users/agomez-dotcms/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/agomez-dotcms/subscriptions","organizations_url":"https://api.github.com/users/agomez-dotcms/orgs","repos_url":"https://api.github.com/users/agomez-dotcms/repos","events_url":"https://api.github.com/users/agomez-dotcms/events{/privacy}","received_events_url":"https://api.github.com/users/agomez-dotcms/received_events","type":"User","site_admin":false},"created_at":"2016-10-14T16:36:13Z","updated_at":"2016-10-14T16:36:13Z","body":"PR: https://github.com/dotCMS/core/pull/9977"}}
{"actor":{"display_login":"agomez-dotcms"}}