Jump to content

Issue with a table in my database


irajkaufman

Recommended Posts

Hello.

I've been developing an app, and everything seemed to be working perfectly fine, earlier today. However, there seems to be a problem with my database (irajkaufman_hoops). I attempted to add a new field to the table "scoring" (a foreign key to the "schedule" table's primary key). My client - dbeaver - just hung and hung. So, I force quit dbeaver, and it asked me if i wanted to upgrade to the latest version. I did so, and actually lost the sql script i had been working on (tho, that's really no big deal). I've tried to reconnect to the database several times since, and while it looks like I can query two of my three tables - "roster" and "schedule" - every attempt to query/refresh the "scoring" table fails/hangs. I'd guess that table has 1200-ish rows - from lots of testing. I was actually planning to truncate the table tonight. However, the table is totally inaccessible to me. Is there anything that can be done to allow me access back to the "scoring" table??

Thanks!!

-ira

Edited by irajkaufman
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...