starred/panel
1
0
Fork 0
mirror of https://github.com/pelican-dev/panel.git synced 2026-02-25 03:14:39 +03:00
Code Issues 42 Packages Projects Releases 12 Wiki Activity

[PR #1854] [MERGED] Fix admin serverlist search #1614

New Issue
Closed
opened 2026-02-04 20:01:29 +03:00 by OVERLORD · 0 comments
OVERLORD commented 2026-02-04 20:01:29 +03:00
Owner
Copy Link

📋 Pull Request Information

Original PR: https://github.com/pelican-dev/panel/pull/1854
Author: @m41denx
Created: 10/31/2025
Status: ✅ Merged
Merged: 11/3/2025
Merged by: @notAreYouScared

Base: main ← Head: fix/admin-list-servers

📝 Commits (1)

  • 859daa7 Fix admin serverlist search

📊 Changes

1 file changed (+4 additions, -1 deletions)

View changed files

📝 app/Filament/Admin/Resources/Servers/Pages/ListServers.php (+4 -1)

📄 Description

When searching servers in admin area a SQL error is thrown:

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'name'
in WHERE is ambiguous (Connection: mariadb, 
SQL: select count(*) as aggregate from `servers` left join `nodes` on `servers`.`node_id` = `nodes`.`id` 
where `node_id` in (1) and (
    `name` like %ddfj% 
    or exists (select * from `eggs` where `servers`.`egg_id` = `eggs`.`id` and `name` like %ddfj%) 
    or exists (select * from `users` where `servers`.`owner_id` = `users`.`id` and `username` like %ddfj%)
)) 
(View: /var/www/pelican/vendor/filament/tables/resources/views/index.blade.php) 
(View: /var/www/pelican/vendor/filament/tables/resources/views/index.blade.php)

This commit fixes described issue

🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.

## 📋 Pull Request Information **Original PR:** https://github.com/pelican-dev/panel/pull/1854 **Author:** [@m41denx](https://github.com/m41denx) **Created:** 10/31/2025 **Status:** ✅ Merged **Merged:** 11/3/2025 **Merged by:** [@notAreYouScared](https://github.com/notAreYouScared) **Base:** `main` ← **Head:** `fix/admin-list-servers` --- ### 📝 Commits (1) - [`859daa7`](https://github.com/pelican-dev/panel/commit/859daa7f2feb1d97e010f44ec232ca86532c44f8) Fix admin serverlist search ### 📊 Changes **1 file changed** (+4 additions, -1 deletions) <details> <summary>View changed files</summary> 📝 `app/Filament/Admin/Resources/Servers/Pages/ListServers.php` (+4 -1) </details> ### 📄 Description When searching servers in admin area a SQL error is thrown: ``` SQLSTATE[23000]: Integrity constraint violation: 1052 Column &#039;name&#039; in WHERE is ambiguous (Connection: mariadb, SQL: select count(*) as aggregate from `servers` left join `nodes` on `servers`.`node_id` = `nodes`.`id` where `node_id` in (1) and ( `name` like %ddfj% or exists (select * from `eggs` where `servers`.`egg_id` = `eggs`.`id` and `name` like %ddfj%) or exists (select * from `users` where `servers`.`owner_id` = `users`.`id` and `username` like %ddfj%) )) (View: /var/www/pelican/vendor/filament/tables/resources/views/index.blade.php) (View: /var/www/pelican/vendor/filament/tables/resources/views/index.blade.php) ``` This commit fixes described issue --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>
OVERLORD added the pull-request label 2026-02-04 20:01:29 +03:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
not confirmed
pull-request
Mirrored from GitHub Pull Request
 👑 sponsor
💰 fund
🔴 hard
🟡 medium
🟡 medium
🟡 medium
🟢 easy
🟢 easy
🟢 easy
No Label pull-request
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
OVERLORD
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/panel#1614
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?