skrivanek Posted August 7, 2008 Report Share Posted August 7, 2008 I'm getting the following error when I try to access the product pages: NVALID SQL: 1030 : Got error 28 from storage engine SQL QUERY FAILURE:SELECT xcart_products.*, xcart_quick_flags.*, xcart_quick_prices.variantid, xcart_pricing.price, IF(xcart_products_lng.productid != '', xcart_products_lng.product, xcart_products.product) as product, IF(xcart_products_lng.productid != '', xcart_products_lng.descr, xcart_products.descr) as descr, IF(xcart_products_lng.productid != '', xcart_products_lng.fulldescr, xcart_products.fulldescr) as fulldescr, IFNULL(xcart_variants.avail, xcart_products.avail) as avail, IFNULL(xcart_variants.weight, xcart_products.weight) as weight, IFNULL(xcart_variants.productcode, xcart_products.productcode) as productcode FROM xcart_pricing, xcart_products LEFT JOIN xcart_quick_flags ON xcart_quick_flags.productid = xcart_products.productid LEFT JOIN xcart_products_lng ON xcart_products_lng.productid = xcart_products.productid AND xcart_products_lng.code = 'US' LEFT JOIN xcart_product_memberships ON xcart_product_memberships.productid = xcart_products.productid INNER JOIN xcart_featured_products ON xcart_products.productid=xcart_featured_products.productid AND xcart_featured_products.avail='Y' AND xcart_featured_products.categoryid='0' INNER JOIN xcart_quick_prices ON xcart_quick_prices.productid = xcart_products.productid AND xcart_quick_prices.membershipid = 0 LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid AND xcart_quick_prices.variantid = xcart_variants.variantid INNER JOIN xcart_products_categories ON xcart_products_categories.productid = xcart_products.productid INNER JOIN xcart_categories ON xcart_products_categories.categoryid = xcart_categories.categoryid LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = xcart_categories.categoryid WHERE xcart_quick_prices.priceid = xcart_pricing.priceid AND xcart_products.product_type <> 'C' AND xcart_products.forsale <> 'B' AND xcart_category_memberships.membershipid IS NULL AND xcart_product_memberships.membershipid IS NULL AND xcart_categories.avail = 'Y' AND xcart_products.forsale = 'Y' GROUP BY xcart_products.productid ORDER BY xcart_featured_products.product_order, xcart_products.product ASC LIMIT 0, 30 Aaron Quote Link to comment Share on other sites More sharing options...
Ritual Posted August 7, 2008 Report Share Posted August 7, 2008 I have a feeling this is NOT what Nathan needs right now... Quote Link to comment Share on other sites More sharing options...
goblyn13 Posted August 7, 2008 Report Share Posted August 7, 2008 I was able to go through most of the steps to place an order without a problem (didn't actually order though) Quote Link to comment Share on other sites More sharing options...
thewartoad Posted August 7, 2008 Report Share Posted August 7, 2008 UT-OH Raggy! Quote Link to comment Share on other sites More sharing options...
Keltheos Posted August 7, 2008 Report Share Posted August 7, 2008 I was able to go through most of the steps to place an order without a problem (didn't actually order though) Ditto. Skriv, try again. Quote Link to comment Share on other sites More sharing options...
Peterdita Posted August 7, 2008 Report Share Posted August 7, 2008 I was getting this same error message this morning. However, I just placed an order and everything worked fine. Quote Link to comment Share on other sites More sharing options...
skrivanek Posted August 7, 2008 Author Report Share Posted August 7, 2008 Working now! And there was much rejoicing. Aaron Quote Link to comment Share on other sites More sharing options...
Nathan Caroland Posted August 7, 2008 Report Share Posted August 7, 2008 Well glad it fixed itself - I imagine he server load and something they did on their end got out of whack and then got back to where it should have been, happens, just glad I'm not the one screaming at the screen right now. Quote Link to comment Share on other sites More sharing options...
Keltheos Posted August 7, 2008 Report Share Posted August 7, 2008 Well glad it fixed itself - I imagine he server load and something they did on their end got out of whack and then got back to where it should have been, happens, just glad I'm not the one screaming at the screen right now. You'd really be frustrated then, huh? hawr hawr hawr Quote Link to comment Share on other sites More sharing options...
TheBugKing Posted August 8, 2008 Report Share Posted August 8, 2008 You'd really be frustrated then, huh? hawr hawr hawr OWW! My eye! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.