Here's the attachment.
At 03:20 PM 9/23/2002 -0700, you wrote:
Use phpinfo(); to figure out if the missing four characters are being
lost in PHP or when you're doing the INSERT or UPDATE into mysql.
Also try doing the INSERT/UPDATE via the mysql command line.
Michael
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Micah Stevens
Sent: Monday, September 23, 2002 3:00 PM
To: [email protected]
Subject: [Dbmail] Dropping characters.
I know this isn't directly related to dbmail, but the people on the
php-db
mailing list aren't being too helpful and I was wondering if anyone here
had any ideas.
I've been having an issue where php will drop the first four characters
from a POSTed form field when inserting/updating information in MySQL. I
noticed while trying to add users to the DBMail database, and I can't
figure out what's going on. At first I thought it might be my script,
but
if I do things manually with a tool like PHPMyadmin it drops the
characters
too.
I started noticing the problem last week after I upgraded to php 4.2.3.
It's always four characters, and it never happens when I have less than
four fields in a form.
I'm running RH 7.2, MySQL 3.23, and PHP 4.2.3.
Any help, or ideas of where to look for problems would be appreciated.
Thank you,
-Micah
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
Title: phpinfo()
![PHP Logo]()
PHP Version 4.2.3 |
| System |
Linux raincross-tech.com 2.4.7-10 #1 Thu Sep 6 17:27:27 EDT
2001 i686 unknown |
| Build Date |
Sep 16 2002 13:35:33 |
| Configure Command |
'./configure' '--with-apxs' '--with-openssl' '--with-zlib'
'--enable-bcmath' '--enable-calendar' '--with-jpeg-dir' '--with-tiff-dir'
'--enable-ctype' '--with-gdbm' '--with-ndbm' '--with-dom' '--enable-exif'
'--enable-ftp' '--with-gd' '--with-jpeg-dir=/usr/local'
'--with-png-dir=/usr/local/lib' '--with-ttf'
'--with-ming=/root/ming-0.1.1' '--with-mysql' '--with-pdflib'
'--with-pgsql=shared' '--enable-trans-sid' '--enable-sockets'
'--enable-sysvsem' '--enable-sysvshm' '--enable-versioning'
'--enable-inline-optimization' '--enable-memory-limit' '--enable-mbstring'
'--enable-wddx' '--enable-mbstr-enc-trans' '--enable-magic-quotes' |
| Server API |
Apache |
| Virtual Directory Support |
disabled |
| Configuration File (php.ini) Path |
/usr/local/lib/php.ini |
| Debug Build |
no |
| Thread Safety |
disabled |
![Zend logo]() This program makes use of the Zend Scripting
Language Engine:
Zend Engine v1.2.0, Copyright (c) 1998-2002 Zend
Technologies
|
Configuration
PHP Core
| Directive |
Local Value |
Master Value |
allow_call_time_pass_reference
|
On |
On |
allow_url_fopen
|
1 |
1 |
always_populate_raw_post_data
|
1 |
1 |
arg_separator.input
|
& |
& |
arg_separator.output
|
& |
& |
asp_tags
|
Off |
Off |
auto_append_file
|
no value |
no value |
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_functions
|
no value |
no value |
display_errors
|
Off |
Off |
display_startup_errors
|
On |
On |
doc_root
|
no value |
no value |
enable_dl
|
On |
On |
error_append_string
|
</b></font> |
</b></font> |
error_log
|
syslog |
syslog |
error_prepend_string
|
<font color=990000><b> |
<font color=990000><b> |
error_reporting
|
2047 |
2047 |
expose_php
|
On |
On |
extension_dir
|
/usr/lib/php4/ |
/usr/lib/php4/ |
file_uploads
|
1 |
1 |
gpc_order
|
GPC |
GPC |
highlight.bg
|
#FFFFFF |
#FFFFFF |
highlight.comment
|
#FF9900 |
#FF9900 |
highlight.default
|
#0000CC |
#0000CC |
highlight.html
|
#000000 |
#000000 |
highlight.keyword
|
#006600 |
#006600 |
highlight.string
|
#CC0000 |
#CC0000 |
html_errors
|
On |
On |
ignore_user_abort
|
Off |
Off |
implicit_flush
|
Off |
Off |
include_path
|
.:/usr/share/php/includes:/usr/share/php/PEAR/ |
.:/usr/share/php/includes:/usr/share/php/PEAR/ |
log_errors
|
On |
On |
magic_quotes_gpc
|
Off |
Off |
magic_quotes_runtime
|
Off |
Off |
magic_quotes_sybase
|
Off |
Off |
max_execution_time
|
60 |
60 |
memory_limit
|
8M |
8M |
open_basedir
|
no value |
no value |
output_buffering
|
no value |
no value |
output_handler
|
no value |
no value |
post_max_size
|
8M |
8M |
precision
|
12 |
12 |
register_argc_argv
|
On |
On |
register_globals
|
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
|
[EMAIL PROTECTED] |
[EMAIL PROTECTED] |
sendmail_path
|
/usr/sbin/sendmail -t -i |
/usr/sbin/sendmail -t -i |
short_open_tag
|
On |
On |
SMTP
|
localhost |
localhost |
sql.safe_mode
|
Off |
Off |
track_errors
|
Off |
Off |
unserialize_callback_func
|
no value |
no value |
upload_max_filesize
|
4M |
4M |
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
|
Off |
Off |
| XML Support |
active |
| XML Namespace Support |
active |
| EXPAT Version |
1.95.2 |
| WDDX Support |
enabled |
| WDDX Session Serializer |
enabled |
| Regex 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 |
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=fakeentry |
a=href,area=href,frame=src,input=src,form=fakeentry |
| Directive |
Local Value |
Master Value |
session.auto_start
|
Off |
Off |
session.cache_expire
|
180 |
180 |
session.cache_limiter
|
nocache |
nocache |
session.cookie_domain
|
no value |
no value |
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_maxlifetime
|
1440 |
1440 |
session.gc_probability
|
1 |
1 |
session.name
|
RCTSESSID |
RCTSESSID |
session.referer_check
|
no value |
no value |
session.save_handler
|
files |
files |
session.save_path
|
/tmp |
/tmp |
session.serialize_handler
|
php |
php |
session.use_cookies
|
On |
On |
session.use_trans_sid
|
1 |
1 |
| Revision |
$Revision: 1.42.2.3 $ |
| PDF Support |
enabled |
| PDFlib GmbH Version |
4.0.2 |
| Revision |
$Revision: 1.106 $ |
| PCRE (Perl Compatible Regular Expressions)
Support |
enabled |
| PCRE Library Version |
3.4 22-Aug-2000 |
| OpenSSL support |
enabled |
| OpenSSL Version |
OpenSSL 0.9.6b [engine] 9 Jul 2001 |
| MySQL Support |
enabled |
| Active Persistent Links |
2 |
| Active Links |
2 |
| Client API version |
3.23.39 |
| MYSQL_MODULE_TYPE |
builtin |
| MYSQL_SOCKET |
/var/lib/mysql/mysql.sock |
| MYSQL_INCLUDE |
|
| MYSQL_LIBS |
|
| Directive |
Local Value |
Master Value |
mysql.allow_persistent
|
On |
On |
mysql.default_host
|
localhost |
localhost |
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
|
8 |
8 |
| Ming SWF output library |
the funk in your trunk |
| Version |
0.2a |
| Multibyte (Japanese) Support |
enabled |
| http input encoding translation |
enabled |
| Directive |
Local Value |
Master Value |
mbstring.detect_order
|
no value |
no value |
mbstring.func_overload
|
0 |
0 |
mbstring.http_input
|
no value |
no value |
mbstring.http_output
|
no value |
no value |
mbstring.internal_encoding
|
no value |
no value |
mbstring.substitute_character
|
no value |
no value |
| GD Support |
enabled |
| GD Version |
1.6.2 or higher |
| JPG Support |
enabled |
| PNG Support |
enabled |
| WBMP Support |
enabled |
| EXIF Support |
enabled |
| EXIF Version |
1.2 |
| Supported EXIF Version |
0210 |
| Supported filetypes |
JPEG,TIFF |
| DOM/XML |
enabled |
| libxml Version |
2.4.19 |
| HTML Support |
enabled |
| XPath Support |
enabled |
| XPointer Support |
enabled |
| DBA support |
enabled |
| Supported handlers |
gdbm ndbm |
| ctype functions |
enabled (experimental) |
| ZLib Support |
enabled |
| 'zlib:' fopen wrapper |
enabled |
| Compiled Version |
1.1.3 |
| Linked Version |
1.1.3 |
| Directive |
Local Value |
Master Value |
zlib.output_compression
|
Off |
Off |
| APACHE_INCLUDE |
|
| APACHE_TARGET |
|
| Apache Version |
Apache/1.3.20 |
| Apache Release |
10320100 |
| Apache API Version |
19990320 |
| Hostname:Port |
raincross-tech.com:80 |
| User/Group |
apache(48)/48 |
| Max Requests |
Per Child: 1000 - Keep Alive: off - Max Per Connection:
100 |
| Timeouts |
Connection: 300 - Keep-Alive: 15 |
| Server Root |
/var/httpd |
| Loaded Modules |
mod_ssl, mod_dav, mod_php4, mod_perl, mod_setenvif, mod_so,
mod_headers, mod_expires, mod_auth_db, mod_auth_anon, mod_auth,
mod_access, mod_rewrite, mod_alias, mod_userdir, mod_actions, mod_imap,
mod_asis, mod_cgi, mod_dir, mod_autoindex, mod_include, mod_info,
mod_status, mod_negotiation, mod_mime, mod_log_referer, mod_log_agent,
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 Environment
| Variable |
Value |
| DOCUMENT_ROOT |
/home/raincross-techcom/public_html |
| HTTP_ACCEPT |
image/gif, image/x-xbitmap, image/jpeg, image/pjpeg,
application/vnd.ms-powerpoint, application/vnd.ms-excel,
application/msword, */* |
| HTTP_ACCEPT_ENCODING |
gzip, deflate |
| HTTP_ACCEPT_LANGUAGE |
en-us |
| HTTP_CONNECTION |
Keep-Alive |
| HTTP_HOST |
www.raincross-tech.com |
| HTTP_USER_AGENT |
Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0) |
| PATH |
/sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin |
| REMOTE_ADDR |
24.205.167.113 |
| REMOTE_PORT |
62877 |
| SCRIPT_FILENAME |
/home/raincross-techcom/public_html/phpinfo.php |
| SERVER_ADDR |
192.220.171.70 |
| SERVER_ADMIN |
[EMAIL PROTECTED] |
| SERVER_NAME |
raincross-tech.com |
| SERVER_PORT |
80 |
| SERVER_SIGNATURE |
|
| SERVER_SOFTWARE |
Apache |
| GATEWAY_INTERFACE |
CGI/1.1 |
| SERVER_PROTOCOL |
HTTP/1.1 |
| REQUEST_METHOD |
GET |
| QUERY_STRING |
|
| REQUEST_URI |
/phpinfo.php |
| SCRIPT_NAME |
/phpinfo.php |
HTTP Headers Information
| HTTP Request Headers |
| HTTP Request |
GET /phpinfo.php HTTP/1.1 |
| Accept |
image/gif, image/x-xbitmap, image/jpeg, image/pjpeg,
application/vnd.ms-powerpoint, application/vnd.ms-excel,
application/msword, */* |
| Accept-Encoding |
gzip, deflate |
| Accept-Language |
en-us |
| Connection |
Keep-Alive |
| Host |
www.raincross-tech.com |
| User-Agent |
Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0) |
| HTTP Response Headers |
| X-Powered-By |
PHP/4.2.3 |
| Connection |
close |
| Transfer-Encoding |
chunked |
| Content-Type |
text/html |
Additional Modules
Environment
| Variable |
Value |
| PWD |
/var/log/httpd |
| HOSTNAME |
raincross-tech.com |
| LESSOPEN |
|/usr/bin/lesspipe.sh %s |
| USER |
root |
| LS_COLORS |
no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32:*.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*.sh=01;32:*.csh=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35: |
| MACHTYPE |
i386-redhat-linux-gnu |
| MAIL |
/var/spool/mail/root |
| INPUTRC |
/etc/inputrc |
| BASH_ENV |
/root/.bashrc |
| LANG |
en_US |
| LOGNAME |
root |
| SHLVL |
2 |
| SHELL |
/bin/bash |
| USERNAME |
root |
| HOSTTYPE |
i386 |
| OSTYPE |
linux-gnu |
| HISTSIZE |
1000 |
| HOME |
/root |
| TERM |
xterm |
| PATH |
/sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin |
| SSH_TTY |
/dev/pts/3 |
| _ |
/usr/sbin/httpd |
PHP Variables
| Variable |
Value |
| PHP_SELF |
/phpinfo.php |
| _SERVER["DOCUMENT_ROOT"] |
/home/raincross-techcom/public_html |
| _SERVER["HTTP_ACCEPT"] |
image/gif, image/x-xbitmap, image/jpeg, image/pjpeg,
application/vnd.ms-powerpoint, application/vnd.ms-excel,
application/msword, */* |
| _SERVER["HTTP_ACCEPT_ENCODING"] |
gzip, deflate |
| _SERVER["HTTP_ACCEPT_LANGUAGE"] |
en-us |
| _SERVER["HTTP_CONNECTION"] |
Keep-Alive |
| _SERVER["HTTP_HOST"] |
www.raincross-tech.com |
| _SERVER["HTTP_USER_AGENT"] |
Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0) |
| _SERVER["PATH"] |
/sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin |
| _SERVER["REMOTE_ADDR"] |
24.205.167.113 |
| _SERVER["REMOTE_PORT"] |
62877 |
| _SERVER["SCRIPT_FILENAME"] |
/home/raincross-techcom/public_html/phpinfo.php |
| _SERVER["SERVER_ADDR"] |
192.220.171.70 |
| _SERVER["SERVER_ADMIN"] |
[EMAIL PROTECTED] |
| _SERVER["SERVER_NAME"] |
raincross-tech.com |
| _SERVER["SERVER_PORT"] |
80 |
| _SERVER["SERVER_SIGNATURE"] |
|
| _SERVER["SERVER_SOFTWARE"] |
Apache |
| _SERVER["GATEWAY_INTERFACE"] |
CGI/1.1 |
| _SERVER["SERVER_PROTOCOL"] |
HTTP/1.1 |
| _SERVER["REQUEST_METHOD"] |
GET |
| _SERVER["QUERY_STRING"] |
|
| _SERVER["REQUEST_URI"] |
/phpinfo.php |
| _SERVER["SCRIPT_NAME"] |
/phpinfo.php |
| _SERVER["PATH_TRANSLATED"] |
/home/raincross-techcom/public_html/phpinfo.php |
| _SERVER["PHP_SELF"] |
/phpinfo.php |
| _SERVER["argv"] |
Array
(
)
|
| _SERVER["argc"] |
0 |
| _ENV["PWD"] |
/var/log/httpd |
| _ENV["HOSTNAME"] |
raincross-tech.com |
| _ENV["LESSOPEN"] |
|/usr/bin/lesspipe.sh %s |
| _ENV["USER"] |
root |
| _ENV["LS_COLORS"] |
no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32:*.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*.sh=01;32:*.csh=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35: |
| _ENV["MACHTYPE"] |
i386-redhat-linux-gnu |
| _ENV["MAIL"] |
/var/spool/mail/root |
| _ENV["INPUTRC"] |
/etc/inputrc |
| _ENV["BASH_ENV"] |
/root/.bashrc |
| _ENV["LANG"] |
en_US |
| _ENV["LOGNAME"] |
root |
| _ENV["SHLVL"] |
2 |
| _ENV["SHELL"] |
/bin/bash |
| _ENV["USERNAME"] |
root |
| _ENV["HOSTTYPE"] |
i386 |
| _ENV["OSTYPE"] |
linux-gnu |
| _ENV["HISTSIZE"] |
1000 |
| _ENV["HOME"] |
/root |
| _ENV["TERM"] |
xterm |
| _ENV["PATH"] |
/sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin |
| _ENV["SSH_TTY"] |
/dev/pts/3 |
| _ENV["_"] |
/usr/sbin/httpd |
PHP License
|
This program is free software; you can redistribute it and/or modify it
under the terms of the PHP License as published by the PHP Group and
included in the distribution in the file: LICENSE
This program is distributed in the hope that it will be useful, but
WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
or FITNESS FOR A PARTICULAR PURPOSE.
If you did not receive a copy of the PHP license, or have any questions
about PHP licensing, please contact [EMAIL PROTECTED]
|
