• Welcome to the Chevereto user community!

    Here users from all over the world gather around to learn the latest about Chevereto and contribute with ideas to improve the software.

    Please keep in mind:

    • 😌 This community is user driven. Be polite with other users.
    • 👉 Is required to purchase a Chevereto license to participate in this community (doesn't apply to Pre-sales).
    • 💸 Purchase a Pro Subscription to get access to active software support and faster ticket response times.

Wrong quota after moving storages

Status
Not open for further replies.
bee

bee

💖 Chevereto Fan
As RunAbove will stop his service, I add SFTP storages to my sites. I moved all photos to the new storage and also changed the IDs in the DB. Everything works fine.

But in the Dashboad under "external storage" I see under my new storages quota only the size of new uploaded photos - not the size from the old photos I moved to the new storage.

How can I fix this?
 
You need to manually populate the storage_space_used value.

Code: 
UPDATE `chv_storages` SET storage_space_used = (SELECT IFNULL(SUM(image_size) + SUM(image_thumb_size) + SUM(image_medium_size),0) FROM `chv_images`
WHERE image_storage_id = STORAGE_ID_HERE) WHERE storage_id = STORAGE_ID_HERE;
 
Last edited:
Status
Not open for further replies.
Back
Top