New Excel Export Error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • pmontanez
    Member
    • Dec 2016
    • 81

    New Excel Export Error

    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
    Member
    • Dec 2016
    • 81

    #2
    Here is copy of my log file:

    PHP Code:
    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

    Comment

    • pmontanez
      Member
      • Dec 2016
      • 81

      #3
      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?

      Comment

      • alasdaircr
        Active Community Member
        • Aug 2014
        • 525

        #4
        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 :-/

        Comment

        • pmontanez
          Member
          • Dec 2016
          • 81

          #5
          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 Code:
           php_admin_value open_basedir %docroot%:%home%/%user%/tmp 
          
          Any suggestions??

          by the way thanks for the important contribution !!
          Last edited by pmontanez; 05-19-2017, 02:46 AM.

          Comment

          • yuri
            Member
            • Mar 2014
            • 8440

            #6
            This may help: https://github.com/espocrm/espocrm/c...bce4f6cbdc9d33
            If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

            Comment

            • pmontanez
              Member
              • Dec 2016
              • 81

              #7
              Still getting a bad server response

              Here is the log error

              PHP Code:
              [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!

              Comment

              • pmontanez
                Member
                • Dec 2016
                • 81

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

                Comment

                • yuri
                  Member
                  • Mar 2014
                  • 8440

                  #9
                  This must solve the problem https://github.com/espocrm/espocrm/c...2ad2822ba34b51
                  If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

                  Comment

                  • pmontanez
                    Member
                    • Dec 2016
                    • 81

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

                    Comment

                    • yuri
                      Member
                      • Mar 2014
                      • 8440

                      #11
                      Yes. It's safe to upgrade. You're welcome.
                      If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

                      Comment

                      • Robert Durov
                        Junior Member
                        • Dec 2017
                        • 19

                        #12
                        I had a similar issue. I solved it when I Iinstalled the Zip extension for PHP.
                        For ubuntu terminal command:
                        Code:
                        sudo apt-get install php-zip

                        Comment

                        • pmontanez
                          Member
                          • Dec 2016
                          • 81

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

                          Comment

                          • olof
                            Senior Member
                            • Jul 2018
                            • 184

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

                            Comment

                            • tanya
                              Senior Member
                              • Jun 2014
                              • 4308

                              #15
                              What is in server error log?

                              Comment

                              Working...