Forums

Backup to Excel and PHP error message

pako69 01 Jun, 2010
CSV export work great.
If i want an Excel file, I have this message in my Excel file :

<b>Warning</b>:
tempnam()
[<a href='function.tempnam'>function.tempnam</a>]:
open_basedir restriction in effect


Thank you
GreyHead 01 Jun, 2010
Hi pako69,

Your ISP has open_basedir set up and it looks as though this is stopping the ExcelWriter creating a temporary file.

Bob
pako69 01 Jun, 2010
Yes, i know, this is security mesure. Is there a way to pass through this problem ?
GreyHead 01 Jun, 2010
Hi pako69,

I'm afraid that's a question for your ISP.

Bob
pako69 15 Jun, 2010
I have asked to my isp, and he don't want to activate openbase_dir for holes security reasons...
Could you tell me where your programm call something to have this error ?

----------------
Warning: tempnam() [function.tempnam]: open_basedir restriction in effect. File() is not within the allowed path(s): (/home/:/tmp:/usr/local/etc/php5/cgi/) in /home/mydomain/domains/mydomain.fr/public_html/administrator/components/com_chronocontact/excelwriter/PPS/File.php on line 87

----------------

I have read this line 87 but i don't understand...

Thank you
pako69 15 Jun, 2010
Nearly worked...
I have made two modifications in those files :
-- File.php, line 87, replaced :
$this->_tmp_filename = tempnam($this->_tmp_dir, "OLE_PPS_File");

by
$this->_tmp_filename = tempnam("/home/domodeco/domains/domodeco.fr/public_html/tmp/", "OLE_PPS_File");


-- Root.php, line 99, replaced :
$this->_tmp_filename = tempnam($this->_tmp_dir, "OLE_PPS_Root");

by
$this->_tmp_filename = tempnam("/home/domodeco/domains/domodeco.fr/public_html/tmp/", "OLE_PPS_Root");


And now i got my excel sheet, but the last ligne is wrong, see by yourself :

挀㤀㘀㌀挀愀 ㌀ ㌀ 㐀ᔀĀ2010-06-13 - 19:42:09 㠁㠀⸀㄀㜀 ⸀㠀 ⸀㔀㐀̀Ā528䜁愀甀搀爀礀܀ĀPascale瀁最愀甀搀爀礀ᘀĀgaudrypascale@yahoo.
This topic is locked and no more replies can be posted.