Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Unable to create DB

Thread began 5/28/2010 3:29 pm by ken317419 | Last modified 6/14/2010 5:45 pm by Eric Mittman | 52226 views | 3 replies |

ken317419

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.

Sign in to reply to this post

Eric Mittman

Your PHP version is definitely quite old, I would recommend updating this to version 5. For your MySQL you can find out the version by going into the sql area of your phpMyAdmin and entering this query:

SELECT version();

Run the query and it should return the version number for you. You should be using version 5 at least.

Sign in to reply to this post

ken317419

Database error

Move entire site to newer server. Now the system will not function. I get error messages when try to do a simple registration. Why did the database not have at least one record included as the admin record?

My admin page goes directly to a chart but no users are registered even a test user. Thus errors...

Host folks tell me the setup files localhost and wa_global are correct but that all. Is there any support which will look at the site on the site to see what is not functioning correctly? Your help is greatly appreciated. Otherwise this product will do me no good.
Ken

Sign in to reply to this post

Eric Mittman

Did you setup a new set of files on the new server? Unless you are transferring an existing site you should upload the files for PowerStore that come from the downloaded zip file and run the installer by trying to login to the admin area.

What are the steps that you have taken to move your store to the new server? If you did not have the store functioning before then you should upload your default PowerStore files to start the installation process on the new server.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...