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

Add warning that hyphens are not supported in database credentials #266

Closed
GoudronViande24 opened this issue Nov 30, 2021 · 5 comments · Fixed by #270
Closed

Add warning that hyphens are not supported in database credentials #266

GoudronViande24 opened this issue Nov 30, 2021 · 5 comments · Fixed by #270
Labels
bug Something isn't working panel panel
Projects
Milestone

Comments

@GoudronViande24
Copy link

GoudronViande24 commented Nov 30, 2021

Describe the bug
When trying to install pterodactyl panel on Ubuntu 20.04:
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-panel' at line 1

To Reproduce
Steps to reproduce the behaviour:

  • Run installation script
  • Enter all the infos
  • The error will happen and the script exits right after

Expected behaviour
Pterodactyl panel get installed

OS (please complete the following information):

  • OS: Ubuntu 20.04
  • Installation: panel only

More logs

Package sebastian/resource-operations is abandoned, you should avoid using it. No replacement was suggested.
Generating optimized autoload files
> Illuminate\Foundation\ComposerScripts::postAutoloadDump
> @php artisan package:discover || true
Discovered Package: fideloper/proxy
Discovered Package: laracasts/utilities
Discovered Package: laravel/tinker
Discovered Package: laravel/ui
Discovered Package: nesbot/carbon
Discovered Package: prologue/alerts
Discovered Package: spatie/laravel-fractal
Discovered Package: spatie/laravel-query-builder
Package manifest generated successfully.
57 packages you are using are looking for funding.
Use the `composer fund` command to find out more!
Application key set successfully.
* Downloaded pterodactyl panel files & installed composer dependencies!
* Performing MySQL queries..
* Creating MySQL user..
* Creating database..
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-panel' at line 1
@vilhelmprytz
Copy link
Member

What database name and database user name did you use?

@GoudronViande24
Copy link
Author

pterodactyl-panel for both

@vilhelmprytz
Copy link
Member

pterodactyl-panel for both

I see. Because of the way we invoke the SQL queries, hyphens probably won't work. Try wiping your machine and using the default values or something like pterodactyl_panel instead.

@GoudronViande24
Copy link
Author

Yep, I did and it worked. It still should be fixed though, or add a warning to prevent users to do it.

@vilhelmprytz
Copy link
Member

Yes, I agree. I will keep this issue upon and we'll check if we can add a warning/allow the usage of hyphens. Thanks!

@vilhelmprytz vilhelmprytz changed the title Error in SQL syntax - Installing panel only Add warning that hyphens are not supported in database credentials Dec 5, 2021
@vilhelmprytz vilhelmprytz added bug Something isn't working panel panel labels Dec 5, 2021
@vilhelmprytz vilhelmprytz added this to To do in v1.0.0 via automation Dec 5, 2021
@vilhelmprytz vilhelmprytz added this to the v1.0.0 milestone Dec 5, 2021
v1.0.0 automation moved this from To do to Done Dec 5, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working panel panel
Projects
No open projects
2 participants