{"action":"created","issue":{"url":"https://api.github.com/repos/laravel/framework/issues/11803","labels_url":"https://api.github.com/repos/laravel/framework/issues/11803/labels{/name}","comments_url":"https://api.github.com/repos/laravel/framework/issues/11803/comments","events_url":"https://api.github.com/repos/laravel/framework/issues/11803/events","html_url":"https://github.com/laravel/framework/issues/11803","id":125823867,"number":11803,"title":"[sqlite] Migration failed on deleting columns","user":{"login":"PhillippOhlandt","id":3123549,"avatar_url":"https://avatars.githubusercontent.com/u/3123549?v=3","gravatar_id":"","url":"https://api.github.com/users/PhillippOhlandt","html_url":"https://github.com/PhillippOhlandt","followers_url":"https://api.github.com/users/PhillippOhlandt/followers","following_url":"https://api.github.com/users/PhillippOhlandt/following{/other_user}","gists_url":"https://api.github.com/users/PhillippOhlandt/gists{/gist_id}","starred_url":"https://api.github.com/users/PhillippOhlandt/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/PhillippOhlandt/subscriptions","organizations_url":"https://api.github.com/users/PhillippOhlandt/orgs","repos_url":"https://api.github.com/users/PhillippOhlandt/repos","events_url":"https://api.github.com/users/PhillippOhlandt/events{/privacy}","received_events_url":"https://api.github.com/users/PhillippOhlandt/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2016-01-10T14:49:00Z","updated_at":"2016-01-10T14:58:20Z","closed_at":null,"body":"Hey,\r\n\r\nin my one migration I create a table with some columns and the next two:\r\n\r\n```\r\n$table->string('theme_author_name');\r\n$table->string('theme_author_bolt_store_id');\r\n```\r\n\r\nIn a later migration I want to delete the two columns because I don't need them anymore:\r\n\r\n```\r\n$table->dropColumn('theme_author_name');\r\n$table->dropColumn('theme_author_bolt_store_id');\r\n```\r\n\r\nEverything works fine on mysql but it fails on sqlite:\r\n\r\n```\r\n  [Illuminate\\Database\\QueryException]\r\n  SQLSTATE[HY000]: General error: 1 no such column: theme_author_name (SQL: CREATE TEMPORARY TABLE __temp__themes AS SELECT id, bolt_store_id, title, name, slug, source, description, installed_version, latest_version, icon, screenshots\r\n  , requirements, theme_created, theme_updated, theme_author_name, application_version, active, created_at, updated_at, author_id FROM themes)\r\n\r\n\r\n\r\n  [PDOException]\r\n  SQLSTATE[HY000]: General error: 1 no such column: theme_author_name\r\n```\r\n\r\nNow I can't migrate my testing DB."},"comment":{"url":"https://api.github.com/repos/laravel/framework/issues/comments/170356587","html_url":"https://github.com/laravel/framework/issues/11803#issuecomment-170356587","issue_url":"https://api.github.com/repos/laravel/framework/issues/11803","id":170356587,"user":{"login":"PhillippOhlandt","id":3123549,"avatar_url":"https://avatars.githubusercontent.com/u/3123549?v=3","gravatar_id":"","url":"https://api.github.com/users/PhillippOhlandt","html_url":"https://github.com/PhillippOhlandt","followers_url":"https://api.github.com/users/PhillippOhlandt/followers","following_url":"https://api.github.com/users/PhillippOhlandt/following{/other_user}","gists_url":"https://api.github.com/users/PhillippOhlandt/gists{/gist_id}","starred_url":"https://api.github.com/users/PhillippOhlandt/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/PhillippOhlandt/subscriptions","organizations_url":"https://api.github.com/users/PhillippOhlandt/orgs","repos_url":"https://api.github.com/users/PhillippOhlandt/repos","events_url":"https://api.github.com/users/PhillippOhlandt/events{/privacy}","received_events_url":"https://api.github.com/users/PhillippOhlandt/received_events","type":"User","site_admin":false},"created_at":"2016-01-10T14:58:20Z","updated_at":"2016-01-10T14:58:20Z","body":"Have you tried it on sqlite? I found out that it works when I delete just one column ..."}}