Cloudron Forum

Hello for two days, have sproblem with searching in Freescout. The searching function does not work.
In log a I see this message:

SQLSTATE[HY000]: General error: 2006 MySQL server has gone away (SQL: select * from jobswherequeue = 7c90a18cea0f6da500945eac8ff58a2c and ((reserved_atis null andavailable_at <= 1635258665) or (reserved_at<= 1635258575)) order byidasc limit 1 for update) {"exception":"[object] (Illuminate\\Database\\QueryException(code: HY000): SQLSTATE[HY000]: General error: 2006 MySQL server has gone away (SQL: select * fromjobswherequeue = 7c90a18cea0f6da500945eac8ff58a2c and ((reserved_atis null andavailable_at <= 1635258665) or (reserved_at<= 1635258575)) order byid asc limit 1 for update) at /app/code/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664, Doctrine\\DBAL\\Driver\\PDO\\Exception(code: HY000): SQLSTATE[HY000]: General error: 2006 MySQL server has gone away at /app/code/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: HY000): SQLSTATE[HY000]: General error: 2006 MySQL server has gone away at /app/code/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:115)

Where is problem ?

@nebulon Hi
here is some update.
I communicated with Freescout, there is probably more problems with FB module.
After some tries setup, they say:

We've checked what Facebook is requesting now. It seems to be almost impossible for people to get "page_messaging" permission for their apps.
We will discontinue "Facebook Integration Module".

@nebulon Hello when i check App log i found this error log:

Error sending payload: (#100)  No matching user {"exception":"[object] (BotMan\Drivers\Facebook\Exceptions\FacebookException(code: 0): Error sending payload: (#100)  No matching user at /app/data/Modules/Facebook/vendor/botman/driver-facebook/src/FacebookDriver.php:516)
[stacktrace]
#0 /app/data/Modules/Facebook/vendor/botman/driver-facebook/src/FacebookDriver.php(411): BotMan\Drivers\Facebook\FacebookDriver->throwExceptionIfResponseNotOk()
#1 /app/data/Modules/Facebook/vendor/botman/botman/src/BotMan.php(655): BotMan\Drivers\Facebook\FacebookDriver->sendPayload()
#2 [internal function]: BotMan\BotMan\BotMan->BotMan\BotMan\{closure}()
#3 /app/data/Modules/Facebook/vendor/mpociot/pipeline/src/Pipeline.php(114): call_user_func_array()
#4 [internal function]: Mpociot\Pipeline\Pipeline->Mpociot\Pipeline\{closure}()
#5 /app/data/Modules/Facebook/vendor/mpociot/pipeline/src/Pipeline.php(102): call_user_func_array()
#6 /app/data/Modules/Facebook/vendor/botman/botman/src/Middleware/MiddlewareManager.php(126): Mpociot\Pipeline\Pipeline->then()
#7 /app/data/Modules/Facebook/vendor/botman/botman/src/BotMan.php(656): BotMan\BotMan\Middleware\MiddlewareManager->applyMiddleware()
#8 /app/data/Modules/Facebook/vendor/botman/botman/src/BotMan.php(642): BotMan\BotMan\BotMan->sendPayload()
#9 /app/data/Modules/Facebook/vendor/botman/botman/src/BotMan.php(560): BotMan\BotMan\BotMan->reply()
#10 /app/data/Modules/Facebook/Providers/FacebookServiceProvider.php(154): BotMan\BotMan\BotMan->say()
#11 [internal function]: Modules\Facebook\Providers\FacebookServiceProvider->Modules\Facebook\Providers\{closure}()
#12 /app/code/overrides/TorMorten/Eventy/Action.php(27): call_user_func_array()
#13 /app/code/vendor/laravel/framework/src/Illuminate/Support/Collection.php(339): TorMorten\Eventy\Action->TorMorten\Eventy\{closure}()
#14 /app/code/overrides/TorMorten/Eventy/Action.php(28): Illuminate\Support\Collection->each()
#15 /app/code/vendor/tormjens/eventy/src/Events.php(139): TorMorten\Eventy\Action->fire()
#16 /app/code/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(221): TorMorten\Eventy\Events->action()
#17 [internal function]: Illuminate\Support\Facades\Facade::__callStatic()
#18 /app/code/app/Jobs/TriggerAction.php(42): call_user_func_array()
#19 [internal function]: App\Jobs\TriggerAction->handle()
#20 /app/code/overrides/Illuminate/Container/BoundMethod.php(29): call_user_func_array()
#21 /app/code/overrides/Illuminate/Container/BoundMethod.php(87): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#22 /app/code/overrides/Illuminate/Container/BoundMethod.php(31): Illuminate\Container\BoundMethod::callBoundMethod()
#23 /app/code/overrides/Illuminate/Container/Container.php(549): Illuminate\Container\BoundMethod::call()
#24 /app/code/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(94): Illuminate\Container\Container->call()
#25 /app/code/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(114): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()
#26 /app/code/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#27 /app/code/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(98): Illuminate\Pipeline\Pipeline->then()
#28 /app/code/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(49): Illuminate\Bus\Dispatcher->dispatchNow()
#29 /app/code/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(76): Illuminate\Queue\CallQueuedHandler->call()
#30 /app/code/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(320): Illuminate\Queue\Jobs\Job->fire()
#31 /app/code/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(270): Illuminate\Queue\Worker->process()
#32 /app/code/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(114): Illuminate\Queue\Worker->runJob()
#33 /app/code/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(101): Illuminate\Queue\Worker->daemon()
#34 /app/code/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(85): Illuminate\Queue\Console\WorkCommand->runWorker()
#35 [internal function]: Illuminate\Queue\Console\WorkCommand->handle()
#36 /app/code/overrides/Illuminate/Container/BoundMethod.php(29): call_user_func_array()
#37 /app/code/overrides/Illuminate/Container/BoundMethod.php(87): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#38 /app/code/overrides/Illuminate/Container/BoundMethod.php(31): Illuminate\Container\BoundMethod::callBoundMethod()
#39 /app/code/overrides/Illuminate/Container/Container.php(549): Illuminate\Container\BoundMethod::call()
#40 /app/code/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\Container\Container->call()
#41 /app/code/vendor/symfony/console/Command/Command.php(255): Illuminate\Console\Command->execute()
#42 /app/code/vendor/laravel/framework/src/Illuminate/Console/Command.php(170): Symfony\Component\Console\Command\Command->run()
#43 /app/code/vendor/symfony/console/Application.php(992): Illuminate\Console\Command->run()
#44 /app/code/vendor/symfony/console/Application.php(255): Symfony\Component\Console\Application->doRunCommand()
#45 /app/code/vendor/symfony/console/Application.php(148): Symfony\Component\Console\Application->doRun()
#46 /app/code/vendor/laravel/framework/src/Illuminate/Console/Application.php(88): Symfony\Component\Console\Application->run()
#47 /app/code/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(121): Illuminate\Console\Application->run()
#48 /app/code/artisan(43): Illuminate\Foundation\Console\Kernel->handle()
#49 {main}
"}

I will be happy for any advice.

Hi,
I installed facebook module and everthing worked well. I recived message from FB and i can replied from Freescout. It work really well.

But when I try sent meesage from FB with small attachement (picture), I did not recived message and conection with Freescout stop working. Now i can not recived any meesages from FB .

I check it, Log App there are no errors. When I try it with diferent FB pages...same problem.
When send message from FB to Freescout with picture .... conection stop worknig...

Any advice ?
Thank you