Comments (4)
yarn run v1.22.19
$ node index.js
Migrating Core Store
Migrating 355/777 items from core_store to strapi_core_store_settings
core_store batch #1
core_store batch #2
core_store batch #3
core_store batch #4
core_store batch #5
core_store batch #6
core_store batch #7
core_store batch #8
(node:83930) UnhandledPromiseRejectionWarning: error: SELECT SETVAL ('strapi_core_store_settings_id_seq', (SELECT MAX(id) + 1 FROM 'strapi_core_store_settings')) - syntax error at or near "'strapi_core_store_settings'"
at Parser.parseErrorMessage (/home/nguyenson/migration-scripts/v3-sql-v4-sql/node_modules/pg-protocol/dist/parser.js:287:98)
at Parser.handlePacket (/home/nguyenson/migration-scripts/v3-sql-v4-sql/node_modules/pg-protocol/dist/parser.js:126:29)
at Parser.parse (/home/nguyenson/migration-scripts/v3-sql-v4-sql/node_modules/pg-protocol/dist/parser.js:39:38)
at Socket. (/home/nguyenson/migration-scripts/v3-sql-v4-sql/node_modules/pg-protocol/dist/index.js:11:42)
at Socket.emit (events.js:400:28)
at addChunk (internal/streams/readable.js:293:12)
at readableAddChunk (internal/streams/readable.js:267:9)
at Socket.Readable.push (internal/streams/readable.js:206:10)
at TCP.onStreamRead (internal/stream_base_commons.js:188:23)
(Usenode --trace-warnings ...
to show where the warning was created)
(node:83930) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). To terminate the node process on unhandled promise rejection, use the CLI flag--unhandled-rejections=strict
(see https://nodejs.org/api/cli.html#cli_unhandled_rejections_mode). (rejection id: 2)
(node:83930) [DEP0018] DeprecationWarning: Unhandled promise rejections are deprecated. In the future, promise rejections that are not handled will terminate the Node.js process with a non-zero exit code.
I have same issue with you
from migration-scripts.
We are running into this issue as well. Any workaround?
from migration-scripts.
I'm having this same error too
from migration-scripts.
Hi guys, you can use this custom repo for migrate postgres v3 to v4, make sure clean all table in schema v4 and init them by yarn develop before run scripts
https://github.com/vitormanfredini/strapi-v3tov4-modified-migration-scripts
from migration-scripts.
Related Issues (20)
- Possible Race Condition While Inserting Data
- Strapi core_store corruption during data migration. HOT 1
- Data migration of many to many relations HOT 1
- v3-mongodb-v3-sql : empty column causing bug on the map method HOT 1
- Media does not get migrated using the v3 SQL to v4 SQL migration scripts HOT 2
- MySql - filter TABLE by DB name
- MySql - filter TABLE_SCHEMA by DB name HOT 2
- Migration script fails on relationships HOT 3
- vscode\sqlite3 absent
- Migration script v3 to v4 pg to pg fails migrating data in a custom plugin
- v3Mongo->v3SQL - Default values not applied to tables when attributes undefined HOT 2
- Bug: Key (id)=(10234366) already exists. HOT 5
- v3SQl > v4SQL: Model tables are not being created? HOT 3
- Migrate strapi_permission (v3) into admin_permissions (v4) - column "fields" of relation "admin_permissions" does not exist (again) and "Cannot read properties of null (reading 'fields')" HOT 8
- Cannot read property layouts of null HOT 2
- [Solution found, needs review from Strapi] Multi-word Collection Types with many-to-many Relationships are skipped HOT 4
- Some fields of some Content-types are displayed twice in Content Manager after running Migration-scripts HOT 3
- Error importing many-to-many relationships for multi-word table names
- PostgreSQL - violates not-null constraint HOT 1
- v3 PostgreSQL to v4 PostgreSQL Migration Data Missing HOT 4
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 migration-scripts.