{"action":"created","issue":{"url":"https://api.github.com/repos/OpenNos/OpenNos/issues/1312","repository_url":"https://api.github.com/repos/OpenNos/OpenNos","labels_url":"https://api.github.com/repos/OpenNos/OpenNos/issues/1312/labels{/name}","comments_url":"https://api.github.com/repos/OpenNos/OpenNos/issues/1312/comments","events_url":"https://api.github.com/repos/OpenNos/OpenNos/issues/1312/events","html_url":"https://github.com/OpenNos/OpenNos/issues/1312","id":184628725,"number":1312,"title":"Error sql","user":{"login":"Halim980","id":22886394,"avatar_url":"https://avatars.githubusercontent.com/u/22886394?v=3","gravatar_id":"","url":"https://api.github.com/users/Halim980","html_url":"https://github.com/Halim980","followers_url":"https://api.github.com/users/Halim980/followers","following_url":"https://api.github.com/users/Halim980/following{/other_user}","gists_url":"https://api.github.com/users/Halim980/gists{/gist_id}","starred_url":"https://api.github.com/users/Halim980/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Halim980/subscriptions","organizations_url":"https://api.github.com/users/Halim980/orgs","repos_url":"https://api.github.com/users/Halim980/repos","events_url":"https://api.github.com/users/Halim980/events{/privacy}","received_events_url":"https://api.github.com/users/Halim980/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-10-22T12:52:08Z","updated_at":"2016-10-22T12:53:34Z","closed_at":"2016-10-22T12:53:33Z","body":"I have this error when I try to excute sql \r\n[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DECLARE @CurrentMigration [nvarchar](max)\r\n\r\nIF object_id('[dbo].[__MigrationHisto' at line 5\r\n[Err] -- ========================================== --\r\n-- Current Migration: 201610211827432_Ares\r\n-- ========================================== --\r\n\r\nDECLARE @CurrentMigration [nvarchar](max)\r\n\r\nIF object_id('[dbo].[__MigrationHistory]') IS NOT NULL\r\n    SELECT @CurrentMigration =\r\n        (SELECT TOP (1) \r\n        [Project1].[MigrationId] AS [MigrationId]\r\n        FROM ( SELECT \r\n        [Extent1].[MigrationId] AS [MigrationId]\r\n        FROM [dbo].[__MigrationHistory] AS [Extent1]\r\n        WHERE [Extent1].[ContextKey] = N'OpenNos.DAL.EF.Migrations.Configuration'\r\n        )  AS [Project1]\r\n        ORDER BY [Project1].[MigrationId] DESC)\r\n\r\nIF @CurrentMigration IS NULL\r\n    SET @CurrentMigration = '0'\r\n\r\nIF @CurrentMigration < '201610211827432_Ares'\r\nBEGIN\r\n    CREATE TABLE [dbo].[Account] (\r\n        [AccountId] [bigint] NOT NULL IDENTITY,\r\n        [Authority] [smallint] NOT NULL,\r\n        [LastCompliment] [datetime] NOT NULL,\r\n        [LastSession] [int] NOT NULL,\r\n        [Name] [nvarchar](255),\r\n        [Password] [varchar](255),\r\n        CONSTRAINT [PK_dbo.Account] PRIMARY KEY ([AccountId])\r\n    )\r\n    CREATE TABLE [dbo].[Character] (\r\n        [CharacterId] [bigint] NOT NULL IDENTITY,\r\n        [AccountId] [bigint] NOT NULL,\r\n        [Act4Dead] [int] NOT NULL,\r\n        [Act4Kill] [int] NOT NULL,\r\n        [Act4Points] [int] NOT NULL,\r\n        [ArenaWinner] [int] NOT NULL,\r\n        [Backpack] [int] NOT NULL,\r\n        [Biography] [nvarchar](max),\r\n        [BuffBlocked] [bit] NOT NULL,\r\n        [Class] [tinyint] NOT NULL,\r\n        [Compliment] [smallint] NOT NULL,\r\n        [Dignity] [real] NOT NULL,\r\n        [EmoticonsBlocked] [bit] NOT NULL,\r\n        [ExchangeBlocked] [bit] NOT NULL,\r\n        [Faction] [int] NOT NULL,\r\n        [FamilyRequestBlocked] [bit] NOT NULL,\r\n        [FriendRequestBlocked] [bit] NOT NULL,\r\n        [Gender] [tinyint] NOT NULL,\r\n        [Gold] [bigint] NOT NULL,\r\n        [GroupRequestBlocked] [bit] NOT NULL,\r\n        [HairColor] [tinyint] NOT NULL,\r\n        [HairStyle] [tinyint] NOT NULL,\r\n        [HeroChatBlocked] [bit] NOT NULL,\r\n        [HeroLevel] [tinyint] NOT NULL,\r\n        [HeroXp] [bigint] NOT NULL,\r\n        [Hp] [int] NOT NULL,\r\n        [HpBlocked] [bit] NOT NULL,\r\n        [JobLevel] [tinyint] NOT NULL,\r\n        [JobLevelXp] [bigint] NOT NULL,\r\n        [Level] [tinyint] NOT NULL,\r\n        [LevelXp] [bigint] NOT NULL,\r\n        [MapId] [smallint] NOT NULL,\r\n        [MapX] [smallint] NOT NULL,\r\n        [MapY] [smallint] NOT NULL,\r\n        [MasterPoints] [int] NOT NULL,\r\n        [MasterTicket] [int] NOT NULL,\r\n        [MinilandInviteBlocked] [bit] NOT NULL,\r\n        [MouseAimLock] [bit] NOT NULL,\r\n        [Mp] [int] NOT NULL,\r\n        [Name] [varchar](255),\r\n        [QuickGetUp] [bit] NOT NULL,\r\n        [RagePoint] [bigint] NOT NULL,\r\n        [Reput] [bigint] NOT NULL,\r\n        [Slot] [tinyint] NOT NULL,\r\n        [SpAdditionPoint] [int] NOT NULL,\r\n        [SpPoint] [int] NOT NULL,\r\n        [State] [tinyint] NOT NULL,\r\n        [TalentLose] [int] NOT NULL,\r\n        [TalentSurrender] [int] NOT NULL,\r\n        [TalentWin] [int] NOT NULL,\r\n        [WhisperBlocked] [bit] NOT NULL,\r\n        CONSTRAINT [PK_dbo.Character] PRIMARY KEY ([CharacterId])\r\n    )\r\n    CREATE INDEX [IX_AccountId] ON [dbo].[Character]([AccountId])\r\n    CREATE INDEX [IX_MapId] ON [dbo].[Character]([MapId])\r\n    CREATE TABLE [dbo].[CharacterSkill] (\r\n        [Id] [uniqueidentifier] NOT NULL,\r\n        [CharacterId] [bigint] NOT NULL,\r\n        [SkillVNum] [smallint] NOT NULL,\r\n        CONSTRAINT [PK_dbo.CharacterSkill] PRIMARY KEY ([Id])\r\n    )\r\n    CREATE INDEX [IX_CharacterId] ON [dbo].[CharacterSkill]([CharacterId])\r\n    CREATE INDEX [IX_SkillVNum] ON [dbo].[CharacterSkill]([SkillVNum])\r\n    CREATE TABLE [dbo].[Skill] (\r\n        [SkillVNum] [smallint] NOT NULL,\r\n        [AttackAnimation] [smallint] NOT NULL,\r\n        [BuffId] [smallint] NOT NULL,\r\n        [CastAnimation] [smallint] NOT NULL,\r\n        [CastEffect] [smallint] NOT NULL,\r\n        [CastId] [smallint] NOT NULL,\r\n        [CastTime] [smallint] NOT NULL,\r\n        [Class] [tinyint] NOT NULL,\r\n        [Cooldown] [smallint] NOT NULL,\r\n        [CPCost] [tinyint] NOT NULL,\r\n      \r\n[Msg] Finished - Unsuccessfully\r\n--------------------------------------------------"},"comment":{"url":"https://api.github.com/repos/OpenNos/OpenNos/issues/comments/255526783","html_url":"https://github.com/OpenNos/OpenNos/issues/1312#issuecomment-255526783","issue_url":"https://api.github.com/repos/OpenNos/OpenNos/issues/1312","id":255526783,"user":{"login":"0Lucifer0","id":15112753,"avatar_url":"https://avatars.githubusercontent.com/u/15112753?v=3","gravatar_id":"","url":"https://api.github.com/users/0Lucifer0","html_url":"https://github.com/0Lucifer0","followers_url":"https://api.github.com/users/0Lucifer0/followers","following_url":"https://api.github.com/users/0Lucifer0/following{/other_user}","gists_url":"https://api.github.com/users/0Lucifer0/gists{/gist_id}","starred_url":"https://api.github.com/users/0Lucifer0/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/0Lucifer0/subscriptions","organizations_url":"https://api.github.com/users/0Lucifer0/orgs","repos_url":"https://api.github.com/users/0Lucifer0/repos","events_url":"https://api.github.com/users/0Lucifer0/events{/privacy}","received_events_url":"https://api.github.com/users/0Lucifer0/received_events","type":"User","site_admin":false},"created_at":"2016-10-22T12:53:33Z","updated_at":"2016-10-22T12:53:33Z","body":"RTFM."}}
{"actor":{"display_login":"0Lucifer0"}}