phpMyAdmin

This Tracker item was closed automatically by the system. It was
previously set to a Pending status, and the original submitter
did not respond within 14 days (the time period specified by
the administrator of this Tracker).

Sorry, cannot reproduce with your exact table. I don't have time to
install the exact PHP version here but I suspect a problem related to your
server. Let's close this.

Again, this is an old machine being replaced soon.

CREATE TABLE IF NOT EXISTS `company_list` (
`id` int(5) NOT NULL auto_increment,
`type` int(3) NOT NULL default '0',
`name` varchar(200) NOT NULL default '',
`title_end` text NOT NULL,
`logo` int(5) NOT NULL default '0',
`external_site` set('yes','no') NOT NULL default 'yes',
`url` text NOT NULL,
` homepage` varchar(75) NOT NULL default '',
`keywords` text NOT NULL,
`description` text NOT NULL,
`templateID` int(3) NOT NULL default '0',
`contact_email` varchar(150) NOT NULL default '',
`contact_phone` varchar(15) NOT NULL default '',
`contact_addy1` varchar(200) NOT NULL default '',
`contact_addy2` varchar(200) NOT NULL default '',
`contact_city` varchar(75) NOT NULL default '',
`contact_state` varchar(20) NOT NULL default '',
`contact_postalcode` varchar(15) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Main companies table'
AUTO_INCREMENT=9 ;


PHP Logo
PHP Version 5.0.4

System Linux tyr.apigroupinc.com 2.6.15-1.1833_FC4smp #1 SMP Wed Mar 1
23:56:51 EST 2006 i686
Build Date Nov 8 2005 08:28:03
Configure Command './configure' '--build=i386-redhat-linux'
'--host=i386-redhat-linux' '--target=i386-redhat-linux-gnu'
'--program-prefix=' '--prefix=/usr' '--exec-prefix=/usr'
'--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc'
'--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib'
'--libexecdir=/usr/libexec' '--localstatedir=/var'
'--sharedstatedir=/usr/com' '--mandir=/usr/share/man'
'--infodir=/usr/share/info' '--cache-file=../config.cache'
'--with-libdir=lib' '--with-config-file-path=/etc'
'--with-config-file-scan-dir=/etc/php.d' '--disable-debug' '--with-pic'
'--disable-rpath' '--with-bz2' '--with-curl' '--with-exec-dir=/usr/bin'
'--with-freetype-dir=/usr' '--with-png-dir=/usr' '--enable-gd-native-ttf'
'--without-gdbm' '--with-gettext' '--with-gmp' '--with-iconv'
'--with-jpeg-dir=/usr' '--with-openssl' '--with-png' '--with-pspell'
'--with-expat-dir=/usr' '--with-pcre-regex=/usr' '--with-zlib'
'--with-layout=GNU' '--enable-exif' '--enable-ftp' '--enable-magic-quotes'
'--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-sysvmsg'
'--enable-track-vars' '--enable-trans-sid' '--enable-yp' '--enable-wddx'
'--with-pear=/usr/share/pear' '--with-kerberos' '--enable-ucd-snmp-hack'
'--with-unixODBC=shared,/usr' '--enable-memory-limit' '--enable-shmop'
'--enable-calendar' '--enable-dbx' '--enable-dio'
'--with-mime-magic=/etc/httpd/conf/magic' '--without-sqlite'
'--with-libxml-dir=/usr' '--with-xml' '--with-apxs2=/usr/sbin/apxs'
'--without-mysql' '--without-gd' '--without-odbc' '--disable-dom'
'--disable-dba'
Server API Apache 2.0 Handler
Virtual Directory Support disabled
Configuration File (php.ini) Path /etc/php.ini
Scan this dir for additional .ini files /etc/php.d
additional .ini files parsed /etc/php.d/gd.ini, /etc/php.d/ldap.ini,
/etc/php.d/mysql.ini, /etc/php.d/mysqli.ini, /etc/php.d/odbc.ini,
/etc/php.d/pgsql.ini
PHP API 20031224
PHP Extension 20041030
Zend Extension 220040412
Debug Build no
Thread Safety disabled
IPv6 Support enabled
Registered PHP Streams php, file, http, ftp, compress.bzip2,
compress.zlib, https, ftps
Registered Stream Socket Transports tcp, udp, unix, udg, ssl, sslv3,
sslv2, tls

Zend logo This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.0.4-dev, Copyright (c) 1998-2004 Zend Technologies

PHP Credits
Configuration
PHP Core
Directive Local Value Master Value
allow_call_time_pass_reference On On
allow_url_fopen 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 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 On On
error_append_string no value no value
error_log no value no value
error_prepend_string no value no value
error_reporting 2047 2039
expose_php On On
extension_dir /usr/lib/php/modules /usr/lib/php/modules
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 /var/www/html/www/jpgraph-2.1.1/src/ /var/www/html/www/jpgraph-2.1.1/src/
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 72000 72000
max_input_time -1 -1
memory_limit 60M 60M
open_basedir no value no value
output_buffering no value no value
output_handler no value no value
post_max_size 60M 60M
precision 14 14
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
sendmail_from jamie.lory@apigroupinc.us jamie.lory@apigroupinc.us
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 60M 60M
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
zend.ze1_compatibility_mode Off Off

apache2handler
Apache Version Apache/2.0.54 (Fedora)
Apache API Version 20020903
Server Administrator root@localhost
Hostname:Port www.apitools.net:443
User/Group apache(48)/48
Max Requests Per Child: 1000 - Keep Alive: off - Max Per Connection: 100
Timeouts Connection: 72000 - Keep-Alive: 72000
Virtual Server Yes
Server Root /etc/httpd
Loaded Modules core prefork http_core mod_so mod_access mod_auth
mod_auth_anon mod_auth_dbm mod_auth_digest util_ldap mod_auth_ldap
mod_include mod_log_config mod_env mod_mime_magic mod_cern_meta mod_expires
mod_deflate mod_headers mod_usertrack mod_setenvif mod_mime mod_dav
mod_status mod_autoindex mod_asis mod_info mod_dav_fs mod_vhost_alias
mod_negotiation mod_dir mod_imap mod_actions mod_speling mod_userdir
mod_alias mod_rewrite mod_proxy proxy_ftp proxy_http proxy_connect
mod_cache mod_suexec mod_disk_cache mod_file_cache mod_mem_cache mod_cgi
mod_auth_mysql mod_perl mod_php5 mod_python mod_ssl

Directive Local Value Master Value
engine 1 1
last_modified 0 0
xbithack 0 0

Apache Environment
Variable Value
HTTPS on
SSL_VERSION_INTERFACE mod_ssl/2.0.54
SSL_VERSION_LIBRARY OpenSSL/0.9.7f
SSL_PROTOCOL TLSv1
SSL_CIPHER DHE-RSA-AES256-SHA
SSL_CIPHER_EXPORT false
SSL_CIPHER_USEKEYSIZE 256
SSL_CIPHER_ALGKEYSIZE 256
SSL_CLIENT_VERIFY NONE
SSL_SERVER_M_VERSION 3
SSL_SERVER_M_SERIAL 3D4A38
SSL_SERVER_V_START Dec 22 14:40:08 2005 GMT
SSL_SERVER_V_END Mar 1 19:31:33 2011 GMT
SSL_SERVER_S_DN /O=www.apitools.net/OU=Domain Control
Validated/CN=www.apitools.net
SSL_SERVER_S_DN_O www.apitools.net
SSL_SERVER_S_DN_OU Domain Control Validated
SSL_SERVER_S_DN_CN www.apitools.net
SSL_SERVER_I_DN /C=US/ST=Arizona/L=Scottsdale/O=Starfield Technologies,
Inc./OU=http://www.starfieldtech.com/repository/CN=Starfield Secure
Certification Authority/emailAddress=practices@starfieldtech.com
SSL_SERVER_I_DN_C US
SSL_SERVER_I_DN_ST Arizona
SSL_SERVER_I_DN_L Scottsdale
SSL_SERVER_I_DN_O Starfield Technologies, Inc.
SSL_SERVER_I_DN_OU http://www.starfieldtech.com/repository
SSL_SERVER_I_DN_CN Starfield Secure Certification Authority
SSL_SERVER_I_DN_Email practices@starfieldtech.com
SSL_SERVER_A_KEY rsaEncryption
SSL_SERVER_A_SIG sha1WithRSAEncryption
SSL_SESSION_ID
0EC78376F1DAA71C14CD777E781915142A63833CE07E9FBCD699D97699E091AC
HTTP_HOST www.apitools.net
HTTP_USER_AGENT Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9)
Gecko/2008052906 Firefox/3.0
HTTP_ACCEPT
text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_LANGUAGE en-us
HTTP_ACCEPT_ENCODING gzip,deflate
HTTP_ACCEPT_CHARSET ISO-8859-1,utf-8;q=0.7,*;q=0.7
HTTP_KEEP_ALIVE 300
HTTP_CONNECTION keep-alive
HTTP_COOKIE user_login=ryan.coleman%40apigroupinc.us;
user_domain=apigroupinc.us; llave=d_0rEp2%3Dz%28jpFk%7E%21_VWc;
x5=Gp%7Cwhq%7C
PATH /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
SERVER_SIGNATURE <address>Apache/2.0.54 (Fedora) Server at
www.apitools.net Port 443</address>
SERVER_SOFTWARE Apache/2.0.54 (Fedora)
SERVER_NAME www.apitools.net
SERVER_ADDR 172.16.1.2
SERVER_PORT 443
REMOTE_ADDR 172.16.1.68
DOCUMENT_ROOT /var/www/html/www
SERVER_ADMIN root@localhost
SCRIPT_FILENAME /var/www/html/www/developers/ryan/info.php
REMOTE_PORT 4031
GATEWAY_INTERFACE CGI/1.1
SERVER_PROTOCOL HTTP/1.1
REQUEST_METHOD GET
QUERY_STRING no value
REQUEST_URI /developers/ryan/info.php
SCRIPT_NAME /developers/ryan/info.php

HTTP Headers Information
HTTP Request Headers
HTTP Request GET /developers/ryan/info.php HTTP/1.1
Host www.apitools.net
User-Agent Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9)
Gecko/2008052906 Firefox/3.0
Accept text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Accept-Language en-us
Accept-Encoding gzip,deflate
Accept-Charset ISO-8859-1,utf-8;q=0.7,*;q=0.7
Keep-Alive 300
Connection keep-alive
Cookie user_login=ryan.coleman%40apigroupinc.us;
user_domain=apigroupinc.us; llave=d_0rEp2%3Dz%28jpFk%7E%21_VWc;
x5=Gp%7Cwhq%7C
HTTP Response Headers
X-Powered-By PHP/5.0.4
Connection close
Transfer-Encoding chunked
Content-Type text/html; charset=UTF-8

bz2
BZip2 Support Enabled
BZip2 Version 1.0.2, 30-Dec-2001

calendar
Calendar support enabled

ctype
ctype functions enabled

curl
CURL support enabled
CURL Information libcurl/7.13.1 OpenSSL/0.9.7f zlib/1.2.2.2
libidn/0.5.15

dbx
dbx support enabled
dbx version 1.1.0
supported databases MySQL ODBC PostgreSQL Microsoft SQL Server FrontBase
Oracle 8 (oci8) Sybase-CT SQLite

Directive Local Value Master Value
dbx.colnames_case unchanged unchanged

dio
dio support enabled

exif
EXIF Support enabled
EXIF Version 1.4 $Id: exif.c,v 1.162.2.8 2005/03/17 17:20:35 iliaa Exp $
Supported EXIF Version 0220
Supported filetypes JPEG,TIFF

ftp
FTP support enabled

gd
GD Support enabled
GD Version bundled (2.0.28 compatible)
FreeType Support enabled
FreeType Linkage with freetype
FreeType Version 2.1.9
GIF Read Support enabled
GIF Create Support enabled
JPG Support enabled
PNG Support enabled
WBMP Support enabled
XBM Support enabled

gettext
GetText Support enabled

gmp
gmp support enabled

iconv
iconv support enabled
iconv implementation glibc
iconv library version 2.3.5

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

ldap
LDAP Support enabled
RCS Version $Id: ldap.c,v 1.154.2.2 2005/01/19 00:27:42 sniper Exp $
Total Links 0/unlimited
API Version 3001
Vendor Name OpenLDAP
Vendor Version 20229

libxml
libXML support active
libXML Version 2.6.20
libXML streams enabled

mime_magic
mime_magic support enabled

Directive Local Value Master Value
mime_magic.debug Off Off
mime_magic.magicfile /etc/httpd/conf/magic /etc/httpd/conf/magic

mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 4.1.20
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient

Directive Local Value Master Value
mysql.allow_persistent On On
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

mysqli
MysqlI Support enabled
Client API version 4.1.20
MYSQLI_SOCKET /var/lib/mysql/mysql.sock

Directive Local Value Master Value
mysqli.default_host no value no value
mysqli.default_port 3306 3306
mysqli.default_pw no value no value
mysqli.default_socket no value no value
mysqli.default_user no value no value
mysqli.max_links Unlimited Unlimited
mysqli.reconnect Off Off

odbc
ODBC Support enabled
Active Persistent Links 0
Active Links 0
ODBC library unixODBC
ODBC_INCLUDE -I/usr/include
ODBC_LFLAGS -L/usr/lib
ODBC_LIBS -lodbc

Directive Local Value Master Value
odbc.allow_persistent On On
odbc.check_persistent On On
odbc.default_db no value no value
odbc.default_pw no value no value
odbc.default_user no value no value
odbc.defaultbinmode return as is return as is
odbc.defaultlrl return up to 4096 bytes return up to 4096 bytes
odbc.max_links Unlimited Unlimited
odbc.max_persistent Unlimited Unlimited

openssl
OpenSSL support enabled
OpenSSL Version OpenSSL 0.9.7f 22 Mar 2005

pcre
PCRE (Perl Compatible Regular Expressions) Support enabled
PCRE Library Version 5.0 13-Sep-2004

pgsql
PostgreSQL Support enabled
PostgreSQL(libpq) Version 8.0.4
Multibyte character support enabled
SSL support enabled
Active Persistent Links 0
Active Links 0

Directive Local Value Master Value
pgsql.allow_persistent On On
pgsql.auto_reset_persistent Off Off
pgsql.ignore_notice Off Off
pgsql.log_notice Off Off
pgsql.max_links Unlimited Unlimited
pgsql.max_persistent Unlimited Unlimited

posix
Revision $Revision: 1.60.2.2 $

pspell
PSpell Support enabled

session
Session 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_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 72000 72000
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 /tmp /tmp
session.serialize_handler php php
session.use_cookies On On
session.use_only_cookies Off Off
session.use_trans_sid 1 1

shmop
shmop support enabled

SimpleXML
Simplexml support enabled
Revision $Revision: 1.139.2.4 $
Schema support enabled

sockets
Sockets Support enabled

SPL
SPL support enabled
Interfaces RecursiveIterator, SeekableIterator
Classes ArrayObject, ArrayIterator, CachingIterator,
CachingRecursiveIterator, DirectoryIterator, FilterIterator, LimitIterator,
ParentIterator, RecursiveDirectoryIterator, RecursiveIteratorIterator,
SimpleXMLIterator

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
auto_detect_line_endings 0 0
date.default_latitude 31.7667 31.7667
date.default_longitude 35.2333 35.2333
date.sunrise_zenith 90.83 90.83
date.sunset_zenith 90.83 90.83
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=fakeentry a=href,area=href,frame=src,input=src,form=fakeentry
user_agent no value no value

sysvmsg
sysvmsg support enabled
Revision $Revision: 1.16.2.3 $

tokenizer
Tokenizer Support enabled

wddx
WDDX Support enabled
WDDX Session Serializer enabled

xml
XML Support active
XML Namespace Support active
libxml2 Version 2.6.20

yp
YP Support enabled

zlib
ZLib Support enabled
Compiled Version 1.2.2.2
Linked Version 1.2.2.2

Directive Local Value Master Value
zlib.output_compression Off Off
zlib.output_compression_level -1 -1
zlib.output_handler no value no value

Additional Modules
Module Name
sysvsem
sysvshm

Environment
Variable Value
LANG C
TERM vt220
PATH /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
PWD /
SHLVL 1
_ /usr/sbin/httpd

PHP Variables
Variable Value
PHP_SELF /developers/ryan/info.php
_REQUEST["user_login"] ryan.coleman@apigroupinc.us
_REQUEST["user_domain"] apigroupinc.us
_REQUEST["llave"] d_0rEp2=z(jpFk~!_VWc
_REQUEST["x5"] Gp|whq|
_COOKIE["user_login"] ryan.coleman@apigroupinc.us
_COOKIE["user_domain"] apigroupinc.us
_COOKIE["llave"] d_0rEp2=z(jpFk~!_VWc
_COOKIE["x5"] Gp|whq|
_SERVER["HTTPS"] on
_SERVER["SSL_VERSION_INTERFACE"] mod_ssl/2.0.54
_SERVER["SSL_VERSION_LIBRARY"] OpenSSL/0.9.7f
_SERVER["SSL_PROTOCOL"] TLSv1
_SERVER["SSL_CIPHER"] DHE-RSA-AES256-SHA
_SERVER["SSL_CIPHER_EXPORT"] false
_SERVER["SSL_CIPHER_USEKEYSIZE"] 256
_SERVER["SSL_CIPHER_ALGKEYSIZE"] 256
_SERVER["SSL_CLIENT_VERIFY"] NONE
_SERVER["SSL_SERVER_M_VERSION"] 3
_SERVER["SSL_SERVER_M_SERIAL"] 3D4A38
_SERVER["SSL_SERVER_V_START"] Dec 22 14:40:08 2005 GMT
_SERVER["SSL_SERVER_V_END"] Mar 1 19:31:33 2011 GMT
_SERVER["SSL_SERVER_S_DN"] /O=www.apitools.net/OU=Domain Control
Validated/CN=www.apitools.net
_SERVER["SSL_SERVER_S_DN_O"] www.apitools.net
_SERVER["SSL_SERVER_S_DN_OU"] Domain Control Validated
_SERVER["SSL_SERVER_S_DN_CN"] www.apitools.net
_SERVER["SSL_SERVER_I_DN"] /C=US/ST=Arizona/L=Scottsdale/O=Starfield
Technologies, Inc./OU=http://www.starfieldtech.com/repository/CN=Starfield
Secure Certification Authority/emailAddress=practices@starfieldtech.com
_SERVER["SSL_SERVER_I_DN_C"] US
_SERVER["SSL_SERVER_I_DN_ST"] Arizona
_SERVER["SSL_SERVER_I_DN_L"] Scottsdale
_SERVER["SSL_SERVER_I_DN_O"] Starfield Technologies, Inc.
_SERVER["SSL_SERVER_I_DN_OU"] http://www.starfieldtech.com/repository
_SERVER["SSL_SERVER_I_DN_CN"] Starfield Secure Certification Authority
_SERVER["SSL_SERVER_I_DN_Email"] practices@starfieldtech.com
_SERVER["SSL_SERVER_A_KEY"] rsaEncryption
_SERVER["SSL_SERVER_A_SIG"] sha1WithRSAEncryption
_SERVER["SSL_SESSION_ID"] 0EC78376F1DAA71C14CD777E781915142A63833CE07E9FBCD699D97699E091AC
_SERVER["HTTP_HOST"] www.apitools.net
_SERVER["HTTP_USER_AGENT"] Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
rv:1.9) Gecko/2008052906 Firefox/3.0
_SERVER["HTTP_ACCEPT"] text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
_SERVER["HTTP_ACCEPT_LANGUAGE"] en-us
_SERVER["HTTP_ACCEPT_ENCODING"] gzip,deflate
_SERVER["HTTP_ACCEPT_CHARSET"] ISO-8859-1,utf-8;q=0.7,*;q=0.7
_SERVER["HTTP_KEEP_ALIVE"] 300
_SERVER["HTTP_CONNECTION"] keep-alive
_SERVER["HTTP_COOKIE"] user_login=ryan.coleman%40apigroupinc.us;
user_domain=apigroupinc.us; llave=d_0rEp2%3Dz%28jpFk%7E%21_VWc;
x5=Gp%7Cwhq%7C
_SERVER["PATH"] /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
_SERVER["SERVER_SIGNATURE"] <address>Apache/2.0.54 (Fedora) Server at
www.apitools.net Port 443</address>
_SERVER["SERVER_SOFTWARE"] Apache/2.0.54 (Fedora)
_SERVER["SERVER_NAME"] www.apitools.net
_SERVER["SERVER_ADDR"] 172.16.1.2
_SERVER["SERVER_PORT"] 443
_SERVER["REMOTE_ADDR"] 172.16.1.68
_SERVER["DOCUMENT_ROOT"] /var/www/html/www
_SERVER["SERVER_ADMIN"] root@localhost
_SERVER["SCRIPT_FILENAME"] /var/www/html/www/developers/ryan/info.php
_SERVER["REMOTE_PORT"] 4031
_SERVER["GATEWAY_INTERFACE"] CGI/1.1
_SERVER["SERVER_PROTOCOL"] HTTP/1.1
_SERVER["REQUEST_METHOD"] GET
_SERVER["QUERY_STRING"] no value
_SERVER["REQUEST_URI"] /developers/ryan/info.php
_SERVER["SCRIPT_NAME"] /developers/ryan/info.php
_SERVER["PHP_SELF"] /developers/ryan/info.php
_SERVER["argv"]

Array
(
)

_SERVER["argc"] 0
_ENV["LANG"] C
_ENV["TERM"] vt220
_ENV["PATH"] /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
_ENV["PWD"] /
_ENV["SHLVL"] 1
_ENV["_"] /usr/sbin/httpd

Can't reproduce your problem with MySQL 4.1.22 and extensions mysql or
mysqli (PHP 5.2.6). Please attach your table structure and give more
information about your PHP version.

MySQL 4.1.20

I've attached the error screen. In my SQL statement that I can pass from
the code -- and through the MySQL CLI -- it works if I put the space in, no
error.

Here you can see the space in the echo'd statement but in the bottom it's
gone?

--
Ryan
File Added: error_space_in_field_update.png

Which exact version number please?

Also, please show me an example of the incorrect UPDATE statement
generated.

Yeah, I forgot to mention that -- we're stuck using MySQL4 for the time
being.

A bug is still a bug, though, even if its an older version of MySQL.

With 2.11.6, I have no problem creating, inserting and updating a table
when there is a space in front of the field name, with MySQL 5.0.51.

I upgraded and it still persists so I moved this up to 2.11.6.

Follow-up -- on UPDATE and INSERT PMA fails to recognize the space and
errors that the column doesn't exist.