Migration issue - Githubissues

Bencor29 / pterodactyl-panel-module-support

Pterodactyl is the open-source game server management panel built with PHP7, Nodejs, and Go. Designed with security in mind, Pterodactyl runs all game servers in isolated Docker containers while exposing a beautiful and intuitive UI to administrators and users.

https://pterodactyl.io

Other

2 stars 0 forks source link

Migration issue #2

Closed ghost closed 5 years ago

ghost commented 5 years ago

Application In Production! * ** Do you really wish to run this command? (yes/no) [no]:

y
Migrating: 2019_09_09_182422_add_triggers_to_foreign_on_plugin_tables

Illuminate\Database\QueryException : SQLSTATE[42S02]: Base table or view not found: 1146 Table 'panel.tickets' doesn't exist (SQL: alter table tickets drop foreign key tickets_server_id_foreign)

at /var/www/panel.nyasky.xyz/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664 660| // If an exception occurs when attempting to run a query, we'll format the error 661| // message to include the bindings with SQL, which will make this exception a 662| // lot more helpful to the developer instead of just the database's errors. 663| catch (Exception $e) {

664| throw new QueryException( 665| $query, $this->prepareBindings($bindings), $e 666| ); 667| } 668|

Exception trace:

1 Doctrine\DBAL\Driver\PDOException::("SQLSTATE[42S02]: Base table or view not found: 1146 Table 'panel.tickets' doesn't exist") /var/www/panel.nyasky.xyz/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:144

2 PDOException::("SQLSTATE[42S02]: Base table or view not found: 1146 Table 'panel.tickets' doesn't exist") /var/www/panel.nyasky.xyz/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:142

Bencor29 commented 5 years ago

@lazarsn Did you extract all the files from the zipfile or only the migration file ?

ghost commented 5 years ago

All files

ghost commented 5 years ago

Look like DB side error I will redo database again

ghost commented 5 years ago

Issue fixed