6.0.0-alpha10
5/14/25

[#15035] Negative gallery counter after unsuccessfull uploads to VFS
Summary Negative gallery counter after unsuccessfull uploads to VFS
Queue Ansel
Queue Version 3.0.9
Type Bug
State Unconfirmed
Priority 1. Low
Owners
Requester AP (at) webmailto (dot) com
Created 09/22/2020 (1695 days ago)
Due
Updated 09/22/2020 (1695 days ago)
Assigned
Resolved
Milestone
Patch No

History
09/22/2020 01:21:08 PM AP (at) webmailto (dot) com Comment #1
State ⇒ Unconfirmed
Priority ⇒ 1. Low
Type ⇒ Bug
Summary ⇒ Negative gallery counter after unsuccessfull uploads to VFS
Queue ⇒ Ansel
Milestone ⇒
Patch ⇒ No
Reply to this comment
Negative gallery counter after unsuccessfull uploads to VFS
After several tries to upload to the VFS with insufficient rights, the 
counter gets negative. When the rights of the VFS fixed, and after 
upload of one image, the next gives and error:
[ansel] SQL QUERY FAILED: SQLSTATE[22003]: Numeric value out of range: 
1264 Out of range value for column 'image_sort' at row 1

Situation resolved with:
update ansel_sharesng set attribute_images = 1 where share_id = 1;

Saved Queries