{"action":"created","issue":{"url":"https://api.github.com/repos/driftyco/ionic2/issues/770","labels_url":"https://api.github.com/repos/driftyco/ionic2/issues/770/labels{/name}","comments_url":"https://api.github.com/repos/driftyco/ionic2/issues/770/comments","events_url":"https://api.github.com/repos/driftyco/ionic2/issues/770/events","html_url":"https://github.com/driftyco/ionic2/issues/770","id":122790509,"number":770,"title":"Errors with SqlStorage","user":{"login":"nraboy","id":983958,"avatar_url":"https://avatars.githubusercontent.com/u/983958?v=3","gravatar_id":"","url":"https://api.github.com/users/nraboy","html_url":"https://github.com/nraboy","followers_url":"https://api.github.com/users/nraboy/followers","following_url":"https://api.github.com/users/nraboy/following{/other_user}","gists_url":"https://api.github.com/users/nraboy/gists{/gist_id}","starred_url":"https://api.github.com/users/nraboy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nraboy/subscriptions","organizations_url":"https://api.github.com/users/nraboy/orgs","repos_url":"https://api.github.com/users/nraboy/repos","events_url":"https://api.github.com/users/nraboy/events{/privacy}","received_events_url":"https://api.github.com/users/nraboy/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-12-17T18:04:37Z","updated_at":"2015-12-17T19:26:36Z","closed_at":null,"body":"I am getting the following error:\r\n\r\n```\r\nI/chromium( 2458): [INFO:CONSOLE(174)] \"OPEN database: __ionicstorage\", source: file:///android_asset/www/plugins/cordova-sqlite-storage/www/SQLitePlugin.js (174)\r\nV/SQLitePlugin( 2458): Android db implementation: sqlite4java (NDK)\r\nV/info    ( 2458): Open sqlite db: /data/data/io.ionic.starter/databases/__ionicstorage\r\nI/chromium( 2458): [INFO:CONSOLE(105)] \"new transaction is waiting for open operation\", source: file:///android_asset/www/plugins/cordova-sqlite-storage/www/SQLitePlugin.js (105)\r\nI/chromium( 2458): [INFO:CONSOLE(6110)] \"CREATING TABLE\", source: file:///android_asset/www/build/js/app.bundle.js (6110)\r\nI/chromium( 2458): [INFO:CONSOLE(105)] \"new transaction is waiting for open operation\", source: file:///android_asset/www/plugins/cordova-sqlite-storage/www/SQLitePlugin.js (105)\r\nE/AndroidProtocolHandler( 2458): Unable to open asset URL: file:///android_asset/www/build/fonts/roboto-regular.ttf\r\nE/AndroidProtocolHandler( 2458): Unable to open asset URL: file:///android_asset/www/build/fonts/roboto-medium.ttf\r\nI/chromium( 2458): [INFO:CONSOLE(79)] \"DB opened: __ionicstorage\", source: file:///android_asset/www/plugins/cordova-sqlite-storage/www/SQLitePlugin.js (79)\r\nE/AndroidProtocolHandler( 2458): Unable to open asset URL: file:///android_asset/www/build/fonts/roboto-regular.woff\r\nE/AndroidProtocolHandler( 2458): Unable to open asset URL: file:///android_asset/www/build/fonts/roboto-medium.woff\r\nW/System.err( 2458): java.sql.SQLException: sqlite3_bind_null failure: bind or column index out of range\r\nW/System.err( 2458): \tat io.liteglue.SQLiteGlueConnection$SQLGStatement.bindNull(SQLiteGlueConnection.java:113)\r\nW/System.err( 2458): \tat io.liteglue.SQLitePlugin$SQLiteDatabaseNDK.executeSqlStatementNDK(SQLitePlugin.java:452)\r\nW/System.err( 2458): \tat io.liteglue.SQLitePlugin$SQLiteDatabaseNDK.executeSqlBatch(SQLitePlugin.java:384)\r\nW/System.err( 2458): \tat io.liteglue.SQLitePlugin$DBRunner.run(SQLitePlugin.java:566)\r\nW/System.err( 2458): \tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1112)\r\nW/System.err( 2458): \tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:587)\r\nW/System.err( 2458): \tat java.lang.Thread.run(Thread.java:818)\r\nV/executeSqlBatch( 2458): SQLitePlugin.executeSql[Batch](): Error=sqlite3_bind_null failure: bind or column index out of range\r\nW/System.err( 2458): java.sql.SQLException: sqlite3_bind_null failure: bind or column index out of range\r\nW/System.err( 2458): \tat io.liteglue.SQLiteGlueConnection$SQLGStatement.bindNull(SQLiteGlueConnection.java:113)\r\nW/System.err( 2458): \tat io.liteglue.SQLitePlugin$SQLiteDatabaseNDK.executeSqlStatementNDK(SQLitePlugin.java:452)\r\nW/System.err( 2458): \tat io.liteglue.SQLitePlugin$SQLiteDatabaseNDK.executeSqlBatch(SQLitePlugin.java:384)\r\nW/System.err( 2458): \tat io.liteglue.SQLitePlugin$DBRunner.run(SQLitePlugin.java:566)\r\nW/System.err( 2458): \tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1112)\r\nW/System.err( 2458): \tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:587)\r\nW/System.err( 2458): \tat java.lang.Thread.run(Thread.java:818)\r\nV/executeSqlBatch( 2458): SQLitePlugin.executeSql[Batch](): Error=sqlite3_bind_null failure: bind or column index out of range\r\nI/chromium( 2458): [INFO:CONSOLE(6114)] \"ERROR -> {\"tx\":{\"db\":{\"openargs\":{\"name\":\"__ionicstorage\",\"location\":2,\"createFromLocation\":0,\"backupFlag\":2,\"existingDatabase\":false,\"dblocation\":\"nosync\"},\"dbname\":\"__ionicstorage\"},\"txlock\":true,\"readOnly\":false,\"executes\":[],\"finalized\":true},\"err\":{\"message\":\"sqlite3_bind_null failure: bind or column index out of range\",\"code\":0}}\"\r\n```\r\n\r\nThis happens when I try to do the following:\r\n\r\n```javascript\r\nthis.storage = new Storage(SqlStorage);\r\nconsole.log(\"CREATING TABLE\");\r\nthis.storage.query('CREATE TABLE IF NOT EXISTS people (id INTEGER PRIMARY KEY, firstname TEXT, lastname TEXT)').then((data) => {\r\n    console.log(\"TABLE CREATED -> \" + JSON.stringify(data));\r\n}, (error) => {\r\n    console.log(\"ERROR -> \" + JSON.stringify(error));\r\n});\r\n```\r\n\r\nLast I checked that is a perfectly fine statement for creating a SQLite table.\r\n\r\nAny insight?\r\n\r\nThanks,"},"comment":{"url":"https://api.github.com/repos/driftyco/ionic2/issues/comments/165555810","html_url":"https://github.com/driftyco/ionic2/issues/770#issuecomment-165555810","issue_url":"https://api.github.com/repos/driftyco/ionic2/issues/770","id":165555810,"user":{"login":"nraboy","id":983958,"avatar_url":"https://avatars.githubusercontent.com/u/983958?v=3","gravatar_id":"","url":"https://api.github.com/users/nraboy","html_url":"https://github.com/nraboy","followers_url":"https://api.github.com/users/nraboy/followers","following_url":"https://api.github.com/users/nraboy/following{/other_user}","gists_url":"https://api.github.com/users/nraboy/gists{/gist_id}","starred_url":"https://api.github.com/users/nraboy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nraboy/subscriptions","organizations_url":"https://api.github.com/users/nraboy/orgs","repos_url":"https://api.github.com/users/nraboy/repos","events_url":"https://api.github.com/users/nraboy/events{/privacy}","received_events_url":"https://api.github.com/users/nraboy/received_events","type":"User","site_admin":false},"created_at":"2015-12-17T19:26:36Z","updated_at":"2015-12-17T19:26:36Z","body":"I won't dig too deep into this since a GitHub issue ticket probably isn't the best place.  I'm just interested to know how it would be different as beta or stable.  Are there plans to snapshot certain plugins to prevent installing a potentially broken build?"}}