discord-tickets / migrate-v3-to-v4 Goto Github PK
View Code? Open in Web Editor NEWA tool to migrate data from v3 to v4.
License: MIT License
A tool to migrate data from v3 to v4.
License: MIT License
Hello! I have an issue while migrating to v4 mysql database.
The provided value for the column is too long for the column's type. Column: name
Migrating ticket 1108366718646095962...
prisma:error
Invalid `prisma.archivedRole.create()` invocation:
Then I manually increased the size of the name
column to 1024 and everything works as expected (tried 255, but that's not enough).
Also this. Increased the size of the name
column of archivedChannels
.
The provided value for the column is too long for the column's type. Column: name
Error:
Invalid `prisma.ticket.create()` invocation:
Expected no errors.
Migrate from v3 to v4 mysql database.
- OS: Ubuntu 20.04
- Node: v18
- NPM: 9.5.1
- Bot: v4
No response
{
data: {
archivedChannels: {
createMany: {
data: []
}
},
category: {
connect: {
? id?: Int
},
? create?: CategoryCreateWithoutTicketsInput | CategoryUncheckedCreateWithou tTicketsInput,
? connectOrCreate?: {
? where: CategoryWhereUniqueInput,
? create: CategoryCreateWithoutTicketsInput | CategoryUncheckedCreateWitho utTicketsInput
? }
},
claimedBy: undefined,
closedBy: undefined,
closedReason: null,
createdAt: new Date('2022-10-07T16:59:22.000Z'),
createdBy: {
connectOrCreate: {
create: {
id: '979270263592087582'
},
where: {
id: '979270263592087582'
}
}
},
firstResponseAt: new Date('2022-10-07T17:03:20.000Z'),
guild: {
connect: {
id: '957713464548270161'
}
},
id: '1027988522059182150',
lastMessageAt: new Date('2022-10-07T17:06:41.000Z'),
number: 28,
open: true,
openingMessageId: '1027988524001132595',
pinnedMessageIds: [],
topic: null
}
}
Argument data.category.connect of type CategoryWhereUniqueInput needs at least o ne argument. Available args are listed in green.
Note: Lines with ? are optional.
Migrate everything successfully
I followed the guidelines on the main hub
- OS: Linux
- Node: 18
- NPM: 7.6.3
- Bot: 3.1.3
my discord is godlyreaper, I can provide an SQL
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.