{"action":"closed","issue":{"url":"https://api.github.com/repos/traccar/traccar/issues/4045","repository_url":"https://api.github.com/repos/traccar/traccar","labels_url":"https://api.github.com/repos/traccar/traccar/issues/4045/labels{/name}","comments_url":"https://api.github.com/repos/traccar/traccar/issues/4045/comments","events_url":"https://api.github.com/repos/traccar/traccar/issues/4045/events","html_url":"https://github.com/traccar/traccar/issues/4045","id":357587780,"node_id":"MDU6SXNzdWUzNTc1ODc3ODA=","number":4045,"title":"Can't delete users in Traccar 4.0 with Microsoft SQL 2014 database","user":{"login":"dlajusticia","id":41141776,"node_id":"MDQ6VXNlcjQxMTQxNzc2","avatar_url":"https://avatars1.githubusercontent.com/u/41141776?v=4","gravatar_id":"","url":"https://api.github.com/users/dlajusticia","html_url":"https://github.com/dlajusticia","followers_url":"https://api.github.com/users/dlajusticia/followers","following_url":"https://api.github.com/users/dlajusticia/following{/other_user}","gists_url":"https://api.github.com/users/dlajusticia/gists{/gist_id}","starred_url":"https://api.github.com/users/dlajusticia/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dlajusticia/subscriptions","organizations_url":"https://api.github.com/users/dlajusticia/orgs","repos_url":"https://api.github.com/users/dlajusticia/repos","events_url":"https://api.github.com/users/dlajusticia/events{/privacy}","received_events_url":"https://api.github.com/users/dlajusticia/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-09-06T10:13:28Z","updated_at":"2018-09-06T11:48:47Z","closed_at":"2018-09-06T11:48:47Z","author_association":"NONE","body":"Hi,\r\n\r\nwhen I try to delete a user, in the Web UI, or directly in the database, I get the following error:\r\n\r\nError in Web UI:\r\n```\r\nEl nombre de objeto 'user_user' no es válido. - SQLServerException (... < QueryBuilder:477 < DataManager:470 < BaseObjectManager:107 < ...)\r\n```\r\n\r\nError in MsSQL Manager:\r\n```\r\nMsg 208, Level 16, State 1, Procedure tg_users_delete, Line 4 [Batch Start Line 0]\r\nEl nombre de objeto 'user_user' no es válido.\r\n```\r\n\r\nIt doesn't matter if it is a user created before or after updating, I get the same error.\r\n\r\nI think there is a problem with table names and the trigger that deletes user related data in other tables on cascade, so I tried editing the schema file 'changelog-3.10.xml' , where appears the trigger 'tg_users_delete', adding 'tc_' to table names, but I had no success.\r\n\r\nAny tips? Thank you in advance."}}
{"actor":{"display_login":"tananaev"}}