{"action":"closed","issue":{"url":"https://api.github.com/repos/litehelpers/Cordova-sqlite-storage/issues/418","repository_url":"https://api.github.com/repos/litehelpers/Cordova-sqlite-storage","labels_url":"https://api.github.com/repos/litehelpers/Cordova-sqlite-storage/issues/418/labels{/name}","comments_url":"https://api.github.com/repos/litehelpers/Cordova-sqlite-storage/issues/418/comments","events_url":"https://api.github.com/repos/litehelpers/Cordova-sqlite-storage/issues/418/events","html_url":"https://github.com/litehelpers/Cordova-sqlite-storage/issues/418","id":132155687,"number":418,"title":"alter table add column not working","user":{"login":"rbabler","id":16963817,"avatar_url":"https://avatars.githubusercontent.com/u/16963817?v=3","gravatar_id":"","url":"https://api.github.com/users/rbabler","html_url":"https://github.com/rbabler","followers_url":"https://api.github.com/users/rbabler/followers","following_url":"https://api.github.com/users/rbabler/following{/other_user}","gists_url":"https://api.github.com/users/rbabler/gists{/gist_id}","starred_url":"https://api.github.com/users/rbabler/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rbabler/subscriptions","organizations_url":"https://api.github.com/users/rbabler/orgs","repos_url":"https://api.github.com/users/rbabler/repos","events_url":"https://api.github.com/users/rbabler/events{/privacy}","received_events_url":"https://api.github.com/users/rbabler/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/litehelpers/Cordova-sqlite-storage/labels/info%20needed","name":"info needed","color":"207de5"},{"url":"https://api.github.com/repos/litehelpers/Cordova-sqlite-storage/labels/question","name":"question","color":"cc317c"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2016-02-08T14:27:23Z","updated_at":"2016-04-03T13:19:22Z","closed_at":"2016-04-03T13:19:22Z","body":"Hi,\r\n\r\nafter device ready i create db tables and alter statements. All statements are succesfully executed.\r\nIf i try to insert in my table, i got an error that my new column (created with alter table add ...) does not exists.\r\nI don´t have a typo.\r\n\r\nIf i clear the data of my app, then i works correctly. But in this way i lost the data and so it is not a possible way.\r\n\r\nIs there a problem, if the table has data and i try to add a new column?\r\n\r\nPlease do you have some tips for me.\r\n\r\nbest regards\r\nRené"}}