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

Problem adding services manually to databse #65

Closed
BentHaase opened this issue Mar 5, 2016 · 2 comments
Closed

Problem adding services manually to databse #65

BentHaase opened this issue Mar 5, 2016 · 2 comments

Comments

@BentHaase
Copy link

Upon following the tutorial in the wiki you get the following error upon executing the sql queries:

INSERT INTO `service_options` (`id`, `parent_service`, `name`, `description`, `tag`, `docker_image`, `created_at`, `updated_at`)
VALUES
    (1, 1, 'Vanilla', 'Vanilla', 'vanilla', 'quay.io/pterodactyl/minecraft:latest', '2015-01-12 12:12:12', '2015-01-12 12:12:12'),
    (2, 2, 'Insurgency', 'Insurgency Dedicated Server', 'srcds', 'quay.io/pterodactyl/srcds', NULL, '-game {{SRCDS_GAME}} -console -port {{SERVER_PORT}} +map {{SRCDS_MAP}} -strictportbind -norestart', '2016-02-12 22:58:38', '2016-02-12 22:58:38'),
    (3, 2, 'Team Fortress 2', 'TF2', 'srcds', 'quay.io/pterodactyl/srcds', NULL, '-game {{SRCDS_GAME}} -console -port {{SERVER_PORT}} +map {{SRCDS_MAP}} -strictportbind -norestart', '2016-02-12 22:58:38', '2016-02-12 22:58:38'),
    (4, 2, 'Custom Game', 'Allows running a custom SRCDS game.', 'srcds', 'quay.io/pterodactyl/srcds', NULL, NULL, '2016-02-12 22:58:38', '2016-02-12 22:58:38');
SQL-Command:
INSERT INTO `service_options` (`id`, `parent_service`, `name`, `description`, `tag`, `docker_image`, `created_at`, `updated_at`) VALUES (1, 1, 'Vanilla', 'Vanilla', 'vanilla', 'quay.io/pterodactyl/minecraft:latest', '2015-01-12 12:12:12', '2015-01-12 12:12:12'), (2, 2, 'Insurgency', 'Insurgency Dedicated Server', 'srcds', 'quay.io/pterodactyl/srcds', NULL, '-game {{SRCDS_GAME}} -console -port {{SERVER_PORT}} +map {{SRCDS_MAP}} -strictportbind -norestart', '2016-02-12 22:58:38', '2016-02-12 22:58:38'), (3, 2, 'Team Fortress 2', 'TF2', 'srcds', 'quay.io/pterodactyl/srcds', NULL, '-game {{SRCDS_GAME}} -console -port {{SERVER_PORT}} +map {{SRCDS_MAP}} -strictportbind -norestart', '2016-02-12 22:58:38', '2016-02-12 22:58:38'), (4, 2, 'Custom Game', 'Allows running a custom SRCDS game.', 'srcds', 'quay.io/pterodactyl/srcds', NULL, NULL, '2016-02-12 22:58:38', '2016-02-12 22:58:38')

#1136 - Column count doesn't match value count at row 2

Basically for the last three rows of the statement 10 instead of 8 values are given.

@BentHaase
Copy link
Author

I'd assume in here INSERT INTO service_options (id, parent_service, name, description, tag, docker_image, created_at, updated_at) you are missing a column for "start parameters" or something like that as well as something that is intended to be NULL (cannot identify this from the given info)

Also there is nothing in here https://github.com/Pterodactyl/Panel/blob/development/database/migrations/2016_01_23_202544_add_service_options.php

I assume you updated the wiki but did not commit :P

@DaneEveritt
Copy link
Member

No longer need to add things manually.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants
@DaneEveritt @BentHaase and others