RE: [Dbmail] Dropping characters.

Micah Stevens Tue, 24 Sep 2002 01:32:58 +0200 (CEST)

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: dbmail@dbmail.org
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
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail

_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail

Title: phpinfo()

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

This program makes use of the Zend Scripting Language Engine:
Zend Engine v1.2.0, Copyright (c) 1998-2002 Zend Technologies

PHP 4 Credits

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

XML Support	active
XML Namespace Support	active
EXPAT Version	1.95.2

wddx

WDDX Support	enabled
WDDX Session Serializer	enabled

standard

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

sockets

Sockets Support

enabled

session

Session Support

enabled

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

posix

Revision

$Revision: 1.42.2.3 $

pdf

PDF Support	enabled
PDFlib GmbH Version	4.0.2
Revision	$Revision: 1.106 $

pcre

PCRE (Perl Compatible Regular Expressions) Support	enabled
PCRE Library Version	3.4 22-Aug-2000

openssl

OpenSSL support	enabled
OpenSSL Version	OpenSSL 0.9.6b [engine] 9 Jul 2001

mysql

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

Ming SWF output library	the funk in your trunk
Version	0.2a

mbstring

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

GD Support	enabled
GD Version	1.6.2 or higher
JPG Support	enabled
PNG Support	enabled
WBMP Support	enabled

ftp

FTP support

enabled

exif

EXIF Support	enabled
EXIF Version	1.2
Supported EXIF Version	0210
Supported filetypes	JPEG,TIFF

domxml

DOM/XML	enabled
libxml Version	2.4.19
HTML Support	enabled
XPath Support	enabled
XPointer Support	enabled

dba

DBA support	enabled
Supported handlers	gdbm ndbm

ctype

ctype functions

enabled (experimental)

calendar

Calendar support

enabled

bcmath

BCMath support

enabled

zlib

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

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

sysvshm

sysvsem

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]

PHP Version 4.2.3

Configuration

PHP Core

Apache Environment

HTTP Headers Information

Additional Modules

Environment

PHP Variables

PHP License

Reply via email to