search

Xethron / migrations-generator

Laravel Migrations Generator: Automatically generate your migrations from an existing database schema.
MIT License
3.32k stars 588 forks source link

Unknown database type _int4 requested #131

Open mclxly opened 7 years ago

mclxly commented 7 years ago

Laravel 5.4 + PostgreSQL 9.5.5

Setting up Tables and Index Migrations [Doctrine\DBAL\DBALException] Unknown database type _int4 requested, Doctrine\DBAL\Platforms\PostgreSQL92 Platform may not support it.

mfn commented 7 years ago

Same issue, here's the full stacktrace:

  Unknown database type _int4 requested, Doctrine\DBAL\Platforms\PostgreSQL92Platform may not support it.

Exception trace:
 () at /project/vendor/doctrine/dbal/lib/Doctrine/DBAL/Platforms/AbstractPlatform.php:423
 Doctrine\DBAL\Platforms\AbstractPlatform->getDoctrineTypeMapping() at /project/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/PostgreSqlSchemaManager.php:349
 Doctrine\DBAL\Schema\PostgreSqlSchemaManager->_getPortableTableColumnDefinition() at /project/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/AbstractSchemaManager.php:820
 Doctrine\DBAL\Schema\AbstractSchemaManager->_getPortableTableColumnList() at /project/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/AbstractSchemaManager.php:175
 Doctrine\DBAL\Schema\AbstractSchemaManager->listTableColumns() at /project/vendor/xethron/migrations-generator/src/Xethron/MigrationsGenerator/Generators/FieldGenerator.php:37
 Xethron\MigrationsGenerator\Generators\FieldGenerator->generate() at /project/vendor/xethron/migrations-generator/src/Xethron/MigrationsGenerator/Generators/SchemaGenerator.php:68
 Xethron\MigrationsGenerator\Generators\SchemaGenerator->getFields() at /project/vendor/xethron/migrations-generator/src/Xethron/MigrationsGenerator/MigrateGenerateCommand.php:233
 Xethron\MigrationsGenerator\MigrateGenerateCommand->generateTablesAndIndices() at /project/vendor/xethron/migrations-generator/src/Xethron/MigrationsGenerator/MigrateGenerateCommand.php:175
 Xethron\MigrationsGenerator\MigrateGenerateCommand->fire() at n/a:n/a
 call_user_func_array() at /project/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:29
 Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() at /project/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:87
 Illuminate\Container\BoundMethod::callBoundMethod() at /project/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:31
 Illuminate\Container\BoundMethod::call() at /project/vendor/laravel/framework/src/Illuminate/Container/Container.php:531
 Illuminate\Container\Container->call() at /project/vendor/laravel/framework/src/Illuminate/Console/Command.php:182
 Illuminate\Console\Command->execute() at /project/vendor/symfony/console/Command/Command.php:264
 Symfony\Component\Console\Command\Command->run() at /project/vendor/laravel/framework/src/Illuminate/Console/Command.php:167
 Illuminate\Console\Command->run() at /project/vendor/symfony/console/Application.php:835
 Symfony\Component\Console\Application->doRunCommand() at /project/vendor/symfony/console/Application.php:200
 Symfony\Component\Console\Application->doRun() at /project/vendor/symfony/console/Application.php:124
 Symfony\Component\Console\Application->run() at /project/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php:122
 Illuminate\Foundation\Console\Kernel->handle() at /project/artisan:35

https://github.com/barryvdh/laravel-ide-helper had a similar issue and solved it with configurable custom mappings, see https://github.com/barryvdh/laravel-ide-helper/blob/3814fe86ca487d05ae06077529a1e5f43f37ab5a/src/Console/ModelsCommand.php#L323-L326 . Maybe something like this could help here?