Created
November 29, 2016 19:03
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [2016-11-29 19:51:35] event.DEBUG: Notified event "console.command" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure". {"event":"console.command","listener":"Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"} | |
| [2016-11-29 19:51:35] event.DEBUG: Notified event "console.command" to listener "Symfony\Component\HttpKernel\EventListener\DumpListener::configure". {"event":"console.command","listener":"Symfony\\Component\\HttpKernel\\EventListener\\DumpListener::configure"} | |
| [2016-11-29 19:51:35] event.DEBUG: Notified event "console.command" to listener "Symfony\Bridge\Monolog\Handler\ConsoleHandler::onCommand". {"event":"console.command","listener":"Symfony\\Bridge\\Monolog\\Handler\\ConsoleHandler::onCommand"} | |
| [2016-11-29 19:51:35] event.DEBUG: Notified event "console.command" to listener "Symfony\Bridge\Monolog\Handler\ConsoleHandler::onCommand". {"event":"console.command","listener":"Symfony\\Bridge\\Monolog\\Handler\\ConsoleHandler::onCommand"} | |
| [2016-11-29 19:51:35] php.DEBUG: mkdir(): File exists {"type":2,"file":"/Users/gserfaty/Sites/collections/vendor/doctrine/doctrine-migrations-bundle/Command/DoctrineCommand.php","line":35,"level":28928} | |
| [2016-11-29 19:51:35] doctrine.DEBUG: SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' | |
| [2016-11-29 19:51:35] doctrine.DEBUG: SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'collection' AND TABLE_NAME = 'genus' | |
| [2016-11-29 19:51:35] doctrine.DEBUG: SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'genus' */ WHERE k.table_name = 'genus' AND k.table_schema = 'collection' /*!50116 AND c.constraint_schema = 'collection' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL | |
| [2016-11-29 19:51:35] doctrine.DEBUG: SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'genus' AND TABLE_SCHEMA = 'collection' | |
| [2016-11-29 19:51:35] doctrine.DEBUG: SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'collection' AND TABLE_NAME = 'genus_note' | |
| [2016-11-29 19:51:35] doctrine.DEBUG: SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'genus_note' */ WHERE k.table_name = 'genus_note' AND k.table_schema = 'collection' /*!50116 AND c.constraint_schema = 'collection' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL | |
| [2016-11-29 19:51:35] doctrine.DEBUG: SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'genus_note' AND TABLE_SCHEMA = 'collection' | |
| [2016-11-29 19:51:35] doctrine.DEBUG: SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'collection' AND TABLE_NAME = 'genus_scientist' | |
| [2016-11-29 19:51:35] doctrine.DEBUG: SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'genus_scientist' */ WHERE k.table_name = 'genus_scientist' AND k.table_schema = 'collection' /*!50116 AND c.constraint_schema = 'collection' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL | |
| [2016-11-29 19:51:35] doctrine.DEBUG: SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'genus_scientist' AND TABLE_SCHEMA = 'collection' | |
| [2016-11-29 19:51:35] doctrine.DEBUG: SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'collection' AND TABLE_NAME = 'migration_versions' | |
| [2016-11-29 19:51:35] doctrine.DEBUG: SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'migration_versions' */ WHERE k.table_name = 'migration_versions' AND k.table_schema = 'collection' /*!50116 AND c.constraint_schema = 'collection' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL | |
| [2016-11-29 19:51:35] doctrine.DEBUG: SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'migration_versions' AND TABLE_SCHEMA = 'collection' | |
| [2016-11-29 19:51:35] doctrine.DEBUG: SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'collection' AND TABLE_NAME = 'sub_family' | |
| [2016-11-29 19:51:36] doctrine.DEBUG: SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'sub_family' */ WHERE k.table_name = 'sub_family' AND k.table_schema = 'collection' /*!50116 AND c.constraint_schema = 'collection' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL | |
| [2016-11-29 19:51:36] doctrine.DEBUG: SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'sub_family' AND TABLE_SCHEMA = 'collection' | |
| [2016-11-29 19:51:36] doctrine.DEBUG: SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'collection' AND TABLE_NAME = 'user' | |
| [2016-11-29 19:51:36] doctrine.DEBUG: SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'user' */ WHERE k.table_name = 'user' AND k.table_schema = 'collection' /*!50116 AND c.constraint_schema = 'collection' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL | |
| [2016-11-29 19:51:36] doctrine.DEBUG: SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'user' AND TABLE_SCHEMA = 'collection' | |
| [Doctrine\DBAL\Schema\SchemaException (30)] | |
| There is no column with name 'id' on table 'genus_scientist'. | |
| Exception trace: | |
| () at /Users/gserfaty/Sites/collections/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/SchemaException.php:86 | |
| Doctrine\DBAL\Schema\SchemaException::columnDoesNotExist() at /Users/gserfaty/Sites/collections/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/Table.php:671 | |
| Doctrine\DBAL\Schema\Table->getColumn() at /Users/gserfaty/Sites/collections/vendor/doctrine/dbal/lib/Doctrine/DBAL/Platforms/MySqlPlatform.php:702 | |
| Doctrine\DBAL\Platforms\MySqlPlatform->getPreAlterTableAlterPrimaryKeySQL() at /Users/gserfaty/Sites/collections/vendor/doctrine/dbal/lib/Doctrine/DBAL/Platforms/MySqlPlatform.php:630 | |
| Doctrine\DBAL\Platforms\MySqlPlatform->getPreAlterTableIndexForeignKeySQL() at /Users/gserfaty/Sites/collections/vendor/doctrine/dbal/lib/Doctrine/DBAL/Platforms/MySqlPlatform.php:612 | |
| Doctrine\DBAL\Platforms\MySqlPlatform->getAlterTableSQL() at /Users/gserfaty/Sites/collections/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/SchemaDiff.php:199 | |
| Doctrine\DBAL\Schema\SchemaDiff->_toSql() at /Users/gserfaty/Sites/collections/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/SchemaDiff.php:136 | |
| Doctrine\DBAL\Schema\SchemaDiff->toSql() at /Users/gserfaty/Sites/collections/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/Schema.php:455 | |
| Doctrine\DBAL\Schema\Schema->getMigrateToSql() at /Users/gserfaty/Sites/collections/vendor/doctrine/migrations/lib/Doctrine/DBAL/Migrations/Tools/Console/Command/DiffCommand.php:107 | |
| Doctrine\DBAL\Migrations\Tools\Console\Command\DiffCommand->execute() at /Users/gserfaty/Sites/collections/vendor/doctrine/doctrine-migrations-bundle/Command/MigrationsDiffDoctrineCommand.php:61 | |
| Doctrine\Bundle\MigrationsBundle\Command\MigrationsDiffDoctrineCommand->execute() at /Users/gserfaty/Sites/collections/vendor/symfony/symfony/src/Symfony/Component/Console/Command/Command.php:254 | |
| Symfony\Component\Console\Command\Command->run() at /Users/gserfaty/Sites/collections/vendor/symfony/symfony/src/Symfony/Component/Console/Application.php:837 | |
| Symfony\Component\Console\Application->doRunCommand() at /Users/gserfaty/Sites/collections/vendor/symfony/symfony/src/Symfony/Component/Console/Application.php:187 | |
| Symfony\Component\Console\Application->doRun() at /Users/gserfaty/Sites/collections/vendor/symfony/symfony/src/Symfony/Bundle/FrameworkBundle/Console/Application.php:80 | |
| Symfony\Bundle\FrameworkBundle\Console\Application->doRun() at /Users/gserfaty/Sites/collections/vendor/symfony/symfony/src/Symfony/Component/Console/Application.php:118 | |
| Symfony\Component\Console\Application->run() at /Users/gserfaty/Sites/collections/bin/console:29 | |
| doctrine:migrations:diff [--editor-cmd [EDITOR-CMD]] [--configuration [CONFIGURATION]] [--db-configuration [DB-CONFIGURATION]] [--filter-expression [FILTER-EXPRESSION]] [--formatted] [--line-length [LINE-LENGTH]] [--em [EM]] [--shard SHARD] [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-e|--env ENV] [--no-debug] [--] <command> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment