New Excel Export Error

[pmontanez]

Good Day,

I'm testing the new Excel report capability, but I'm getting "Bad Server Response" error message. Now I'm trying to replicate on Espo Demo site, but it hasn't been updated to 4.7.
Any Extra PHP library needed on server site for this to work?

I'm currently using Espo 4.7 Advance Pkg 1.22.0 - PHP 5.5.9

Thanks,

[pmontanez]

Here is copy of my log file:

Espo.WARNING: E_WARNING: tempnam(): open_basedir restriction in effect. File(/tmp/) is not within the allowed path(s): (/home/pathtohtml/public_html:/home/espocrm/tmp) {"code":2,"message":"t$
Espo.WARNING: E_WARNING: ZipArchive::open(): Empty string as source {"code":2,"message":"ZipArchive::open(): Empty string as source","file":"/home//public_html/crm/vendor/phpoffice/php$
Espo.WARNING: E_WARNING: ZipArchive::open(): Empty string as source {"code":2,"message":"ZipArchive::open(): Empty string as source","file":"/home//public_html/crm/vendor/phpoffice/php$
 Espo.ERROR: API [POST]:/:controller/action/:action, Params:Array (     [controller] => Report     [action] => exportList ) , InputData: {"ids":["586c79455684e5a68","586c79455d0de6249","586c794558b1955f7","586c79455$
 Espo.ERROR: Display Error: Could not open  for writing., Code: 0 URL: /crm/api/v1/Report/action/exportList [] [] 

I guess that /tmp folder is missing - Perhaps is missing on the Update file script

[pmontanez]

Good Day Guys,

Wondering if this is confirmed a Bug or something wrong on my server site. Wondering if anybody else is having the same issue?

[alasdaircr]

It's a setting on your server, but Espo should be able to handle this. Right now it just blindly expects /tmp to be writeable - I know this as I wrote the code :-/

[pmontanez]

alasdaircr thanks for above, I think is Open_basedir issue. However, I added the following line on my apache basedir.spl file without any success:

 php_admin_value open_basedir %docroot%:%home%/%user%/tmp 

Any suggestions??

by the way thanks for the important contribution !!

[yuri]

This may help: https://github.com/espocrm/espocrm/c...bce4f6cbdc9d33

[pmontanez]

Still getting a bad server response

Here is the log error

[2017-05-20 15:50:21] Espo.WARNING: E_WARNING: ZipArchive::open(): Empty string as source {"code":2,"message":"ZipArchive::open(): Empty string as source","file":"/home/*****/public_html/crm/vendor/phpoffice/php$
[2017-05-20 15:50:21] Espo.WARNING: E_WARNING: ZipArchive::open(): Empty string as source {"code":2,"message":"ZipArchive::open(): Empty string as source","file":"/home/*****/public_html/crm/vendor/phpoffice/php$
[2017-05-20 15:50:21] Espo.ERROR: API [POST]:/:controller/action/:action, Params:Array (     [controller] => Report     [action] => exportList ) , InputData: {"ids":["586c7944ba19b6ca7","586c79444a2b66e46","586c79452d4158715","586c79452$
[2017-05-20 15:50:21] Espo.ERROR: Display Error: Could not open  for writing., Code: 0 URL: /crm/api/v1/Report/action/exportList [] []
[2017-05-20 15:50:46] Espo.WARNING: E_WARNING: ZipArchive::open(): Empty string as source {"code":2,"message":"ZipArchive::open(): Empty string as source","file":"/home/****/public_html/crm/vendor/phpoffice/php$
[2017-05-20 15:50:46] Espo.WARNING: E_WARNING: ZipArchive::open(): Empty string as source {"code":2,"message":"ZipArchive::open(): Empty string as source","file":"/home/*****/public_html/crm/vendor/phpoffice/php$
[2017-05-20 15:50:46] Espo.ERROR: API [POST]:/:controller/action/:action, Params:Array (     [controller] => Report     [action] => exportList ) , InputData: {"ids":["586c7944ba19b6ca7","586c79444a2b66e46","586c79452d4158715","586c79452$
[2017-05-20 15:50:46] Espo.ERROR: Display Error: Could not open  for writing., Code: 0 URL: /crm/api/v1/Report/action/exportList [] [] 

Any ideas??

Thanks!

[pmontanez]

I cant't make this to work - Any hope for a hot fix patch? thanks guys!

[yuri]

This must solve the problem https://github.com/espocrm/espocrm/c...2ad2822ba34b51

[pmontanez]

yuri Working as Intended - Will this Update save? Thanks a Million for your help!

[yuri]

Yes. It's safe to upgrade. You're welcome.

[Robert Durov]

I had a similar issue. I solved it when I Iinstalled the Zip extension for PHP.
For ubuntu terminal command:

sudo apt-get install php-zip

[pmontanez]

Robert thanks for the Tip - I will add the library to my setup!

[olof]

We get an HTTP ERROR 500 when we try and do an Excel export? We are using NGNX.
Has anyone seen this?
Olof

[tanya]

What is in server error log?