Updating from 8.6.2 to 8.7.0, error during upgrade-finalize: You have requested a non-existent parameter "23W"

rsp · 18 October 2024 13:35

I think we have same issue for upgrade 7.14 to 8.7

Special character in database password creates issues

opened 04:03PM - 07 Oct 24 UTC

Type: Bug Priority:Important Area: Installation Severity: Major

### Issue I just ran a test migration of our 7.14 instance to 8.7.0 and get an …error since our database password contains special characters (pure ascii characters in the range %21 to %7e). Changing the password to remove any character apart from 0-9a-zA-Z "fixes" the problem temporarily but this can't be a long term solution. Here is the specific error message: ``` PHP Fatal error: Uncaught Symfony\\Component\\DependencyInjection\\Exception\\ParameterNotFoundException: You have requested a non-existent parameter "xxxxxxxxxxx". in /var/www/suitecrm/cache/prod/Container91EHOYK/App_KernelProdContainer.php:2089 Stack trace: #0 /var/www/suitecrm/vendor/symfony/dependency-injection/EnvVarProcessor.php(343): Container91EHOYK\\App_KernelProdContainer->getParameter() #1 [internal function]: Symfony\\Component\\DependencyInjection\\EnvVarProcessor->Symfony\\Component\\DependencyInjection\\{closure}() #2 /var/www/suitecrm/vendor/symfony/dependency-injection/EnvVarProcessor.php(335): preg_replace_callback() #3 /var/www/suitecrm/vendor/symfony/dependency-injection/Container.php(382): Symfony\\Component\\DependencyInjection\\EnvVarProcessor->getEnv() #4 /var/www/suitecrm/cache/prod/Container91EHOYK/App_KernelProdContainer.php(607): Symfony\\Component\\DependencyInjection\\Container->getEnv() #5 /var/www/suitecrm/cache/prod/Container91EHOYK/App_KernelProdContainer.php(676): Container91EHOYK\\App_KernelProdContainer::getDoctrine_Dbal_DefaultConnectionService() #6 /var/www/suitecrm/cache/prod/Container91EHOYK/App_KernelProdContainer.php(618): Container91EHOYK\\App_KernelProdContainer::getDoctrine_Orm_DefaultEntityManagerService() #7 /var/www/suitecrm/vendor/symfony/var-exporter/Internal/LazyObjectState.php(100): Container91EHOYK\\App_KernelProdContainer::Container91EHOYK\\{closure}() #8 /var/www/suitecrm/vendor/symfony/var-exporter/LazyGhostTrait.php(178): Symfony\\Component\\VarExporter\\Internal\\LazyObjectState->initialize() #9 /var/www/suitecrm/vendor/doctrine/orm/src/EntityManager.php(207): Container91EHOYK\\EntityManagerGhost6410e2e->__get() #10 /var/www/suitecrm/vendor/doctrine/doctrine-bundle/src/CacheWarmer/DoctrineMetadataCacheWarmer.php(42): Doctrine\\ORM\\EntityManager->getMetadataFactory() #11 /var/www/suitecrm/vendor/symfony/framework-bundle/CacheWarmer/AbstractPhpFileCacheWarmer.php(47): Doctrine\\Bundle\\DoctrineBundle\\CacheWarmer\\DoctrineMetadataCacheWarmer->doWarmUp() #12 /var/www/suitecrm/vendor/symfony/http-kernel/CacheWarmer/CacheWarmerAggregate.php(108): Symfony\\Bundle\\FrameworkBundle\\CacheWarmer\\AbstractPhpFileCacheWarmer->warmUp() #13 /var/www/suitecrm/vendor/symfony/http-kernel/Kernel.php(545): Symfony\\Component\\HttpKernel\\CacheWarmer\\CacheWarmerAggregate->warmUp() #14 /var/www/suitecrm/core/backend/Kernel.php(112): Symfony\\Component\\HttpKernel\\Kernel->initializeContainer() #15 /var/www/suitecrm/vendor/autoload_runtime.php(37): App\\Kernel->init() #16 /var/www/suitecrm/public/index.php(5): require_once('...') #17 {main} thrown in /var/www/suitecrm/cache/prod/Container91EHOYK/App_KernelProdContainer.php on line 2089 ``` ### Possible Fix _No response_ ### Steps to Reproduce the Issue ```bash 1. Create a 7.14 instance 2. Set the password to use a special character (e.g. $) 3. Perform the migration to 8.7 4. Try to open the web site Temporary fix and confirmation that the handling of special characters is the issue 1. Change the password to using only numbers, lower and uppercase characters 2. Update .env.local and public/legacy/config.php with the new password 3. Open the web site again ``` ### Context _No response_ ### Version 8.7.0 ### What browser are you currently using? Firefox ### Browser Version _No response_ ### Environment Information PHP 8.2.24, MySQL 8.0.39 ### Operating System and Version Tuxedo 3 (Ubuntu Clone)