• 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
  • Chevereto Support CLST

    Support response

    Support checklist

    • Got a Something went wrong message? Read this guide and provide the actual error. Do not skip this.
    • Confirm that the server meets the System Requirements
    • Check for any available Hotfix - your issue could be already reported/fixed
    • Read documentation - It will be required to Debug and understand Errors for a faster support response

General error: 1364 Field 'storage_id' doesn't have a default value (HY000)

M

Mortgage

Chevereto Member
Hey community!

I'm trying to create BackBlade as a secondary option - Chevereto is throwing this error when trying to add the external storage:

Code: 
SQLSTATE[HY000]: General error: 1364 Field 'storage_id' doesn't have a default value (HY000)

Running this SQL query fixed it:
Code: 
ALTER TABLE storages MODIFY storage_id BIGINT(32) NOT NULL AUTO_INCREMENT;

Unsolved question:
How can I keep both my VPS Storage and my Backblaze B2 Cloud Storage synced? Is this a good idea (in case one gets suspended again)? Do I just add both as external storage make them both "Active" and they will both get the uploads? How's it work if multiple storage is set as Active?
 
Last edited:
Sort by date Sort by votes
Hello,

You should really pay attention to your supply chain because table storage is correctly defined with AUTO_INCREMENT:

github.com

chevereto/app/schemas/mysql-8/storages.sql at fad8a342fe901cd0135f67a1854881073aa4e928 · chevereto/chevereto

The mature, battle-tested, high-end, OG self-hosted image and video hosting solution trusted since 2007. Build your own Flickr or Imgur-style media sharing platform with complete control over your ...
github.com github.com

I ignore how you got that table with the wrong table definition, most likely someone tempered that manually.
 
Upvote 0 Downvote
Rodolfo said:
Hello,

You should really pay attention to your supply chain because table storage is correctly defined with AUTO_INCREMENT:

github.com

chevereto/app/schemas/mysql-8/storages.sql at fad8a342fe901cd0135f67a1854881073aa4e928 · chevereto/chevereto

The mature, battle-tested, high-end, OG self-hosted image and video hosting solution trusted since 2007. Build your own Flickr or Imgur-style media sharing platform with complete control over your ...
github.com github.com

I ignore how you got that table with the wrong table definition, most likely someone tempered that manually.
Click to expand...

Hey Rodolfo,

Yeah it was very weird. I think it's from the database backup and restore. When I took a backup via PhpMyAdmin (DB > Export > Custom > Compression: Gzipped.) it also duplicated the albums table and tried to import it twice and throw errors. Thankfully didn't break anything!

I didn't get the AUTO_INCREMENT when I added Amazon S3 but when I added a third Backblaze immediately after the error appeared and I added both of them within minutes of one another.. weird!

It's most likely why I'm having trouble updating from v4.0.12

I haven't done anything manually (DB side anyway) only custom things I have done are overwrites of theme.
 
Upvote 0 Downvote
You must log in or register to reply here.
Back
Top