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

Out of range value for image height #1461

New Issue
Open
opened 2026-10-05 00:44:50 +02:00 by adam · 1 comment
adam commented 2026-10-05 00:44:50 +02:00
Owner
Copy link
Copy source

[mysql error 1264] Out of range value for column 'height' at row 1 UPDATE piwigo_images SET width=8192, height=122880 WHERE id=95 in /opt/piwigo/include/dblayer/functions_mysqli.inc.php on line 864

The above error occurs when Large size images is uploaded
This error maybe fixed by editting maximum heght size of mysql.
But I am newer.
Could you answer the following question?

  1. Which file I should edid to edit maximum heght size of mysql?
  2. Side effect of editting maximum heght size
> [mysql error 1264] Out of range value for column 'height' at row 1 UPDATE piwigo_images SET width=8192, height=122880 WHERE id=95 in /opt/piwigo/include/dblayer/functions_mysqli.inc.php on line 864 The above error occurs when Large size images is uploaded This error maybe fixed by editting maximum heght size of mysql. But I am newer. Could you answer the following question? 1. Which file I should edid to edit maximum heght size of mysql? 2. Side effect of editting maximum heght size <!-- github-sync-id:1265757087 -->
adam commented 2026-10-05 00:44:51 +02:00
Author
Owner
Copy link
Copy source

The above error reason is "height" data type in mysql is smallint.
Smallint range is 0 ~ 65535.
But my uploaded image height is 122880.
In mysql, the insterted value of the height is NULL,, so error occurs.

Resolving it can be to change "height" data type from smallint to MIDIUMINT.

Could you tell me the side effect of "height" data type?

The above error reason is "height" data type in mysql is smallint. Smallint range is 0 ~ 65535. But my uploaded image height is 122880. In mysql, the insterted value of the height is NULL,, so error occurs. Resolving it can be to change "height" data type from smallint to MIDIUMINT. Could you tell me the side effect of "height" data type? <!-- github-comment-id:1154830089 -->
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#1461