View Single Post
  #25  
Old 11-10-2004, 02:27 PM
 
GM GM is offline
 

eXpert
  
Join Date: Mar 2004
Location: Canada
Posts: 293
 

Default

Ok this is a new one... I go to my store and it's empty?

with this error:
Code:
INVALID SQL: 1030 : Got error 28 from table handler SQL QUERY FAILURE: SELECT xcart_products.*, MIN(xcart_pricing.price) as price, price as taxed_price , xcart_products_lng.product as product_lng, xcart_products_lng.descr as descr_lng, xcart_products_lng.full_descr as fulldescr_lng FROM xcart_products, xcart_pricing , xcart_featured_products, xcart_products_categories LEFT JOIN xcart_products_lng ON xcart_products_lng.productid = xcart_products.productid AND xcart_products_lng.code = 'US' WHERE xcart_products.productid=xcart_featured_products.productid AND xcart_featured_products.avail='Y' AND xcart_featured_products.categoryid='0' AND xcart_pricing.productid=xcart_products.productid AND xcart_pricing.quantity=1 AND xcart_pricing.variantid = 0 AND xcart_pricing.membership IN ('','') AND xcart_products.forsale='Y' AND xcart_products_categories.productid=xcart_products.productid AND (xcart_products.avail>0 OR xcart_products.product_type NOT IN ('','N')) GROUP BY xcart_products.productid ORDER BY xcart_featured_products.product_order LIMIT 0, 6

Is this a hack or what?
[Update] O.K. it's not the software it was a hack attempt, problem solved.[/Update]
__________________
v. 4.0.14 (GM Style)
O.S. Linux
Build Your Own Diamond Ring
Reply With Quote