Votive Glass	Car Diffuser	Fragrance Oils	Diffuser & Oil	Lamp Rings
Votives	Travel Tins	Jelly Jars	16 Oz Frosted	Wick Trimmers

Cartweaver Debugger

Queries

0: SELECT SUM(cart_sku_qty) AS CartCount
, cart_custcart_ID
FROM tbl_cart
GROUP BY cart_custcart_ID
HAVING cart_custcart_ID = 3980841

1:
SELECT DISTINCT P.product_ID
FROM tbl_products P
INNER JOIN tbl_skus S
ON P.product_ID = S.SKU_ProductID WHERE
P.product_OnWeb = 1
AND P.product_Archive = 0

product_ID
35
36
37
38
39
40
42
43
44
47

2: SELECT p.product_ID,
p.product_Name,
p.product_ShortDescription
FROM tbl_products p
WHERE p.product_ID IN (35,36,37,38,39,40,42,43,44,47)
ORDER BY p.product_Sort,
p.product_Name LIMIT 0, 10

product_ID	product_Name	product_ShortDescription
36	Votive Glass
42	Car Diffuser
35	Fragrance Oils
43	Diffuser & Oil
44	Lamp Rings
37	Votives
38	Travel Tins
39	Jelly Jars
40	16 Oz Frosted
47	Wick Trimmers

3: SELECT p.product_ID,
p.product_Name,
p.product_ShortDescription
FROM tbl_products p
WHERE p.product_ID IN (35,36,37,38,39,40,42,43,44,47)
ORDER BY p.product_Sort,
p.product_Name

product_ID	product_Name	product_ShortDescription
36	Votive Glass
42	Car Diffuser
35	Fragrance Oils
43	Diffuser & Oil
44	Lamp Rings
37	Votives
38	Travel Tins
39	Jelly Jars
40	16 Oz Frosted
47	Wick Trimmers

4: SELECT prdctImage_FileName
FROM tbl_prdtimages
WHERE prdctImage_ProductID = 36
AND prdctImage_ImgTypeID = 1

prdctImage_FileName
votglas.gif

5: SELECT product_Discounts
FROM tbl_products
WHERE product_ID = 36

product_Discounts
0

6: SELECT prdctImage_FileName
FROM tbl_prdtimages
WHERE prdctImage_ProductID = 42
AND prdctImage_ImgTypeID = 1

prdctImage_FileName
diffuserthumb.jpg

7: SELECT product_Discounts
FROM tbl_products
WHERE product_ID = 42

product_Discounts
0

8: SELECT prdctImage_FileName
FROM tbl_prdtimages
WHERE prdctImage_ProductID = 35
AND prdctImage_ImgTypeID = 1

prdctImage_FileName
fragoilthumb.jpg

9: SELECT product_Discounts
FROM tbl_products
WHERE product_ID = 35

product_Discounts
1

10: SELECT prdctImage_FileName
FROM tbl_prdtimages
WHERE prdctImage_ProductID = 43
AND prdctImage_ImgTypeID = 1

prdctImage_FileName
fradiffoilthumb.jpg

11: SELECT product_Discounts
FROM tbl_products
WHERE product_ID = 43

product_Discounts
0

12: SELECT prdctImage_FileName
FROM tbl_prdtimages
WHERE prdctImage_ProductID = 44
AND prdctImage_ImgTypeID = 1

prdctImage_FileName
lampringthumb.jpg

13: SELECT product_Discounts
FROM tbl_products
WHERE product_ID = 44

product_Discounts
0

14: SELECT prdctImage_FileName
FROM tbl_prdtimages
WHERE prdctImage_ProductID = 37
AND prdctImage_ImgTypeID = 1

prdctImage_FileName
votivesthumb.jpg

15: SELECT product_Discounts
FROM tbl_products
WHERE product_ID = 37

product_Discounts
1

16: SELECT prdctImage_FileName
FROM tbl_prdtimages
WHERE prdctImage_ProductID = 38
AND prdctImage_ImgTypeID = 1

prdctImage_FileName
tinthumb.jpg

17: SELECT product_Discounts
FROM tbl_products
WHERE product_ID = 38

product_Discounts
1

18: SELECT prdctImage_FileName
FROM tbl_prdtimages
WHERE prdctImage_ProductID = 39
AND prdctImage_ImgTypeID = 1

prdctImage_FileName
jellythumb.jpg

19: SELECT product_Discounts
FROM tbl_products
WHERE product_ID = 39

product_Discounts
1

20: SELECT prdctImage_FileName
FROM tbl_prdtimages
WHERE prdctImage_ProductID = 40
AND prdctImage_ImgTypeID = 1

prdctImage_FileName
frostythumb.jpg

21: SELECT product_Discounts
FROM tbl_products
WHERE product_ID = 40

product_Discounts
1

22: SELECT prdctImage_FileName
FROM tbl_prdtimages
WHERE prdctImage_ProductID = 47
AND prdctImage_ImgTypeID = 1

prdctImage_FileName
wicktrimmer_thumb.jpg

23: SELECT product_Discounts
FROM tbl_products
WHERE product_ID = 47

product_Discounts
0

Page Variables

Var

Value

Page Variables

Var

Value

name

Cartweaver

Page Variables

Var	Value
hostname	localhost
database	candles_candledata
databaseUsername	candles
databasePassword	h00cher5
databaseType	mysql
recordCount	1
debug	1
connection	Resource id #7

Page Variables

Var	Value
db	CWDBMySQL.php
targetGoToCart	https://secure168.hostgator.com/~candles/showcart.php
targetCheckout	https://secure168.hostgator.com/~candles/orderform.php
targetConfirmOrder	https://secure168.hostgator.com/~candles/confirmation.php
targetResults	http://www.candlesbythecreek.com/results.php
targetDetails	http://www.candlesbythecreek.com/details.php
recordsAtATime	10
onSubmitAction	Confirm
cwLocale	(empty)
hostname	localhost
database	candles_candledata
databaseUsername	candles
databasePassword	h00cher5
mailServer	localhost
detailsDisplay	Advanced
paymentAuthType	gateway
paymentAuthName	dummy.php
websiteURL	http://www.candlesbythecreek.com/
websiteSSLURL	https://secure168.hostgator.com/~candles/
imageThumbFolder	cw2/assets/product_thumb/
imageLargeFolder	cw2/assets/product_full/
cwDebug	1
debugPassword	(empty)
enableErrorHandling	(empty)
allowBackOrders	1

debugger

OFF

sku_qty

(empty)

sku_id

(empty)

qtyAdded

(empty)

cwError

Array

Var	Value
(empty)

optionList

(empty)

productId

(empty)

CartId

3980841

thisPage

/results.php

thisPageQS

/results.php?debug=

thisPageName

results.php

thisLocation

http://candlesbythecreek.com/results.php

thisLocationQS

http://candlesbythecreek.com/results.php?debug=

queries

Array

Var	Value
queries[0]	Array
queries[1]	Array
queries[2]	Array
queries[3]	Array
queries[4]	Array
queries[5]	Array
queries[6]	Array
queries[7]	Array
queries[8]	Array
queries[9]	Array
queries[10]	Array
queries[11]	Array
queries[12]	Array
queries[13]	Array
queries[14]	Array
queries[15]	Array
queries[16]	Array
queries[17]	Array
queries[18]	Array
queries[19]	Array
queries[20]	Array
queries[21]	Array
queries[22]	Array
queries[23]	Array

cwDebuggerStrings

Array

Var	Value
(empty)

val

(empty)

key

(empty)

temp

(empty)

column

(empty)

row

(empty)

URL Variables

Var	Value
debug	(empty)

Form Variables

Var	Value

Session Variables

Var	Value
Remote_Quote	0
UPS_Error	0
ShipMethCode	0
CartId	3980841
debug	1
shipCalcType	localcalc
companyname	Candles By The Creek
companyaddress1	1210 Currey Road
companycity	Nashville
companystate	TN
companyzip	37217
companycountry	USA
companyphone	615-361-5371
companyfax	(empty)
companyemail	candlesbythecreek@comcast.net
showupsell	1
AllowBackOrders	1
chargeShipBase	0
chargeShipByWeight	1
chargeShipExtension	1
enableShipping	1
enableremoteship	0
chrgbaseremote	0
enableErrorHandling	(empty)
AnyDiscounts	1
Productid	40
discactive	1
Discount_Description	Discount Will Be Applied At Cart

Environment Variables

Var	Value
DOCUMENT_ROOT	/home/candles/public_html
GATEWAY_INTERFACE	CGI/1.1
HTTP_ACCEPT	text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,/;q=0.5
HTTP_ACCEPT_CHARSET	ISO-8859-1,utf-8;q=0.7,*;q=0.7
HTTP_ACCEPT_ENCODING	gzip
HTTP_ACCEPT_LANGUAGE	en-us,en;q=0.5
HTTP_CACHE_CONTROL	no-cache
HTTP_CONNECTION	close
HTTP_COOKIE	PHPSESSID=31dec6bdc6f19dfe80b4be69bf08300a; CartId=3980841
HTTP_HOST	candlesbythecreek.com
HTTP_PRAGMA	no-cache
HTTP_USER_AGENT	CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
HTTP_X_CC_ID	ccc02-02
PATH	/bin:/usr/bin
QUERY_STRING	debug=
REDIRECT_STATUS	200
REMOTE_ADDR	38.107.191.98
REMOTE_PORT	49166
REQUEST_METHOD	GET
REQUEST_URI	/results.php?debug=
SCRIPT_FILENAME	/home/candles/public_html/results.php
SCRIPT_NAME	/results.php
SERVER_ADDR	74.52.133.2
SERVER_ADMIN	webmaster@candlesbythecreek.com
SERVER_NAME	candlesbythecreek.com
SERVER_PORT	80
SERVER_PROTOCOL	HTTP/1.1
SERVER_SIGNATURE	Apache mod_fcgid/2.3.5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 Server at candlesbythecreek.com Port 80
SERVER_SOFTWARE	Apache mod_fcgid/2.3.5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635
UNIQUE_ID	TIkuVEo0hQIAACwrGu0AAAIZ

Cookie Variables

Var	Value
PHPSESSID	31dec6bdc6f19dfe80b4be69bf08300a
CartId	3980841

File Variables

Var	Value

Object

Var	Value

Class Methods

Var	Value
0	CWCart
1	setSkuQty
2	checkStockCount
3	setSkuId
4	setCWError
5	setOptionList
6	setProductId
7	setCartId
8	getSkuQty
9	getCartQty
10	getCartItemQty
11	getSkuId
12	getQtyAdded
13	getCWError
14	getOptionList
15	getProductId
16	getCartId
17	displayError
18	update
19	updateItem
20	delete
21	multiOption
22	add
23	addItem
24	clearCart
25	cartLinks

Class Variables

Catchable fatal error: Object of class DB could not be converted to string in /home/candles/public_html/cw2/CWLibrary/CWDebugger.php on line 214

Var	Value
name	Cartweaver

Welcome To Our Candle Store

Votive Glass

Car Diffuser

Fragrance Oils

Diffuser & Oil

Lamp Rings

Votives

Travel Tins

Jelly Jars

16 Oz Frosted

Wick Trimmers

Cartweaver Debugger

Queries

Page Variables

Page Variables

Page Variables

Page Variables

URL Variables

Form Variables

Session Variables

Environment Variables

Cookie Variables

File Variables

Object

Class Methods

Class Variables