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

    Support response

    Support checklist

error after latest update, update failed

I'm running into the same issue. When running the SQL manually, I get the following:

SQL query:

ALTER TABLE chv_users MODIFY user_username varchar(255) NOT NULL

MySQL said:

#1071 - Specified key was too long; max key length is 1000 bytes

To resolve I modified the user_username column to be Innodb instead of MyIsam.
 
Last edited:
Hello

To correct the 1071 errors, before upgrading chevereto, it suffices to convert the MyISAM tables into InnoDB via PhpMyAdmin and that under MySQL V5.7.xx very important !!! the MySQL version

Here are the lines to run under PhpMyAdmin via SQL tab:
ALTER TABLE chv_albums ENGINE=InnoDB;
ALTER TABLE chv_images ENGINE=InnoDB;
ALTER TABLE chv_redirects ENGINE=InnoDB;
ALTER TABLE chv_users ENGINE=InnoDB;

Then upgrade from chevereto to V3.20.7 and everything works perfectly

I just upgraded from chevereto V3.15.1 to chevereto V3.20.7 and everything went very well

And stop writing nonsense !!!!! Thank you

JfrPro
 

Attachments

  • base.jpg
    base.jpg
    845.8 KB · Views: 11
  • after .jpg
    after .jpg
    863.3 KB · Views: 11
Last edited:
 
Back
Top