search

jzakotnik / openlibry

Simple and easy software to manage school libraries - books, users, rentals and statistics. Enjoy!
https://openlibry.de
MIT License
6 stars 3 forks source link

User ID zu groß für die Datenbank #102

Open jzakotnik opened 3 months ago

jzakotnik commented 3 months ago

Zum Fehler: Hier der komplette Log. Als Zusatzinfo: Ich habe ohne eingetragene Klasse auf Speichern geklickt.

big@big-HP-250-G6-Notebook-PC:~/openlibry$ docker compose up WARN[0000] /home/big/openlibry/docker-compose.yml:versionis obsolete [+] Running 1/0 ✔ Container openlibry Created 0.0s Attaching to openlibry openlibry | openlibry | > [openlibry@0.9.0](mailto:openlibry@0.9.0) start openlibry | > PORT=3000 next start openlibry | openlibry | ▲ Next.js 14.2.4 openlibry | - Local: http://localhost:3000/ openlibry | openlibry | ✓ Starting... openlibry | Server startup openlibry | ✓ Ready in 756ms openlibry | Server startup openlibry | ERROR in getAllUsers: PrismaClientKnownRequestError: openlibry | Invalidprisma.user.findMany()invocation: openlibry | openlibry | openlibry | Inconsistent column data: Conversion failed: Value 18974892374 does not fit in an INT column, try migrating the 'id' column type to BIGINT openlibry | at In.handleRequestError (/app/node_modules/@prisma/client/runtime/library.js:122:6877) openlibry | at In.handleAndLogRequestError (/app/node_modules/@prisma/client/runtime/library.js:122:6211) openlibry | at In.request (/app/node_modules/@prisma/client/runtime/library.js:122:5919) openlibry | at async l (/app/node_modules/@prisma/client/runtime/library.js:127:11167) openlibry | at async a (/app/.next/server/pages/user.js:1:11253) openlibry | at async eZ (/app/.next/server/pages/user.js:1:8232) openlibry | at async e3 (/app/node_modules/next/dist/compiled/next-server/pages.runtime.prod.js:31:594) openlibry | at async doRender (/app/node_modules/next/dist/server/base-server.js:1425:30) openlibry | at async cacheEntry.responseCache.get.routeKind (/app/node_modules/next/dist/server/base-server.js:1599:28) openlibry | at async NextNodeServer.renderToResponseWithComponentsImpl (/app/node_modules/next/dist/server/base-server.js:1507:28) { openlibry | code: 'P2023', openlibry | clientVersion: '5.15.1', openlibry | meta: { openlibry | modelName: 'User', openlibry | message: "Conversion failed: Value 18974892374 does not fit in an INT column, try migrating the 'id' column type to BIGINT" openlibry | } openlibry | } openlibry | ⨯ PrismaClientKnownRequestError: openlibry | Invalidprisma.user.findMany()invocation: openlibry | openlibry | openlibry | Inconsistent column data: Conversion failed: Value 18974892374 does not fit in an INT column, try migrating the 'id' column type to BIGINT openlibry | at In.handleRequestError (/app/node_modules/@prisma/client/runtime/library.js:122:6877) openlibry | at In.handleAndLogRequestError (/app/node_modules/@prisma/client/runtime/library.js:122:6211) openlibry | at In.request (/app/node_modules/@prisma/client/runtime/library.js:122:5919) openlibry | at async l (/app/node_modules/@prisma/client/runtime/library.js:127:11167) openlibry | at async a (/app/.next/server/pages/user.js:1:11253) openlibry | at async eZ (/app/.next/server/pages/user.js:1:8232) openlibry | at async e3 (/app/node_modules/next/dist/compiled/next-server/pages.runtime.prod.js:31:594) openlibry | at async doRender (/app/node_modules/next/dist/server/base-server.js:1425:30) openlibry | at async cacheEntry.responseCache.get.routeKind (/app/node_modules/next/dist/server/base-server.js:1599:28) openlibry | at async NextNodeServer.renderToResponseWithComponentsImpl (/app/node_modules/next/dist/server/base-server.js:1507:28) { openlibry | code: 'P2023', openlibry | clientVersion: '5.15.1', openlibry | meta: { openlibry | modelName: 'User', openlibry | message: "Conversion failed: Value 18974892374 does not fit in an INT column, try migrating the 'id' column type to BIGINT" openlibry | } openlibry | } openlibry | ERROR in getAllUsers: PrismaClientKnownRequestError: openlibry | Invalidprisma.user.findMany()invocation: openlibry | openlibry | openlibry | Inconsistent column data: Conversion failed: Value 18974892374 does not fit in an INT column, try migrating the 'id' column type to BIGINT openlibry | at In.handleRequestError (/app/node_modules/@prisma/client/runtime/library.js:122:6877) openlibry | at In.handleAndLogRequestError (/app/node_modules/@prisma/client/runtime/library.js:122:6211) openlibry | at In.request (/app/node_modules/@prisma/client/runtime/library.js:122:5919) openlibry | at async l (/app/node_modules/@prisma/client/runtime/library.js:127:11167) openlibry | at async a (/app/.next/server/pages/user.js:1:11253) openlibry | at async eZ (/app/.next/server/pages/user.js:1:8232) openlibry | at async e3 (/app/node_modules/next/dist/compiled/next-server/pages.runtime.prod.js:31:594) openlibry | at async doRender (/app/node_modules/next/dist/server/base-server.js:1425:30) openlibry | at async cacheEntry.responseCache.get.routeKind (/app/node_modules/next/dist/server/base-server.js:1599:28) openlibry | at async NextNodeServer.renderToResponseWithComponentsImpl (/app/node_modules/next/dist/server/base-server.js:1507:28) { openlibry | code: 'P2023', openlibry | clientVersion: '5.15.1', openlibry | meta: { openlibry | modelName: 'User', openlibry | message: "Conversion failed: Value 18974892374 does not fit in an INT column, try migrating the 'id' column type to BIGINT" openlibry | } openlibry | } openlibry | ⨯ PrismaClientKnownRequestError: openlibry | Invalidprisma.user.findMany()` invocation: openlibry | openlibry | openlibry | Inconsistent column data: Conversion failed: Value 18974892374 does not fit in an INT column, try migrating the 'id' column type to BIGINT openlibry | at In.handleRequestError (/app/node_modules/@prisma/client/runtime/library.js:122:6877) openlibry | at In.handleAndLogRequestError (/app/node_modules/@prisma/client/runtime/library.js:122:6211) openlibry | at In.request (/app/node_modules/@prisma/client/runtime/library.js:122:5919) openlibry | at async l (/app/node_modules/@prisma/client/runtime/library.js:127:11167) openlibry | at async a (/app/.next/server/pages/user.js:1:11253) openlibry | at async eZ (/app/.next/server/pages/user.js:1:8232) openlibry | at async e3 (/app/node_modules/next/dist/compiled/next-server/pages.runtime.prod.js:31:594) openlibry | at async doRender (/app/node_modules/next/dist/server/base-server.js:1425:30) openlibry | at async cacheEntry.responseCache.get.routeKind (/app/node_modules/next/dist/server/base-server.js:1599:28) openlibry | at async NextNodeServer.renderToResponseWithComponentsImpl (/app/node_modules/next/dist/server/base-server.js:1507:28) { openlibry | code: 'P2023', openlibry | clientVersion: '5.15.1', openlibry | meta: { openlibry | modelName: 'User', openlibry | message: "Conversion failed: Value 18974892374 does not fit in an INT column, try migrating the 'id' column type to BIGINT" openlibry | } openlibry | } Bildschirmfoto_2024-06-21_21-08-09

`

Originally posted by @fb4thxUall in https://github.com/jzakotnik/openlibry/discussions/95#discussioncomment-9843092

jzakotnik commented 3 months ago

See also https://github.com/prisma/prisma/issues/16144#issuecomment-1450369681