{"action":"created","issue":{"url":"https://api.github.com/repos/osTicket/osTicket-1.8/issues/2646","labels_url":"https://api.github.com/repos/osTicket/osTicket-1.8/issues/2646/labels{/name}","comments_url":"https://api.github.com/repos/osTicket/osTicket-1.8/issues/2646/comments","events_url":"https://api.github.com/repos/osTicket/osTicket-1.8/issues/2646/events","html_url":"https://github.com/osTicket/osTicket-1.8/issues/2646","id":111144705,"number":2646,"title":"1.9.12 Problem with status when installing in different language","user":{"login":"vrowdy","id":15103416,"avatar_url":"https://avatars.githubusercontent.com/u/15103416?v=3","gravatar_id":"","url":"https://api.github.com/users/vrowdy","html_url":"https://github.com/vrowdy","followers_url":"https://api.github.com/users/vrowdy/followers","following_url":"https://api.github.com/users/vrowdy/following{/other_user}","gists_url":"https://api.github.com/users/vrowdy/gists{/gist_id}","starred_url":"https://api.github.com/users/vrowdy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vrowdy/subscriptions","organizations_url":"https://api.github.com/users/vrowdy/orgs","repos_url":"https://api.github.com/users/vrowdy/repos","events_url":"https://api.github.com/users/vrowdy/events{/privacy}","received_events_url":"https://api.github.com/users/vrowdy/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-10-13T09:44:02Z","updated_at":"2015-10-13T11:04:34Z","closed_at":null,"body":"See also #1852 , but since no developer has responded to that issue yet and my comment there would probably go unnoticed, I am opening up a new issue.\r\n\r\nThe problem is as follows: when installing osTicket in a different language, something goes wrong with ticket status database table creation. The statuses are there in the admin panel, but you cannot change a ticket to another status. The status menu is just empty. This goes for the Dutch language pack as well as some other languages. More detailled:\r\n\r\nThis problem is also occuring with the Dutch language pack.\r\n\r\nDuring installation, I chose to install everything in Dutch. I do get the correct ticket statuses (in Dutch) in the right place in the Admin-panel.\r\nHowever, I am unable to change any ticket to any other status than 'open'. Also, the 'default status for new tickets'-setting also only shows 'open'.\r\n\r\nWhen I install osTicket in English, this problem doesn't occur. But as stated before, this requires a lot of translation afterwards because a lot of strings are setup in the database during installation.\r\n\r\nI'm using osTicket 1.9.12. This seems to be a critical bug in the language-pack support. Perhaps something should be change in the translation file, but something should definately be change in osTicket installation as well, so that even when the translation file is missing some info, the installation still is performed correctly.\r\nCurrenty, it is impossible to use osTicket in Dutch.\r\n\r\nI hope this issue can be resolved soon."},"comment":{"url":"https://api.github.com/repos/osTicket/osTicket-1.8/issues/comments/147683969","html_url":"https://github.com/osTicket/osTicket-1.8/issues/2646#issuecomment-147683969","issue_url":"https://api.github.com/repos/osTicket/osTicket-1.8/issues/2646","id":147683969,"user":{"login":"vrowdy","id":15103416,"avatar_url":"https://avatars.githubusercontent.com/u/15103416?v=3","gravatar_id":"","url":"https://api.github.com/users/vrowdy","html_url":"https://github.com/vrowdy","followers_url":"https://api.github.com/users/vrowdy/followers","following_url":"https://api.github.com/users/vrowdy/following{/other_user}","gists_url":"https://api.github.com/users/vrowdy/gists{/gist_id}","starred_url":"https://api.github.com/users/vrowdy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vrowdy/subscriptions","organizations_url":"https://api.github.com/users/vrowdy/orgs","repos_url":"https://api.github.com/users/vrowdy/repos","events_url":"https://api.github.com/users/vrowdy/events{/privacy}","received_events_url":"https://api.github.com/users/vrowdy/received_events","type":"User","site_admin":false},"created_at":"2015-10-13T11:04:34Z","updated_at":"2015-10-13T11:04:34Z","body":"I managed to fix it by myself.\r\nThe problem is as follows:\r\nIn the database table ticket_status there is a field 'state'. That filed contains certain descriptions in English, for example 'closed'. These fields should never be translated - they are internal fields referenced by PHP code. They are the keys by which osTicket knows which state is actually closed, because the text shown to the user is translated.\r\n\r\nSolution is resetting the values in the field 'state' back to their original English values.\r\n\r\nSo there a are two problems: the translators shouldn't have translated this field, but more importantly, during the creation of the database (during setup), osTicket should not use these translated values even if they are provided by the language pack.\r\n\r\nAlso, checks should be made to make sure this doesn't happen as well for other tables / values."}}