Deleting a database host #264

Closed
opened 2026-02-05 17:21:39 +03:00 by OVERLORD · 1 comment
Owner

Originally created by @oleksandr1811 on GitHub (Feb 27, 2025).

Current Behavior

When deleting a database host, error 500 occurs.

SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (LNPQyr2f8DWT.database_host_node, CONSTRAINT database_host_node_database_host_id_foreign FOREIGN KEY (database_host_id) REFERENCES database_hosts (id)) (Connection: mysql, SQL: delete from database_hosts where id = 16)

Expected Behavior

The database host must be deleted

Steps to Reproduce

After deleting the host in the database_host_node table, everything works

Panel Version

1.0.0-beta17

Wings Version

1.0.0-beta9

Games and/or Eggs Affected

No response

Docker Image

No response

Error Logs


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.
Originally created by @oleksandr1811 on GitHub (Feb 27, 2025). ### Current Behavior When deleting a database host, error 500 occurs. SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`LNPQyr2f8DWT`.`database_host_node`, CONSTRAINT `database_host_node_database_host_id_foreign` FOREIGN KEY (`database_host_id`) REFERENCES `database_hosts` (`id`)) (Connection: mysql, SQL: delete from `database_hosts` where `id` = 16) ### Expected Behavior The database host must be deleted ### Steps to Reproduce After deleting the host in the database_host_node table, everything works ### Panel Version 1.0.0-beta17 ### Wings Version 1.0.0-beta9 ### Games and/or Eggs Affected _No response_ ### Docker Image _No response_ ### Error Logs ```bash ``` ### Is there an existing issue for this? - [x] I have searched the existing issues before opening this issue. - [x] 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. - [x] 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.
Author
Owner

@rmartinoscar commented on GitHub (Feb 27, 2025):

Hey this has already been adressed and will be fixed in the next beta
https://github.com/pelican-dev/panel/pull/899

@rmartinoscar commented on GitHub (Feb 27, 2025): Hey this has already been adressed and will be fixed in the next beta https://github.com/pelican-dev/panel/pull/899
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/panel-pelican-dev#264