Comments (3)
I also tried
'image' => ['type' => 'varbinary'],
Similar/same issue:
SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near ","
LINE 5: "image",
from migrations.
@dereuromark Could you please share your code?
I have tried with a new migration and:
$this->table('posts')
->addColumn('name', 'string', ['length' => 255])
->addColumn('description', 'string', ['length' => 255])
->addColumn('image', 'blob', ['length' => null, 'null' => true])
->create();
and it creates the field correctly. I am probably missing something but if you share your code it's better.
My versions:
cakephp/cakephp 5.0.3 The CakePHP framework
cakephp/migrations 4.1.1 Database Migration plugin for CakePHP based on Phinx
from migrations.
The code is linked in that failing CI run
You can execute it locally by checking out master (cakephp 5) and see that it only works for SQlite apparently.
Not sure why blob doesnt seem to work for Mysql and Postgres.
from migrations.
Related Issues (20)
- migration create command is not creating required folders HOT 4
- update src folder links
- PR #584 now requires a config/Seeds directory even if it is not needed HOT 5
- ID columns now unsigned by default since 3.7.0 HOT 2
- Migrator truncates phinxlog of migration sets whose tables are not dropped. HOT 8
- update seed HOT 2
- bake migration_diff does not support --source for multiple database configs HOT 1
- Baking migration_snapshot ignores constraint names
- Schema not quoted on Postgres HOT 2
- 4.x Migrations without Phinx HOT 15
- migration_diff warning `Undefined array key "precision"` HOT 2
- migrations and Phinx causes error with migrations due to INT casting on migration version HOT 1
- Using newQuery() is deprecated. Instead, use `insertQuery()`, `deleteQuery()`, `selectQuery()` or `updateQuery()` HOT 7
- Baking fields HOT 2
- Migrate database snapshot HOT 1
- migration_diff generates incorrect code for decimal column definition change HOT 2
- Migration issues in Cake5 HOT 4
- Adding SET_NULL foreign keys fails HOT 6
- How to migrate migration files? HOT 6
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from migrations.