{"action":"created","issue":{"url":"https://api.github.com/repos/bobdenotter/seo/issues/16","labels_url":"https://api.github.com/repos/bobdenotter/seo/issues/16/labels{/name}","comments_url":"https://api.github.com/repos/bobdenotter/seo/issues/16/comments","events_url":"https://api.github.com/repos/bobdenotter/seo/issues/16/events","html_url":"https://github.com/bobdenotter/seo/issues/16","id":124760858,"number":16,"title":"Database exception when adding SEO type field to existing database","user":{"login":"Pinpickle","id":3238878,"avatar_url":"https://avatars.githubusercontent.com/u/3238878?v=3","gravatar_id":"","url":"https://api.github.com/users/Pinpickle","html_url":"https://github.com/Pinpickle","followers_url":"https://api.github.com/users/Pinpickle/followers","following_url":"https://api.github.com/users/Pinpickle/following{/other_user}","gists_url":"https://api.github.com/users/Pinpickle/gists{/gist_id}","starred_url":"https://api.github.com/users/Pinpickle/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Pinpickle/subscriptions","organizations_url":"https://api.github.com/users/Pinpickle/orgs","repos_url":"https://api.github.com/users/Pinpickle/repos","events_url":"https://api.github.com/users/Pinpickle/events{/privacy}","received_events_url":"https://api.github.com/users/Pinpickle/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-01-04T13:44:05Z","updated_at":"2016-01-04T20:56:54Z","closed_at":null,"body":"In Bolt v2.2.16, when I add a field of type SEO when a database (SQLite) is already present, I get the following exception:\r\n\r\n```\r\nDoctrine\\DBAL\\Exception\\DriverException thrown with message \"An exception occurred while executing 'ALTER TABLE bolt_resources ADD COLUMN seo CLOB NOT NULL':\r\n\r\nSQLSTATE[HY000]: General error: 1 Cannot add a NOT NULL column with default value NULL\"\r\n\r\nStacktrace:\r\n#18 Doctrine\\DBAL\\Exception\\DriverException in /vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractSQLiteDriver.php:85\r\n#17 Doctrine\\DBAL\\Driver\\AbstractSQLiteDriver:convertException in /vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:116\r\n#16 Doctrine\\DBAL\\DBALException:driverExceptionDuringQuery in /vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:996\r\n#15 Bolt\\Controllers\\Backend:dbUpdate in <#unknown>:0\r\n#14 Doctrine\\DBAL\\Driver\\PDOException in /vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:59\r\n#13 Bolt\\Controllers\\Backend:dbUpdate in <#unknown>:0\r\n#12 PDOException in /vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:57\r\n#11 PDO:exec in /vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:57\r\n#10 Doctrine\\DBAL\\Driver\\PDOConnection:exec in /vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:993\r\n#9 Doctrine\\DBAL\\Connection:executeUpdate in /vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/AbstractSchemaManager.php:1017\r\n#8 Doctrine\\DBAL\\Schema\\AbstractSchemaManager:_execSql in /vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/AbstractSchemaManager.php:626\r\n#7 Doctrine\\DBAL\\Schema\\AbstractSchemaManager:alterTable in /vendor/bolt/bolt/src/Database/IntegrityChecker.php:306\r\n#6 Bolt\\Database\\IntegrityChecker:repairTables in /vendor/bolt/bolt/src/Controllers/Backend.php:220\r\n#5 Bolt\\Controllers\\Backend:dbUpdate in <#unknown>:0\r\n#4 call_user_func_array in /vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpKernel.php:145\r\n#3 Symfony\\Component\\HttpKernel\\HttpKernel:handleRaw in /vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpKernel.php:66\r\n#2 Symfony\\Component\\HttpKernel\\HttpKernel:handle in /vendor/silex/silex/src/Silex/Application.php:547\r\n#1 Silex\\Application:handle in /vendor/silex/silex/src/Silex/Application.php:524\r\n#0 Silex\\Application:run in /public/index.php:35\r\n```\r\n\r\nOn the latest SEO extension version"},"comment":{"url":"https://api.github.com/repos/bobdenotter/seo/issues/comments/168806521","html_url":"https://github.com/bobdenotter/seo/issues/16#issuecomment-168806521","issue_url":"https://api.github.com/repos/bobdenotter/seo/issues/16","id":168806521,"user":{"login":"ScreamZ","id":6640835,"avatar_url":"https://avatars.githubusercontent.com/u/6640835?v=3","gravatar_id":"","url":"https://api.github.com/users/ScreamZ","html_url":"https://github.com/ScreamZ","followers_url":"https://api.github.com/users/ScreamZ/followers","following_url":"https://api.github.com/users/ScreamZ/following{/other_user}","gists_url":"https://api.github.com/users/ScreamZ/gists{/gist_id}","starred_url":"https://api.github.com/users/ScreamZ/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ScreamZ/subscriptions","organizations_url":"https://api.github.com/users/ScreamZ/orgs","repos_url":"https://api.github.com/users/ScreamZ/repos","events_url":"https://api.github.com/users/ScreamZ/events{/privacy}","received_events_url":"https://api.github.com/users/ScreamZ/received_events","type":"User","site_admin":false},"created_at":"2016-01-04T20:56:54Z","updated_at":"2016-01-04T20:56:54Z","body":"Probable solution is to make it nullable, or make something updating fields... :/"}}