{"action":"created","issue":{"url":"https://api.github.com/repos/translate/pootle/issues/3659","labels_url":"https://api.github.com/repos/translate/pootle/issues/3659/labels{/name}","comments_url":"https://api.github.com/repos/translate/pootle/issues/3659/comments","events_url":"https://api.github.com/repos/translate/pootle/issues/3659/events","html_url":"https://github.com/translate/pootle/issues/3659","id":66939330,"number":3659,"title":"`update_stores` fails after renaming directory and store from uppercase to lowercase","user":{"login":"ta2-1","id":682845,"avatar_url":"https://avatars.githubusercontent.com/u/682845?v=3","gravatar_id":"","url":"https://api.github.com/users/ta2-1","html_url":"https://github.com/ta2-1","followers_url":"https://api.github.com/users/ta2-1/followers","following_url":"https://api.github.com/users/ta2-1/following{/other_user}","gists_url":"https://api.github.com/users/ta2-1/gists{/gist_id}","starred_url":"https://api.github.com/users/ta2-1/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ta2-1/subscriptions","organizations_url":"https://api.github.com/users/ta2-1/orgs","repos_url":"https://api.github.com/users/ta2-1/repos","events_url":"https://api.github.com/users/ta2-1/events{/privacy}","received_events_url":"https://api.github.com/users/ta2-1/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2015-04-07T17:07:20Z","updated_at":"2015-05-06T16:13:32Z","closed_at":null,"body":"```pytb\r\nTraceback (most recent call last):\r\n  File \"/home/l10n/pootle/pootle/apps/pootle_app/management/commands/__init__.py\", line 43, in do_translation_project\r\n    process_stores = self.handle_translation_project(tp, **options)\r\n  File \"/home/l10n/pootle/pootle/apps/pootle_app/management/commands/update_stores.py\", line 41, in handle_translation_project\r\n    translation_project.scan_files()\r\n  File \"/home/l10n/pootle/pootle/apps/pootle_translationproject/models.py\", line 375, in scan_files\r\n    file_filter,\r\n  File \"/home/l10n/pootle/pootle/apps/pootle_app/project_tree.py\", line 254, in add_files\r\n    fs_subdir, db_subdir, file_filter)\r\n  File \"/home/l10n/pootle/pootle/apps/pootle_app/project_tree.py\", line 254, in add_files\r\n    fs_subdir, db_subdir, file_filter)\r\n  File \"/home/l10n/pootle/pootle/apps/pootle_app/project_tree.py\", line 254, in add_files\r\n    fs_subdir, db_subdir, file_filter)\r\n  File \"/home/l10n/pootle/pootle/apps/pootle_app/project_tree.py\", line 224, in add_files\r\n    file_filter)\r\n  File \"/home/l10n/pootle/pootle/apps/pootle_app/project_tree.py\", line 125, in split_files_and_dirs\r\n    for child_path in [child_path for child_path in os.listdir(real_dir)\r\nOSError: [Errno 2] No such file or directory: '/home/l10n/production/serge/po/web_evernote/ar/resources/mail/PremiumGiftSubscriptionConfirmationStencil'\r\n```\r\n\r\nIt happened because MySQL used case insensitive collation `utf8_general_ci`. So probably we shouldn't use it.\r\n"},"comment":{"url":"https://api.github.com/repos/translate/pootle/issues/comments/99526132","html_url":"https://github.com/translate/pootle/issues/3659#issuecomment-99526132","issue_url":"https://api.github.com/repos/translate/pootle/issues/3659","id":99526132,"user":{"login":"ta2-1","id":682845,"avatar_url":"https://avatars.githubusercontent.com/u/682845?v=3","gravatar_id":"","url":"https://api.github.com/users/ta2-1","html_url":"https://github.com/ta2-1","followers_url":"https://api.github.com/users/ta2-1/followers","following_url":"https://api.github.com/users/ta2-1/following{/other_user}","gists_url":"https://api.github.com/users/ta2-1/gists{/gist_id}","starred_url":"https://api.github.com/users/ta2-1/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ta2-1/subscriptions","organizations_url":"https://api.github.com/users/ta2-1/orgs","repos_url":"https://api.github.com/users/ta2-1/repos","events_url":"https://api.github.com/users/ta2-1/events{/privacy}","received_events_url":"https://api.github.com/users/ta2-1/received_events","type":"User","site_admin":false},"created_at":"2015-05-06T16:13:32Z","updated_at":"2015-05-06T16:13:32Z","body":"It's not easy to solve this issue without creating\r\n> a hard dependency on a specific collation type in a specific database.\r\nWe won't do it.\r\n\r\nThat four SQL queries don't affect the whole DB and the search functionality. It's valid for EN for MySQL. I didn't tested it on other DBs. But unfortunately we can't create a migration for these specific changes or include them to `initdb` script. \r\n@dwaynebailey, can you please add some warnings to the docs as @julen suggested [here](https://github.com/translate/pootle/issues/3659#issuecomment-90822500) or anything else you prefer.\r\n\r\n"}}