local.ERROR /predis/predis/src/Command/ZSetReverseRangeByScore.php

[stephenmeehanuk]

Hi
I understand if this is outside the scope of support for Statamic, but has anyone come across this problem?

Redis is installed, redis-cli ping returns PONG and I can access the CP. but the website won't load, it's showing 500 SERVER ERROR

predis/predis was part of require, but I removed it and reinstalled it to be in require-dev. I've updated composer.json and ran composer update on the staging server, but I'm still getting this error?

[2023-06-07 21:21:44] local.ERROR: include(/home/ploi/preview.website.com/vendor/composer/../predis/predis/src/Command/ZSetReverseRangeByScore.php): Failed to open stream: No such file or directory {"exception":"[object] (ErrorException(code: 0): include(/home/ploi/preview.website.com/vendor/composer/../predis/predis/src/Command/ZSetReverseRangeByScore.php): Failed to open stream: No such file or directory at /home/ploi/preview.website.com/vendor/composer/ClassLoader.php:571)
[stacktrace]
#0 /home/ploi/preview.website.com/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/HandleExceptions.php(257): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError()
#1 /home/ploi/preview.website.com/vendor/composer/ClassLoader.php(571): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->Illuminate\\Foundation\\Bootstrap\\{closure}()
#2 /home/ploi/preview.website.com/vendor/composer/ClassLoader.php(571): include('...')
#3 /home/ploi/preview.website.com/vendor/composer/ClassLoader.php(428): Composer\\Autoload\\includeFile()
#4 /home/ploi/preview.website.com/vendor/predis/predis/src/Profile/RedisProfile.php(92): Composer\\Autoload\\ClassLoader->loadClass()
#5 /home/ploi/preview.website.com/vendor/predis/predis/src/Client.php(323): Predis\\Profile\\RedisProfile->createCommand()
#6 /home/ploi/preview.website.com/vendor/predis/predis/src/Client.php(314): Predis\\Client->createCommand()
#7 /home/ploi/preview.website.com/vendor/laravel/framework/src/Illuminate/Redis/Connections/Connection.php(116): Predis\\Client->__call()
#8 /home/ploi/preview.website.com/vendor/laravel/framework/src/Illuminate/Redis/Connections/Connection.php(216): Illuminate\\Redis\\Connections\\Connection->command()
#9 /home/ploi/preview.website.com/vendor/laravel/horizon/src/Repositories/RedisSupervisorRepository.php(39): Illuminate\\Redis\\Connections\\Connection->__call()
#10 /home/ploi/preview.website.com/vendor/laravel/horizon/src/Repositories/RedisSupervisorRepository.php(50): Laravel\\Horizon\\Repositories\\RedisSupervisorRepository->names()
#11 /home/ploi/preview.website.com/vendor/laravel/horizon/src/Repositories/RedisSupervisorRepository.php(99): Laravel\\Horizon\\Repositories\\RedisSupervisorRepository->all()
#12 /home/ploi/preview.website.com/vendor/laravel/horizon/src/MasterSupervisor.php(165): Laravel\\Horizon\\Repositories\\RedisSupervisorRepository->longestActiveTimeout()
#13 /home/ploi/preview.website.com/vendor/laravel/horizon/src/ListensForSignals.php(52): Laravel\\Horizon\\MasterSupervisor->terminate()
#14 /home/ploi/preview.website.com/vendor/laravel/horizon/src/MasterSupervisor.php(238): Laravel\\Horizon\\MasterSupervisor->processPendingSignals()
#15 /home/ploi/preview.website.com/vendor/laravel/horizon/src/MasterSupervisor.php(212): Laravel\\Horizon\\MasterSupervisor->loop()
#16 /home/ploi/preview.website.com/vendor/laravel/horizon/src/Console/HorizonCommand.php(56): Laravel\\Horizon\\MasterSupervisor->monitor()
#17 /home/ploi/preview.website.com/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Laravel\\Horizon\\Console\\HorizonCommand->handle()
#18 /home/ploi/preview.website.com/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#19 /home/ploi/preview.website.com/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
#20 /home/ploi/preview.website.com/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod()
#21 /home/ploi/preview.website.com/vendor/laravel/framework/src/Illuminate/Container/Container.php(651): Illuminate\\Container\\BoundMethod::call()
#22 /home/ploi/preview.website.com/vendor/laravel/framework/src/Illuminate/Console/Command.php(136): Illuminate\\Container\\Container->call()
#23 /home/ploi/preview.website.com/vendor/symfony/console/Command/Command.php(291): Illuminate\\Console\\Command->execute()
#24 /home/ploi/preview.website.com/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run()
#25 /home/ploi/preview.website.com/vendor/symfony/console/Application.php(1002): Illuminate\\Console\\Command->run()
#26 /home/ploi/preview.website.com/vendor/symfony/console/Application.php(299): Symfony\\Component\\Console\\Application->doRunCommand()
#27 /home/ploi/preview.website.com/vendor/symfony/console/Application.php(171): Symfony\\Component\\Console\\Application->doRun()
#28 /home/ploi/preview.website.com/vendor/laravel/framework/src/Illuminate/Console/Application.php(102): Symfony\\Component\\Console\\Application->run()
#29 /home/ploi/preview.website.com/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(129): Illuminate\\Console\\Application->run()
#30 /home/ploi/preview.website.com/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle()
#31 {main}

Environment

Environment
Application Name: Statamic
Laravel Version: 10.13.2
PHP Version: 8.2.6
Composer Version: 2.5.7
Environment: local
Debug Mode: OFF
URL: preview.website.com
Maintenance Mode: OFF

Cache
Config: NOT CACHED
Events: NOT CACHED
Routes: NOT CACHED
Views: CACHED

Drivers
Broadcasting: pusher
Cache: redis
Database: mysql
Logs: stack / single
Mail: smtp
Queue: redis
Session: file

Statamic
Addons: 0
Antlers: runtime
Stache Watcher: Enabled
Static Caching: half
Version: 4.5.0 PRO

.env

APP_NAME='L.B. Foster'
APP_ENV=local
APP_KEY=XXXXXXXXXXX
APP_DEBUG=false
APP_URL=https://preview.website.com

STATAMIC_LICENSE_KEY=XXXXXXXXXXX
STATAMIC_STACHE_WATCHER=true
STATAMIC_STATIC_CACHING_STRATEGY=half
STATAMIC_REVISIONS_ENABLED=false
STATAMIC_GRAPHQL_ENABLED=false
STATAMIC_API_ENABLED=false
STATAMIC_GIT_ENABLED=false

LOG_CHANNEL=stack

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=lbf_2022
DB_USERNAME=root
DB_PASSWORD=

BROADCAST_DRIVER=pusher
CACHE_DRIVER=redis
FILESYSTEM_DISK=local
QUEUE_CONNECTION=redis
REDIS_DATABASE=0
SESSION_DRIVER=file
SESSION_LIFETIME=120

REDIS_HOST=127.0.0.1
REDIS_PASSWORD=null
REDIS_PORT=6379

MAIL_MAILER=smtp
MAIL_HOST=smtp.mailtrap.io
MAIL_PORT=2525
MAIL_USERNAME=null
MAIL_PASSWORD=null
MAIL_ENCRYPTION=null
MAIL_FROM_ADDRESS=null
MAIL_FROM_NAME="${APP_NAME}"

PUSHER_APP_ID="1355356"
PUSHER_APP_KEY=xxx
PUSHER_APP_SECRET=xxx
PUSHER_APP_CLUSTER="us2"

AWS_ACCESS_KEY_ID=
AWS_SECRET_ACCESS_KEY=
AWS_DEFAULT_REGION=us-east-1
AWS_BUCKET=

MIX_PUSHER_APP_KEY="${PUSHER_APP_KEY}"
MIX_PUSHER_APP_CLUSTER="${PUSHER_APP_CLUSTER}"

composer require and require-dev

"require": {
        "php": "^8.1",
        "guzzlehttp/guzzle": "^7.2",
        "laravel/framework": "^10.8",
        "laravel/horizon": "^5.16",
        "laravel/sanctum": "^3.2",
        "laravel/tinker": "^2.8",
        "pusher/pusher-php-server": "^7.2",
        "statamic/cms": "^4.0",
        "statamic/collaboration": "^0.6.0"
    },
    "require-dev": {
        "barryvdh/laravel-debugbar": "^3.8.1",
        "fakerphp/faker": "^1.9.1",
        "laravel/pint": "^1.0",
        "laravel/sail": "^1.18",
        "mockery/mockery": "^1.4.4",
        "nunomaduro/collision": "^7.0",
        "phpunit/phpunit": "^10.1",
        "predis/predis": "^2.1",
        "spatie/laravel-ignition": "^2.0"
    },

[duncanmcclean]

Unsure about how to resolve the issue - does it work when you move Predis back to the 'require' section.

FYI: You've left in your Pusher keys. It's best practice to revoke them now.

[stephenmeehanuk]

Thanks, it didn't work when Predis was in the require section. I'm using Ploi, as I understand it, Predis isn't required on a server as it's possible to install PHPRedis on the server.

I'll revoke those keys too.

I'll keep hacking away!

[stephenmeehanuk]

Made a little bit of progress...

The staging site now loads.

I updated my .env to this

BROADCAST_DRIVER=log
CACHE_DRIVER=redis
FILESYSTEM_DISK=local
QUEUE_CONNECTION=redis
REDIS_DATABASE=0
SESSION_DRIVER=file
SESSION_LIFETIME=120

But, I'm seeing a new error...

[2023-06-08 09:42:46] local.ERROR: SQLSTATE[HY000] [2002] Connection refused (Connection: mysql, SQL: insert into `failed_jobs`

and this

[previous exception] [object] (PDOException(code: 2002): SQLSTATE[HY000] [2002] Connection refused at /home/ploi/preview.website.com/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:65)

Anyone know what's causing these errors?

I'm using a queue in Ploi