Question: Export to Excel file

Export to Excel file

Hi, Team I have a problem when I export a report to excel file. I got a message as below. This site can’t be reachedThe webpage at http://site.com/order/admin/products/product_actions mig

JG

justin Go

Asked
Hi, Team

I have a problem when I export a report to excel file.
I got a message as below.

This site can’t be reachedThe webpage at http://site.com/order/admin/products/product_actions might be temporarily down or it may have moved permanently to a new web address.
ERR_INVALID_RESPONSE

Could you help what it is problem?

Thank you
  • MS

    Mian Saleem

    Answered
    Hello,

    If you using the latest version then please check server error logs and let me know the error details so that I can suggest solution. Otherwise you can update.

    You can enable app logs by changing the `log_threshold` to 1 in `app/config/config.php` then try to export again to re produce errors. Lastly check the latest log file in the `app/logs/` folder.

    Thank you
  • JG

    justin Go

    Answered
    Hi, Sorry for reply late.
    I have enable app logs as your instruction. Please refer as follows.

    <?php defined('BASEPATH') OR exit('No direct script access allowed'); ?>

    ERROR - 2020-06-17 16:50:48 --> Severity: Core Warning --> Module 'sqlite3' already loaded Unknown 0
    ERROR - 2020-06-17 16:50:49 --> Severity: Core Warning --> Module 'sqlite3' already loaded Unknown 0
    ERROR - 2020-06-17 16:50:55 --> Could not find the language line "34.5000"
    ERROR - 2020-06-17 16:50:55 --> Could not find the language line "1030.2300"
    ERROR - 2020-06-17 16:50:55 --> Could not find the language line "1502.1300"
    ERROR - 2020-06-17 16:50:55 --> Severity: error --> Exception: Class 'ZipArchive' not found /home/caffech1/public_html/order/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Writer/Xlsx.php 210
    ERROR - 2020-06-17 16:50:55 --> Severity: Core Warning --> Module 'sqlite3' already loaded Unknown 0
    ERROR - 2020-06-17 16:50:58 --> Severity: Core Warning --> Module 'sqlite3' already loaded Unknown 0
    ERROR - 2020-06-17 16:50:59 --> Severity: Core Warning --> Module 'sqlite3' already loaded Unknown 0
    ERROR - 2020-06-17 16:51:05 --> Severity: Core Warning --> Module 'sqlite3' already loaded Unknown 0
    ERROR - 2020-06-17 16:51:06 --> Severity: Core Warning --> Module 'sqlite3' already loaded Unknown 0
    ERROR - 2020-06-17 16:51:08 --> Severity: error --> Exception: Class 'ZipArchive' not found /home/caffech1/public_html/order/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Writer/Xlsx.php 210
    ERROR - 2020-06-17 16:51:08 --> Severity: Core Warning --> Module 'sqlite3' already loaded Unknown 0
    ERROR - 2020-06-17 16:51:08 --> Severity: error --> Exception: Class 'ZipArchive' not found /home/caffech1/public_html/order/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Writer/Xlsx.php 210
    ERROR - 2020-06-17 16:51:08 --> Severity: Core Warning --> Module 'sqlite3' already loaded Unknown 0
    ERROR - 2020-06-17 16:51:10 --> Severity: Core Warning --> Module 'sqlite3' already loaded Unknown 0
    ERROR - 2020-06-17 16:51:10 --> Severity: Core Warning --> Module 'sqlite3' already loaded Unknown 0
    ERROR - 2020-06-17 16:51:24 --> Severity: Core Warning --> Module 'sqlite3' already loaded Unknown 0
    ERROR - 2020-06-17 16:51:24 --> Severity: Core Warning --> Module 'sqlite3' already loaded Unknown 0
    ERROR - 2020-06-17 16:51:27 --> Severity: Core Warning --> Module 'sqlite3' already loaded Unknown 0
    ERROR - 2020-06-17 16:51:28 --> Severity: Core Warning --> Module 'sqlite3' already loaded Unknown 0
    ERROR - 2020-06-17 16:51:30 --> Severity: error --> Exception: Class 'ZipArchive' not found /home/caffech1/public_html/order/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Writer/Xlsx.php 210
    ERROR - 2020-06-17 16:51:30 --> Severity: Core Warning --> Module 'sqlite3' already loaded Unknown 0
    ERROR - 2020-06-17 16:51:31 --> Severity: error --> Exception: Class 'ZipArchive' not found /home/caffech1/public_html/order/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Writer/Xlsx.php 210
    ERROR - 2020-06-17 16:51:31 --> Severity: Core Warning --> Module 'sqlite3' already loaded Unknown 0
    ERROR - 2020-06-17 16:51:36 --> Severity: error --> Exception: Class 'ZipArchive' not found /home/caffech1/public_html/order/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Writer/Xlsx.php 210
    ERROR - 2020-06-17 16:51:36 --> Severity: Core Warning --> Module 'sqlite3' already loaded Unknown 0
  • MS

    Mian Saleem

    Answered
    This item is not compatible with `sqlite` Please use `MySQL` Thank you
  • JG

    justin Go

    Answered
    I'm not quite sure how to configure the setting.
    Would you able to help regarding this? or please advise me who shall I contact to get a help?

    Thank you
  • MS

    Mian Saleem

    Answered
    Hello,

    When PHP says "module already loaded" it usually means that the php.ini or auto-loaded additional .ini/.conf files contain directives to load the stated module, but you've got it listed multiple times. You can check with your server admin/host about this. You should fix the other issues first.

    PHP needs to have the zip extension installed, `apt-get install php-zip` server config issue, server admin/host should be able to help you.

    My server administration knowledge is limited. Once the above resolved, please test again and if still have issue, let me know. I am here to help.

    Thank you
  • Login to Reply