{"action":"created","issue":{"url":"https://api.github.com/repos/zlepper/TechnicSolderHelper/issues/25","labels_url":"https://api.github.com/repos/zlepper/TechnicSolderHelper/issues/25/labels{/name}","comments_url":"https://api.github.com/repos/zlepper/TechnicSolderHelper/issues/25/comments","events_url":"https://api.github.com/repos/zlepper/TechnicSolderHelper/issues/25/events","html_url":"https://github.com/zlepper/TechnicSolderHelper/issues/25","id":54948860,"number":25,"title":"SQL issues with Sangar","user":{"login":"brynjolf","id":871342,"avatar_url":"https://avatars.githubusercontent.com/u/871342?v=3","gravatar_id":"","url":"https://api.github.com/users/brynjolf","html_url":"https://github.com/brynjolf","followers_url":"https://api.github.com/users/brynjolf/followers","following_url":"https://api.github.com/users/brynjolf/following{/other_user}","gists_url":"https://api.github.com/users/brynjolf/gists{/gist_id}","starred_url":"https://api.github.com/users/brynjolf/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/brynjolf/subscriptions","organizations_url":"https://api.github.com/users/brynjolf/orgs","repos_url":"https://api.github.com/users/brynjolf/repos","events_url":"https://api.github.com/users/brynjolf/events{/privacy}","received_events_url":"https://api.github.com/users/brynjolf/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-01-20T22:20:21Z","updated_at":"2015-01-21T02:37:19Z","closed_at":null,"body":"Happened after deleting the SolderHelper folder and starting over on a directory on Wanderlust Reloaded. Most likely OpenComputers causing the issue.\r\n\r\n```\r\nSQL logic error or missing database\r\nnear \"Sangar\": syntax error\r\n   at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)\r\n   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()\r\n   at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)\r\n   at System.Data.SQLite.SQLiteDataReader.NextResult()\r\n   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)\r\n   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)\r\n   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)\r\n   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()\r\n   at TechnicSolderHelper.SQL.SqlHelper.ExecuteDatabaseQuery(String sql, Boolean async)\r\n   at TechnicSolderHelper.SQL.OwnPermissionsSqlHelper.AddAuthor(String modId, String authorName)\r\n   at TechnicSolderHelper.SolderHelper.GetAuthors(Mcmod mod)\r\n   at TechnicSolderHelper.SolderHelper.CreateTechnicModZip(Mcmod mod, String modfile)\r\n   at TechnicSolderHelper.SolderHelper.Start()\r\n   at TechnicSolderHelper.SolderHelper.button1_Click(Object sender, EventArgs e)\r\n   at System.Windows.Forms.Control.OnClick(EventArgs e)\r\n   at System.Windows.Forms.Button.OnClick(EventArgs e)\r\n   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)\r\n   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)\r\n   at System.Windows.Forms.Control.WndProc(Message& m)\r\n   at System.Windows.Forms.ButtonBase.WndProc(Message& m)\r\n   at System.Windows.Forms.Button.WndProc(Message& m)\r\n   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)\r\n   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)\r\n   at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)\r\n   at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)\r\n   at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)\r\n   at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)\r\n   at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)\r\n   at System.Windows.Forms.Application.Run(Form mainForm)\r\n   at TechnicSolderHelper.Program.Main()\r\n```\r\n"},"comment":{"url":"https://api.github.com/repos/zlepper/TechnicSolderHelper/issues/comments/70774965","html_url":"https://github.com/zlepper/TechnicSolderHelper/issues/25#issuecomment-70774965","issue_url":"https://api.github.com/repos/zlepper/TechnicSolderHelper/issues/25","id":70774965,"user":{"login":"unseenline","id":10588509,"avatar_url":"https://avatars.githubusercontent.com/u/10588509?v=3","gravatar_id":"","url":"https://api.github.com/users/unseenline","html_url":"https://github.com/unseenline","followers_url":"https://api.github.com/users/unseenline/followers","following_url":"https://api.github.com/users/unseenline/following{/other_user}","gists_url":"https://api.github.com/users/unseenline/gists{/gist_id}","starred_url":"https://api.github.com/users/unseenline/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/unseenline/subscriptions","organizations_url":"https://api.github.com/users/unseenline/orgs","repos_url":"https://api.github.com/users/unseenline/repos","events_url":"https://api.github.com/users/unseenline/events{/privacy}","received_events_url":"https://api.github.com/users/unseenline/received_events","type":"User","site_admin":false},"created_at":"2015-01-21T02:37:19Z","updated_at":"2015-01-21T02:37:19Z","body":"I can can confirm that there is an error when loading the WanderLust Reloaded mod pack from FTB\r\nI'm attaching my error log as it has line numbers that should be of help.\r\n```\r\nSQL logic error or missing database\r\nnear \"Sangar\": syntax error\r\n   at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)\r\n   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()\r\n   at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)\r\n   at System.Data.SQLite.SQLiteDataReader.NextResult()\r\n   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)\r\n   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)\r\n   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)\r\n   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()\r\n   at TechnicSolderHelper.SQL.SqlHelper.ExecuteDatabaseQuery(String sql, Boolean async) in c:\\GAMES\\Minecraft\\TechnicSolderHelperFork\\TechnicSolderHelper\\SQL\\SQLhelper.cs:line 97\r\n   at TechnicSolderHelper.SQL.OwnPermissionsSqlHelper.AddAuthor(String modId, String authorName) in c:\\GAMES\\Minecraft\\TechnicSolderHelperFork\\TechnicSolderHelper\\SQL\\OwnPermissionsSQLHelper.cs:line 142\r\n   at TechnicSolderHelper.SolderHelper.GetAuthors(Mcmod mod) in c:\\GAMES\\Minecraft\\TechnicSolderHelperFork\\TechnicSolderHelper\\TechnicSolderHelper.cs:line 119\r\n   at TechnicSolderHelper.SolderHelper.CreateTechnicModZip(Mcmod mod, String modfile) in c:\\GAMES\\Minecraft\\TechnicSolderHelperFork\\TechnicSolderHelper\\TechnicStuff.cs:line 369\r\n   at TechnicSolderHelper.SolderHelper.Start() in c:\\GAMES\\Minecraft\\TechnicSolderHelperFork\\TechnicSolderHelper\\TechnicSolderHelper.cs:line 472\r\n   at TechnicSolderHelper.SolderHelper.button1_Click(Object sender, EventArgs e) in c:\\GAMES\\Minecraft\\TechnicSolderHelperFork\\TechnicSolderHelper\\TechnicSolderHelper.cs:line 1320\r\n   at System.Windows.Forms.Control.OnClick(EventArgs e)\r\n   at System.Windows.Forms.Button.OnClick(EventArgs e)\r\n   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)\r\n   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)\r\n   at System.Windows.Forms.Control.WndProc(Message& m)\r\n   at System.Windows.Forms.ButtonBase.WndProc(Message& m)\r\n   at System.Windows.Forms.Button.WndProc(Message& m)\r\n   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)\r\n   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)\r\n   at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)\r\n   at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)\r\n   at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)\r\n   at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)\r\n   at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)\r\n   at System.Windows.Forms.Application.Run(Form mainForm)\r\n   at TechnicSolderHelper.Program.Main() in c:\\GAMES\\Minecraft\\TechnicSolderHelperFork\\TechnicSolderHelper\\Program.cs:line 18\r\n```"}}