• 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

Update from 4.0.0-beta.11 to 4.0.0 issue with table_prefix

elliotks

Chevereto Member
▶ Reproduction steps
  1. Use CHEVERETO_DB_TABLE_PREFIX to use non-default chv_
  2. Update from 4.0.0-beta.11 to 4.0.0
  3. open site /update
😢 Unexpected result

I forgot the exact error, but it was looking for table chv_albums


📃 Error log message

N/A

Workaround:
Modify ./app/legacy/install/installer.php and replace chv_ with the value of my changed "CHEVERETO_DB_TABLE_PREFIX" value. I tried using
%table_prefix%albums but it didn't work for some reason when I tested. Maybe I needed to use %table_prefix%albums ?

928 if (version_compare($installed_version, '4.0.0', '<')) {
929 $passwordAlbums = DB::queryFetchAll(
930 <<<SQL
931 SELECT album_id id, album_password password
932 FROM chv_albums
933 WHERE album_password IS NOT NULL;
934 SQL
935 );
936 $albumUpdateQueries = '';
937 foreach ($passwordAlbums as $album) {
938 $hashAlbum = password_hash($album['password'], PASSWORD_BCRYPT);
939 $albumUpdateQueries .=
940 <<<SQL
941 UPDATE chv_albums
942 SET album_password = '{$hashAlbum}'
943 WHERE album_id = {$album['id']};
944
945 SQL;
946 }
947 }
 
Back
Top