« Back

You are in : Recent Topics » Cartweaver ColdFusion » New install error

New install error

biornt

on 29-Jul-2010 06:55 PM.

in Cartweaver ColdFusion

I am getting this error from a completely clean install.

Any suggestions are apreciated. And yes, it is an Access database for now, but it should still work.

Thanks in advance.

biorn

The following information is meant for the website developer for debugging purposes.

Error Occurred While Processing Request

Error Executing Database Query.

[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'p.product_ID = s.SKU_ProductID INNER JOIN tbl_cart c ON c.cart_sku_ID = s.SKU_ID LEFT JOIN tbl_skuoption_rel r ON s.SKU_ID = r.optn_rel_SKU_ID LEFT JOIN tbl_skuoptions so ON so.option_ID = r.optn_rel_Option_ID LEFT JOIN tbl_list_optiontypes ot ON ot.optionty'.

The error occurred in D:Inetpubamericaautogroupcw3CWTagsCWIncFunctions.cfm: line 448
Called from D:Inetpubamericaautogroupcw3CWIncShowCart.cfm: line 137
Called from D:Inetpubamericaautogroupcw3CWIncShowCart.cfm: line 136
Called from D:Inetpubamericaautogroupcw3CWIncShowCart.cfm: line 1
Called from D:Inetpubamericaautogroupcw3CWIncShowCart.cfm: line 1
Called from D:InetpubamericaautogroupShowCart.cfm: line 24
Called from D:Inetpubamericaautogroupcw3CWTagsCWIncFunctions.cfm: line 448
Called from D:Inetpubamericaautogroupcw3CWIncShowCart.cfm: line 137
Called from D:Inetpubamericaautogroupcw3CWIncShowCart.cfm: line 136
Called from D:Inetpubamericaautogroupcw3CWIncShowCart.cfm: line 1
Called from D:Inetpubamericaautogroupcw3CWIncShowCart.cfm: line 1
Called from D:InetpubamericaautogroupShowCart.cfm: line 24

446 : LEFT JOIN tbl_list_optiontypes ot 447 : ON ot.optiontype_ID = so.option_Type_ID 448 : WHERE c.cart_custcart_ID = <cfqueryparam cfsqltype="cf_sql_varchar" value="#Arguments.CartID#" /> 449 : AND p.product_Archive = 0 450 : AND s.SKU_ShowWeb = 1

VENDORERRORCODE	-3100
SQLSTATE	42000
SQL	SELECT p.product_ID, p.product_Name, p.product_shipchrg, s.SKU_MerchSKUID , s.SKU_ID, c.cart_sku_qty, s.SKU_Price, s.SKU_Weight, ot.optiontype_Name , so.option_Name, c.cart_sku_qty * s.sku_price AS TotalPrice , c.cart_sku_qty * s.SKU_Weight AS TotalWeight FROM tbl_products p INNER JOIN tbl_skus s ON p.product_ID = s.SKU_ProductID INNER JOIN tbl_cart c ON c.cart_sku_ID = s.SKU_ID LEFT JOIN tbl_skuoption_rel r ON s.SKU_ID = r.optn_rel_SKU_ID LEFT JOIN tbl_skuoptions so ON so.option_ID = r.optn_rel_Option_ID LEFT JOIN tbl_list_optiontypes ot ON ot.optiontype_ID = so.option_Type_ID WHERE c.cart_custcart_ID = (param 1) AND p.product_Archive = 0 AND s.SKU_ShowWeb = 1 AND p.product_OnWeb = 1 ORDER BY p.product_Sort, p.product_Name, s.SKU_Sort, s.SKU_ID , so.option_Name, so.option_Sort
DATASOURCE	AAAAAAA

Resources:

Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.

Browser	Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; HPDTDF; .NET4.0C)
Remote Address	76.168.188.84
Referrer	https://www6202.ssldomain.com/americaautogroup/ShowCart.cfm?cart=4241123&result=1&stockalert=No&returnurl=http://www.americaautogroup.com/Details.cfm?ProdID=22
Date/Time	29-Jul-10 06:43 PM

Stack Trace (click to expand)

No status

wrightstork

on 30-Jul-2010 08:17 AM

It has to do with setting the dbtype to Access in one of the files...I will find it here in a minute I hope.

...

found it....CWTagGlobalSettings...insert <cfset Application.DBType = "MSAccess"> right after the cfswitch on line 190,

-Mark Wright

biornt

on 30-Jul-2010 09:51 AM

Thank you so much, that was the right direction, but I needed to also update two other lines from "MySQL" to "MSAccess" - line 176 and 181.

Still I am curious as to why did was necessary. I have installed about 30 CW CF carts in the past several years, almost since the first version, and several with SQL, but I have never had this issue with an Access install.

This paticular instal is on a shared CF9 server - anyone have any idea if that may have something to do with it?

biorn

wrightstork

on 30-Jul-2010 11:56 AM

They may have disabled the CreateObject() function.

-Mark Wright

Topic Type :

No of days :

Back

Top

Permalink

Statistics

3
Replies
127
Views
0
Followers

Tags for the post

No tags available for this topic.

Show all available tags

CF Error on Adding a Discount in Ad...

Response title

New install error

Error Executing Database Query.

Re: New install error

Re: New install error

Re: New install error

Insert Link

Insert Object [for YouTube videos and the like]

Add Image