Database upgrade error on v4.2.2

[Pavel_M]

▶ Reproduction steps

1. Current installation Chevereto v4.1.4
2. Run php app/upgrading.php

😢 Unexpected result

The website «Something went wrong» for all pages.

📃 Error log message

app/upgrading.php:

# Backtrace
------------------------------------------------------------
0 /www/app/legacy/install/installer.php:2253
{main}()
------------------------------------------------------------
1 /www/app/legacy/commands/update.php:18
require_once()
------------------------------------------------------------
2 /www/app/legacy/entrypoints/cli.php:55
require_once(string(length=61))
------------------------------------------------------------
3 /www/app/bin/legacy:13
require_once(string(length=61))
------------------------------------------------------------

[672f264ea467e] LogicException in /www/app/legacy/install/installer.php:2253

# Message
Error executing the Chevereto update query.
SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'image_original_exifdata' at row 8028
Try running each of the following statements in the database console to find the conflict.

index.php:

# Message [Code #2]
Array to string conversion

# URI

# Method

# Backtrace
------------------------------------------------------------
0 /www/app/src/Legacy/functions.php:1131
{main}()
------------------------------------------------------------
1
strval(array(size=0))
------------------------------------------------------------
2 /www/app/src/Legacy/functions.php:1131
array_map(string(length=6), array(size=148))
------------------------------------------------------------
3 /www/app/legacy/entrypoints/index.php:36
Chevereto\Legacy\loaderHandler(array(size=3), array(size=53), array(size=0), array(size=0), array(size=0), array(size=3), array(size=53), array(size=0))
------------------------------------------------------------
4 /www/index.php:12
require_once(string(length=63))
------------------------------------------------------------

 

[Rodolfo]

Hello Pavel,

Thank you for reaching out to Chevereto support.

RE: app/upgrading.php

It appears that there is an issue with the column type for image_original_exifdata. In version 4.2.0, the column type was changed from longtext to text to match the maximum size for Exif data, which is 64 KB. However, since Chevereto stores this data in JSON format, it adds some overhead that wasn't anticipated. The column type should be updated to mediumtext to resolve this issue.

RE: index.php

Chevereto requires ENV variables to be of type string (or string-convertible). Please review your app/env.php file or your server's ENV settings for any conflicting values.

If you need further assistance, please let us know.

 

[Pavel_M]

Please review your app/env.php file or your server's ENV settings for any conflicting values.

My app/env.php which didn't change during the update:

<?php

return [
    'CHEVERETO_DB_HOST' => 'mariadb',
    'CHEVERETO_DB_NAME' => 'chevereto',
    'CHEVERETO_DB_PASS' => '*****',
    'CHEVERETO_DB_PORT' => '3306',
    'CHEVERETO_DB_USER' => 'chevereto',
    'CHEVERETO_DB_TABLE_PREFIX' => 'chv_',
    'CHEVERETO_ENABLE_PHP_PAGES' => '1',
    'CHEVERETO_ENCRYPTION_KEY' => '*****',
    'CHEVERETO_DEBUG_LEVEL' => '1',
];

 

[Rodolfo]

@Pavel_M The $envVar variable is sourced from app/env-default.php, app/env.php and ENV. At some point your server is passing an array value for these.

I've already confirmed this bug and it will be fixed in the next patch.

 

[Rodolfo]

Fixed in Chevereto v4.2.3