Forums

Try to Fix backup to excel 0Bytes problem

jackky 30 Apr, 2009
Hi..
I'm using
- Joomla 1.5.9
- chronoforms Chrono Contact V3.1_RC4.11
- PHP Version 5.2.6-1+lenny2

Problem: Backup to excel delivers an empty excel-file with 0Bytes.Excel alerts: File could not be opened

I can't backup to cvs because i use tis620_thai_ci, after backup, i can't read thai language.
If I backup in Phpmyadmin to xls-file everything is correct.

After chack this problem, i think script can't work because open_basedir blocking them.
So..I tell ISP for problem.., He said open_basedir seting can't change because it's security of server.

and now, I want to know what's scripts in where files to set tmp-folder location.

thank you
jackky
GreyHead 30 Apr, 2009
Hi Jakky,

In Site Admin go to Help | System Info | Directory Permissions and right down the bottom you will see the path to the system tmp directory and it will say if it is writable or not.

Bob
jackky 30 Apr, 2009
Hi Bob

Help | System Info | Directory Permissions => All of list to be Writable now.

.
.
.
plugins/system/ Writable
plugins/user/ Writable
plugins/xmlrpc/ Writable
tmp/ Writable
templates/ Writable
Cache Directory /home/www/virtual/website.com/htdocs/cache/ Writable
Cache Directory /home/www/virtual/website.com/htdocs/administrator/cache/ Writable

and in... Help | System Info | PHP Information...
open_basedir /home/www/virtual/website.com/:/usr/share/php:/tmp
jackky 30 Apr, 2009
and
PHP Configuration
---------------------------------------------------------
PHP Core
Directive Local Value Master Value
allow_call_time_pass_reference On On
allow_url_fopen On On
allow_url_include Off Off
always_populate_raw_post_data Off Off
arg_separator.input & &
arg_separator.output & &
asp_tags Off Off
auto_append_file no value no value
auto_globals_jit On On
auto_prepend_file no value no value
browscap no value no value
default_charset no value no value
default_mimetype text/html text/html
define_syslog_variables Off Off
disable_classes no value no value
.
.
.
.
error_reporting 6135 6135
expose_php On On
extension_dir /usr/lib/php5/20060613+lfs /usr/lib/php5/20060613+lfs
file_uploads On On
.
.
html_errors On On
ignore_repeated_errors Off Off
ignore_repeated_source Off Off
ignore_user_abort Off Off
implicit_flush Off Off
include_path .:/usr/share/php:/usr/share/pear .:/usr/share/php:/usr/share/pear
log_errors Off Off
log_errors_max_len 1024 1024
magic_quotes_gpc On On
magic_quotes_runtime Off Off
magic_quotes_sybase Off Off
mail.force_extra_parameters no value no value
max_execution_time 30 30
max_input_nesting_level 64 64
max_input_time 60 60
memory_limit 64M 64M
open_basedir /home/www/virtual/ownersbiz.com/:/usr/share/php:/tmp no value <======== open_basedir
output_buffering no value no value
output_handler no value no value
post_max_size 200M 200M
precision 12 12
realpath_cache_size 16K 16K
realpath_cache_ttl 120 120
register_argc_argv On On
register_globals On On
register_long_arrays On On
report_memleaks On On
report_zend_debug On On
safe_mode Off Off
safe_mode_exec_dir no value no value
safe_mode_gid Off Off
safe_mode_include_dir no value no value
.
.
sql.safe_mode Off Off
suhosin.log.phpscript 0 0
suhosin.log.phpscript.is_safe Off Off
suhosin.log.phpscript.name no value no value
suhosin.log.sapi no value no value
suhosin.log.script no value no value
suhosin.log.script.name no value no value
suhosin.log.syslog no value no value
suhosin.log.syslog.facility no value no value
suhosin.log.syslog.priority no value no value
suhosin.log.use-x-forwarded-for Off Off
track_errors Off Off
unserialize_callback_func no value no value
upload_max_filesize 200M 200M
upload_tmp_dir no value no value
user_dir no value no value
variables_order EGPCS EGPCS
xmlrpc_error_number 0 0
xmlrpc_errors Off Off
y2k_compliance On On
zend.ze1_compatibility_mode Off Off
Max_admin 30 Apr, 2009
Hi Jackky, I suggested a fix in another post!

Cheers
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
jackky 01 May, 2009
Hi Max

Thank you, i will find your post.
This topic is locked and no more replies can be posted.