biornt

New install error

in Cartweaver ColdFusion • 1 year ago

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)

Replies(3)

wrightsto..

Re: New install error

1 year ago

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

Re: New install error

1 year ago

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

wrightsto..

Re: New install error

1 year ago

They may have disabled the CreateObject() function.

-Mark Wright

Top Reply

Response title

Attachments

New to this Portal?

New install error

Error Executing Database Query.

Replies(3)

Re: New install error

Re: New install error

Re: New install error

Statistics

Tags

Actions

Related Posts