{"action":"created","issue":{"url":"https://api.github.com/repos/xpressengine/xe-core/issues/1677","labels_url":"https://api.github.com/repos/xpressengine/xe-core/issues/1677/labels{/name}","comments_url":"https://api.github.com/repos/xpressengine/xe-core/issues/1677/comments","events_url":"https://api.github.com/repos/xpressengine/xe-core/issues/1677/events","html_url":"https://github.com/xpressengine/xe-core/issues/1677","id":97454986,"number":1677,"title":"MSSQL 환경 아래에서 칼럼 추가가 필요한 모듈 업데이트가 실패함","user":{"login":"RapidWorkers","id":6492071,"avatar_url":"https://avatars.githubusercontent.com/u/6492071?v=3","gravatar_id":"","url":"https://api.github.com/users/RapidWorkers","html_url":"https://github.com/RapidWorkers","followers_url":"https://api.github.com/users/RapidWorkers/followers","following_url":"https://api.github.com/users/RapidWorkers/following{/other_user}","gists_url":"https://api.github.com/users/RapidWorkers/gists{/gist_id}","starred_url":"https://api.github.com/users/RapidWorkers/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/RapidWorkers/subscriptions","organizations_url":"https://api.github.com/users/RapidWorkers/orgs","repos_url":"https://api.github.com/users/RapidWorkers/repos","events_url":"https://api.github.com/users/RapidWorkers/events{/privacy}","received_events_url":"https://api.github.com/users/RapidWorkers/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-07-27T12:46:17Z","updated_at":"2015-07-27T14:18:09Z","closed_at":null,"body":"안녕하세요\r\n제가 XE를 구동하는 환경은 아래와 같습니다.\r\napp : Microsoft-IIS/8.5\r\nxe_version : 1.8.7\r\nphp : 5.4.24\r\n\r\n````\r\n05. alter table xe_menu_item add desc  nvarchar(250)  default ''  not null \r\n\t\t0.000858 sec. Query  : 0\r\n\t\t\t   Array\r\n(\r\n    [0] => Array\r\n        (\r\n            [0] => 42000\r\n            [SQLSTATE] => 42000\r\n            [1] => 156\r\n            [code] => 156\r\n            [2] => [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'desc'.\r\n            [message] => [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'desc'.\r\n        )\r\n\r\n    [1] => Array\r\n        (\r\n            [0] => 42000\r\n            [SQLSTATE] => 42000\r\n            [1] => 8180\r\n            [code] => 8180\r\n            [2] => [Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not be prepared.\r\n            [message] => [Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not be prepared.\r\n        )\r\n\r\n)\r\n.\r\n\t\tConnection: Master XXXX\r\n\t\tQuery ID: member.getMemberListWithinGroup\r\n\t\tCalled: . ()\r\n````\r\nDB로는 제목에도 써있다시피 MSSQL을 사용중입니다. 이번에 사이트를 업데이트하면서 모듈 업데이트를 눌렀으나 업데이트가 하나도 되지 않아(...) 디버그하여 확인해보니 위와 같은 문제가 발생하였습니다. 코어측에서 따옴표를 다 날리는건지 desc부분에 따옴표가 없어서 생기는 오류입니다.\r\n즉 \r\n````alter table xe_menu_item add desc  nvarchar(250)  default ''  not null```` 를\r\n\r\n````alter table xe_menu_item add \"desc\"  nvarchar(250)  default ''  not null ````로 수정하면 동작합니다.\r\n\r\n해결 부탁드립니다.\r\n\r\n비슷한 사례(?) : #1641\r\n\r\n1.8.1 환경 아니면 그 이전부터 존재하던 문제로 보입니다."},"comment":{"url":"https://api.github.com/repos/xpressengine/xe-core/issues/comments/125222367","html_url":"https://github.com/xpressengine/xe-core/issues/1677#issuecomment-125222367","issue_url":"https://api.github.com/repos/xpressengine/xe-core/issues/1677","id":125222367,"user":{"login":"RapidWorkers","id":6492071,"avatar_url":"https://avatars.githubusercontent.com/u/6492071?v=3","gravatar_id":"","url":"https://api.github.com/users/RapidWorkers","html_url":"https://github.com/RapidWorkers","followers_url":"https://api.github.com/users/RapidWorkers/followers","following_url":"https://api.github.com/users/RapidWorkers/following{/other_user}","gists_url":"https://api.github.com/users/RapidWorkers/gists{/gist_id}","starred_url":"https://api.github.com/users/RapidWorkers/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/RapidWorkers/subscriptions","organizations_url":"https://api.github.com/users/RapidWorkers/orgs","repos_url":"https://api.github.com/users/RapidWorkers/repos","events_url":"https://api.github.com/users/RapidWorkers/events{/privacy}","received_events_url":"https://api.github.com/users/RapidWorkers/received_events","type":"User","site_admin":false},"created_at":"2015-07-27T14:18:09Z","updated_at":"2015-07-27T14:18:09Z","body":"일단 PR을 올리기는 했습니다만... MSSQL 드라이버가 MySQL 복붙판이나 다름이 없습니다 ㅠㅠ\r\n디폴트값이 존재할경우 alter부분을 손봐야 하는 등 앞으로 많은 부분에서 수정이 필요하겠네요."}}