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

[elliotks]

▶ 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 }

 

[Rodolfo]

We can confirm the bug and we will fix it in the next revision.

Many thanks @elliotks for bring this to our attention.

 

[Rodolfo]

Fixed in V4.0.1

👉 https://chevereto.com/community/threads/chevereto-v4-0-1.14607/