Jump to content

[SOLVED] Undefined variable: formatstr in Excel reader.php


CodeJunkie88

Recommended Posts

Hi everyone,

 

I'm really stumped regarding this problem when running my php script.  On one server I don't get the error but on almost every other server I've tried it on I get an "Undefined variable: $formatsr on line 410" message.  here is the PHPinfo output from the server that doesn't give me the error message:

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

PHP Version 5.2.4

 

System Linux web2505 2.4.31 #7 Wed Aug 17 12:03:50 EDT 2005 i686

Build Date Oct 18 2007 16:12:14

Configure Command ./configure '--with-mysql=/usr/local/mysql' '--disable-debug' '--disable-posix' '--with-apache=../apache_1.3.39/' '--with-imap=../../pine4.64/imap/' '--with-gd' '--with-zlib-dir' '--enable-soap' '--enable-siteguard' '--with-mcrypt' '--enable-gd-native-ttf' '--with-jpeg-dir' '--with-png-dir' '--with-ttf' '--with-xml' '--with-dom' '--with-cal' '--with-freetype-dir' '--with-gdbm' '--with-db' '--with-dba' '--enable-wddx' '--enable-inline-optimization' '--with-gettext' '--with-curl' '--enable-dbase' '--with-db2' '--with-openssl' '--with-ndb' '--enable-mbstring'

Server API Apache

Virtual Directory Support disabled

Configuration File (php.ini) Path /usr/local/lib

Loaded Configuration File /usr/local/lib/php.ini

PHP API 20041225

PHP Extension 20060613

Zend Extension 220060519

Debug Build no

Thread Safety disabled

Zend Memory Manager enabled

IPv6 Support enabled

Registered PHP Streams php, file, data, http, ftp, compress.zlib, https, ftps

Registered Stream Socket Transports tcp, udp, unix, udg, ssl, sslv3, sslv2, tls

Registered Stream Filters string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, convert.iconv.*, zlib.*

 

This program makes use of the Zend Scripting Language Engine:

Zend Engine v2.2.0, Copyright © 1998-2007 Zend Technologies

 

 

PHP Credits

Configuration

PHP CoreDirective Local Value Master Value

allow_call_time_pass_reference On On

allow_external_includes Off Off

allow_url_fopen On On

allow_url_include On On

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

disable_functions no value no value

display_errors Off Off

display_startup_errors Off Off

doc_root no value no value

docref_ext no value no value

docref_root no value no value

enable_dl Off Off

error_append_string no value no value

error_log no value no value

error_prepend_string no value no value

error_reporting 1 1

expose_php On On

extension_dir /usr/local/lib/php/extensions/no-debug-non-zts-20060613 /usr/local/lib/php/extensions/no-debug-non-zts-20060613

file_uploads On On

global_deny_external_includes On On

highlight.bg #FFFFFF #FFFFFF

highlight.comment #FF8000 #FF8000

highlight.default #0000BB #0000BB

highlight.html #000000 #000000

highlight.keyword #007700 #007700

highlight.string #DD0000 #DD0000

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 . .

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 -1 -1

memory_limit 128M 128M

open_basedir no value no value

output_buffering 0 0

output_handler no value no value

post_max_size 250000000 250000000

precision 14 14

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 /usr/local/php/bin /usr/local/php/bin

safe_mode_gid Off Off

safe_mode_include_dir no value no value

sendmail_from no value no value

sendmail_path /usr/sbin/sendmail -t -i /usr/sbin/sendmail -t -i

serialize_precision 100 100

short_open_tag On On

SMTP localhost localhost

smtp_port 25 25

sql.safe_mode Off Off

track_errors Off Off

unserialize_callback_func no value no value

upload_max_filesize 250000000 250000000

upload_tmp_dir /localservices/phpupload /localservices/phpupload

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

 

 

apacheAPACHE_INCLUDE no value

APACHE_TARGET no value

Apache Version Apache

Apache Release 10339100

Apache API Version 19990320

Hostname:Port www.carrierzone.com:0

User/Group nobody(65534)/65534

Max Requests Per Child: 10000 - Keep Alive: on - Max Per Connection: 100

Timeouts Connection: 150 - Keep-Alive: 10

Server Root /services/apache

Loaded Modules mod_hproxy, mod_php5, mod_frontpage, mod_setenvif, mod_auth, mod_access, mod_rewrite, mod_alias, mod_speling, mod_actions, mod_imap, mod_cgi, mod_dir, mod_autoindex, mod_include, mod_negotiation, mod_mime, mod_log_config, mod_env, mod_vhost_alias, http_core

 

Directive Local Value Master Value

child_terminate 0 0

engine 1 1

last_modified 0 0

xbithack 0 0

 

 

Apache EnvironmentVariable Value

DOCUMENT_ROOT /services/webpages/m/k/mklo.net/public

GDFONTPATH /services/share/fonts

HTTP_ACCEPT text/html, application/xml;q=0.9, application/xhtml+xml, image/png, image/jpeg, image/gif, image/x-xbitmap, */*;q=0.1

HTTP_ACCEPT_CHARSET iso-8859-1, utf-8, utf-16, *;q=0.1

HTTP_ACCEPT_ENCODING deflate, gzip, x-gzip, identity, *;q=0

HTTP_ACCEPT_LANGUAGE en-US,en;q=0.9

HTTP_CONNECTION Keep-Alive

HTTP_HOST www.mklo.net

HTTP_USER_AGENT Opera/9.52 (Windows NT 6.0; U; en)

MvCONFIG_LIBRARY /services/websoftware/miva/Empresa/cgi-bin/libmivaconfig.so

PATH /usr/bin:/bin:/sbin:/usr/sbin:/usr/local/bin

REMOTE_ADDR 68.100.219.215

REMOTE_HOST ip68-100-219-215.dc.dc.cox.net

REMOTE_PORT 50193

SCRIPT_FILENAME /services/webpages/m/k/mklo.net/public/phpinfo.php

SERVER_ADDR 64.29.145.73

SERVER_ADMIN or webmaster

SERVER_DOMAIN mklo.net

SERVER_NAME www.mklo.net

SERVER_PORT 80

SERVER_SIGNATURE no value

SERVER_SOFTWARE Apache

GATEWAY_INTERFACE CGI/1.1

SERVER_PROTOCOL HTTP/1.1

REQUEST_METHOD GET

QUERY_STRING no value

REQUEST_URI /phpinfo.php

SCRIPT_NAME /phpinfo.php

 

 

HTTP Headers InformationHTTP Request Headers

HTTP Request GET /phpinfo.php HTTP/1.1

Accept text/html, application/xml;q=0.9, application/xhtml+xml, image/png, image/jpeg, image/gif, image/x-xbitmap, */*;q=0.1

Accept-Charset iso-8859-1, utf-8, utf-16, *;q=0.1

Accept-Encoding deflate, gzip, x-gzip, identity, *;q=0

Accept-Language en-US,en;q=0.9

Connection Keep-Alive

Host www.mklo.net

User-Agent Opera/9.52 (Windows NT 6.0; U; en)

HTTP Response Headers

X-Powered-By PHP/5.2.4

Keep-Alive timeout=10, max=100

Connection Keep-Alive

Transfer-Encoding chunked

Content-Type text/html

 

 

ctypectype functions enabled

 

 

curlcURL support enabled

cURL Information libcurl/7.17.0 OpenSSL/0.9.8g zlib/1.2.3

 

 

datedate/time support enabled

"Olson" Timezone Database Version 2007.6

Timezone Database internal

Default timezone America/New_York

 

Directive Local Value Master Value

date.default_latitude 31.7667 31.7667

date.default_longitude 35.2333 35.2333

date.sunrise_zenith 90.583333 90.583333

date.sunset_zenith 90.583333 90.583333

date.timezone no value no value

 

 

dbaDBA support enabled

Supported handlers gdbm cdb cdb_make db2 inifile flatfile

 

 

domDOM/XML enabled

DOM/XML API Version 20031129

libxml Version 2.6.27

HTML Support enabled

XPath Support enabled

XPointer Support enabled

Schema Support enabled

RelaxNG Support enabled

 

 

filterInput Validation and Filtering enabled

Revision $Revision: 1.52.2.39 $

 

Directive Local Value Master Value

filter.default unsafe_raw unsafe_raw

filter.default_flags no value no value

 

 

gdGD Support enabled

GD Version bundled (2.0.34 compatible)

FreeType Support enabled

FreeType Linkage with freetype

FreeType Version 2.3.5

GIF Read Support enabled

GIF Create Support enabled

JPG Support enabled

PNG Support enabled

WBMP Support enabled

XBM Support enabled

 

 

gettextGetText Support enabled

 

 

hashhash support enabled

Hashing Engines md2 md4 md5 sha1 sha256 sha384 sha512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru gost adler32 crc32 crc32b haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5

 

 

iconviconv support enabled

iconv implementation glibc

iconv library version 2.2.4

 

Directive Local Value Master Value

iconv.input_encoding ISO-8859-1 ISO-8859-1

iconv.internal_encoding ISO-8859-1 ISO-8859-1

iconv.output_encoding ISO-8859-1 ISO-8859-1

 

 

imapIMAP c-Client Version 2000

 

 

jsonjson support enabled

json version 1.2.1

 

 

libxmllibXML support active

libXML Version 2.6.27

libXML streams enabled

 

 

mbstringMultibyte Support enabled

Multibyte string engine libmbfl

Multibyte (japanese) regex support enabled

Multibyte regex (oniguruma) version 4.4.4

Multibyte regex (oniguruma) backtrack check On

 

mbstring extension makes use of "streamable kanji code filter and converter", which is distributed under the GNU Lesser General Public License version 2.1.

 

Directive Local Value Master Value

mbstring.detect_order no value no value

mbstring.encoding_translation Off Off

mbstring.func_overload 0 0

mbstring.http_input pass pass

mbstring.http_output pass pass

mbstring.internal_encoding no value no value

mbstring.language neutral neutral

mbstring.strict_detection Off Off

mbstring.substitute_character no value no value

 

 

mcryptmcrypt support enabled

Version 2.5.8

Api No 20021217

Supported ciphers cast-128 gost rijndael-128 twofish arcfour cast-256 loki97 rijndael-192 saferplus wake blowfish-compat des rijndael-256 serpent xtea blowfish enigma rc2 tripledes

Supported modes cbc cfb ctr ecb ncfb nofb ofb stream

 

Directive Local Value Master Value

mcrypt.algorithms_dir no value no value

mcrypt.modes_dir no value no value

 

 

mysqlMySQL Support enabled

Active Persistent Links 0

Active Links 0

Client API version 3.23.54

MYSQL_MODULE_TYPE external

MYSQL_SOCKET /tmp/mysql.sock

MYSQL_INCLUDE -I/usr/local/mysql/include/mysql

MYSQL_LIBS -L/usr/local/mysql/lib/mysql -lmysqlclient

 

Directive Local Value Master Value

mysql.allow_persistent Off Off

mysql.connect_timeout 60 60

mysql.default_host no value no value

mysql.default_password no value no value

mysql.default_port no value no value

mysql.default_socket no value no value

mysql.default_user no value no value

mysql.max_links Unlimited Unlimited

mysql.max_persistent Unlimited Unlimited

mysql.trace_mode Off Off

 

 

opensslOpenSSL support enabled

OpenSSL Version OpenSSL 0.9.8f 11 Oct 2007

 

 

pcrePCRE (Perl Compatible Regular Expressions) Support enabled

PCRE Library Version 7.2 2007-06-19

 

Directive Local Value Master Value

pcre.backtrack_limit 100000 100000

pcre.recursion_limit 100000 100000

 

 

PDOPDO support enabled

PDO drivers sqlite2, sqlite

 

 

pdo_sqlitePDO Driver for SQLite 3.x enabled

PECL Module version (bundled) 1.0.1 $Id: pdo_sqlite.c,v 1.10.2.6.2.2 2007/03/23 14:30:00 wez Exp $

SQLite Library 3.3.17

 

 

ReflectionReflection enabled

Version $Id: php_reflection.c,v 1.164.2.33.2.45 2007/08/20 17:01:22 sebastian Exp $

 

 

sessionSession Support enabled

Registered save handlers files user sqlite

Registered serializer handlers php php_binary wddx

 

Directive Local Value Master Value

session.auto_start Off Off

session.bug_compat_42 On On

session.bug_compat_warn On On

session.cache_expire 180 180

session.cache_limiter nocache nocache

session.cookie_domain no value no value

session.cookie_httponly Off Off

session.cookie_lifetime 0 0

session.cookie_path / /

session.cookie_secure Off Off

session.entropy_file no value no value

session.entropy_length 0 0

session.gc_divisor 100 100

session.gc_maxlifetime 1440 1440

session.gc_probability 1 1

session.hash_bits_per_character 4 4

session.hash_function 0 0

session.name PHPSESSID PHPSESSID

session.referer_check no value no value

session.save_handler files files

session.save_path /services/webdata/php_sessions /services/webdata/php_sessions

session.serialize_handler php php

session.use_cookies On On

session.use_only_cookies Off Off

session.use_trans_sid 0 0

 

 

SimpleXMLSimplexml support enabled

Revision $Revision: 1.151.2.22.2.35 $

Schema support enabled

 

 

siteguardSiteGuard Support enabled

Userlock enabled

uid 8025

ipf no

homedirprefix /services/webpages

WebServerMode enabled

 

 

soapSoap Client enabled

Soap Server enabled

 

Directive Local Value Master Value

soap.wsdl_cache 1 1

soap.wsdl_cache_dir /tmp /tmp

soap.wsdl_cache_enabled 1 1

soap.wsdl_cache_limit 5 5

soap.wsdl_cache_ttl 86400 86400

 

 

SPLSPL support enabled

Interfaces Countable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject

Classes AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, DirectoryIterator, DomainException, EmptyIterator, FilterIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RegexIterator, RuntimeException, SimpleXMLIterator, SplFileInfo, SplFileObject, SplObjectStorage, SplTempFileObject, UnderflowException, UnexpectedValueException

 

 

SQLiteSQLite support enabled

PECL Module version 2.0-dev $Id: sqlite.c,v 1.166.2.13.2.9 2007/05/19 17:58:22 iliaa Exp $

SQLite Library 2.8.17

SQLite Encoding iso8859

 

Directive Local Value Master Value

sqlite.assoc_case 0 0

 

 

standardRegex Library Bundled library enabled

Dynamic Library Support enabled

Path to sendmail /usr/sbin/sendmail -t -i

 

Directive Local Value Master Value

assert.active 1 1

assert.bail 0 0

assert.callback no value no value

assert.quiet_eval 0 0

assert.warning 1 1

auto_detect_line_endings 0 0

default_socket_timeout 60 60

safe_mode_allowed_env_vars PHP_ PHP_

safe_mode_protected_env_vars LD_LIBRARY_PATH LD_LIBRARY_PATH

url_rewriter.tags a=href,area=href,frame=src,form=,fieldset= a=href,area=href,frame=src,form=,fieldset=

user_agent no value no value

 

 

tokenizerTokenizer Support enabled

 

 

wddxWDDX Support enabled

WDDX Session Serializer enabled

 

 

xmlXML Support active

XML Namespace Support active

libxml2 Version 2.6.27

 

 

xmlreaderXMLReader enabled

 

 

xmlwriterXMLWriter enabled

 

 

zlibZLib Support enabled

Stream Wrapper support compress.zlib://

Stream Filter support zlib.inflate, zlib.deflate

Compiled Version 1.2.3

Linked Version 1.2.3

 

Directive Local Value Master Value

zlib.output_compression Off Off

zlib.output_compression_level -1 -1

zlib.output_handler no value no value

 

 

Additional ModulesModule Name

dbase

 

 

EnvironmentVariable Value

SHELL /bin/bash

SSH_CLIENT 64.29.146.10 42909 22

USER root

TWO_TASK /localservices/oracle8/network/admin/tnsnames.ora

LD_LIBRARY_PATH /localservices/oracle8/lib

LS_COLORS no value

ORACLE_SID TOR

GDFONTPATH /services/share/fonts

MAIL /var/mail/root

PATH /usr/bin:/bin:/sbin:/usr/sbin:/usr/local/bin

PWD /root

SHLVL 3

HOME /root

LS_OPTIONS -a -N --color=none -T 0

LOGNAME root

ORACLE_HOME /localservices/oracle8

_ /services/apache/bin/httpd

 

 

PHP VariablesVariable Value

PHP_SELF /phpinfo.php

_SERVER["DOCUMENT_ROOT"] /services/webpages/m/k/mklo.net/public

_SERVER["GDFONTPATH"] /services/share/fonts

_SERVER["HTTP_ACCEPT"] text/html, application/xml;q=0.9, application/xhtml+xml, image/png, image/jpeg, image/gif, image/x-xbitmap, */*;q=0.1

_SERVER["HTTP_ACCEPT_CHARSET"] iso-8859-1, utf-8, utf-16, *;q=0.1

_SERVER["HTTP_ACCEPT_ENCODING"] deflate, gzip, x-gzip, identity, *;q=0

_SERVER["HTTP_ACCEPT_LANGUAGE"] en-US,en;q=0.9

_SERVER["HTTP_CONNECTION"] Keep-Alive

_SERVER["HTTP_HOST"] www.mklo.net

_SERVER["HTTP_USER_AGENT"] Opera/9.52 (Windows NT 6.0; U; en)

_SERVER["MvCONFIG_LIBRARY"] /services/websoftware/miva/Empresa/cgi-bin/libmivaconfig.so

_SERVER["PATH"] /usr/bin:/bin:/sbin:/usr/sbin:/usr/local/bin

_SERVER["REMOTE_ADDR"] 68.100.219.215

_SERVER["REMOTE_HOST"] ip68-100-219-215.dc.dc.cox.net

_SERVER["REMOTE_PORT"] 50193

_SERVER["SCRIPT_FILENAME"] /services/webpages/m/k/mklo.net/public/phpinfo.php

_SERVER["SERVER_ADDR"] 64.29.145.73

_SERVER["SERVER_ADMIN"] or webmaster

_SERVER["SERVER_DOMAIN"] mklo.net

_SERVER["SERVER_NAME"] www.mklo.net

_SERVER["SERVER_PORT"] 80

_SERVER["SERVER_SIGNATURE"] no value

_SERVER["SERVER_SOFTWARE"] Apache

_SERVER["GATEWAY_INTERFACE"] CGI/1.1

_SERVER["SERVER_PROTOCOL"] HTTP/1.1

_SERVER["REQUEST_METHOD"] GET

_SERVER["QUERY_STRING"] no value

_SERVER["REQUEST_URI"] /phpinfo.php

_SERVER["SCRIPT_NAME"] /phpinfo.php

_SERVER["PATH_TRANSLATED"] /services/webpages/m/k/mklo.net/public/phpinfo.php

_SERVER["PHP_SELF"] /phpinfo.php

_SERVER["REQUEST_TIME"] 1220291649

_SERVER["argv"] Array

(

)

_SERVER["argc"] 0

_ENV["SHELL"] /bin/bash

_ENV["SSH_CLIENT"] 64.29.146.10 42909 22

_ENV["USER"] root

_ENV["TWO_TASK"] /localservices/oracle8/network/admin/tnsnames.ora

_ENV["LD_LIBRARY_PATH"] /localservices/oracle8/lib

_ENV["LS_COLORS"] no value

_ENV["ORACLE_SID"] TOR

_ENV["GDFONTPATH"] /services/share/fonts

_ENV["MAIL"] /var/mail/root

_ENV["PATH"] /usr/bin:/bin:/sbin:/usr/sbin:/usr/local/bin

_ENV["PWD"] /root

_ENV["SHLVL"] 3

_ENV["HOME"] /root

_ENV["LS_OPTIONS"] -a -N --color=none -T 0

_ENV["LOGNAME"] root

_ENV["ORACLE_HOME"] /localservices/oracle8

_ENV["_"] /services/apache/bin/httpd

 

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

 

Here's the PHPINFO output from the one tha's giving me a problem:

 

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

 

PHP Version 5.2.4-2ubuntu5.3

 

System Linux intra 2.6.24-19-server #1 SMP Wed Jun 18 15:18:00 UTC 2008 i686

Build Date Jul 23 2008 06:28:41

Server API Apache 2.0 Handler

Virtual Directory Support disabled

Configuration File (php.ini) Path /etc/php5/apache2

Loaded Configuration File /etc/php5/apache2/php.ini

Scan this dir for additional .ini files /etc/php5/apache2/conf.d

additional .ini files parsed /etc/php5/apache2/conf.d/mysql.ini, /etc/php5/apache2/conf.d/mysqli.ini, /etc/php5/apache2/conf.d/pdo.ini, /etc/php5/apache2/conf.d/pdo_mysql.ini

PHP API 20041225

PHP Extension 20060613

Zend Extension 220060519

Debug Build no

Thread Safety disabled

Zend Memory Manager enabled

IPv6 Support enabled

Registered PHP Streams zip, php, file, data, http, ftp, compress.bzip2, compress.zlib, https, ftps

Registered Stream Socket Transports tcp, udp, unix, udg, ssl, sslv3, sslv2, tls

Registered Stream Filters string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, convert.iconv.*, bzip2.*, zlib.*

 

This server is protected with the Suhosin Patch 0.9.6.2

Copyright © 2006 Hardened-PHP Project

 

This program makes use of the Zend Scripting Language Engine:

Zend Engine v2.2.0, Copyright © 1998-2007 Zend Technologies

 

 

PHP Credits

Configuration

PHP CoreDirective 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

disable_functions no value no value

display_errors On On

display_startup_errors Off Off

doc_root no value no value

docref_ext no value no value

docref_root no value no value

enable_dl Off Off

error_append_string no value no value

error_log no value no value

error_prepend_string no value no value

error_reporting 6135 6135

expose_php On On

extension_dir /opt/lampp/lib/php/extensions/no-debug-non-zts-20020429 /opt/lampp/lib/php/extensions/no-debug-non-zts-20020429

file_uploads On On

highlight.bg #FFFFFF #FFFFFF

highlight.comment #FF8000 #FF8000

highlight.default #0000BB #0000BB

highlight.html #000000 #000000

highlight.keyword #007700 #007700

highlight.string #DD0000 #DD0000

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 128M 128M

open_basedir no value no value

output_buffering no value no value

output_handler no value no value

post_max_size 128M 128M

precision 12 12

realpath_cache_size 16K 16K

realpath_cache_ttl 120 120

register_argc_argv On On

register_globals Off Off

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

sendmail_from no value no value

sendmail_path /usr/sbin/sendmail -t -i /usr/sbin/sendmail -t -i

serialize_precision 100 100

short_open_tag On On

SMTP localhost localhost

smtp_port 25 25

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 2M 2M

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

 

 

apache2handlerApache Version Apache/2.2.8 (Ubuntu) PHP/5.2.4-2ubuntu5.3 with Suhosin-Patch

Apache API Version 20051115

Server Administrator webmaster@localhost

Hostname:Port hop.mywebhop.org:0

User/Group www-data(33)/33

Max Requests Per Child: 0 - Keep Alive: on - Max Per Connection: 100

Timeouts Connection: 300 - Keep-Alive: 15

Virtual Server Yes

Server Root /etc/apache2

Loaded Modules core mod_log_config mod_logio prefork http_core mod_so mod_alias mod_auth_basic mod_authn_file mod_authz_default mod_authz_groupfile mod_authz_host mod_authz_user mod_autoindex mod_cgi mod_dir mod_env mod_mime mod_negotiation mod_php5 mod_setenvif mod_status

 

Directive Local Value Master Value

engine 1 1

last_modified 0 0

xbithack 0 0

 

 

Apache EnvironmentVariable Value

HTTP_USER_AGENT Opera/9.52 (Windows NT 6.0; U; en)

HTTP_HOST 70.108.254.138

HTTP_ACCEPT text/html, application/xml;q=0.9, application/xhtml+xml, image/png, image/jpeg, image/gif, image/x-xbitmap, */*;q=0.1

HTTP_ACCEPT_LANGUAGE en-US,en;q=0.9

HTTP_ACCEPT_CHARSET iso-8859-1, utf-8, utf-16, *;q=0.1

HTTP_ACCEPT_ENCODING deflate, gzip, x-gzip, identity, *;q=0

HTTP_CACHE_CONTROL no-cache

HTTP_CONNECTION Keep-Alive, TE

HTTP_TE deflate, gzip, chunked, identity, trailers

PATH /usr/local/bin:/usr/bin:/bin

SERVER_SIGNATURE <address>Apache/2.2.8 (Ubuntu) PHP/5.2.4-2ubuntu5.3 with Suhosin-Patch Server at 70.108.254.138 Port 80</address>

SERVER_SOFTWARE Apache/2.2.8 (Ubuntu) PHP/5.2.4-2ubuntu5.3 with Suhosin-Patch

SERVER_NAME 70.108.254.138

SERVER_ADDR 192.168.1.2

SERVER_PORT 80

REMOTE_ADDR 68.100.219.215

DOCUMENT_ROOT /var/www/

SERVER_ADMIN webmaster@localhost

SCRIPT_FILENAME /var/www/xampp.orig/xampp/phpinfo.php

REMOTE_PORT 53953

GATEWAY_INTERFACE CGI/1.1

SERVER_PROTOCOL HTTP/1.1

REQUEST_METHOD GET

QUERY_STRING no value

REQUEST_URI /xampp.orig/xampp/phpinfo.php

SCRIPT_NAME /xampp.orig/xampp/phpinfo.php

 

 

HTTP Headers InformationHTTP Request Headers

HTTP Request GET /xampp.orig/xampp/phpinfo.php HTTP/1.1

User-Agent Opera/9.52 (Windows NT 6.0; U; en)

Host 70.108.254.138

Accept text/html, application/xml;q=0.9, application/xhtml+xml, image/png, image/jpeg, image/gif, image/x-xbitmap, */*;q=0.1

Accept-Language en-US,en;q=0.9

Accept-Charset iso-8859-1, utf-8, utf-16, *;q=0.1

Accept-Encoding deflate, gzip, x-gzip, identity, *;q=0

Cache-Control no-cache

Connection Keep-Alive, TE

TE deflate, gzip, chunked, identity, trailers

HTTP Response Headers

X-Powered-By PHP/5.2.4-2ubuntu5.3

Keep-Alive timeout=15, max=100

Connection Keep-Alive

Transfer-Encoding chunked

Content-Type text/html

 

 

bcmathBCMath support enabled

 

 

bz2BZip2 Support Enabled

Stream Wrapper support compress.bz2://

Stream Filter support bzip2.decompress, bzip2.compress

BZip2 Version 1.0.4, 20-Dec-2006

 

 

calendarCalendar support enabled

 

 

ctypectype functions enabled

 

 

datedate/time support enabled

"Olson" Timezone Database Version 2007.6

Timezone Database internal

Default timezone America/New_York

 

Directive Local Value Master Value

date.default_latitude 31.7667 31.7667

date.default_longitude 35.2333 35.2333

date.sunrise_zenith 90.583333 90.583333

date.sunset_zenith 90.583333 90.583333

date.timezone no value no value

 

 

dbaDBA support enabled

Supported handlers cdb cdb_make db4 inifile flatfile

 

 

domDOM/XML enabled

DOM/XML API Version 20031129

libxml Version 2.6.31

HTML Support enabled

XPath Support enabled

XPointer Support enabled

Schema Support enabled

RelaxNG Support enabled

 

 

exifEXIF Support enabled

EXIF Version 1.4 $Id: exif.c,v 1.173.2.5.2.20 2007/06/10 20:12:45 iliaa Exp $

Supported EXIF Version 0220

Supported filetypes JPEG,TIFF

 

 

filterInput Validation and Filtering enabled

Revision $Revision: 1.52.2.39 $

 

Directive Local Value Master Value

filter.default unsafe_raw unsafe_raw

filter.default_flags no value no value

 

 

ftpFTP support enabled

 

 

gettextGetText Support enabled

 

 

hashhash support enabled

Hashing Engines md2 md4 md5 sha1 sha256 sha384 sha512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru gost adler32 crc32 crc32b haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5

 

 

iconviconv support enabled

iconv implementation glibc

iconv library version 2.7

 

Directive Local Value Master Value

iconv.input_encoding ISO-8859-1 ISO-8859-1

iconv.internal_encoding ISO-8859-1 ISO-8859-1

iconv.output_encoding ISO-8859-1 ISO-8859-1

 

 

jsonjson support enabled

json version 1.2.1

 

 

libxmllibXML support active

libXML Version 2.6.31

libXML streams enabled

 

 

mbstringMultibyte Support enabled

Multibyte string engine libmbfl

Multibyte (japanese) regex support enabled

Multibyte regex (oniguruma) version 4.4.4

Multibyte regex (oniguruma) backtrack check On

 

mbstring extension makes use of "streamable kanji code filter and converter", which is distributed under the GNU Lesser General Public License version 2.1.

 

Directive Local Value Master Value

mbstring.detect_order no value no value

mbstring.encoding_translation Off Off

mbstring.func_overload 0 0

mbstring.http_input pass pass

mbstring.http_output pass pass

mbstring.internal_encoding ISO-8859-1 no value

mbstring.language neutral neutral

mbstring.strict_detection Off Off

mbstring.substitute_character no value no value

 

 

mime_magicmime_magic support invalid magic file, disabled

 

Directive Local Value Master Value

mime_magic.debug Off Off

mime_magic.magicfile /usr/share/file/magic.mime /usr/share/file/magic.mime

 

 

opensslOpenSSL support enabled

OpenSSL Version OpenSSL 0.9.8g 19 Oct 2007

 

 

pcrePCRE (Perl Compatible Regular Expressions) Support enabled

PCRE Library Version 7.4 2007-09-21

 

Directive Local Value Master Value

pcre.backtrack_limit 100000 100000

pcre.recursion_limit 100000 100000

 

 

posixRevision $Revision: 1.70.2.3.2.16 $

 

 

ReflectionReflection enabled

Version $Id: php_reflection.c,v 1.164.2.33.2.45 2007/08/20 17:01:22 sebastian Exp $

 

 

sessionSession Support enabled

Registered save handlers files user

Registered serializer handlers php php_binary wddx

 

Directive Local Value Master Value

session.auto_start Off Off

session.bug_compat_42 On On

session.bug_compat_warn On On

session.cache_expire 180 180

session.cache_limiter nocache nocache

session.cookie_domain no value no value

session.cookie_httponly Off Off

session.cookie_lifetime 0 0

session.cookie_path / /

session.cookie_secure Off Off

session.entropy_file no value no value

session.entropy_length 0 0

session.gc_divisor 100 100

session.gc_maxlifetime 1440 1440

session.gc_probability 0 0

session.hash_bits_per_character 4 4

session.hash_function 0 0

session.name PHPSESSID PHPSESSID

session.referer_check no value no value

session.save_handler files files

session.save_path /var/lib/php5 /var/lib/php5

session.serialize_handler php php

session.use_cookies On On

session.use_only_cookies Off Off

session.use_trans_sid 0 0

 

 

shmopshmop support enabled

 

 

SimpleXMLSimplexml support enabled

Revision $Revision: 1.151.2.22.2.35 $

Schema support enabled

 

 

soapSoap Client enabled

Soap Server enabled

 

Directive Local Value Master Value

soap.wsdl_cache 1 1

soap.wsdl_cache_dir /tmp /tmp

soap.wsdl_cache_enabled 1 1

soap.wsdl_cache_limit 5 5

soap.wsdl_cache_ttl 86400 86400

 

 

socketsSockets Support enabled

 

 

SPLSPL support enabled

Interfaces Countable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject

Classes AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, DirectoryIterator, DomainException, EmptyIterator, FilterIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RegexIterator, RuntimeException, SimpleXMLIterator, SplFileInfo, SplFileObject, SplObjectStorage, SplTempFileObject, UnderflowException, UnexpectedValueException

 

 

standardRegex Library Bundled library enabled

Dynamic Library Support enabled

Path to sendmail /usr/sbin/sendmail -t -i

 

Directive Local Value Master Value

assert.active 1 1

assert.bail 0 0

assert.callback no value no value

assert.quiet_eval 0 0

assert.warning 1 1

auto_detect_line_endings 0 0

default_socket_timeout 60 60

safe_mode_allowed_env_vars PHP_ PHP_

safe_mode_protected_env_vars LD_LIBRARY_PATH LD_LIBRARY_PATH

url_rewriter.tags a=href,area=href,frame=src,input=src,form=,fieldset= a=href,area=href,frame=src,input=src,form=,fieldset=

user_agent no value no value

 

 

sysvmsgsysvmsg support enabled

Revision $Revision: 1.20.2.3.2.6 $

 

 

tokenizerTokenizer Support enabled

 

 

wddxWDDX Support enabled

WDDX Session Serializer enabled

 

 

xmlXML Support active

XML Namespace Support active

libxml2 Version 2.6.31

 

 

xmlreaderXMLReader enabled

 

 

xmlwriterXMLWriter enabled

 

 

zipZip enabled

Extension Version $Id: php_zip.c,v 1.1.2.38 2007/08/06 22:02:32 bjori Exp $

Zip version 2.0.0

Libzip version 0.7.1

 

 

zlibZLib Support enabled

Stream Wrapper support compress.zlib://

Stream Filter support zlib.inflate, zlib.deflate

Compiled Version 1.2.1.1

Linked Version 1.2.3.3

 

Directive Local Value Master Value

zlib.output_compression Off Off

zlib.output_compression_level -1 -1

zlib.output_handler no value no value

 

 

Additional ModulesModule Name

sysvsem

sysvshm

 

 

EnvironmentVariable Value

APACHE_PID_FILE /var/run/apache2.pid

PATH /usr/local/bin:/usr/bin:/bin

LANG C

APACHE_RUN_GROUP www-data

APACHE_RUN_USER www-data

PWD /etc/init.d

 

 

PHP VariablesVariable Value

_SERVER["HTTP_USER_AGENT"] Opera/9.52 (Windows NT 6.0; U; en)

_SERVER["HTTP_HOST"] 70.108.254.138

_SERVER["HTTP_ACCEPT"] text/html, application/xml;q=0.9, application/xhtml+xml, image/png, image/jpeg, image/gif, image/x-xbitmap, */*;q=0.1

_SERVER["HTTP_ACCEPT_LANGUAGE"] en-US,en;q=0.9

_SERVER["HTTP_ACCEPT_CHARSET"] iso-8859-1, utf-8, utf-16, *;q=0.1

_SERVER["HTTP_ACCEPT_ENCODING"] deflate, gzip, x-gzip, identity, *;q=0

_SERVER["HTTP_CACHE_CONTROL"] no-cache

_SERVER["HTTP_CONNECTION"] Keep-Alive, TE

_SERVER["HTTP_TE"] deflate, gzip, chunked, identity, trailers

_SERVER["PATH"] /usr/local/bin:/usr/bin:/bin

_SERVER["SERVER_SIGNATURE"] <address>Apache/2.2.8 (Ubuntu) PHP/5.2.4-2ubuntu5.3 with Suhosin-Patch Server at 70.108.254.138 Port 80</address>

_SERVER["SERVER_SOFTWARE"] Apache/2.2.8 (Ubuntu) PHP/5.2.4-2ubuntu5.3 with Suhosin-Patch

_SERVER["SERVER_NAME"] 70.108.254.138

_SERVER["SERVER_ADDR"] 192.168.1.2

_SERVER["SERVER_PORT"] 80

_SERVER["REMOTE_ADDR"] 68.100.219.215

_SERVER["DOCUMENT_ROOT"] /var/www/

_SERVER["SERVER_ADMIN"] webmaster@localhost

_SERVER["SCRIPT_FILENAME"] /var/www/xampp.orig/xampp/phpinfo.php

_SERVER["REMOTE_PORT"] 53953

_SERVER["GATEWAY_INTERFACE"] CGI/1.1

_SERVER["SERVER_PROTOCOL"] HTTP/1.1

_SERVER["REQUEST_METHOD"] GET

_SERVER["QUERY_STRING"] no value

_SERVER["REQUEST_URI"] /xampp.orig/xampp/phpinfo.php

_SERVER["SCRIPT_NAME"] /xampp.orig/xampp/phpinfo.php

_SERVER["PHP_SELF"] /xampp.orig/xampp/phpinfo.php

_SERVER["REQUEST_TIME"] 1220319702

_SERVER["argv"] Array

(

)

_SERVER["argc"] 0

_ENV["APACHE_PID_FILE"] /var/run/apache2.pid

_ENV["PATH"] /usr/local/bin:/usr/bin:/bin

_ENV["LANG"] C

_ENV["APACHE_RUN_GROUP"] www-data

_ENV["APACHE_RUN_USER"] www-data

_ENV["PWD"] /etc/init.d

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

 

I would really appreciate help on this.  Thanks.

Link to comment
Share on other sites

Your code is dependent on register_globals and needs to be fixed. Register_globals were turned off in php4.2 in the year 2002. No new code, new tutorials, new books, or new hosting accounts after that point in time should have relied on register_globals or should have turned them on. Register_globals have been completely removed in php6.

Link to comment
Share on other sites

Hi PFMaBiSmAd,

 

Looks like that was it.  I found an updated version of that Excel script and installed it.  Lo and behold, the error message is gone.  I guess the author fixed it so it no longer uses register_globals. I wasn't aware register_globals would be completely removed so luckily I've always thought register_globals were a messy way of passing data and I've always passed data as arguments instead of setting globals.

 

Thanks a lot for your help.

 

Terry

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.