pterodactyl / panel

Pterodactyl® is a free, open-source game server management panel built with PHP, React, and Go. Designed with security in mind, Pterodactyl runs all game servers in isolated Docker containers while exposing a beautiful and intuitive UI to end users.
https://pterodactyl.io
Other
6.41k stars 1.57k forks source link

During the upgrade from 1.1.3 to 1.2.0: EggSeeder fails to update default eggs #2978

Closed DingosGotMyBaby closed 3 years ago

DingosGotMyBaby commented 3 years ago

Background (please complete the following information):

Describe the bug A clear and concise description of what the bug is. Please provide additional information too, depending on what you have issues with: Panel: PHP 7.4.13, MYSQL: Ver 8.0.22-0ubuntu0.20.04.3 Running php artisan migrate --seed --force fails to update the default eggs, The columns that it complains about, do exist in the database.

username@host:/var/www/pterodactyl$ php artisan migrate --seed --force
Nothing to migrate.
Seeding: NestSeeder
Seeded:  NestSeeder (0 seconds)
Seeding: EggSeeder
*********************************************
*     Updating Eggs for Nest: Minecraft     *
*********************************************

In Connection.php line 671:

  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'docker_image' in 'field list' (SQL: update `eggs` set `docker_image` = quay.io/pterodactyl/core:java, `eggs`.`updated_at` = 2021-01-05 20:51:03 where `id` = 1)  

In PDOConnection.php line 66:

  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'docker_image' in 'field list'  

In PDOConnection.php line 64:

  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'docker_image' in 'field list'  

username@host:/var/www/pterodactyl$

To Reproduce Steps to reproduce the behavior:

  1. Begin upgrade from 1.1.3 to 1.2.0
  2. Run php artisan migrate --seed --force
  3. Watch it fail

Expected behavior A clear and concise description of what you expected to happen. If applicable, add screenshots or a recording to help explain your problem. I expect it to seed the database correctly and not error out

DaneEveritt commented 3 years ago

No one else has reported this issue, I think your system is just messed up somehow.

mzramna commented 3 years ago

same issue here,i've updated to latest panel today,reinstalled everyting,deleted the folder /var/www/pterodactyl to recreate it,removed everyting related in docker ,updated to php 7.4 ;removed and recreated pterodactyl user and panel table into mysql,it does not show the table in the select * from information_schema.tables where table_schema = panel; command,it returns : ERROR 1054 (42S22): Unknown column 'panel' in 'where clause' and at the select * from information_schema.tables returns none related to the panel database

DaneEveritt commented 3 years ago

Then you don't have a database called panel, this isn't a bug.