DarkflameUniverse / NexusDashboard

Dashboard for Complete Management of a DLU game server
GNU Affero General Public License v3.0
47 stars 7 forks source link

Trying to Login to Dashboard throws error "Unknown column 'accounts.email' in 'field list'" #71

Closed justwlocke closed 1 year ago

justwlocke commented 1 year ago

Am I dumb? Did I miss a step somewhere?

I went through the whole install process via the "Windows Manual" steps, ran the page with "flask run", I've got it open in my browser. But I need to sign in with a username and password, and I never made one for Nexus. (And there's no register button anywhere, despite me thinking there should be one while looking at the files)

I filled out settings.py with the username/pass for the database, and I tried them on the login page, but it throws an error, simply saying "Internal Server Error

The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application."

Yet the server itself doesn't show an error in powershell. The only error I wasn't able to fix was the command "flask db upgrade" not being able to find the brickprimatives folder in \res\ (Which it couldn't find because I couldn't find it to put it in there.)((I assume the same would happen with the models textures and ui folders, as I couldn't find those either.))

Windows 10 With Python 3.8.0, as specified in the setup ImageMagick-7.1.1-Q16

aronwk-aaron commented 1 year ago

Please ensure that you've read the setup step carefully and check all the settings under app/settings_example.py for what you can customize

justwlocke commented 1 year ago
  1. Ok I see the registration setting in the settings.py file. Not going to touch it because I don't need anybody else accessing it.
  2. Yeah, I realized that later last night that I was trying to use the wrong credentials on the login page, because I got the simple Account Manager working. However, when I try to use the creds I use for the game, I sadly still get the error in the browser, and no error in the console.
  3. It is connected to the same DB as the server and AccountManager is. image The logs seem to indicate some email field is causing the problem, but I didn't touch the email related settings at all, so I'm not sure why that is. If you have any suggestions for changing them, I'm all ears, lol.

Here's the Log nexus_dashboard.log

I'd gone over the steps multiple times before making this post, checked out the other issues as well.

I'm going to rename the title because now the question is less "How do I?" and more "Logging in throws an error".

aronwk-aaron commented 1 year ago

you need to run migrations

justwlocke commented 1 year ago

Ah... I could have sworn I ran both previously, but upon redoing it, its fixed the issue. I must've missed "flask db upgrade", or maybe something broke it.

Either way, I've logged in now. Thank you.