Admin logon just keeps repeating....

[hawkwynd]

Downloaded v. 1.1.4d of zen cart, and followed the instructions for the installation.

Downloaded PayPal patch PPEC-137-patches-May10-07b.zip
Downloaded UPS patch USPS_patch_may14-2007b.zip

During the install, I received the following error:

A database could not be created. You will have to create one manually, or use an existing database.

So, in the install, I unchecked to have zencart create the database, and then I received the following error:

Error in CREATE TABLE address_book ( address_book_id int NOT NULL auto_increment, customers_id int NOT NULL, entry_gender char(1) NOT NULL, entry_company varchar(32), entry_firstname varchar(32) NOT NULL, entry_lastname varchar(32) NOT NULL, entry_street_address varchar(64) NOT NULL, entry_suburb varchar(32), entry_postcode varchar(10) NOT NULL, entry_city varchar(32) NOT NULL, entry_state varchar(32), entry_country_id int DEFAULT \'0\' NOT NULL, entry_zone_id int DEFAULT \'0\' NOT NULL, PRIMARY KEY (address_book_id), KEY idx_address_book_customers_id (customers_id) ) . You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'0\' NOT NULL, entry_zone_id int DEFAULT \'0\' NOT NULL, PRIMARY KEY (add' at line 13

I'm beginning to wonder if there isn't an issue with my PHP, I will contact my hosting support for info.

[hawkwynd]

For added information, here is my hosts phpinfo():

PHP Version 4.4.4

System Linux cheetah.serverstoday.com 2.6.9-42.0.3.EL #1 Mon Sep 25 17:14:19 EDT 2006 i686
Build Date Mar 20 2007 04:29:33
Configure Command './configure' '--prefix=/usr' '--with-xml' '--enable-bcmath' '--enable-calendar' '--with-curl' '--with-dom' '--with-dom-xslt' '--with-dom-exslt' '--enable-exif' '--with-swf=/usr/local/flash' '--enable-ftp' '--with-gd' '--with-jpeg-dir=/usr/local' '--with-png-dir=/usr' '--with-xpm-dir=/usr/X11R6' '--with-gettext' '--with-iconv' '--with-imap=/usr/local/imap-2004g' '--enable-mbstring' '--enable-mbstr-enc-trans' '--enable-mbregex' '--with-mcrypt' '--with-mhash' '--enable-magic-quotes' '--with-mysqli' '--with-mysql=/usr' '--with-openssl' '--enable-discard-path' '--with-pdflib' '--with-pear' '--with-pspell' '--enable-sockets' '--with-ttf' '--with-freetype-dir=/usr' '--enable-gd-native-ttf' '--with-zlib'
Server API CGI
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.zlib

This program makes use of the Zend Scripting Language Engine:
Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies with Zend Extension Manager v1.0.10, Copyright (c) 2003-2006, by Zend Technologies with Zend Optimizer v3.0.1, Copyright (c) 1998-2006, by Zend Technologies


--------------------------------------------------------------------------------

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_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 Off Off
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 error_log error_log
error_prepend_string no value no value
error_reporting 2039 2039
expose_php Off Off
extension_dir /usr/local/lib/php/extensions/no-debug-non-zts-20020429/ /usr/local/lib/php/extensions/no-debug-non-zts-20020429/
file_uploads On On
gpc_order GPC GPC
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 .:/usr/lib/php:/usr/local/lib/php .:/usr/lib/php:/usr/local/lib/php
log_errors On On
log_errors_max_len 1024 1024
magic_quotes_gpc On On
magic_quotes_runtime On On
magic_quotes_sybase Off Off
max_execution_time 30 30
max_input_time 60 60
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
report_memleaks 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 no value no value
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 2M 2M
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 On On


Zend Optimizer
Optimization Pass 1 enabled
Optimization Pass 2 enabled
Optimization Pass 3 enabled
Optimization Pass 4 enabled
Optimization Pass 9 enabled
Zend Loader enabled
License Path no value


bcmath
BCMath support enabled


calendar
Calendar support enabled


ctype
ctype functions enabled


curl
CURL support enabled
CURL Information libcurl/7.12.1 OpenSSL/0.9.7a zlib/1.2.1.2 libidn/0.5.6


domxml
DOM/XML enabled
DOM/XML API Version 20020815
libxml Version 20622
HTML Support enabled
XPath Support enabled
XPointer Support enabled
DOM/XSLT enabled
libxslt Version 1.1.16
libxslt compiled against libxml Version 2.6.22
DOM/EXSLT enabled
libexslt Version 1.1.16


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


ffmpeg
ffmpeg support (ffmpeg-php) enabled
ffmpeg-php version 0.5.0
libavcodec version Lavc51.20.0
libavformat version Lavf50.6.0

Directive Local Value Master Value
ffmpeg.allow_persistent 0 0


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


iconv
iconv support enabled
iconv implementation glibc
iconv library version 2.3.4

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


imap
IMAP c-Client Version 2004


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 cast-128 gost rijndael-128 twofish arcfour cast-256 loki97 rijndael-192 saferplus wake blowfish-compat des rijndael-256 serpent xtea blowfish enigma rc2 tripledes
Supported modes cbc cfb ctr 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.1.21
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib -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.7a Feb 19 2003


overload
User-Space Object Overloading Support enabled


pcre
PCRE (Perl Compatible Regular Expressions) Support enabled
PCRE Library Version 6.6 06-Feb-2006


pdf
PDF Support enabled
PDFlib GmbH Version 5.0.3
Revision $Revision: 1.112.2.11.2.1 $


posix
Revision $Revision: 1.51.2.4.2.1 $


pspell
PSpell Support enabled


session
Session Support enabled
Registered save handlers files user

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 1440 1440
session.gc_probability 1 1
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 Off Off


sockets
Sockets Support 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
auto_detect_line_endings 0 0
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=,fieldset= a=href,area=href,frame=src,input=src,form=,fieldset=
user_agent no value no value


swf
swf support enabled


tokenizer
Tokenizer Support enabled


xml
XML Support active
XML Namespace Support active
EXPAT Version 1.95.6


zlib
ZLib Support enabled
Compiled Version 1.2.1.2
Linked Version 1.2.1.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


Environment
Variable Value
PATH /usr/local/bin:/usr/bin:/bin
DOCUMENT_ROOT /home/cryptic/public_html
HTTP_ACCEPT */*
HTTP_ACCEPT_ENCODING gzip, deflate
HTTP_ACCEPT_LANGUAGE en-us
HTTP_CONNECTION Keep-Alive
HTTP_COOKIE zenid=8e4caed2160cf1c01a280c87788231c0; zenAdminID=213f459b864cd6a222d8de7151470cb0; cprelogin=no
HTTP_HOST crypticimports.com
HTTP_UA_CPU x86
HTTP_USER_AGENT Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Avant Browser; .NET CLR 1.0.3705; .NET CLR 1.1.4322; Media Center PC 4.0)
REMOTE_ADDR 76.180.0.65
REMOTE_PORT 43428
SCRIPT_FILENAME /home/cryptic/public_html/phpinfo.php
SERVER_ADDR 74.52.181.138
SERVER_ADMIN [email protected]
SERVER_NAME www.crypticimports.com
SERVER_PORT 80
SERVER_SOFTWARE Apache/1.3.37 (Unix) mod_mono/1.0.2 mod_jk/1.2.14 mod_python/2.7.11 Python/2.4.3 mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/5.0.2.2635.SR1.2 mod_ssl/2.8.28 OpenSSL/0.9.7a PHP-CGI/0.1b
GATEWAY_INTERFACE CGI/1.1
SERVER_PROTOCOL HTTP/1.1
REQUEST_METHOD GET
QUERY_STRING no value
REQUEST_URI /phpinfo.php
SCRIPT_NAME /phpinfo.php


PHP Variables
Variable Value
PHP_SELF /phpinfo.php
_REQUEST["zenid"] 8e4caed2160cf1c01a280c87788231c0
_REQUEST["zenAdminID"] 213f459b864cd6a222d8de7151470cb0
_REQUEST["cprelogin"] no
_COOKIE["zenid"] 8e4caed2160cf1c01a280c87788231c0
_COOKIE["zenAdminID"] 213f459b864cd6a222d8de7151470cb0
_COOKIE["cprelogin"] no
_SERVER["PATH"] /usr/local/bin:/usr/bin:/bin
_SERVER["DOCUMENT_ROOT"] /home/cryptic/public_html
_SERVER["HTTP_ACCEPT"] */*
_SERVER["HTTP_ACCEPT_ENCODING"] gzip, deflate
_SERVER["HTTP_ACCEPT_LANGUAGE"] en-us
_SERVER["HTTP_CONNECTION"] Keep-Alive
_SERVER["HTTP_COOKIE"] zenid=8e4caed2160cf1c01a280c87788231c0; zenAdminID=213f459b864cd6a222d8de7151470cb0; cprelogin=no
_SERVER["HTTP_HOST"] crypticimports.com
_SERVER["HTTP_UA_CPU"] x86
_SERVER["HTTP_USER_AGENT"] Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Avant Browser; .NET CLR 1.0.3705; .NET CLR 1.1.4322; Media Center PC 4.0)
_SERVER["REMOTE_ADDR"] 76.180.0.65
_SERVER["REMOTE_PORT"] 43428
_SERVER["SCRIPT_FILENAME"] /home/cryptic/public_html/phpinfo.php
_SERVER["SERVER_ADDR"] 74.52.181.138
_SERVER["SERVER_ADMIN"] [email protected]
_SERVER["SERVER_NAME"] www.crypticimports.com
_SERVER["SERVER_PORT"] 80
_SERVER["SERVER_SOFTWARE"] Apache/1.3.37 (Unix) mod_mono/1.0.2 mod_jk/1.2.14 mod_python/2.7.11 Python/2.4.3 mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/5.0.2.2635.SR1.2 mod_ssl/2.8.28 OpenSSL/0.9.7a PHP-CGI/0.1b
_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["PHP_SELF"] /phpinfo.php
_SERVER["argv"] Array
(
)

_SERVER["argc"] 0
_ENV["PATH"] /usr/local/bin:/usr/bin:/bin
_ENV["DOCUMENT_ROOT"] /home/cryptic/public_html
_ENV["HTTP_ACCEPT"] */*
_ENV["HTTP_ACCEPT_ENCODING"] gzip, deflate
_ENV["HTTP_ACCEPT_LANGUAGE"] en-us
_ENV["HTTP_CONNECTION"] Keep-Alive
_ENV["HTTP_COOKIE"] zenid=8e4caed2160cf1c01a280c87788231c0; zenAdminID=213f459b864cd6a222d8de7151470cb0; cprelogin=no
_ENV["HTTP_HOST"] crypticimports.com
_ENV["HTTP_UA_CPU"] x86
_ENV["HTTP_USER_AGENT"] Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Avant Browser; .NET CLR 1.0.3705; .NET CLR 1.1.4322; Media Center PC 4.0)
_ENV["REMOTE_ADDR"] 76.180.0.65
_ENV["REMOTE_PORT"] 43428
_ENV["SCRIPT_FILENAME"] /home/cryptic/public_html/phpinfo.php
_ENV["SERVER_ADDR"] 74.52.181.138
_ENV["SERVER_ADMIN"] [email protected]
_ENV["SERVER_NAME"] www.crypticimports.com
_ENV["SERVER_PORT"] 80
_ENV["SERVER_SOFTWARE"] Apache/1.3.37 (Unix) mod_mono/1.0.2 mod_jk/1.2.14 mod_python/2.7.11 Python/2.4.3 mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/5.0.2.2635.SR1.2 mod_ssl/2.8.28 OpenSSL/0.9.7a PHP-CGI/0.1b
_ENV["GATEWAY_INTERFACE"] CGI/1.1
_ENV["SERVER_PROTOCOL"] HTTP/1.1
_ENV["REQUEST_METHOD"] GET
_ENV["QUERY_STRING"] no value
_ENV["REQUEST_URI"] /phpinfo.php
_ENV["SCRIPT_NAME"] /phpinfo.php

[Ajeh]

Downloaded v. 1.1.4d of zen cart, and followed the instructions for the installation.

What did you download?

The current version of Zen Cart is Zen Cart v1.3.7 ...

[hawkwynd]

Ok. This figures. I'll download 1.3.7 now and try again...

[hawkwynd]

Turns out there's an issue with my hosting provider. I read somewhere the Zen Cart doesn't play well with servers who run PHP API in CGI mode under Linux. So, I emailed the support team of Roundberry (host) and asked them about it, and informed them about the problems I've been having. They replied they're re-installing the zen cart.

Guess what. It did nothing, still having the same issue, can't even access the administrative panel of Zen Cart, even after doing several things.

So, the tasks continue - Zen cart was running flawlessly for 3 weeks as I prepared to launch the store. On the very night I was to launch, these issues began, and since I've not been able to get it working at all. I can only believe that my host made some kind of changes to cause this, as I made no changes to anything code wise or SQL wise within Zen cart.

If anyone knows a reliable hosting service provider who has Zen cart running well, please drop me a note.

Thank you,
Scott

[hawkwynd]

Solution: Provider had some settings wrong on the server, and reset them back, and now all is working again.

What a pain in the arse. Now I have to re-load everything, import certain sections of the products database... Damn.. What a waste of time because my provider screwed up the server..

Man..

[drupal-guy]

Somewhat related to some of the problems listed here is the DB configuration.

As far as I can tell, Zencart only has the classes for mysql (includes/classes/db), Although it might work just fine with mysqli, one needs to be careful during the setup not to provide mysqli as the DB_TYPE as validation is done on it:

if (( (!file_exists('includes/configure.php') && !file_exists('includes/local/configure.php'))     ) || (DB_TYPE == '') || (!file_exists('includes/classes/db/' .DB_TYPE . '/query_factory.php')    )) {
  header('location: zc_install/index.php');
  exit;
}

If you have set the type to mysqli, the condition above will validate as includes/classes/db/mysqli/query_factory.php doesn't exist....