• Welcome to the Chevereto User Community!

    Here, users from all over the world come together to learn, share, and collaborate on everything related to Chevereto. It's a place to exchange ideas, ask questions, and help improve the software.

    Please keep in mind:

    • This community is user-driven. Always be polite and respectful to others.
    • Support development by purchasing a Chevereto license, which also gives you priority support.
    • Go further by joining the Community Subscription for even faster response times and to help sustain this space

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