https://supertokens.com/ logo
Docs
Join the conversationJoin Discord
Channels
community
contributing
general
github-activity
info
introductions
new-releases
random
security
support-questions
welcome-0xdelusion
welcome-aj-ya
welcome-aleksandrc
welcome-alpinjs
welcome-amberlamps1
welcome-andrew-rodriguez
welcome-ankit-choudhary
welcome-anthony-stod-custodio
welcome-call-in
welcome-chwalbox
welcome-claybiokiller
welcome-co7e
welcome-cosmoecwsa
welcome-devdag
welcome-dinso
welcome-drebotelho
welcome-elio
welcome-ernest
welcome-foxbarrington
welcome-fromscratch
welcome-galto4ir
welcome-goetzum
welcome-hay-kot
welcome-himanshu-kukreja
welcome-hossambarakat
welcome-ichikawakazuto
welcome-jahir9991
welcome-jamesl
welcome-jerry123424
welcome-john-oliver
welcome-jonas-alexanderson
welcome-jxyz
welcome-kelvinwop
welcome-kraz
welcome-lancekey
welcome-leoo
welcome-lukeacollins
welcome-m-j-mon
welcome-malik-khoja
welcome-marco
welcome-mardadi
welcome-meshguy
welcome-metamorph
welcome-mike-tectu
welcome-mirzok
welcome-mozomig
welcome-naberyou66_
welcome-nacer
welcome-namratha
welcome-naveenkumar
welcome-nightlight
welcome-nischith
welcome-notankit
welcome-olawumi
welcome-pavan-kumar-reddy-n
welcome-pineappaul
welcome-poothebear
welcome-rick
welcome-samuel-qosenergy
welcome-samuelstroschein
welcome-shubhamgoel23
welcome-shubhamkaushal
welcome-sidebar
welcome-surajsli
welcome-suyash_
welcome-syntaxerror
welcome-tauno
welcome-tauno
welcome-tawnoz
welcome-teclali
welcome-tls
welcome-turbosepp
welcome-vikram_shadow
welcome-yann
Powered by Linen
support-questions
  • r

    rp

    01/11/2021, 9:38 AM
    yea true. So you will have to query it manually
  • u

    user

    01/11/2021, 9:38 AM
    It's strange that's happening
  • r

    rp

    01/11/2021, 9:38 AM
    yea it is.. will investigate the issue at some point
  • u

    user

    01/11/2021, 9:38 AM
    Unless something looks wrong here in terms of the generated introspection
  • u

    user

    01/11/2021, 9:40 AM
    Let me take a look again
  • r

    rp

    01/11/2021, 9:40 AM
    cool. Lmk. I have created an issue for now: https://github.com/supertokens/supertokens-core/issues/152
  • r

    rp

    01/11/2021, 9:40 AM
    Feel free to comment in the above
  • u

    user

    01/11/2021, 9:52 AM
    @User I posted in the github issue the exact migration file that Prisma Migrate is creating
  • u

    user

    01/11/2021, 9:53 AM
    Let me know if anything looks like it was generated incorrectly
  • u

    user

    01/11/2021, 9:55 AM
    https://www.prisma.io/docs/concepts/components/prisma-migrate
  • r

    rp

    01/11/2021, 10:01 AM
    Thanks
  • u

    user

    01/11/2021, 10:10 AM
    message has been deleted
  • r

    rp

    01/11/2021, 10:11 AM
    error still coming?
  • u

    user

    01/11/2021, 10:12 AM
    Yeah do you think you could look over the migration file Prisma created. Maybe one of the types is wrong?
  • u

    user

    01/11/2021, 10:12 AM
    https://github.com/supertokens/supertokens-core/issues/152
  • r

    rp

    01/11/2021, 10:12 AM
    yea. you are right
  • r

    rp

    01/11/2021, 10:13 AM
    time_joined
    should be
    BIGINT UNSIGNED NOT NULL
  • r

    rp

    01/11/2021, 10:13 AM
    not
    INTEGER
  • r

    rp

    01/11/2021, 10:14 AM
    same for
    created_at_time
    in
    session_info
    table
  • r

    rp

    01/11/2021, 10:14 AM
    and for
    expires_at
    in
    session_info
  • r

    rp

    01/11/2021, 10:14 AM
    and for
    created_at_time
    in
    key_value
  • r

    rp

    01/11/2021, 10:15 AM
    You can see the desired table structure here: https://supertokens.io/docs/emailpassword/quick-setup/database-setup/mysql (scroll down and click on "See table structure")
  • r

    rp

    01/11/2021, 10:15 AM
    and compare with what prisma generated
  • r

    rp

    01/11/2021, 10:15 AM
    i believe, correcting those should sort this issue out!
  • u

    user

    01/11/2021, 10:16 AM
    kk let me modify this migration file and see what happens
  • u

    user

    01/11/2021, 10:42 AM
    Okay it's 100% something related to bigint
  • r

    rp

    01/11/2021, 10:42 AM
    yea.
  • r

    rp

    01/11/2021, 10:43 AM
    are you using postgres or mysql?
  • u

    user

    01/11/2021, 10:43 AM
    I have an idea
  • u

    user

    01/11/2021, 10:43 AM
    I'm using Postgres
Powered by Linen
Title
u

user

01/11/2021, 10:43 AM
I'm using Postgres
View count: 2