freescout-help-desk / freescout

FreeScout — Free self-hosted help desk & shared mailbox (Zendesk / Help Scout alternative)
https://freescout.net
GNU Affero General Public License v3.0
2.97k stars 490 forks source link

Whoops, looks like something went wrong | freescout 1.8.48 and 1.8.49 #2536

Closed GaneshKandu closed 1 year ago

GaneshKandu commented 1 year ago

Hi,

I am getting error while install of freescout 1.8.48

Freescout didn't migrated any table in database.

database credentials are correct in .env file and database connection with same credentials working fine.

error log

storage/logs/laravel-2023-01-11.log

[2023-01-11 02:09:59] production.ERROR: No application encryption key has been specified. {"exception":"[object] (RuntimeException(code: 0): No application encryption key has been specified. at /home/soft/public_html/manual/freescout1848/vendor/laravel/framework/src/Illuminate/Encryption/EncryptionServiceProvider.php:42)
[stacktrace]
#0 {freescout path}/vendor/laravel/framework/src/Illuminate/Support/helpers.php(1038): Illuminate\\Encryption\\EncryptionServiceProvider->Illuminate\\Encryption\\{closure}(NULL)
#1 {freescout path}/vendor/laravel/framework/src/Illuminate/Encryption/EncryptionServiceProvider.php(46): tap(NULL, Object(Closure))
#2 {freescout path}/vendor/laravel/framework/src/Illuminate/Encryption/EncryptionServiceProvider.php(24): Illuminate\\Encryption\\EncryptionServiceProvider->key(Array)
#3 {freescout path}/overrides/laravel/framework/src/Illuminate/Container/Container.php(749): Illuminate\\Encryption\\EncryptionServiceProvider->Illuminate\\Encryption\\{closure}(Object(Illuminate\\Foundation\\Application), Array)
#4 {freescout path}/overrides/laravel/framework/src/Illuminate/Container/Container.php(631): Illuminate\\Container\\Container->build(Object(Closure))
#5 {freescout path}/overrides/laravel/framework/src/Illuminate/Container/Container.php(586): Illuminate\\Container\\Container->resolve('encrypter', Array)
#6 {freescout path}/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(732): Illuminate\\Container\\Container->make('encrypter', Array)
#7 {freescout path}/overrides/laravel/framework/src/Illuminate/Container/Container.php(885): Illuminate\\Foundation\\Application->make('encrypter')
#8 {freescout path}/overrides/laravel/framework/src/Illuminate/Container/Container.php(813): Illuminate\\Container\\Container->resolveClass(Object(ReflectionParameter))
#9 {freescout path}/overrides/laravel/framework/src/Illuminate/Container/Container.php(780): Illuminate\\Container\\Container->resolveDependencies(Array)
#10 {freescout path}/overrides/laravel/framework/src/Illuminate/Container/Container.php(631): Illuminate\\Container\\Container->build('App\\\\Http\\\\Middle...')
#11 {freescout path}/overrides/laravel/framework/src/Illuminate/Container/Container.php(586): Illuminate\\Container\\Container->resolve('App\\\\Http\\\\Middle...', Array)
#12 {freescout path}/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(732): Illuminate\\Container\\Container->make('App\\\\Http\\\\Middle...', Array)
#13 {freescout path}/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(138): Illuminate\\Foundation\\Application->make('App\\\\Http\\\\Middle...')
#14 {freescout path}/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#15 {freescout path}/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))
#16 {freescout path}/overrides/laravel/framework/src/Illuminate/Routing/Router.php(660): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#17 {freescout path}/overrides/laravel/framework/src/Illuminate/Routing/Router.php(635): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request))
#18 {freescout path}/overrides/laravel/framework/src/Illuminate/Routing/Router.php(601): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route))
#19 {freescout path}/overrides/laravel/framework/src/Illuminate/Routing/Router.php(590): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request))
#20 {freescout path}/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request))
#21 {freescout path}/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request))
#22 {freescout path}/app/Http/Middleware/TerminateHandler.php(12): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))
#23 {freescout path}/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): App\\Http\\Middleware\\TerminateHandler->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#24 {freescout path}/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#25 {freescout path}/app/Http/Middleware/ResponseHeaders.php(11): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))
#26 {freescout path}/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): App\\Http\\Middleware\\ResponseHeaders->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#27 {freescout path}/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#28 {freescout path}/vendor/fideloper/proxy/src/TrustProxies.php(56): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))
#29 {freescout path}/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Fideloper\\Proxy\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#30 {freescout path}/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#31 {freescout path}/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(30): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))
#32 {freescout path}/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#33 {freescout path}/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#34 {freescout path}/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(30): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))
#35 {freescout path}/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#36 {freescout path}/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#37 {freescout path}/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))
#38 {freescout path}/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#39 {freescout path}/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#40 {freescout path}/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))
#41 {freescout path}/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#42 {freescout path}/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#43 {freescout path}/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))
#44 {freescout path}/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(151): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#45 {freescout path}/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request))
#46 {freescout path}/public/index.php(83): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request))
#47 {main}
"} 
[2023-01-11 02:09:59] production.ERROR: No application encryption key has been specified. {"exception":"[object] (RuntimeException(code: 0): No application encryption key has been specified. at {freescout path}/vendor/laravel/framework/src/Illuminate/Encryption/EncryptionServiceProvider.php:42)
[stacktrace]
#0 {freescout path}/vendor/laravel/framework/src/Illuminate/Support/helpers.php(1038): Illuminate\\Encryption\\EncryptionServiceProvider->Illuminate\\Encryption\\{closure}(NULL)
#1 {freescout path}/vendor/laravel/framework/src/Illuminate/Encryption/EncryptionServiceProvider.php(46): tap(NULL, Object(Closure))
#2 {freescout path}/vendor/laravel/framework/src/Illuminate/Encryption/EncryptionServiceProvider.php(24): Illuminate\\Encryption\\EncryptionServiceProvider->key(Array)
#3 {freescout path}/overrides/laravel/framework/src/Illuminate/Container/Container.php(749): Illuminate\\Encryption\\EncryptionServiceProvider->Illuminate\\Encryption\\{closure}(Object(Illuminate\\Foundation\\Application), Array)
#4 {freescout path}/overrides/laravel/framework/src/Illuminate/Container/Container.php(631): Illuminate\\Container\\Container->build(Object(Closure))
#5 {freescout path}/overrides/laravel/framework/src/Illuminate/Container/Container.php(586): Illuminate\\Container\\Container->resolve('encrypter', Array)
#6 {freescout path}/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(732): Illuminate\\Container\\Container->make('encrypter', Array)
#7 {freescout path}/overrides/laravel/framework/src/Illuminate/Container/Container.php(885): Illuminate\\Foundation\\Application->make('encrypter')
#8 {freescout path}/overrides/laravel/framework/src/Illuminate/Container/Container.php(813): Illuminate\\Container\\Container->resolveClass(Object(ReflectionParameter))
#9 {freescout path}/overrides/laravel/framework/src/Illuminate/Container/Container.php(780): Illuminate\\Container\\Container->resolveDependencies(Array)
#10 {freescout path}/overrides/laravel/framework/src/Illuminate/Container/Container.php(631): Illuminate\\Container\\Container->build('App\\\\Http\\\\Middle...')
#11 {freescout path}/overrides/laravel/framework/src/Illuminate/Container/Container.php(586): Illuminate\\Container\\Container->resolve('App\\\\Http\\\\Middle...', Array)
#12 {freescout path}/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(732): Illuminate\\Container\\Container->make('App\\\\Http\\\\Middle...', Array)
#13 {freescout path}/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(215): Illuminate\\Foundation\\Application->make('App\\\\Http\\\\Middle...')
#14 {freescout path}/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(189): Illuminate\\Foundation\\Http\\Kernel->terminateMiddleware(Object(Illuminate\\Http\\Request), Object(Illuminate\\Http\\Response))
#15 {freescout path}/public/index.php(88): Illuminate\\Foundation\\Http\\Kernel->terminate(Object(Illuminate\\Http\\Request), Object(Illuminate\\Http\\Response))
#16 {main}
"} 
[2023-01-11 02:11:00] production.ERROR: SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected (SQL: insert into `jobs` (`queue`, `attempts`, `reserved_at`, `available_at`, `created_at`, `payload`) values (default, 0, , 1673421060, 1673421060, {"displayName":"App\\Jobs\\RestartQueueWorker","job":"Illuminate\\Queue\\CallQueuedHandler@call","maxTries":null,"timeout":null,"timeoutAt":null,"data":{"commandName":"App\\Jobs\\RestartQueueWorker","command":"O:27:\"App\\Jobs\\RestartQueueWorker\":7:{s:6:\"\u0000*\u0000job\";N;s:10:\"connection\";N;s:5:\"queue\";s:7:\"default\";s:15:\"chainConnection\";N;s:10:\"chainQueue\";N;s:5:\"delay\";N;s:7:\"chained\";a:0:{}}"}})) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 3D000): SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected (SQL: insert into `jobs` (`queue`, `attempts`, `reserved_at`, `available_at`, `created_at`, `payload`) values (default, 0, , 1673421060, 1673421060, {\"displayName\":\"App\\\\Jobs\\\\RestartQueueWorker\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"timeout\":null,\"timeoutAt\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\RestartQueueWorker\",\"command\":\"O:27:\\\"App\\\\Jobs\\\\RestartQueueWorker\\\":7:{s:6:\\\"\\u0000*\\u0000job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";s:7:\\\"default\\\";s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:5:\\\"delay\\\";N;s:7:\\\"chained\\\";a:0:{}}\"}})) at {freescout path}/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664, Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 3D000): SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected at {freescout path}/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 3D000): SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected at {freescout path}/overrides/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:82)
[stacktrace]
#0 {freescout path}/vendor/laravel/framework/src/Illuminate/Database/Connection.php(624): Illuminate\\Database\\Connection->runQueryCallback('insert into `jo...', Array, Object(Closure))
#1 {freescout path}/vendor/laravel/framework/src/Illuminate/Database/Connection.php(459): Illuminate\\Database\\Connection->run('insert into `jo...', Array, Object(Closure))
#2 {freescout path}/vendor/laravel/framework/src/Illuminate/Database/Connection.php(411): Illuminate\\Database\\Connection->statement('insert into `jo...', Array)
#3 {freescout path}/vendor/laravel/framework/src/Illuminate/Database/Query/Processors/Processor.php(32): Illuminate\\Database\\Connection->insert('insert into `jo...', Array)
#4 {freescout path}/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2159): Illuminate\\Database\\Query\\Processors\\Processor->processInsertGetId(Object(Illuminate\\Database\\Query\\Builder), 'insert into `jo...', Array, NULL)
#5 {freescout path}/vendor/laravel/framework/src/Illuminate/Queue/DatabaseQueue.php(158): Illuminate\\Database\\Query\\Builder->insertGetId(Array)
#6 {freescout path}/vendor/laravel/framework/src/Illuminate/Queue/DatabaseQueue.php(82): Illuminate\\Queue\\DatabaseQueue->pushToDatabase('default', '{\"displayName\":...')
#7 {freescout path}/vendor/laravel/framework/src/Illuminate/Queue/Queue.php(44): Illuminate\\Queue\\DatabaseQueue->push(Object(App\\Jobs\\RestartQueueWorker), '', 'default')
#8 {freescout path}/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(177): Illuminate\\Queue\\Queue->pushOn('default', Object(App\\Jobs\\RestartQueueWorker))
#9 {freescout path}/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(160): Illuminate\\Bus\\Dispatcher->pushCommandToQueue(Object(Illuminate\\Queue\\DatabaseQueue), Object(App\\Jobs\\RestartQueueWorker))
#10 {freescout path}/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(73): Illuminate\\Bus\\Dispatcher->dispatchToQueue(Object(App\\Jobs\\RestartQueueWorker))
#11 {freescout path}/vendor/laravel/framework/src/Illuminate/Foundation/Bus/PendingDispatch.php(112): Illuminate\\Bus\\Dispatcher->dispatch(Object(App\\Jobs\\RestartQueueWorker))
#12 {freescout path}/app/Console/Commands/ClearCache.php(57): Illuminate\\Foundation\\Bus\\PendingDispatch->__destruct()
#13 [internal function]: App\\Console\\Commands\\ClearCache->handle()
#14 {freescout path}/overrides/laravel/framework/src/Illuminate/Container/BoundMethod.php(29): call_user_func_array(Array, Array)
#15 {freescout path}/overrides/laravel/framework/src/Illuminate/Container/BoundMethod.php(87): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#16 {freescout path}/overrides/laravel/framework/src/Illuminate/Container/BoundMethod.php(31): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))
#17 {freescout path}/overrides/laravel/framework/src/Illuminate/Container/Container.php(549): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)
#18 {freescout path}/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\\Container\\Container->call(Array)
#19 {freescout path}/vendor/symfony/console/Command/Command.php(255): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArrayInput), Object(Illuminate\\Console\\OutputStyle))
#20 {freescout path}/vendor/laravel/framework/src/Illuminate/Console/Command.php(170): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArrayInput), Object(Illuminate\\Console\\OutputStyle))
#21 {freescout path}/vendor/symfony/console/Application.php(992): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArrayInput), Object(Symfony\\Component\\Console\\Output\\BufferedOutput))
#22 {freescout path}/vendor/symfony/console/Application.php(255): Symfony\\Component\\Console\\Application->doRunCommand(Object(App\\Console\\Commands\\ClearCache), Object(Symfony\\Component\\Console\\Input\\ArrayInput), Object(Symfony\\Component\\Console\\Output\\BufferedOutput))
#23 {freescout path}/vendor/symfony/console/Application.php(148): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArrayInput), Object(Symfony\\Component\\Console\\Output\\BufferedOutput))
#24 {freescout path}/vendor/laravel/framework/src/Illuminate/Console/Application.php(88): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArrayInput), Object(Symfony\\Component\\Console\\Output\\BufferedOutput))
#25 {freescout path}/vendor/laravel/framework/src/Illuminate/Console/Application.php(177): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArrayInput), Object(Symfony\\Component\\Console\\Output\\BufferedOutput))
#26 {freescout path}/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(249): Illuminate\\Console\\Application->call('freescout:clear...', Object(Illuminate\\Support\\Collection), NULL)
#27 {freescout path}/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(221): Illuminate\\Foundation\\Console\\Kernel->call('freescout:clear...', Array)
#28 {freescout path}/overrides/rachidlaasri/laravel-installer/src/Helpers/EnvironmentManager.php(158): Illuminate\\Support\\Facades\\Facade::__callStatic('call', Array)
#29 {freescout path}/overrides/rachidlaasri/laravel-installer/src/Controllers/EnvironmentController.php(151): RachidLaasri\\LaravelInstaller\\Helpers\\EnvironmentManager->saveFileWizard(Object(Illuminate\\Http\\Request))
#30 [internal function]: RachidLaasri\\LaravelInstaller\\Controllers\\EnvironmentController->saveWizard(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Redirector))
#31 {freescout path}/overrides/laravel/framework/src/Illuminate/Routing/Controller.php(54): call_user_func_array(Array, Array)
#32 {freescout path}/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction('saveWizard', Array)
#33 {freescout path}/vendor/laravel/framework/src/Illuminate/Routing/Route.php(212): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(RachidLaasri\\LaravelInstaller\\Controllers\\EnvironmentController), 'saveWizard')
#34 {freescout path}/vendor/laravel/framework/src/Illuminate/Routing/Route.php(169): Illuminate\\Routing\\Route->runController()
#35 {freescout path}/overrides/laravel/framework/src/Illuminate/Routing/Router.php(658): Illuminate\\Routing\\Route->run()
#36 {freescout path}/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))
#37 {freescout path}/overrides/rachidlaasri/laravel-installer/src/Middleware/canInstall.php(52): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))
#38 {freescout path}/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): RachidLaasri\\LaravelInstaller\\Middleware\\canInstall->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#39 {freescout path}/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#40 {freescout path}/app/Http/Middleware/CustomHandle.php(22): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))
#41 {freescout path}/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): App\\Http\\Middleware\\CustomHandle->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#42 {freescout path}/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#43 {freescout path}/app/Http/Middleware/LogoutIfDeleted.php(28): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))
#44 {freescout path}/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): App\\Http\\Middleware\\LogoutIfDeleted->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#45 {freescout path}/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#46 {freescout path}/app/Http/Middleware/Localize.php(27): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))
#47 {freescout path}/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): App\\Http\\Middleware\\Localize->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#48 {freescout path}/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#49 {freescout path}/app/Http/Middleware/HttpsRedirect.php(49): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))
#50 {freescout path}/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): App\\Http\\Middleware\\HttpsRedirect->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#51 {freescout path}/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#52 {freescout path}/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))
#53 {freescout path}/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#54 {freescout path}/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#55 {freescout path}/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(67): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))
#56 {freescout path}/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#57 {freescout path}/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#58 {freescout path}/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))
#59 {freescout path}/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#60 {freescout path}/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#61 {freescout path}/app/Http/Middleware/TokenAuth.php(31): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))
#62 {freescout path}/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): App\\Http\\Middleware\\TokenAuth->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#63 {freescout path}/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#64 {freescout path}/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(63): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))
#65 {freescout path}/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#66 {freescout path}/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#67 {freescout path}/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))
#68 {freescout path}/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#69 {freescout path}/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#70 {freescout path}/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(59): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))
#71 {freescout path}/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#72 {freescout path}/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#73 {freescout path}/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))
#74 {freescout path}/overrides/laravel/framework/src/Illuminate/Routing/Router.php(660): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#75 {freescout path}/overrides/laravel/framework/src/Illuminate/Routing/Router.php(635): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request))
#76 {freescout path}/overrides/laravel/framework/src/Illuminate/Routing/Router.php(601): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route))
#77 {freescout path}/overrides/laravel/framework/src/Illuminate/Routing/Router.php(590): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request))
#78 {freescout path}/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request))
#79 {freescout path}/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request))
#80 {freescout path}/app/Http/Middleware/TerminateHandler.php(12): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))
#81 {freescout path}/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): App\\Http\\Middleware\\TerminateHandler->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#82 {freescout path}/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#83 {freescout path}/app/Http/Middleware/ResponseHeaders.php(11): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))
#84 {freescout path}/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): App\\Http\\Middleware\\ResponseHeaders->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#85 {freescout path}/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#86 {freescout path}/vendor/fideloper/proxy/src/TrustProxies.php(56): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))
#87 {freescout path}/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Fideloper\\Proxy\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#88 {freescout path}/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#89 {freescout path}/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(30): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))
#90 {freescout path}/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#91 {freescout path}/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#92 {freescout path}/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(30): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))
#93 {freescout path}/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#94 {freescout path}/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#95 {freescout path}/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))
#96 {freescout path}/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#97 {freescout path}/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#98 {freescout path}/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))
#99 {freescout path}/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#100 {freescout path}/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#101 {freescout path}/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))
#102 {freescout path}/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(151): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#103 {freescout path}/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request))
#104 {freescout path}/public/index.php(83): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request))
#105 {main}
"} 
freescout-helpdesk commented 1 year ago

Most likely due to https://github.com/freescout-helpdesk/freescout/wiki/Installation-Guide#-permissions-issue

arash-khajelou commented 1 year ago

Have you tried running the php artisan key:generate command to create an app key?

GaneshKandu commented 1 year ago

Have you tried running the php artisan key:generate command to create an app key?

when i am hitting url, freescout creating .env with generated APP_KEY it self

GaneshKandu commented 1 year ago

Most likely due to https://github.com/freescout-helpdesk/freescout/wiki/Installation-Guide#-permissions-issue

i am giving recursive writable permission yet i am getting this issue

arash-khajelou commented 1 year ago

Can you please share the information below:

  1. Content of your .env file.
    cat .env
  2. List of your databases
    show databases; -- if using mysql
  3. Check if mysql is running or not:
    lsof -ti:3306 #if the lsof is not installed so you can install it with your package manager.
  4. List of your directory permissions:
    ls -alh /path/to/the/freescout-project/

Providing these information would help to aim fixing the issue.

GaneshKandu commented 1 year ago

cat .env

# Every time you are making changes in .env file, in order changes to take an effect you need to run:
# php artisan freescout:clear-cache

# Application URL
APP_URL=http://domain.com/manual/freescout1848

# Use HTTP protocol and redirect to HTTPS
APP_FORCE_HTTPS=false

# Improve security
SESSION_SECURE_COOKIE=false

# Timezones: https://github.com/freescout-helpdesk/freescout/wiki/PHP-Timezones
# Comment it to use default timezone from php.ini
APP_TIMEZONE=America/New_York

# Default language
APP_LOCALE=en

# Database settings
DB_CONNECTION=mysql
DB_HOST=localhost
DB_PORT=3306
DB_DATABASE=freescout1848
DB_USERNAME=root
DB_PASSWORD="password"

# Run the following console command to generate the key: php artisan key:generate
# Otherwise application will show the following error: "Whoops, looks like something went wrong"
APP_KEY=base64:TxzesqnQyjf6HAR2SFM29dQT9PEeFgOrYvdE9OsOyZ0=

# Uncomment to see errors in your browser, don't forget to comment it back when debugging finished
#APP_DEBUG=true

show databases;

mysql>
mysql>
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| freescout1848      |
| mysql              |
| performance_schema |
+--------------------+
4 rows in set (0.00 sec)
mysql>

lsof -ti:3306

[root@server freescout1848]# lsof -ti:3306
1285
[root@server freescout1848]#

ls -alh /path/to/the/freescout-project/

[root@penel freescout1848]# ls -alh .
total 624K
drwxrwxrwx 16 soft   soft   4.0K Jan 11 03:33 .
drwxrwxrwx  3 soft   soft     84 Jan 11 03:32 ..
drwxrwxrwx 16 soft   soft   4.0K Jan 10 03:36 app
-rwxrwxrwx  1 soft   soft   2.3K Jan 10 03:36 artisan
drwxrwxrwx  3 soft   soft     34 Jan 10 03:36 bootstrap
-rwxrwxrwx  1 soft   soft    18K Jan 10 03:36 composer.json
-rwxrwxrwx  1 soft   soft   238K Jan 10 03:36 composer.lock
drwxrwxrwx  2 soft   soft   4.0K Jan 10 03:36 config
drwxrwxrwx  5 soft   soft     72 Jan 10 03:36 database
-rwxrwxrwx  1 soft   soft    186 Jan 10 03:36 .editorconfig
-rw-r--r--  1 apache apache 1003 Jan 11 03:33 .env
-rwxrwxrwx  1 soft   soft   1.5K Jan 11 03:32 .env.example
-rwxrwxrwx  1 soft   soft    163 Jan 10 03:36 .env.travis
-rwxrwxrwx  1 soft   soft    111 Jan 10 03:36 .gitattributes
-rwxrwxrwx  1 soft   soft     41 Jan 10 03:36 .gitcommit
drwxrwxrwx  3 soft   soft     79 Jan 10 03:36 .github
-rwxrwxrwx  1 soft   soft    733 Jan 10 03:36 .gitignore
-rwxrwxrwx  1 soft   soft    461 Jan 10 03:36 .htaccess
-rwxrwxrwx  1 soft   soft    34K Jan 10 03:36 LICENSE
drwxrwxrwx  2 soft   soft     22 Jan 11 03:33 Modules
drwxrwxrwx 25 soft   soft   4.0K Jan 10 03:36 overrides
-rwxrwxrwx  1 soft   soft   1.2K Jan 10 03:36 package.json
-rwxrwxrwx  1 soft   soft   1.2K Jan 10 03:36 phpunit.xml
drwxrwxrwx  8 soft   soft   4.0K Jan 10 03:36 public
-rwxrwxrwx  1 soft   soft   5.9K Jan 10 03:36 README.md
drwxrwxrwx  5 soft   soft     45 Jan 10 03:36 resources
drwxrwxrwx  2 soft   soft     60 Jan 10 03:36 routes
-rwxrwxrwx  1 soft   soft     79 Jan 10 03:36 SECURITY.md
-rwxrwxrwx  1 soft   soft    542 Jan 10 03:36 server.php
drwxrwxrwx  6 soft   soft     62 Jan 10 03:36 storage
drwxrwxrwx  3 soft   soft     68 Jan 10 03:36 tests
drwxrwxrwx  2 soft   soft     23 Jan 10 03:36 tools
-rwxrwxrwx  1 soft   soft    255 Jan 10 03:36 .travis.yml
drwxrwxrwx 46 soft   soft   4.0K Jan 10 03:36 vendor
-rwxrwxrwx  1 soft   soft    549 Jan 10 03:36 webpack.mix.js
-rwxrwxrwx  1 soft   soft   236K Jan 10 03:36 yarn.lock
[root@panel freescout1848]#
arash-khajelou commented 1 year ago

As I see you are deploying the project by the user soft and the apache user is the one who needs access to do read and write on the project. So you can do two things:

  1. Make the apache owner of the project path:
    chown -R apache:apache /path/to/the/project
  2. Or you can just add the apache user to soft group:
    usermod -aG soft apache

    This way the problem with file permissions would be fixed.

The other configurations look good.

GaneshKandu commented 1 year ago

chown -R apache:apache /path/to/the/project is not working getting same issue.

GaneshKandu commented 1 year ago

what mysql version are you using ? @arash-khajelou

arash-khajelou commented 1 year ago

I'm using version 5.7.

GaneshKandu commented 1 year ago

I'm using version 5.7.

tested install on Mysql 5.7

i got same issue, but different log error

[2023-01-11 04:40:50] production.ERROR: SQLSTATE[HY000] [1045] Access denied for user ''@'localhost' (using password: NO) {"exception":"[object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1045): SQLSTATE[HY000] [1045] Access denied for user ''@'localhost' (using password: NO) at {freescout path}/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user ''@'localhost' (using password: NO) at {freescout path}/overrides/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:38)

my database username is blank, but its in .env file.

tested old version 1.8.47 its working perfectly fine. on mysql 5.5 and 5.7

GaneshKandu commented 1 year ago

php artisan migrate also working

freescout-helpdesk commented 1 year ago

Hi,

I am getting same error while install of freescout 1.8.48, tested old version 1.8.47 its working perfectly

Whoops, looks like something went wrong

Check Manage > Logs > App Logs to find the exact error message.

GaneshKandu commented 1 year ago

This error still persist in free scout 1.8.49 via installation through browser

for some reason username from database details getting blank

freescout-helpdesk commented 1 year ago

What's your PHP version?

GaneshKandu commented 1 year ago

I tested it on PHP 7.1 PHP 7.4 and PHP 8.1

freescout-helpdesk commented 1 year ago

Try to install the latest release: https://github.com/freescout-helpdesk/freescout/releases/tag/1.8.50 It fixes potential issue which could cause installation errors.

GaneshKandu commented 1 year ago

This error still persist in freescout 1.8.50

freescout-helpdesk commented 1 year ago

Ok. It looks like we can't help here. Try to use some other hosting or find someone who can install it for you: https://github.com/freescout-helpdesk/freescout/wiki/Hire-Developer

freescout-helpdesk commented 1 year ago

The issue has been fixed in FreeScout v1.8.52

GaneshKandu commented 1 year ago

worked thanks ! @freescout-helpdesk