{"action":"created","issue":{"url":"https://api.github.com/repos/openwebwork/webwork-open-problem-library/issues/64","labels_url":"https://api.github.com/repos/openwebwork/webwork-open-problem-library/issues/64/labels{/name}","comments_url":"https://api.github.com/repos/openwebwork/webwork-open-problem-library/issues/64/comments","events_url":"https://api.github.com/repos/openwebwork/webwork-open-problem-library/issues/64/events","html_url":"https://github.com/openwebwork/webwork-open-problem-library/issues/64","id":29950607,"number":64,"title":"webwork unable to import; mysql error","user":{"login":"bldewolf","id":457295,"avatar_url":"https://avatars.githubusercontent.com/u/457295?v=3","gravatar_id":"","url":"https://api.github.com/users/bldewolf","html_url":"https://github.com/bldewolf","followers_url":"https://api.github.com/users/bldewolf/followers","following_url":"https://api.github.com/users/bldewolf/following{/other_user}","gists_url":"https://api.github.com/users/bldewolf/gists{/gist_id}","starred_url":"https://api.github.com/users/bldewolf/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bldewolf/subscriptions","organizations_url":"https://api.github.com/users/bldewolf/orgs","repos_url":"https://api.github.com/users/bldewolf/repos","events_url":"https://api.github.com/users/bldewolf/events{/privacy}","received_events_url":"https://api.github.com/users/bldewolf/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2014-03-22T00:37:36Z","updated_at":"2015-02-23T22:32:35Z","closed_at":"2015-02-23T22:32:35Z","body":"Trying to import OPL into webwork using OPL-Update causes this error:\r\n\r\nDBD::mysql::st execute failed: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' at /opt/webwork/webwork2/bin/OPL-update line 290, <IN> line 1097.\r\n\r\nThis error occurs when handling line 1097 and 1098 of OpenProblemLibrary/Textbooks.  These lines contain extended characters that aren't UTF8, but also aren't valid latin1 characters.\r\n\r\nI initially tried changing the database to UTF8 instead of latin1, but this caused course creation to fail (I suppose that should be a separate bug against webwork2).  Next, I changed the symbols to plaintext counterparts (\"pi\" and \"inf\").  After this change, the import succeeds.\r\n\r\nIdeally, these characters should be changed to their correct UTF8 characters and the database changed to accept UTF8 (perhaps just the columns handling this data?)."},"comment":{"url":"https://api.github.com/repos/openwebwork/webwork-open-problem-library/issues/comments/75652160","html_url":"https://github.com/openwebwork/webwork-open-problem-library/issues/64#issuecomment-75652160","issue_url":"https://api.github.com/repos/openwebwork/webwork-open-problem-library/issues/64","id":75652160,"user":{"login":"jwj61","id":1873320,"avatar_url":"https://avatars.githubusercontent.com/u/1873320?v=3","gravatar_id":"","url":"https://api.github.com/users/jwj61","html_url":"https://github.com/jwj61","followers_url":"https://api.github.com/users/jwj61/followers","following_url":"https://api.github.com/users/jwj61/following{/other_user}","gists_url":"https://api.github.com/users/jwj61/gists{/gist_id}","starred_url":"https://api.github.com/users/jwj61/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jwj61/subscriptions","organizations_url":"https://api.github.com/users/jwj61/orgs","repos_url":"https://api.github.com/users/jwj61/repos","events_url":"https://api.github.com/users/jwj61/events{/privacy}","received_events_url":"https://api.github.com/users/jwj61/received_events","type":"User","site_admin":false},"created_at":"2015-02-23T22:32:35Z","updated_at":"2015-02-23T22:32:35Z","body":"I removed the offending characters.  Thanks for pointing it out."}}