Repairing table ...145 : Table './legendar_432/xcart_products' is marked as crashed and should be repaired
INVALID SQL: 145 : Table './legendar_432/xcart_products' is marked as crashed and should be repaired
SQL QUERY FAILURE:SELECT forsale FROM xcart_products WHERE productid='205'
Repairing table ...145 : Table './legendar_432/xcart_products' is marked as crashed and should be repaired
INVALID SQL: 145 : Table './legendar_432/xcart_products' is marked as crashed and should be repaired
SQL QUERY FAILURE:SELECT xcart_products.*, xcart_products.avail-0 AS avail, MIN(xcart_pricing.price) as price , IF(xcart_products_lng.product != '' AND xcart_products_lng.product IS NOT NULL, xcart_products_lng.product, xcart_products.product) as product, IF(xcart_products_lng.descr != '' AND xcart_products_lng.descr IS NOT NULL, xcart_products_lng.descr, xcart_products.descr) as descr, IF(xcart_products_lng.fulldescr != '' AND xcart_products_lng.fulldescr IS NOT NULL, xcart_products_lng.fulldescr, xcart_products.fulldescr) as fulldescr, xcart_quick_flags.*, xcart_quick_prices.variantid, xcart_quick_prices.priceid, xcart_clean_urls.clean_url, xcart_clean_urls.mtime FROM xcart_pricing, xcart_products LEFT JOIN xcart_products_lng ON xcart_products_lng.code='en' AND xcart_products_lng.productid = xcart_products.productid LEFT JOIN xcart_quick_prices ON xcart_products.productid = xcart_quick_prices.productid AND xcart_quick_prices.membershipid = '0' LEFT JOIN xcart_quick_flags ON xcart_products.productid = xcart_quick_flags.productid LEFT JOIN xcart_product_memberships ON xcart_product_memberships.productid = xcart_products.productid LEFT JOIN xcart_clean_urls ON xcart_clean_urls.resource_type = 'P' AND xcart_clean_urls.resource_id = xcart_products.productid WHERE xcart_products.productid='205' AND xcart_products.product_type <> 'C' AND xcart_products.forsale <> 'B' AND (xcart_product_memberships.membershipid = '0' OR xcart_product_memberships.membershipid IS NULL) AND xcart_quick_prices.membershipid = '0' AND xcart_quick_prices.priceid = xcart_pricing.priceid GROUP BY xcart_products.productid
Repairing table ...145 : Table './legendar_432/xcart_products' is marked as crashed and should be repaired
INVALID SQL: 145 : Table './legendar_432/xcart_products' is marked as crashed and should be repaired
SQL QUERY FAILURE:SELECT xcart_products.productid, xcart_products.provider, IF(xcart_products_lng.productid != '', xcart_products_lng.product, xcart_products.product) as product, xcart_products.productcode, xcart_products.avail, xcart_pricing.price, xcart_quick_prices.variantid, 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, IF(xcart_classes.classid IS NULL,'','Y') as is_product_options, IF(xcart_variants.variantid IS NULL,'','Y') as is_variant, xcart_product_taxes.taxid FROM xcart_product_links, xcart_pricing, xcart_products LEFT JOIN xcart_products_lng ON xcart_products.productid = xcart_products_lng.productid AND code = 'en' LEFT JOIN xcart_quick_prices ON xcart_quick_prices.productid = xcart_products.productid AND xcart_quick_prices.membershipid = '0' LEFT JOIN xcart_product_memberships ON xcart_product_memberships.productid = xcart_products.productid LEFT JOIN xcart_classes ON xcart_classes.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid AND xcart_quick_prices.variantid = xcart_variants.variantid LEFT JOIN xcart_product_taxes ON xcart_product_taxes.productid = xcart_products.productid INNER JOIN xcart_products_categories ON xcart_products_categories.productid = xcart_products.productid INNER JOIN xcart_categories ON xcart_categories.categoryid = xcart_products_categories.categoryid AND xcart_categories.avail = 'Y' LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = xcart_categories.categoryid WHERE (xcart_category_memberships.membershipid = '' OR xcart_category_memberships.membershipid IS NULL) AND xcart_products.forsale='Y' AND (xcart_product_memberships.membershipid = '' OR xcart_product_memberships.membershipid IS NULL) AND xcart_quick_prices.priceid = xcart_pricing.priceid AND xcart_products.productid = xcart_products_categories.productid AND xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_products.productid = xcart_pricing.productid AND xcart_pricing.quantity = '1' AND xcart_pricing.membershipid = '0' AND xcart_products.product_type <> 'C' AND xcart_products.forsale <> 'B' AND (xcart_pricing.variantid = '0' OR xcart_variants.variantid = xcart_pricing.variantid) AND (IFNULL(xcart_variants.avail, xcart_products.avail) > '0' OR xcart_products.product_type NOT IN ('','N')) AND xcart_products.productid = xcart_product_links.productid2 AND xcart_product_links.productid1 = '205' GROUP BY xcart_products.productid ORDER BY xcart_product_links.orderby, product
Repairing table ...145 : Table './legendar_432/xcart_products' is marked as crashed and should be repaired
INVALID SQL: 145 : Table './legendar_432/xcart_products' is marked as crashed and should be repaired
SQL QUERY FAILURE:UPDATE xcart_products SET views_stats = (views_stats + 1) WHERE productid='205'


If the page is not updated in 2 seconds, please follow this link: continue >>