{"action":"created","issue":{"url":"https://api.github.com/repos/JadeCore/JadeCore/issues/78","repository_url":"https://api.github.com/repos/JadeCore/JadeCore","labels_url":"https://api.github.com/repos/JadeCore/JadeCore/issues/78/labels{/name}","comments_url":"https://api.github.com/repos/JadeCore/JadeCore/issues/78/comments","events_url":"https://api.github.com/repos/JadeCore/JadeCore/issues/78/events","html_url":"https://github.com/JadeCore/JadeCore/issues/78","id":184407402,"number":78,"title":"SQL update error: 2016_10_20_09_world_548.sql  with  Out of range","user":{"login":"angelsss","id":19160348,"avatar_url":"https://avatars.githubusercontent.com/u/19160348?v=3","gravatar_id":"","url":"https://api.github.com/users/angelsss","html_url":"https://github.com/angelsss","followers_url":"https://api.github.com/users/angelsss/followers","following_url":"https://api.github.com/users/angelsss/following{/other_user}","gists_url":"https://api.github.com/users/angelsss/gists{/gist_id}","starred_url":"https://api.github.com/users/angelsss/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/angelsss/subscriptions","organizations_url":"https://api.github.com/users/angelsss/orgs","repos_url":"https://api.github.com/users/angelsss/repos","events_url":"https://api.github.com/users/angelsss/events{/privacy}","received_events_url":"https://api.github.com/users/angelsss/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-10-21T06:15:36Z","updated_at":"2016-10-21T09:57:44Z","closed_at":null,"body":"Issue: the last sql at the end of **2016_10_20_09_world_548.sql** \r\n\r\nUPDATE creature SET equipment_id=0 WHERE equipment_id=69296;\r\nERROR: Out of range value for column 'equipment_id'  \r\n `equipment_id` tinyint(3) NOT NULL DEFAULT '0', （-32768 32767）\r\n\r\n**the scheme of creature limit: equipment_id between  -32768 32767 but updated to 69296**\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/JadeCore/JadeCore/issues/comments/255342093","html_url":"https://github.com/JadeCore/JadeCore/issues/78#issuecomment-255342093","issue_url":"https://api.github.com/repos/JadeCore/JadeCore/issues/78","id":255342093,"user":{"login":"Bodeguero","id":8006687,"avatar_url":"https://avatars.githubusercontent.com/u/8006687?v=3","gravatar_id":"","url":"https://api.github.com/users/Bodeguero","html_url":"https://github.com/Bodeguero","followers_url":"https://api.github.com/users/Bodeguero/followers","following_url":"https://api.github.com/users/Bodeguero/following{/other_user}","gists_url":"https://api.github.com/users/Bodeguero/gists{/gist_id}","starred_url":"https://api.github.com/users/Bodeguero/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Bodeguero/subscriptions","organizations_url":"https://api.github.com/users/Bodeguero/orgs","repos_url":"https://api.github.com/users/Bodeguero/repos","events_url":"https://api.github.com/users/Bodeguero/events{/privacy}","received_events_url":"https://api.github.com/users/Bodeguero/received_events","type":"User","site_admin":false},"created_at":"2016-10-21T09:57:44Z","updated_at":"2016-10-21T09:57:44Z","body":"@angelsss is using this version? https://github.com/JadeCore/JadeCore/releases/tag/JCDB548.07?\r\n\r\nI just download this release and runs the query and I have no errors! Very strange it!\r\n\r\nI'm using **JCDB_548_07_full_2016_10_11.sql** - no have errors look:\r\n\r\n**1 queries executed, 1 success, 0 errors, 0 warnings**\r\n\r\n```\r\nQuery: UPDATE creature SET equipment_id=0 WHERE equipment_id=69296\r\n\r\n1 row(s) affected\r\n\r\nExecution Time : 0.050 sec\r\nTransfer Time  : 0 sec\r\nTotal Time     : 0.051 sec\r\n```\r\n\r\n\r\n\r\n"}}
{"actor":{"display_login":"Bodeguero"}}