Creating Database table error
rytir2001
PROOP

a year ago

Hey, I am trying to create a database table with access_token stored in as text but I am getting the error that you can see in the screenshot, I cannot figure out how to make it work x)

error: BLOB/TEXT column 'access_token' used in key specification without a key length

Project ID: f3975026-241c-403b-9826-55764e418ffa

Solved

22 Replies

rytir2001
PROOP

a year ago

thank you for any help


rytir2001
PROOP

a year ago

I've tried different things like this

1310352440524279800


rytir2001
PROOP

a year ago

the database is mysql


a year ago

try with varchar


a year ago

looks like thats not an option, i would recommend using a database GUI tool like dbgate


rytir2001
PROOP

a year ago

is there some that is online?


rytir2001
PROOP

a year ago

I'd prefer not installing another software for this


a year ago

you can deploy the dbgate template into your project!


rytir2001
PROOP

a year ago

1310371270323601400


rytir2001
PROOP

a year ago

I am getting this when I click deploy template


a year ago

I assume you ran into trial limitations


rytir2001
PROOP

a year ago

hm, possible


rytir2001
PROOP

a year ago

aight, fixed, how do I now use this?


rytir2001
PROOP

a year ago

oh


rytir2001
PROOP

a year ago

nvm


rytir2001
PROOP

a year ago

I think I figured it out


rytir2001
PROOP

a year ago

sorry, I am a bit new to this, appreciate the help Brody


a year ago

no problem, were you able to get that table made?


rytir2001
PROOP

a year ago

making it rn


rytir2001
PROOP

a year ago

yeah, made the table


a year ago

awesome!


a year ago

!s


Status changed to Solved brody over 1 year ago


Loading...