Request ======= GET http://www.cyclepartsforless.com/category/473817 HTTP/1.1 x-cc-id: ccc01-02 Host: www.cyclepartsforless.com User-Agent: CCBot/1.0 (+http://www.commoncrawl.org/bot.html) Accept: text/html, application/xhtml+xml, text/xml;q=0.9, text/plain;q=0.8, image/png, */*;q=0.5 Accept-Language: en-us, en;q=0.5 Accept-Charset: ISO-8859-1, utf-8;q=0.7, *;q=0.7 X-Cnection: close Cache-Control: no-cache Pragma: no-cache Cookie: account-proxy=6; sitecookie=9238c5abead1456192a35048088697a7 X-Forwarded-For: 38.107.179.213 HTTPS: off X-Version-Shortcut: true Account: 2162862 Server: smith22 Streamed Request. (Length: 0 Read: 0) Parameters ========== pathprefix = / cache = 1328631389162 account = 2162862 pathid = 473817 remainingpath = category/473817 Error ===== select Price_P.ACCOUNT_ID as c1, Price_P.PRODUCT_ID as c2, Price_P.PRICESET_ID as c3, Price_P.PRICE as c4, Price_P.SALEPRICE as c5, Price_P.AVAILABLE as c6, Price_P.ONSALE as c7, Price_P.FEATURED as c8, Price_P.DIRTY as c9, Price_P.USEMAP as c10, Price_P.SUGGESTEDPRICE as c11, Product_P.ACCOUNT_ID as c12, Product_P.PRODUCT_ID as c13, Product_P.KIND as c14, Product_P.NAME as c15, Product_P.SKU as c16, Product_P.SUMMARY as c17, Product_P.IMAGEURL as c18, Product_P.BRAND as c19, Product_P.DIRTY as c20, Product_P.TAG as c21, Product_P.ICONURL as c22, Product_P.ICONTOLERANCE as c23, Product_P.SUPPLIER_ID as c24, Product_P.SHOWADDCART as c25 from Price_P, Product_P, (select distinct ProductCategory_P.PRODUCT_ID as PRODUCT_ID from ProductCategory_P where ProductCategory_P.ACCOUNT_ID = ? AND ProductCategory_P.CATEGORY_ID in (?)) v where Product_P.PRODUCT_ID = v.PRODUCT_ID AND Product_P.ACCOUNT_ID = ? AND Price_P.ACCOUNT_ID = Product_P.ACCOUNT_ID AND Price_P.PRODUCT_ID = Product_P.PRODUCT_ID AND Price_P.PRICESET_ID = ? AND Price_P.AVAILABLE = ? order by lower(Product_P.NAME) nulls last 1: 2162862 2: 473817 3: 2162862 4: 1 5: T ------------- Database operation canceled. [ORA-01013: user requested cancel of current operation ] imergent.database.Oracle.processException(Oracle.java:182) imergent.database.Databases.processException(Databases.java:590) imergent.database.SQL.query(SQL.java:222) imergent.database.SQL.select(SQL.java:356) imergent.product.Products.select(Products.java:779) imergent.pageelement.AbstractProductList.validate(AbstractProductList.java:299) imergent.page.Page.validate(Page.java:1690) imergent.page.Page.validate(Page.java:1643) imergent.site.SiteHandler.processPage(SiteHandler.java:1194) imergent.site.SiteHandler.process(SiteHandler.java:643) imergent.http.HttpResponse.process(HttpResponse.java:477) imergent.http.Worker.run(Worker.java:279)

Database operation canceled. [ORA-01013: user requested cancel of current operation ]