Jump to content

Shopping Cart / Checkout Not Working


Guest Dale Massey

Recommended Posts

Guest jeromas

I have the same problem here, and posted a while back, but no one seemed to know the answer. One of the posts I browsed through said it was due to having a large quantity of products in the database and that the script responsible for parsing the items wasn't able to 'handle it'. I don't think that is true, as even the scripts I've written for my online quote system are able to parse my (currently) 5500+ item inventory..I can't imagine that the authors of Cubecart, especially after looking at the code, have written a script that will throw up like that, but then again even the smallest bugs can do the strangest things...anyone got any ideas?

Link to comment
Share on other sites

I imagine it cold be weird characters, either in the product code, description, or possibly the price (ie comma instead of dot)

If you look at your raw database in PHPmyAdmin, can you see any strange characters?

I think we had problems with people adding punctuation, tabs, etc..

I'd do an EXPORT in to EXCEL and double check it all looks tabled nicely.

Then you can reimport it once corrected.

The number of products is irrelevent IMHO as it has foundit in database, it's just the cart memory of the single add to porduct that is giving jip. Whcih seems like a corrupted product to me.

CLeaning it with excel should hoighligh it.

You could also just import the first 50 porducts to prove it wasn't a size thing.

BACKUP your database before you do all this of ocurse !

Link to comment
Share on other sites

Guest slsmayville

I'm having the same issue and since I only have 4 items listed, I highly doubt it's due to a large list of items.

Meanwhile, this is just a pain in the rear...

Link to comment
Share on other sites

Guest jeromas

I've checked the data, and even gone so far as to try saving the files with different sets of line breaks, but that usually ends up with incorrect importation of the records into the database. There are no odd visible characters in the database itself. It seems odd that the item is added correctly to the basket, but on 'View Basket', it doesn't correctly show the item or any other information related to it. If anyone figures it out, please post it here.

Link to comment
Share on other sites

Guest jeromas

As an update, I have done the following

(1) Emptied my store database and entered a single record using PHPMyAdmin. The results were the same when I tried to 'View Basket' -- no item information is there.

(2) Experimented with various line breaks from Unix, Windows, and Mac on my .csv files that I imported into my store database. That didn't help either.

(3) Removed the extra database fields in my inventory table that I use for my own purposes and did steps 1 and 2 again. That didn't help either.

(4) Re-uploaded all of the cart files from a fresh download in binary mode. Originally when I installed the store, transferring all the files in binary mode caused the installation to fail, so I re-installed using ascii transfer mode and just re-uploaded the images in binary mode. This step didn't help either.

I am fresh out of ideas as to why I can't use the cart system in 3.0.2. The only other step I can think of is to post the php server settings from my web host. If anyone has any ideas, please let those of us out there having this problem know what is up.

PHP Version 4.3.11

System Linux box12.bluehost.com 2.4.21-32.0.1.ELsmp #1 SMP Wed May 25 14:26:33 EDT 2005 i686

Build Date Jun 16 2005 00:07:09

Configure Command './configure' '--prefix=/usr' '--with-xml' '--enable-bcmath' '--enable-calendar' '--with-curl' '--with-dom' '--with-dom-xslt' '--with-dom-exslt' '--enable-ftp' '--with-gd' '--with-jpeg-dir=/usr/local' '--with-png-dir=/usr' '--with-xpm-dir=/usr/X11R6' '--with-gettext' '--with-imap' '--with-imap-ssl' '--with-kerberos' '--enable-mbstring' '--enable-mbstr-enc-trans' '--enable-mbregex' '--with-mcrypt' '--with-mhash' '--with-ming=../ming-0.2a' '--enable-magic-quotes' '--with-mysql' '--with-openssl' '--enable-discard-path' '--with-pear' '--with-pgsql=/usr' '--enable-xslt' '--with-xslt-sablot' '--enable-sockets' '--enable-track-vars' '--with-ttf' '--with-freetype-dir=/usr' '--enable-gd-native-ttf' '--enable-versioning' '--with-zip' '--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 20021010

Debug Build no

Thread Safety disabled

Registered PHP Streams php, http, ftp, https, ftps, compress.zlib

Zend logo This program makes use of the Zend Scripting Language Engine:

Zend Engine v1.3.0, Copyright © 1998-2004 Zend Technologies with Zend Extension Manager v1.0.6, Copyright © 2003-2004, by Zend Technologies with Zend Optimizer v2.5.7, Copyright © 1998-2004, by 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_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 error_log error_log

error_prepend_string no value no value

error_reporting 2039 2039

expose_php On On

extension_dir ./ ./

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 Off Off

magic_quotes_sybase Off Off

max_execution_time 30 30

max_input_time -1 -1

open_basedir no value no value

output_buffering no value no value

output_handler no value no value

post_max_size 55M 55M

precision 14 14

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 Off Off

Zend Optimizer

Optimization Pass 1 enabled

Optimization Pass 2 enabled

Optimization Pass 3 enabled

Optimization Pass 4 enabled

Optimization Pass 9 disabled

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.0 OpenSSL/0.9.7a zlib/1.1.4

domxml

DOM/XML enabled

DOM/XML API Version 20020815

libxml Version 20616

HTML Support enabled

XPath Support enabled

XPointer Support enabled

DOM/XSLT enabled

libxslt Version 1.1.8

libxslt compiled against libxml Version 2.6.11

DOM/EXSLT enabled

libexslt Version 1.1.8

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

imap

IMAP c-Client Version 2001

SSL Support enabled

Kerberos 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 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

ming

Ming SWF output library enabled

Version 0.3beta1

mysql

MySQL Support enabled

Active Persistent Links 0

Active Links 0

Client API version 3.23.49

MYSQL_MODULE_TYPE builtin

MYSQL_SOCKET /var/tmp/mysql.sock

MYSQL_INCLUDE no value

MYSQL_LIBS no value

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 4.5 01-December-2003

pgsql

PostgreSQL Support enabled

PostgreSQL(libpq) Version 7.3.10-RH

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.51.2.3 $

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 On On

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,form=,fieldset= a=href,area=href,frame=src,form=,fieldset=

user_agent no value no value

tokenizer

Tokenizer Support enabled

xml

XML Support active

XML Namespace Support active

EXPAT Version 1.95.6

xslt

XSLT support enabled

Backend Sablotron

Sablotron Version 1.0.1

Sablotron Information Cflags: -g -O2 Libs: -L/usr/lib -lexpat Prefix: /usr

zip

Zip support enabled

zlib

ZLib Support enabled

Compiled Version 1.1.4

Linked Version 1.1.4

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/punchcar/public_html

HTTP_ACCEPT text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,:unsure:;q=0.5

HTTP_ACCEPT_CHARSET ISO-8859-1,utf-8;q=0.7,*;q=0.7

HTTP_ACCEPT_ENCODING gzip,deflate

HTTP_ACCEPT_LANGUAGE en-us,en;q=0.5

HTTP_CONNECTION keep-alive

HTTP_COOKIE ccUser=YTg5Y2ExYTQ4MmU4OGY0NTgxNmZiZjI3MWU5OTM4ZTg%3D; PHPSESSID=3431ba2ab1c7bf1887f77e151d77b1ab

HTTP_HOST www.punchcard-pcs.com

HTTP_KEEP_ALIVE 300

HTTP_REFERER http://www.punchcard-pcs.com/classic_gamin.../serverInfo.php

HTTP_USER_AGENT Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2

REMOTE_ADDR 216.98.228.148

REMOTE_PORT 60677

SCRIPT_FILENAME /home/punchcar/public_html/classic_gaming/admin/misc/info.php

SERVER_ADDR 67.138.240.169

SERVER_ADMIN [email protected]

SERVER_NAME www.punchcard-pcs.com

SERVER_PORT 80

SERVER_SOFTWARE Apache/1.3.33 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/5.0.2.2635 mod_ssl/2.8.22 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 /classic_gaming/admin/misc/info.php

SCRIPT_NAME /classic_gaming/admin/misc/info.php

PHP Variables

Variable Value

PHP_SELF /classic_gaming/admin/misc/info.php

_REQUEST["ccUser"] YTg5Y2ExYTQ4MmU4OGY0NTgxNmZiZjI3MWU5OTM4ZTg=

_REQUEST["PHPSESSID"] 3431ba2ab1c7bf1887f77e151d77b1ab

_COOKIE["ccUser"] YTg5Y2ExYTQ4MmU4OGY0NTgxNmZiZjI3MWU5OTM4ZTg=

_COOKIE["PHPSESSID"] 3431ba2ab1c7bf1887f77e151d77b1ab

_SERVER["PATH"] /usr/local/bin:/usr/bin:/bin

_SERVER["DOCUMENT_ROOT"] /home/punchcar/public_html

_SERVER["HTTP_ACCEPT"] text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,:w00t:;q=0.5

_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,en;q=0.5

_SERVER["HTTP_CONNECTION"] keep-alive

_SERVER["HTTP_COOKIE"] ccUser=YTg5Y2ExYTQ4MmU4OGY0NTgxNmZiZjI3MWU5OTM4ZTg%3D; PHPSESSID=3431ba2ab1c7bf1887f77e151d77b1ab

_SERVER["HTTP_HOST"] www.punchcard-pcs.com

_SERVER["HTTP_KEEP_ALIVE"] 300

_SERVER["HTTP_REFERER"] http://www.punchcard-pcs.com/classic_gamin.../serverInfo.php

_SERVER["HTTP_USER_AGENT"] Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2

_SERVER["REMOTE_ADDR"] 216.98.228.148

_SERVER["REMOTE_PORT"] 60677

_SERVER["SCRIPT_FILENAME"] /home/punchcar/public_html/classic_gaming/admin/misc/info.php

_SERVER["SERVER_ADDR"] 67.138.240.169

_SERVER["SERVER_ADMIN"] [email protected]

_SERVER["SERVER_NAME"] www.punchcard-pcs.com

_SERVER["SERVER_PORT"] 80

_SERVER["SERVER_SOFTWARE"] Apache/1.3.33 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/5.0.2.2635 mod_ssl/2.8.22 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"] /classic_gaming/admin/misc/info.php

_SERVER["SCRIPT_NAME"] /classic_gaming/admin/misc/info.php

_SERVER["PHP_SELF"] /classic_gaming/admin/misc/info.php

_SERVER["argv"]

Array

(

)

_SERVER["argc"] 0

_ENV["PATH"] /usr/local/bin:/usr/bin:/bin

_ENV["DOCUMENT_ROOT"] /home/punchcar/public_html

_ENV["HTTP_ACCEPT"] text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,:w00t:;q=0.5

_ENV["HTTP_ACCEPT_CHARSET"] ISO-8859-1,utf-8;q=0.7,*;q=0.7

_ENV["HTTP_ACCEPT_ENCODING"] gzip,deflate

_ENV["HTTP_ACCEPT_LANGUAGE"] en-us,en;q=0.5

_ENV["HTTP_CONNECTION"] keep-alive

_ENV["HTTP_COOKIE"] ccUser=YTg5Y2ExYTQ4MmU4OGY0NTgxNmZiZjI3MWU5OTM4ZTg%3D; PHPSESSID=3431ba2ab1c7bf1887f77e151d77b1ab

_ENV["HTTP_HOST"] www.punchcard-pcs.com

_ENV["HTTP_KEEP_ALIVE"] 300

_ENV["HTTP_REFERER"] http://www.punchcard-pcs.com/classic_gamin.../serverInfo.php

_ENV["HTTP_USER_AGENT"] Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2

_ENV["REMOTE_ADDR"] 216.98.228.148

_ENV["REMOTE_PORT"] 60677

_ENV["SCRIPT_FILENAME"] /home/punchcar/public_html/classic_gaming/admin/misc/info.php

_ENV["SERVER_ADDR"] 67.138.240.169

_ENV["SERVER_ADMIN"] [email protected]

_ENV["SERVER_NAME"] www.punchcard-pcs.com

_ENV["SERVER_PORT"] 80

_ENV["SERVER_SOFTWARE"] Apache/1.3.33 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/5.0.2.2635 mod_ssl/2.8.22 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"] /classic_gaming/admin/misc/info.php

_ENV["SCRIPT_NAME"] /classic_gaming/admin/misc/info.php

Link to comment
Share on other sites

Guest unbeaten

Hiya Peeps

I had the same problem with mine. The Key comes in setting the taxes up before you add any products.

This really is the solution. Although this could be a bit of a bugger if you have added loads of products already!!

If you have there is hope PM me

Link to comment
Share on other sites

Guest yoursite

You Just Need To Update All Your Products By Clicking On Them And Then Pressing Update, This Will Fix The Problem And Correct The Check Out Process.

Link to comment
Share on other sites

Guest jeromas

Well, it looks like yoursite is right - just pressing the 'Edit Product' button in the admin cPanel works if you then add that particular item to the basket.

Unfortunately, I have almost 6000 products in my database, so could the dev's share what the update button does to the records? To me it looks like maybe it was just using addslashes() to put slashes around any punctuation found in the records. If so, is there any punctuation that is allowed in the records? It should be fairly easy to do a global search and replace..

I've already added slashes to all of the ' found, as well as getting rid of the few commas present (though my fields were delimited by :). Anything else I should take care of with a record?

Thanks for the input.

Link to comment
Share on other sites

Having the same problem as you call, can't find an "UPDATE" button. Where would it be?

When I try to "Edit" to adjust, I get a "Failure to Update Category" Response.

Any suggestions?

Link to comment
Share on other sites

I have just been to your site and did a test purchase everything worked fine!!!

Try the following, remove all cookies from your computer, remove all members from the website you have set up to test with then close all your browser windows, restart your browser and try the whole registration and purchase again.

One of the problems is tesing the site several times and using different usernames etc, the cookies on your computer can confuse the store.

It worked for me..

Link to comment
Share on other sites

Strange, I've tried what you suggested, and had a few associates try from different computers and we're getting blank shopping cart screens.

I try to do the "Edit" trick for each product, but when I click "Edit" from the product page, I get a "Failure to Edit Category" message in red at top of page.

Any ideas?

What folders are involved and what permissions are they supposed to be, if you know, to edit a category, and/or display the images and carry the cookies into the shopping cart. Perhaps on the update permissions got changed? Problem is striking me that way.

thanx

Marc

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...