Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Postgres migrate fails #5077

Closed
3 tasks done
xboxfly15 opened this issue Apr 24, 2024 · 1 comment
Closed
3 tasks done

Postgres migrate fails #5077

xboxfly15 opened this issue Apr 24, 2024 · 1 comment
Labels
not confirmed Report seems plausible but requires additional testing or 3rd part confirmation.

Comments

@xboxfly15
Copy link

xboxfly15 commented Apr 24, 2024

Current Behavior

Fresh install. Using postgres database type.
I run php artisan migrate --seed --force and everything says "DONE" up until "2016_10_23_193810_add_foreign_keys_servers".
This fails and caused the whole command and install to fail.

It says:

2016_10_23_193810_add_foreign_keys_servers ............................................................................................ 683ms FAIL

In AbstractPlatform.php line 441:
 Unknown database type anyelement requested, Doctrine\DBAL\Platforms\PostgreSQL100Platform may not support it.

Expected Behavior

For the migrate command to finish and succeed.

Steps to Reproduce

Use postgres database type. Fresh install.
Run php artisan migrate --seed --force according to Database setup - Getting Started guide.
(I am aware develop is far from release and should not be used in production. Just making you aware of this bug to fix in the develop branch)

Panel Version

develop - #5bcf6fd

Wings Version

N/A - Haven't gotten to the stage where I setup Wings. DB wont setup

Games and/or Eggs Affected

No response

Docker Image

No response

Error Logs

[pterodactyl@pterodactyl]$ php artisan migrate --seed --force

   INFO  Preparing database.  

  Creating migration table .............................................................................................................. 491ms DONE

   INFO  Running migrations.  

  2016_01_23_195641_add_allocations_table ............................................................................................... 607ms DONE
  2016_01_23_195851_add_api_keys ........................................................................................................ 504ms DONE
  2016_01_23_200044_add_api_permissions ................................................................................................. 509ms DONE
  2016_01_23_200159_add_downloads ....................................................................................................... 717ms DONE
  2016_01_23_200421_create_failed_jobs_table ............................................................................................ 515ms DONE
  2016_01_23_200440_create_jobs_table ................................................................................................... 667ms DONE
  2016_01_23_200528_add_locations ....................................................................................................... 709ms DONE
  2016_01_23_200648_add_nodes ........................................................................................................... 708ms DONE
  2016_01_23_201433_add_password_resets ................................................................................................. 749ms DONE
  2016_01_23_201531_add_permissions ..................................................................................................... 459ms DONE
  2016_01_23_201649_add_server_variables ................................................................................................ 465ms DONE
  2016_01_23_201748_add_servers ......................................................................................................... 950ms DONE
  2016_01_23_202544_add_service_options ................................................................................................. 469ms DONE
  2016_01_23_202731_add_service_varibles ................................................................................................ 519ms DONE
  2016_01_23_202943_add_services ........................................................................................................ 492ms DONE
  2016_01_23_203119_create_settings_table ............................................................................................... 706ms DONE
  2016_01_23_203150_add_subusers ........................................................................................................ 716ms DONE
  2016_01_23_203159_add_users ........................................................................................................... 745ms DONE
  2016_01_23_203947_create_sessions_table ............................................................................................... 677ms DONE
  2016_01_25_234418_rename_permissions_column ......................................................................................... 2,653ms DONE
  2016_02_07_172148_add_databases_tables ................................................................................................ 778ms DONE
  2016_02_07_181319_add_database_servers_table .......................................................................................... 503ms DONE
  2016_02_13_154306_add_service_option_default_startup ................................................................................ 2,336ms DONE
  2016_02_20_155318_add_unique_service_field .......................................................................................... 6,082ms DONE
  2016_02_27_163411_add_tasks_table ..................................................................................................... 565ms DONE
  2016_02_27_163447_add_tasks_log_table ................................................................................................. 503ms DONE
  2016_08_30_212718_add_ip_alias ...................................................................................................... 2,325ms DONE
  2016_08_30_213301_modify_ip_storage_method .......................................................................................... 2,848ms DONE
  2016_09_01_193520_add_suspension_for_servers ........................................................................................ 2,725ms DONE
  2016_09_01_211924_remove_active_column .............................................................................................. 2,722ms DONE
  2016_09_02_190647_add_sftp_password_storage ......................................................................................... 2,714ms DONE
  2016_09_04_171338_update_jobs_tables ................................................................................................ 5,797ms DONE
  2016_09_04_172028_update_failed_jobs_table .......................................................................................... 2,820ms DONE
  2016_09_04_182835_create_notifications_table .......................................................................................... 826ms DONE
  2016_09_07_163017_add_unique_identifier ............................................................................................. 2,651ms DONE
  2016_09_14_145945_allow_longer_regex_field .......................................................................................... 1,919ms DONE
  2016_09_17_194246_add_docker_image_column ........................................................................................... 2,722ms DONE
  2016_09_21_165554_update_servers_column_name ........................................................................................ 3,125ms DONE
  2016_09_29_213518_rename_double_insurgency ............................................................................................ 186ms DONE
  2016_10_07_152117_build_api_log_table ................................................................................................. 505ms DONE
  2016_10_14_164802_update_api_keys ................................................................................................... 2,647ms DONE
  2016_10_23_181719_update_misnamed_bungee .............................................................................................. 160ms DONE
  2016_10_23_193810_add_foreign_keys_servers ............................................................................................ 680ms FAIL

In AbstractPlatform.php line 441:
                                                                                                                 
  Unknown database type anyelement requested, Doctrine\DBAL\Platforms\PostgreSQL100Platform may not support it.

Is there an existing issue for this?

  • I have searched the existing issues before opening this issue.
  • I have provided all relevant details, including the specific game and Docker images I am using if this issue is related to running a server.
  • I have checked in the Discord server and believe this is a bug with the software, and not a configuration issue with my specific system.
@xboxfly15 xboxfly15 added the not confirmed Report seems plausible but requires additional testing or 3rd part confirmation. label Apr 24, 2024
@matthewpi
Copy link
Member

PostgreSQL is only supported on the experimental develop branch which is not ready for use. You should be using 1.0-develop and MariaDB (or MySQL).

I intend to officially support PostgreSQL in the future, but until then use what already works.

@matthewpi matthewpi closed this as not planned Won't fix, can't repro, duplicate, stale May 4, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
not confirmed Report seems plausible but requires additional testing or 3rd part confirmation.
Projects
None yet
Development

No branches or pull requests

2 participants