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.29k stars 1.54k forks source link

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`) #5145

Open TutorialMan7727 opened 5 days ago

TutorialMan7727 commented 5 days ago

Current Behavior

Cant log into panel. Gives error

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

Expected Behavior

Be able to log into pannel

Steps to Reproduce

Install panel in docker with

version: '3.8'
x-common:
  database:
    &db-environment
    MYSQL_PASSWORD: &db-password "password"
    MYSQL_ROOT_PASSWORD: "not password"
  panel:
    &panel-environment
    APP_URL: "https://pterodactyl"
    APP_TIMEZONE: "Europe/London"
    TRUSTED_PROXIES: "*"

#
# ------------------------------------------------------------------------------------------
# DANGER ZONE BELOW
#
# The remainder of this file likely does not need to be changed. Please only make modifications
# below if you understand what you are doing.
#
services:
  database:
    image: mariadb:10.5
    restart: always
    command: --default-authentication-plugin=mysql_native_password
    volumes:
      - "./database:/var/lib/mysql"
    environment:
      <<: *db-environment
      MYSQL_DATABASE: "panel"
      MYSQL_USER: "pterodactyl"
  cache:
    image: redis:alpine
    restart: always
  panel:
    image: ghcr.io/pterodactyl/panel:latest
    restart: always
    links:
      - database
      - cache
    volumes:
      - "./var/:/app/var/"
      - "./nginx/:/etc/nginx/http.d/"
      - "./certs/:/etc/letsencrypt/"
      - "./logs/:/app/storage/logs"
    environment:
      <<: [*panel-environment]
      DB_PASSWORD: *db-password
      APP_REPORT_ALL_EXCEPTIONS: "true"
      APP_ENV: "production"
      APP_ENVIRONMENT_ONLY: "false"
      CACHE_DRIVER: "redis"
      SESSION_DRIVER: "redis"
      QUEUE_DRIVER: "redis"
      REDIS_HOST: "cache"
      DB_HOST: "database"
      DB_PORT: "3306"

networks:
  default:
    name: all
    external: true

Panel Version

1.11.7

Wings Version

NA

Games and/or Eggs Affected

NA

Docker Image

NA

Error Logs

https://pteropaste.com/j8cv

Is there an existing issue for this?

lezetho commented 5 days ago

This is not a bug / issue. Please reach out to support on the Discord instead. https://discord.gg/pterodactyl