v3 to v4 upgrade failure

[hlx98007]

Hi, I was running a v3 multi site, and I am trying to upgrade that to v4.

I have encountered an issue:

sudo -u nginx /var/www/pic/app/bin/legacy -C update

shows

PDOException thrown in /var/www/pic.ke.fo/app/src/Legacy/G/DB.php:151

# Message [Code #42000]
SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP COLUMN `user_is_dark_mode`; check that it exists

 

[Rodolfo]

Check this hotfix.

 

[hlx98007]

@Rodolfo Thanks,

Proceed now has this issue:

INSERT IGNORE INTO `chv_login_connections` (login_connection_user_id, login_connection_provider_id, login_connection_date_gmt,
 login_connection_resource_id, login_connection_resource_name,
 login_connection_token)
SELECT login_user_id, login_provider_id, max(login_date_gmt), login_resource_id, login_resource_name, '' token
FROM `chv_logins`
 JOIN `chv_login_providers` ON login_provider_name = login_type
WHERE login_type IN ('facebook', 'twitter', 'google', 'vk')
GROUP BY login_user_id, login_provider_id;

#1267 - Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '='

I fixed it by adding "COLLATE utf8mb4_unicode_ci" right after "ON login_provider_name"

 

[hlx98007]

@Rodolfo
when trying to update b2 setting (legacy):

During inheritance of JsonSerializable: Uncaught Chevere\Throwable\Exceptions\ErrorException: Return type of obregonco\B2\File::jsonSerialize() should either be compatible with JsonSerializable::jsonSerialize(): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /var/www/pic.ke.fo/app/vendor/obregonco/backblaze-b2/src/File.php:112
Stack trace:
#0 /var/www/pic.ke.fo/app/vendor/obregonco/backblaze-b2/src/File.php(5): Chevere\ThrowableHandler\errorAsException()
#1 /var/www/pic.ke.fo/app/vendor/composer/ClassLoader.php(444): include('/var/www/pic.ke...')
#2 /var/www/pic.ke.fo/app/vendor/composer/ClassLoader.php(322): Composer\Autoload\includeFile()
#3 /var/www/pic.ke.fo/app/vendor/obregonco/backblaze-b2/src/Client.php(651): Composer\Autoload\ClassLoader->loadClass()
#4 /var/www/pic.ke.fo/app/vendor/obregonco/backblaze-b2/src/Client.php(248): obregonco\B2\Client->uploadStandardFile()
#5 /var/www/pic.ke.fo/app/src/Legacy/Classes/Storage.php(257): obregonco\B2\Client->upload()
#6 /var/www/pic.ke.fo/app/src/Legacy/Classes/Storage.php(474): Chevereto\Legacy\Classes\Storage::uploadFiles()
#7 /var/www/pic.ke.fo/app/src/Legacy/Classes/Storage.php(573): Chevereto\Legacy\Classes\Storage::test()
#8 /var/www/pic.ke.fo/app/legacy/routes/json.php(637): Chevereto\Legacy\Classes\Storage::update()
#9 /var/www/pic.ke.fo/app/src/Legacy/G/Handler.php(227): Chevereto\Legacy\G\Handler->{closure}()
#10 /var/www/pic.ke.fo/app/src/Legacy/G/Handler.php(151): Chevereto\Legacy\G\Handler->processRequest()
#11 /var/www/pic.ke.fo/app/legacy/load/web.php(448): Chevereto\Legacy\G\Handler->__construct()
#12 /var/www/pic.ke.fo/app/legacy/entrypoints/index.php(25): require_once('/var/www/pic.ke...')
#13 /var/www/pic.ke.fo/index.php(12): require_once('/var/www/pic.ke...')
#14 {main}</div>

F12 says POST to json endpoint but the submit is a form type. maybe something wrong here?

I also noticed that some of the external service API secret keys are scrambled, I had to re-enter the correct API secret.