News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

Why does the component work fine at localhost but don't work at the combat site?

Started by borro, October 07, 2016, 16:28:15 PM

Previous topic - Next topic

borro

Hello!

I've developed the Joomla 3.x+VM3.x component(download link) with the access to it from a backend of Joomla. It works fine at localhost but not at the combat server. When I access the component via clicking "Components"->"Get the excel!" at backend I see an error message which tells that:
QuoteCann't get the access to the site
The page https://somesite.com/administrator/index.php?option=com_vmpricelist&view=download probably temporary unaccessible or connstanlty moved to anew address
ERR_INVALID_RESPONSE
I also attach the screenshot of the broken page with the info from a Network tab of Chrome developer toolbar

Please help to understand why it is so.

Thank you!
Wish you happiness!

GJC Web Design

It must be server related.. should an xml be created for download?

perhaps mimetype handling etc.. a good host will be able to help u
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

borro

Quote from: GJC Web Design on October 07, 2016, 22:30:10 PM
It must be server related.. should an xml be created for download?

perhaps mimetype handling etc.. a good host will be able to help u

Good morning! Thank you.

An excel 2007 file should be created by this component after click at "Download" button at the backend panel. To achieve this such headers are used in view.html.php file:

...
        header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header("Content-Disposition:attachment;filename='document.xlsx'");
        header('Cache-Control: max-age=0');
        $writer = PHPExcel_IOFactory::createWriter($excel, 'Excel2007');
...


I'm using the PHPExcel 1.8.0 to create excel document. As I found out if I change  'Excel2007' with  'Excel5' everything works fine. What is wrong?
Wish you happiness!

GJC Web Design

GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation