Export data from Settings fails

Hello
When I want to export data from the admin Settings, it takes forever, then display the result inside the browser instead of downloading a file

I see with Chrome inspector the erreur :
export:1 Failed to load resource: the server responded with a status of 500 (Internal Server Error)

Where should I look for to solve this issue ?

On premise, Ubuntu 16, 4.5.19 release

Regards

Matthieu

Please check storage/logs/laravel-error.log for details about the error

Hello

Here are the last lines

[2020-07-09 15:18:40] production.ERROR: PhantomJS - Failed to load https://invoices.cliczone.fr/view/xxxx?phantomjs=true&phantomjs_secret=xxxx: file_exists(): open_basedir restriction in effect. File(/usr/bin/phantomjs) is not within the allowed path(s): (/var/www/virtual/cliczone.fr/:/usr/share/php/:/dev/random:/dev/urandom) {“context”:“PHP”,“user_id”:7,“account_id”:1,“user_name”:“John DOE”,“method”:“PUT”,“user_agent”:“Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.97 Safari/537.36”,“locale”:“fr”,“ip”:“xx.xx.xx.xx”,“count”:16,“is_console”:“no”,“is_api”:“no”,“db_server”:“mysql”,“url”:“invoices/3860”} []
[2020-07-10 11:29:40] production.ERROR: ErrorException [0] : /var/www/virtual/cliczone.fr/invoices/htdocs/vendor/symfony/process/PhpExecutableFinder.php [Line 65] => is_executable(): open_basedir restriction in effect. File(/usr/bin/php) is not within the allowed path(s): (/var/www/virtual/cliczone.fr/:/usr/share/php/:/dev/random:/dev/urandom) {“context”:“PHP”,“user_id”:1,“account_id”:1,“user_name”:“John DOE”,“method”:“GET”,“user_agent”:“Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/xx.xx.xx.xx Safari/537.36”,“locale”:“fr”,“ip”:“xx.xx.xx.xx”,“count”:3,“is_console”:“no”,“is_api”:“no”,“db_server”:“mysql”,“url”:“update”} []
[2020-07-10 11:44:25] production.ERROR: Symfony\Component\Debug\Exception\FatalErrorException [1] : /var/www/virtual/cliczone.fr/invoices/htdocs/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/HasAttributes.php [Line 426] => Maximum execution time of 360 seconds exceeded {“context”:“PHP”,“user_id”:1,“account_id”:1,“user_name”:“Matthieu HUTIN”,“method”:“POST”,“user_agent”:“Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/xx.xx.xx.xx Safari/537.36”,“locale”:“fr”,“ip”:“xx.xx.xx.xx”,“count”:4,“is_console”:“no”,“is_api”:“no”,“db_server”:“mysql”,“url”:“export”} []
[2020-07-10 13:10:48] production.ERROR: Symfony\Component\Debug\Exception\FatalErrorException [1] : /var/www/virtual/cliczone.fr/invoices/htdocs/vendor/laravel/framework/src/Illuminate/Cache/FileStore.php [Line 187] => Maximum execution time of 360 seconds exceeded {“context”:“PHP”,“user_id”:1,“account_id”:1,“user_name”:“John DOE”,“method”:“POST”,“user_agent”:“Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/xx.xx.xx.xx Safari/537.36”,“locale”:“fr”,“ip”:“xx.xx.xx.xx”,“count”:5,“is_console”:“no”,“is_api”:“no”,“db_server”:“mysql”,“url”:“export”} []
[2020-07-10 14:15:42] production.ERROR: Doctrine\DBAL\Driver\PDOException [2002] : /var/www/virtual/cliczone.fr/invoices/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php [Line 47] => SQLSTATE[HY000] [2002] No such file or directory {“context”:“PHP”,“user_id”:0,“account_id”:0,“user_name”:"",“method”:“GET”,“user_agent”:“Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1;)”,“locale”:“fr”,“ip”:“xx.xx.xx.xx”,“count”:1,“is_console”:“no”,“is_api”:“no”,“db_server”:“mysql”,“url”:"/"} []
[2020-07-10 14:15:42] production.ERROR: Doctrine\DBAL\Driver\PDOException [2002] : /var/www/virtual/cliczone.fr/invoices/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php [Line 47] => SQLSTATE[HY000] [2002] No such file or directory {“context”:“PHP”,“user_id”:0,“account_id”:0,“user_name”:"",“method”:“GET”,“user_agent”:“Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1;)”,“locale”:“fr”,“ip”:“xx.xx.xx.xx”,“count”:4,“is_console”:“no”,“is_api”:“no”,“db_server”:“mysql”,“url”:“setup”} []
[2020-07-10 14:24:10] production.ERROR: Symfony\Component\Debug\Exception\FatalErrorException [1] : /var/www/virtual/cliczone.fr/invoices/htdocs/vendor/nesbot/carbon/src/Carbon/Carbon.php [Line 517] => Maximum execution time of 360 seconds exceeded {“context”:“PHP”,“user_id”:1,“account_id”:1,“user_name”:“John DOE”,“method”:“POST”,“user_agent”:“Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_5) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.1.1 Safari/605.1.15”,“locale”:“fr”,“ip”:“xx.xx.xx.xx”,“count”:1,“is_console”:“no”,“is_api”:“no”,“db_server”:“mysql”,“url”:“export”} []

Thanks

Matthieu

I think this is the key part, it may help to increase the limit

Thanks
I’ve looked at all php.ini files on the server but could not found one with 360 value to raise… only 60 so i supposed it is stored somewhere else…
And maybe my vServer is soo slow i need to upgrade it because 360 is quiet long jus to export 2 years of invoices