#Unable to view databases in panel

25 messages · Page 1 of 1 (latest)

tulip flower
#

The database page on every server panel is returning the error shown. The API call returns a 500 error. I ran the database migration and it's still doing it.

Here's the error the API is returning

{
    "errors": [
        {
            "code": "UnexpectedValueException",
            "status": "500",
            "detail": "An unexpected error was encountered while processing this request, please try again."
        }
    ]
}

And the laravel logs:

[2024-04-11 02:06:35] production.NOTICE: A query exception was encountered while trying to load settings from the database: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'panel.settings' doesn't exist (Connection: mysql, SQL: select * from `settings`)

I ran the db command using artisan to be sure. Still getting the error with viewing databases in servers.

image.png
thorn marlinBOT
#

@tulip flower; You'll need to grab the error logs from the Panel. The following command uploads the last 150 lines of this day's log to our pastebin and provides a link you can share.
tail -n 150 /var/www/pterodactyl/storage/logs/laravel-$(date +%F).log | nc pteropaste.com 99

tulip flower
#

I should note that I set up pterodactyl and wings with a docker compose file (on different hosts). The database that is connected to pterodactyl for use in servers is hosted on the same server with the servers and it can log in properly.

tulip flower
stiff compass
#

hello, i have the same problem, im trying to open/view my database but i cant find the button anywhere

tulip flower
#

To fix it the env variables HASHID_SALT should be set to a 20 character string and HASHID_LENGTH should be 8

tulip flower
stiff compass
#

nono, im talking about like the information and whatnot

#

the tables

#

...

tulip flower
#

Ah sorry.

stiff compass
#

yeah

#

do u know how to fix that?

tulip flower
#

Can you give me some more details. I'm confused a bit

stiff compass
#

ok so i made a database, im trying to make the tables and stuff but i dont know how to open the thing to do that

#

usually theres a button to open the database or smth but its not here

tulip flower
#

I know there's a page to add the database and then there's another for adding db's inside of the database host you set up. Not sure of anything to view the tables

stiff compass
#

heh

tulip flower
#

Other than connecting with a mysql client and looking that way

stiff compass
#

yeah i think thats what i mean

#

how would i do that

tulip flower
stiff compass
#

ahh

#

alright thanks

tulip flower
#

Np