fmoreira86

I hope so...

You've to read it compeletly / watch the video... (... )even though this version after the release of 8.1, is not really maintained anymore when it comes to bug fixes, SECURITY FIXES and so on" This was the first red flag... The second: "if you want to make sure that you are receiving all the security fixes (...), make sure to upgrade to Prestashop 8.1"

I use maria db (with caching enabled)

Hi all! I just watched this video: I'm still on 1.7.8.x branch and I'll quote some sentences from this video: - " as part of the extended securitysupport period we released 1.7.8.10 (...) we decided to also release the security for this version as well, even though this version after the release of 8.1, is not really maintained anymore when it comes to bug fixes, SECURITY FIXES and so on" - "if you want to make sure that you are receiving all the security fixes (...), make sure to upgrade to Prestashop 8.1" My feeling about this video (and this is maybe the speaker is not native english speaker (?)) is that prestashop is slowly forgetting the guidelines that they wrote some time ago: " this means that patch releases of PrestaShop 1.7.8 will only be published if critical bugs are reported or if security fixes are needed.", "This maintenance period will end when PrestaShop 9.0.0 is released. When this day comes, PrestaShop 1.7 will not be maintained anymore." Source: https://build.prestashop-project.org/news/2023/178-in-extended-support-phase/ A security fix should ALWAYS be read as something important, so I don't understand this "favor" that the development team did to us... if there's a commitment to provide SEVERE bug fixes and SECURITY bug fixes, this should be honored. Any software project (paid or "free") should stick to the plan having a straight and clear communication. Am I the only one who got confused? Any thoughts?

Based on the module description: So, if we don't use any of these, it's probably safe to truncate I would say...

Thank you! So it's perfectly safe to truncate from times to times right with the store in maintenance mode, right?

Thanks for your reply! What's the goal of this table?

Based on PS official demo: Database information MySQL version: 10.5.19-MariaDB-0+deb11u2

I have the same question... Can someone please explain if it's ok to truncate this table from times to times?

Thanks for your reply! There's not a great amount of "reds". There's also some recommendations. What would you suggest based on the config I shared?

This weekend I swaped from Mysql 8 to MariaDB 10.5 and instantly noticed a performance improvement. As MariaDB still supports Query Cache I tried with the settings PS recommends: https://devdocs.prestashop-project.org/8/scale/optimizations/ In fact it improves the whole page *A LOT*, for instance I've arround 180K orders, and with query cache I can open the "orders" tab in about 1.5 seconds Vs 2.6 seconds with query cache disable VS Mysql 8 6seconds (!!!). I've arround 50 to 100 users concurrent users and I'm a bit worried about keeping query cache enabled, for instance due to "Waiting for query cache lock" issue, etc. : https://mysqlquicksand.wordpress.com/2020/05/08/10-reasons-why-mysql-query-cache-should-be-switched-off/ With this beeing said, my PS runs on a 32GB RAM, 32 core CPU, with Enterprise SSDs (not NVME). I'm using the recommended settings pretty much: query_cache_limit = 128K query_cache_size = 32M query_cache_type = ON table_open_cache = 4000 thread_cache_size = 80 host_cache_size=1000 read_buffer_size = 2M read_rnd_buffer_size = 1M join_buffer_size = 2M sort_buffer_size = 2M innodb_buffer_pool_size = 12G performance_schema = OFF max_heap_table_size = 2G tmp_table_size = 2G Tipically my front office loads in 1.2 to 2.8 seconds now (depending if it's a product page, category page, search page, etc) ... but you know, we're always trying to improve things. Any comments / suggestions?

The official demo remains at 1.7 version. I think this tells everything...

Hi there! I got these errors at the end of the upgrade: [SKIP] directory "/app/cache/" does not exist and cannot be emptied. [CLEANING CACHE] File dev removed [CLEANING CACHE] File prod removed Migrating old setting file... parameters file already exists! Finished... [INTERNAL] /var/www/MYDIRECTORY/modules/autoupgrade/vendor/composer/ClassLoader.php line 444 - include(/var/www/MYDIRECTORY/vendor/composer/../doctrine/event-manager/lib/Doctrine/Common/EventManager.php): failed to open stream: No such file or directory [INTERNAL] /var/www/MYDIRECTORY/modules/autoupgrade/vendor/composer/ClassLoader.php line 444 - include(): Failed opening '/var/www/MYDIRECTORY/vendor/composer/../doctrine/event-manager/lib/Doctrine/Common/EventManager.php' for inclusion (include_path='/var/www/MYDIRECTORY/vendor/pear/pear_exception:/var/www/MYDIRECTORY/vendor/pear/console_getopt:/var/www/MYDIRECTORY/vendor/pear/pear-core-minimal/src:/var/www/MYDIRECTORY/vendor/pear/archive_tar:.:/usr/share/php') [INTERNAL] /var/www/MYDIRECTORY/modules/autoupgrade/vendor/composer/ClassLoader.php line 444 - include(/var/www/MYDIRECTORY/vendor/composer/../doctrine/event-manager/lib/Doctrine/Common/EventSubscriber.php): failed to open stream: No such file or directory [INTERNAL] /var/www/MYDIRECTORY/modules/autoupgrade/vendor/composer/ClassLoader.php line 444 - include(): Failed opening '/var/www/MYDIRECTORY/vendor/composer/../doctrine/event-manager/lib/Doctrine/Common/EventSubscriber.php' for inclusion (include_path='/var/www/MYDIRECTORY/vendor/pear/pear_exception:/var/www/MYDIRECTORY/vendor/pear/console_getopt:/var/www/MYDIRECTORY/vendor/pear/pear-core-minimal/src:/var/www/MYDIRECTORY/vendor/pear/archive_tar:.:/usr/share/php') [INTERNAL] /var/www/MYDIRECTORY/modules/autoupgrade/vendor/composer/ClassLoader.php line 444 - include(/var/www/MYDIRECTORY/vendor/composer/../doctrine/event-manager/lib/Doctrine/Common/EventManager.php): failed to open stream: No such file or directory [INTERNAL] /var/www/MYDIRECTORY/modules/autoupgrade/vendor/composer/ClassLoader.php line 444 - include(): Failed opening '/var/www/MYDIRECTORY/vendor/composer/../doctrine/event-manager/lib/Doctrine/Common/EventManager.php' for inclusion (include_path='/var/www/MYDIRECTORY/vendor/pear/pear_exception:/var/www/MYDIRECTORY/vendor/pear/console_getopt:/var/www/MYDIRECTORY/vendor/pear/pear-core-minimal/src:/var/www/MYDIRECTORY/vendor/pear/archive_tar:.:/usr/share/php') [INTERNAL] /var/www/MYDIRECTORY/vendor/symfony/symfony/src/Symfony/Bridge/Doctrine/ContainerAwareEventManager.php line 23 - Error: Class 'Doctrine\Common\EventManager' not found #0 /var/www/MYDIRECTORY/modules/autoupgrade/vendor/composer/ClassLoader.php(444): include() #1 /var/www/MYDIRECTORY/modules/autoupgrade/vendor/composer/ClassLoader.php(322): Composer\Autoload\includeFile() #2 [internal function]: Composer\Autoload\ClassLoader->loadClass() #3 /var/www/MYDIRECTORY/var/cache/prod/ContainerFnfubs4/appProdProjectContainer.php(2935): spl_autoload_call() #4 /var/www/MYDIRECTORY/var/cache/prod/ContainerFnfubs4/appProdProjectContainer.php(2969): ContainerFnfubs4\appProdProjectContainer->getDoctrine_Dbal_DefaultConnectionService() #5 /var/www/MYDIRECTORY/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Container.php(306): ContainerFnfubs4\appProdProjectContainer->getDoctrine_Orm_DefaultEntityManagerService() #6 /var/www/MYDIRECTORY/vendor/symfony/symfony/src/Symfony/Bridge/Doctrine/ManagerRegistry.php(63): Symfony\Component\DependencyInjection\Container->get() #7 /var/www/MYDIRECTORY/vendor/doctrine/persistence/lib/Doctrine/Persistence/AbstractManagerRegistry.php(204): Symfony\Bridge\Doctrine\ManagerRegistry->getService() #8 /var/www/MYDIRECTORY/vendor/symfony/symfony/src/Symfony/Bridge/Doctrine/CacheWarmer/ProxyCacheWarmer.php(53): Doctrine\Persistence\AbstractManagerRegistry->getManagers() #9 /var/www/MYDIRECTORY/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/CacheWarmer/CacheWarmerAggregate.php(52): Symfony\Bridge\Doctrine\CacheWarmer\ProxyCacheWarmer->warmUp() #10 /var/www/MYDIRECTORY/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php(686): Symfony\Component\HttpKernel\CacheWarmer\CacheWarmerAggregate->warmUp() #11 /var/www/MYDIRECTORY/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php(135): Symfony\Component\HttpKernel\Kernel->initializeContainer() #12 /var/www/MYDIRECTORY/modules/autoupgrade/classes/UpgradeTools/SymfonyAdapter.php(76): Symfony\Component\HttpKernel\Kernel->boot() #13 /var/www/MYDIRECTORY/modules/autoupgrade/classes/UpgradeTools/CoreUpgrader/CoreUpgrader17.php(56): PrestaShop\Module\AutoUpgrade\UpgradeTools\SymfonyAdapter->initAppKernel() #14 /var/www/MYDIRECTORY/modules/autoupgrade/classes/UpgradeTools/CoreUpgrader/CoreUpgrader.php(87): PrestaShop\Module\AutoUpgrade\UpgradeTools\CoreUpgrader\CoreUpgrader17->initConstants() #15 /var/www/MYDIRECTORY/modules/autoupgrade/classes/TaskRunner/Upgrade/UpgradeDb.php(42): PrestaShop\Module\AutoUpgrade\UpgradeTools\CoreUpgrader\CoreUpgrader->doUpgrade() #16 /var/www/MYDIRECTORY/fnm/autoupgrade/ajax-upgradetab.php(53): PrestaShop\Module\AutoUpgrade\TaskRunner\Upgrade\UpgradeDb->run() #17 {main} I also end up with these information at the information page: Missing files (7) vendor/composer/installers/phpstan.neon.dist vendor/composer/installers/src/Composer/Installers/MiaoxingInstaller.php vendor/composer/installers/src/Composer/Installers/WinterInstaller.php vendor/composer/installers/src/Composer/Installers/TastyIgniterInstaller.php vendor/composer/installers/src/Composer/Installers/ProcessWireInstaller.php vendor/composer/installers/src/Composer/Installers/StarbugInstaller.php vendor/composer/installers/src/Composer/Installers/PantheonInstaller.php Updated files (10) vendor/composer/installers/src/Composer/Installers/TaoInstaller.php vendor/composer/installers/src/Composer/Installers/SyDESInstaller.php vendor/composer/installers/src/Composer/Installers/MauticInstaller.php vendor/composer/installers/src/Composer/Installers/Installer.php vendor/composer/installers/src/Composer/Installers/MoodleInstaller.php vendor/composer/installers/src/Composer/Installers/OxidInstaller.php vendor/composer/installers/src/Composer/Installers/BaseInstaller.php vendor/composer/installers/src/Composer/Installers/CakePHPInstaller.php vendor/composer/installers/src/Composer/Installers/CockpitInstaller.php vendor/composer/installers/src/Composer/Installers/OctoberInstaller.php On my testing environment I also got this: [INTERNAL] /var/www/MYDIRECTORY/vendor/doctrine/inflector/lib/Doctrine/Common/Inflector/Inflector.php line 70 - Error: Class 'Doctrine\Inflector\InflectorFactory' not found #0 /var/www/MYDIRECTORY/vendor/doctrine/inflector/lib/Doctrine/Common/Inflector/Inflector.php(58): Doctrine\Common\Inflector\Inflector::createFactory() #1 /var/www/MYDIRECTORY/vendor/doctrine/inflector/lib/Doctrine/Common/Inflector/Inflector.php(92): Doctrine\Common\Inflector\Inflector::getInstance() #2 /var/www/MYDIRECTORY/vendor/doctrine/doctrine-cache-bundle/DependencyInjection/CacheProviderLoader.php(117): Doctrine\Common\Inflector\Inflector::classify() #3 /var/www/MYDIRECTORY/vendor/doctrine/doctrine-cache-bundle/DependencyInjection/CacheProviderLoader.php(102): Doctrine\Bundle\DoctrineCacheBundle\DependencyInjection\CacheProviderLoader->getDefinitionClass() #4 /var/www/MYDIRECTORY/vendor/doctrine/doctrine-cache-bundle/DependencyInjection/CacheProviderLoader.php(38): Doctrine\Bundle\DoctrineCacheBundle\DependencyInjection\CacheProviderLoader->definitionClassExists() #5 /var/www/MYDIRECTORY/vendor/doctrine/doctrine-cache-bundle/DependencyInjection/SymfonyBridgeAdapter.php(130): Doctrine\Bundle\DoctrineCacheBundle\DependencyInjection\CacheProviderLoader->loadCacheProvider() #6 /var/www/MYDIRECTORY/vendor/doctrine/doctrine-bundle/DependencyInjection/DoctrineExtension.php(785): Doctrine\Bundle\DoctrineCacheBundle\DependencyInjection\SymfonyBridgeAdapter->loadCacheDriver() #7 /var/www/MYDIRECTORY/vendor/doctrine/doctrine-bundle/DependencyInjection/DoctrineExtension.php(796): Doctrine\Bundle\DoctrineBundle\DependencyInjection\DoctrineExtension->loadCacheDriver() #8 /var/www/MYDIRECTORY/vendor/doctrine/doctrine-bundle/DependencyInjection/DoctrineExtension.php(429): Doctrine\Bundle\DoctrineBundle\DependencyInjection\DoctrineExtension->loadOrmCacheDrivers() #9 /var/www/MYDIRECTORY/vendor/doctrine/doctrine-bundle/DependencyInjection/DoctrineExtension.php(392): Doctrine\Bundle\DoctrineBundle\DependencyInjection\DoctrineExtension->loadOrmEntityManager() #10 /var/www/MYDIRECTORY/vendor/doctrine/doctrine-bundle/DependencyInjection/DoctrineExtension.php(77): Doctrine\Bundle\DoctrineBundle\DependencyInjection\DoctrineExtension->ormLoad() #11 /var/www/MYDIRECTORY/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/MergeExtensionConfigurationPass.php(71): Doctrine\Bundle\DoctrineBundle\DependencyInjection\DoctrineExtension->load() #12 /var/www/MYDIRECTORY/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/DependencyInjection/MergeExtensionConfigurationPass.php(39): Symfony\Component\DependencyInjection\Compiler\MergeExtensionConfigurationPass->process() #13 /var/www/MYDIRECTORY/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/Compiler.php(140): Symfony\Component\HttpKernel\DependencyInjection\MergeExtensionConfigurationPass->process() #14 /var/www/MYDIRECTORY/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ContainerBuilder.php(789): Symfony\Component\DependencyInjection\Compiler\Compiler->compile() #15 /var/www/MYDIRECTORY/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php(643): Symfony\Component\DependencyInjection\ContainerBuilder->compile() #16 /var/www/MYDIRECTORY/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php(135): Symfony\Component\HttpKernel\Kernel->initializeContainer() #17 /var/www/MYDIRECTORY/modules/autoupgrade/classes/UpgradeTools/SymfonyAdapter.php(76): Symfony\Component\HttpKernel\Kernel->boot() #18 /var/www/MYDIRECTORY/modules/autoupgrade/classes/UpgradeTools/CoreUpgrader/CoreUpgrader17.php(56): PrestaShop\Module\AutoUpgrade\UpgradeTools\SymfonyAdapter->initAppKernel() #19 /var/www/MYDIRECTORY/modules/autoupgrade/classes/UpgradeTools/CoreUpgrader/CoreUpgrader.php(87): PrestaShop\Module\AutoUpgrade\UpgradeTools\CoreUpgrader\CoreUpgrader17->initConstants() #20 /var/www/MYDIRECTORY/modules/autoupgrade/classes/TaskRunner/Upgrade/UpgradeDb.php(42): PrestaShop\Module\AutoUpgrade\UpgradeTools\CoreUpgrader\CoreUpgrader->doUpgrade() #21 /var/www/MYDIRECTORY/MYADMIN/autoupgrade/ajax-upgradetab.php(53): PrestaShop\Module\AutoUpgrade\TaskRunner\Upgrade\UpgradeDb->run() #22 {main} So I just rolled back. Any hints?

Hi ! Opened a ticket on github, but since this is very specific I'm just waiting for someone telling me that he/she "can't reproduce the issue". Here it goes: My PS is 1.7.7.8 version. All the backoffice works just fine. However in this version, Brands & Suppliers take me 2 minutes to load. I've a dev environment where I upgraded to 1.7.8.2 and it loads in seconds. Server software version: Apache PHP version: 7.2.24-0ubuntu0.18.04.10 Memory limit: 512M Max execution time: 600 Upload Max File size: 128M MySQL version: 5.7.36-0ubuntu0.18.04.1 Tables prefix: ps_ MySQL engine: InnoDB MySQL driver: DbPDO

Hi! You'll never eliminate it. This is how the Web works. We managed to improve it slightly with some cache methods but in the end PS... is what it is... Our page loads in 2.2 seconds which is good however our TTFB is 1s.