starred/panel-pelican-dev
1
0
Fork 0
mirror of https://github.com/pelican-dev/panel.git synced 2026-05-04 18:00:48 +03:00
Code Issues 41 Packages Projects Releases 10 Wiki Activity

500 Server Error: SQLite too many SQL variables when accessing folder with many files #308

New Issue
Closed
opened 2026-02-05 17:24:29 +03:00 by OVERLORD · 1 comment
OVERLORD commented 2026-02-05 17:24:29 +03:00
Owner
Copy Link

Originally created by @jvsod on GitHub (Apr 14, 2025).

Originally assigned to: @rmartinoscar on GitHub.

Current Behavior

SQLSTATE[HY000]: General error: 1 too many SQL variables
...
insert into "files" (...) values (...), (...), ...

Expected Behavior

I need the folder to load properly without issue. The issue with the folder having too many files inside it, is causing an error 500 for myself and others when trying to access this folder. I need the error resolved.

This used to work fine in a previous update, but seems to have stopped working in a recent update.

Steps to Reproduce

Create a folder which then contains more than the SQLLite variables limit and try accessing the folder in the panel via the "Files" section of the individual server hosted.

Panel Version

1.0.0-beta19

Wings Version

v1.0.0-beta11

Games and/or Eggs Affected

No response

Docker Image

No response

Error Logs

SQLSTATE[HY000]: General error: 1 too many SQL variables
...
insert into "files" (...) values (...), (...), ...

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 @jvsod on GitHub (Apr 14, 2025). Originally assigned to: @rmartinoscar on GitHub. ### Current Behavior SQLSTATE[HY000]: General error: 1 too many SQL variables ... insert into "files" (...) values (...), (...), ... ### Expected Behavior I need the folder to load properly without issue. The issue with the folder having too many files inside it, is causing an error 500 for myself and others when trying to access this folder. I need the error resolved. This used to work fine in a previous update, but seems to have stopped working in a recent update. ### Steps to Reproduce Create a folder which then contains more than the SQLLite variables limit and try accessing the folder in the panel via the "Files" section of the individual server hosted. ### Panel Version 1.0.0-beta19 ### Wings Version v1.0.0-beta11 ### Games and/or Eggs Affected _No response_ ### Docker Image _No response_ ### Error Logs ```bash SQLSTATE[HY000]: General error: 1 too many SQL variables ... insert into "files" (...) values (...), (...), ... ``` ### 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.
OVERLORD commented 2026-02-05 17:24:32 +03:00
Author
Owner
Copy Link

@rmartinoscar commented on GitHub (Apr 14, 2025):

What kind of folder has this many files right bellow it (not nested) ?
https://sqlite.org/limits.html

To prevent excessive memory allocations, the maximum value of a host parameter number is SQLITE_MAX_VARIABLE_NUMBER, which defaults to 999 for SQLite versions prior to 3.32.0 (2020-05-22) or 32766 for SQLite versions after 3.32.0.

We only support sqlite 3.35+

But i agree this shouldn't throw

@rmartinoscar commented on GitHub (Apr 14, 2025): What kind of folder has this many files right bellow it (not nested) ? https://sqlite.org/limits.html > To prevent excessive memory allocations, the maximum value of a host parameter number is SQLITE_MAX_VARIABLE_NUMBER, which defaults to 999 for SQLite versions prior to 3.32.0 (2020-05-22) or 32766 for SQLite versions after 3.32.0. We only support sqlite 3.35+ But i agree this shouldn't throw
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
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-pelican-dev#308
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?