#Server Error 500 when creating new server

20 messages · Page 1 of 1 (latest)

solar ore
#

Hello, Yesterday I updated my panel and wings and now I can't seem to create new servers, when i fill out the new server form and hit create i just go straight to server error 500.

I have exported logs from both the panel and wings, nothing in there seems to be new though so im not sure if it's throwing an error at all (there should be an entry around 740am 05/01/2023 from just a few minutes ago.

https://ptero.co/nyqolivyke
https://pteropaste.com/pk38do

Can anyone please help with the best way forward?

cerulean falconBOT
#

Hey @solar ore! Post your Panel logs to find out more information about the cause of your 500 server errors tail -n 150 /var/www/pterodactyl/storage/logs/laravel-$(date +%F).log | nc pteropaste.com 99

burnt hornet
#

Seems to be a problem with your database. Double check .env file in the root folder of pterodactyl and ensure connection details are correct.

cerulean falconBOT
#

The env file can be found at /var/www/pterodactyl/.env. Files starting with a . in Linux are hidden so it may not show up in file browsers by default. You can open it directly with nano /var/www/pterodactyl/.env

solar ore
#

my .env file seems fine, i did run into some issues with database migration in the update though, I ended up having to wipe it and start again from a backup

cerulean falconBOT
#

The env file can be found at /var/www/pterodactyl/.env. Files starting with a . in Linux are hidden so it may not show up in file browsers by default. You can open it directly with nano /var/www/pterodactyl/.env

solar ore
#

i wonder if i've done something wrong with the database then

burnt hornet
#

In the logs it says that the table “failed_jobs” doesn’t have the column “uuid”. Look that up in the database and report back

solar ore
#

what's the best way to look it up in the database?

burnt hornet
#

Any tool to view a database, e.g. phpmyadmin

solar ore
#

It appears there is uuid data but it is in the payload column

image.png
solar ore
#

Do I just create a new column called uuid? or can i rename the payload column?

burnt hornet
#

That indicates that something has gone wrong with your database migration. You said you had to wipe the database and go again from a backup. As this backup is from an old version of pterodactyl, it’s not compatible with the new one as it wasn’t modified during the update process I guess. Can you load a backup of pterodactyl prior to updating anything and then start the update process from scratch?

solar ore
#

I could - I actually did do the database migration process on this database

#

I'm not sure if i would do anything different had I started again now

#

Its possible I could delete and re-create the database all together now- and then import the old one and then remigrate it again?

solar ore
#

For anyone with this issue, Instead of starting all over - I renamed the database to "panelbroken" in phpmyadmin, remade the panel database with :

mysql -u root -p
CREATE DATABASE panel;
GRANT ALL PRIVILEGES ON panel.* TO 'pterodactyl'@'127.0.0.1' WITH GRANT OPTION;
exit

I then reimported my old database which was saved as panel.sql:
mysql -u root -p panel < panel.sql

Then I re-ran the migration
php artisan migrate --seed --force

And now its working perfectly 🙂

#

Thanks @burnt hornet for all your help

desert turret
cerulean falconBOT