adam/Piwigo
1
0 Fork 0
mirror of https://github.com/Piwigo/Piwigo.git synced 2026-10-30 21:52:00 +01:00
Code Issues 657 Packages Projects Releases Wiki Activity

SMALLINT issue with category IDs #2048

New Issue
Open
opened 2026-10-05 01:04:44 +02:00 by adam · 0 comments
adam commented 2026-10-05 01:04:44 +02:00
Owner
Copy link
Copy source

This is related to this forum topic:

https://piwigo.org/forum/viewtopic.php?id=34064

In short, we have reached 54k unique IDs now. So the limit of 65535 albums because of categories id having SMALLINT attribute will soon be reached as well. I understand that our case use is unusual, but if we do change all the attributes to INT, will that be overwritten by future Piwigo updates?

Generally, why is it SMALLINT from the start?

The thing is - it's also not actually even the real number of albums we have, because whenever we change the album name and sync it it will get a new ID and the old link will be deleted... We actually have around 30-40k.

This is related to this forum topic: https://piwigo.org/forum/viewtopic.php?id=34064 In short, we have reached 54k unique IDs now. So the limit of 65535 albums because of categories id having SMALLINT attribute will soon be reached as well. I understand that our case use is unusual, but if we do change all the attributes to INT, will that be overwritten by future Piwigo updates? Generally, why is it SMALLINT from the start? The thing is - it's also not actually even the real number of albums we have, because whenever we change the album name and sync it it will get a new ID and the old link will be deleted... We actually have around 30-40k. <!-- github-sync-id:3019707339 -->
Sign in to join this conversation.
No Branch/Tag Specified
Labels
No items
No labels
Milestone
No items
No Milestone
Projects
Clear projects
No projects
Assignees
Clear assignees
adam (Adam Wojcieszonek)
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: adam/Piwigo#2048