Unable to create DB
I receive error messages in MySQL when trying to add the user registration table. First error is on email size of 500 requesting BLOB, then get error that adjacent field syntax error. changed size from 500 to varchar 100 in both cases (password) then the timestamp showed up as an X and syntax error.
First if MySql not current for this software (how do I check the version) or is it something else. I am copying the .sql and paste into the windows before "go".
phpMyAdmin - 2.11.3 is the host software I am using.
Error
SQL query:
PHP Version 4.4.4
System Linux host23.webserver1010.com 2.4.33.2 #4 SMP Wed Aug 23 10:41:21 EDT 2006 i686
Build Date May 15 2007 12:13:56
Configure Command './configure' '--prefix=/usr/local/' '--with-apxs=/etc/httpd/bin/apxs' '--disable-cgi' '--enable-versioning' '--enable-pic' '--disable-posix-threads' '--enable-
Server API Apache
Virtual Directory Support disabled
Configuration File (php.ini) Path /usr/local/Zend/etc/php.ini
PHP API 20020918
PHP Extension 20020429
Zend Extension 20050606
Debug Build no
Zend Memory Manager enabled
Thread Safety disabled
Registered PHP Streams php, http, ftp, https, ftps, compress.bzip2, compress.zlib
Configuration
PHP Core
extension_dir /usr/local/lib/php/extensions /usr/local/lib/php/extensions
file_uploads On On
gpc_order GPC GPC
html_errors On On
iinclude_path ./:/usr/local/lib/php ./:/usr/local/lib/php
memory_limit 18388608 18388608
upload_max_filesize 2097152 2097152
apache
Apache Version Apache/1.3.35 (Unix) ApacheJServ/1.1.2 PHP/4.4.4 FrontPage/5.0.2.2635 Rewrit/1.1a
Apache Release 10335100
Apache API Version 19990320
Hostname:Port beyetransformed.org:80
User/Group www(501)/503
Max Requests Per Child: 20 - Keep Alive: on - Max Per Connection: 100
Timeouts Connection: 300 - Keep-Alive: 15
Server Root /etc/httpd
Loaded Modules mod_jserv, mod_headers, mod_casp2, mod_php4, mod_rewrite, mod_frontpage, mod_setenvif, mod_imap, mod_auth, mod_access, mod_actions, mod_asis, mod_dir, mod_autoindex, mod_include, mod_status, mod_negotiation, mod_cgi, mod_mime, mod_log_config, mod_env, mod_auth_ala, mod_so, mod_proxy, mod_alias, mod_userdir, http_core
Apache Environment
Variable Value
DOCUMENT_ROOT /home/beyetran/beyetransformed-www
HTTP_ACCEPT text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_HOST beyetransformed.org
HTTP_KEEP_ALIVE 115
HTTP_USER_AGENT Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.3) Gecko/20100401 Firefox/3.6.3
PATH /usr/bin:/bin
REMOTE_ADDR 97.113.69.205
REMOTE_PORT 14352
SCRIPT_FILENAME /home/beyetran/beyetransformed-www/phpinfo.php
SERVER_ADDR 65.109.11.121
SERVER_ADMIN webmaster@beyetransformed.org
SERVER_NAME beyetransformed.org
SERVER_PORT 80
SERVER_SIGNATURE no value
SERVER_SOFTWARE Apache/1.3.35 (Unix) ApacheJServ/1.1.2 PHP/4.4.4 FrontPage/5.0.2.2635 Rewrit/1.1a
GATEWAY_INTERFACE CGI/1.1
SERVER_PROTOCOL HTTP/1.1
calendar
Calendar support enabled
ctype
ctype functions enabled
curl
CURL support enabled
CURL Information libcurl/7.12.1 OpenSSL/0.9.7e zlib/1.2.3
cybercash
Cybercash Support enabled
dba
DBA support enabled
Supported handlers gdbm cdb cdb_make inifile flatfile
domxml
DOM/XML enabled
DOM/XML API Version 20020815
libxml Version 20419
HTML Support enabled
XPath Support enabled
XPointer Support enabled
exif
EXIF Support enabled
EXIF Version 1.4 $Id: exif.c,v 1.118.2.37.2.4 2006/01/01 13:46:52 sniper 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
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
imap
IMAP c-Client Version 2001
SSL Support enabled
mbstring
Multibyte Support enabled
Japanese support enabled
Simplified chinese support enabled
Traditional chinese support enabled
Korean support enabled
Russian support enabled
Multibyte (japanese) regex support enabled
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.substitute_character no value no value
mcrypt
mcrypt support enabled
version >= 2.4.x
Supported ciphers arcfour blowfish-compat blowfish cast-128 cast-256 des enigma gost loki97 panama rc2 rijndael-128 rijndael-192 rijndael-256 safer-sk128 safer-sk64 saferplus serpent threeway tripledes twofish wake xtea
Supported modes cbc cfb ecb ncfb nofb ofb stream
Directive Local Value Master Value
mcrypt.algorithms_dir no value no value
mcrypt.modes_dir no value no value
mhash
MHASH support Enabled
MHASH API Version 20020524
mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 4.0.26
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 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
openssl
OpenSSL support enabled
OpenSSL Version OpenSSL 0.9.7e 25 Oct 2004
PCRE (Perl Compatible Regular Expressions) Support enabled
PCRE Library Version 6.6 06-Feb-2006
posix
Revision $Revision: 1.51.2.4.2.1 $
pspell
PSpell Support enabled
zlib
ZLib Support enabled
Compiled Version 1.2.1
Linked Version 1.2.3
Additional Modules
Module Name
dbase
Environment
Variable Value
PWD /home3/root
HOSTNAME host23.webserver1010.com
MACHTYPE i386-redhat-linux-gnu
LOGNAME root
SHLVL 2
SHELL /bin/sh
HOSTTYPE i386
OSTYPE linux-gnu
HOME /root
TERM dumb
PATH /usr/bin:/bin
_ /etc/httpd/bin/httpd
PHP Variables
Variable Value
PHP_SELF /phpinfo.php
PHP_AUTH_USER beyetran
PHP_AUTH_PW uT4pxxV3
_REQUEST["SortListParam"] Alpha
_REQUEST["PHPSESSID"] 0e18a4d98e7108569b433973daf486bd
_COOKIE["SortListParam"] Alpha
_COOKIE["PHPSESSID"] 0e18a4d98e7108569b433973daf486bd
_SERVER["DOCUMENT_ROOT"] /home/beyetran/beyetransformed-www
_SERVER["HTTP_ACCEPT"] text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
_SERVER["HTTP_ACCEPT_CHARSET"] ISO-8859-1,utf-8;q=0.7,*;q=0.7
_SERVER["HTTP_ACCEPT_ENCODING"] gzip,deflate
_SERVER["HTTP_ACCEPT_LANGUAGE"] en-us
_SERVER["HTTP_CONNECTION"] keep-alive
_SERVER["HTTP_COOKIE"] SortListParam=Alpha; PHPSESSID=0e18a4d98e7108569b433973daf486bd
_SERVER["HTTP_HOST"] beyetransformed.org
_SERVER["HTTP_KEEP_ALIVE"] 115
_SERVER["HTTP_USER_AGENT"] Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.3) Gecko/20100401 Firefox/3.6.3
_SERVER["PATH"] /usr/bin:/bin
_SERVER["REMOTE_ADDR"] 97.113.69.205
_SERVER["REMOTE_PORT"] 14352
_SERVER["SCRIPT_FILENAME"] /home/beyetran/beyetransformed-www/phpinfo.php
_SERVER["SERVER_ADDR"] 65.109.11.121
_SERVER["SERVER_ADMIN"] webmaster@beyetransformed.org
_SERVER["SERVER_NAME"] beyetransformed.org
_SERVER["SERVER_PORT"] 80
_SERVER["SERVER_SIGNATURE"] no value
_SERVER["SERVER_SOFTWARE"] Apache/1.3.35 (Unix) ApacheJServ/1.1.2 PHP/4.4.4 FrontPage/5.0.2.2635 Rewrit/1.1a
_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"] /home/beyetran/beyetransformed-www/phpinfo.php
_SERVER["PHP_SELF"] /phpinfo.php
_SERVER["PHP_AUTH_USER"] beyetran
_SERVER["PHP_AUTH_PW"] uT4pxxV3
_SERVER["argv"] Array
(
CREATE TABLE `users` (
`UserID` int( 11 ) NOT NULL AUTO_INCREMENT ,
`UserEmail` varchar( 500 ) default NULL ,
`UserPassword` varchar( 500 ) default NULL ,
`UserFirstName` varchar( 50 ) default NULL ,
`UserLastName` varchar( 50 ) default NULL ,
`UserCity` varchar( 90 ) default NULL ,
`UserState` varchar( 20 ) default NULL ,
`UserZip` varchar( 12 ) default NULL ,
`UserEmailVerified` tinyint( 1 ) default '0',
`UserRegistrationDate` timestamp NULL default CURRENT_TIMESTAMP ,
`UserVerificationCode` varchar( 20 ) default NULL ,
`UserIP` varchar( 50 ) default NULL ,
`UserPhone` varchar( 20 ) default NULL ,
`UserFax` varchar( 20 ) default NULL ,
`UserCountry` varchar( 20 ) default NULL ,
`UserAddress` varchar( 100 ) default NULL ,
`UserAddress2` varchar( 50 ) default NULL ,
PRIMARY KEY ( `UserID` )
)
MySQL said:
#1074 - Too big column length for column 'UserEmail' (max = 255). Use BLOB instead
You help is appreciated.