INVALID SQL: 145 : Table './xcart2/xcart_sessions_data' is marked as crashed and should be repaired SQL QUERY FAILURE: SELECT count(*) FROM xcart_sessions_data WHERE sessid='b8b1797aa451901bfb5f051dee163463' INVALID SQL: 145 : Table './xcart2/xcart_sessions_data' is marked as crashed and should be repaired SQL QUERY FAILURE: DELETE FROM xcart_sessions_data WHERE expiry<'1327747991' INVALID SQL: 145 : Table './xcart2/xcart_sessions_data' is marked as crashed and should be repaired SQL QUERY FAILURE: SELECT * FROM xcart_sessions_data WHERE sessid='b8b1797aa451901bfb5f051dee163463' INVALID SQL: 145 : Table './xcart2/xcart_sessions_data' is marked as crashed and should be repaired SQL QUERY FAILURE: REPLACE INTO xcart_sessions_data (sessid, start, expiry) VALUES('b8b1797aa451901bfb5f051dee163463', '1327747991', '1327751591') INVALID SQL: 145 : Table './xcart2/xcart_sessions_data' is marked as crashed and should be repaired SQL QUERY FAILURE: UPDATE xcart_sessions_data SET data='a:5:{s:11:\"editor_mode\";s:0:\"\";s:8:\"is_robot\";s:1:\"N\";s:5:\"robot\";s:0:\"\";s:11:\"is_location\";s:0:\"\";s:9:\"adaptives\";a:1:{s:14:\"is_first_start\";s:1:\"Y\";}}' WHERE sessid='b8b1797aa451901bfb5f051dee163463' INVALID SQL: 145 : Table './xcart2/xcart_sessions_data' is marked as crashed and should be repaired SQL QUERY FAILURE: UPDATE xcart_sessions_data SET data='a:19:{s:11:\"editor_mode\";s:0:\"\";s:8:\"is_robot\";s:1:\"N\";s:5:\"robot\";s:0:\"\";s:11:\"is_location\";s:0:\"\";s:9:\"adaptives\";a:1:{s:14:\"is_first_start\";s:1:\"Y\";}s:11:\"logout_user\";s:0:\"\";s:26:\"session_failed_transaction\";s:0:\"\";s:16:\"add_to_cart_time\";s:0:\"\";s:17:\"always_allow_shop\";s:0:\"\";s:4:\"wlid\";s:0:\"\";s:10:\"js_enabled\";s:1:\"Y\";s:11:\"top_message\";s:0:\"\";s:7:\"partner\";s:0:\"\";s:15:\"partner_clickid\";s:0:\"\";s:14:\"adv_campaignid\";s:0:\"\";s:15:\"referer_session\";b:0;s:5:\"login\";s:0:\"\";s:10:\"login_type\";s:0:\"\";s:6:\"logged\";s:0:\"\";}' WHERE sessid='b8b1797aa451901bfb5f051dee163463' INVALID SQL: 145 : Table './xcart2/xcart_sessions_data' is marked as crashed and should be repaired SQL QUERY FAILURE: UPDATE xcart_sessions_data SET data='a:25:{s:11:\"editor_mode\";s:0:\"\";s:8:\"is_robot\";s:1:\"N\";s:5:\"robot\";s:0:\"\";s:11:\"is_location\";s:0:\"\";s:9:\"adaptives\";a:1:{s:14:\"is_first_start\";s:1:\"Y\";}s:11:\"logout_user\";s:0:\"\";s:26:\"session_failed_transaction\";s:0:\"\";s:16:\"add_to_cart_time\";s:0:\"\";s:17:\"always_allow_shop\";s:0:\"\";s:4:\"wlid\";s:0:\"\";s:10:\"js_enabled\";s:1:\"Y\";s:11:\"top_message\";s:0:\"\";s:7:\"partner\";s:0:\"\";s:15:\"partner_clickid\";s:0:\"\";s:14:\"adv_campaignid\";s:0:\"\";s:15:\"referer_session\";b:0;s:5:\"login\";s:0:\"\";s:10:\"login_type\";s:0:\"\";s:6:\"logged\";s:0:\"\";s:4:\"cart\";s:0:\"\";s:12:\"stats_pageid\";s:1:\"2\";s:15:\"stats_page_time\";i:1327747991;s:18:\"stats_pages_string\";s:1:\"2\";s:19:\"stats_transactionid\";s:0:\"\";s:22:\"stats_transaction_step\";s:0:\"\";}' WHERE sessid='b8b1797aa451901bfb5f051dee163463' INVALID SQL: 1054 : Unknown column 'xcart_products.productid' in 'on clause' SQL QUERY FAILURE: SELECT COUNT(xcart_products.productid), MIN(xcart_pricing.price) as price , xcart_products_lng.product as product_lng, xcart_products_lng.descr as descr_lng, xcart_products_lng.full_descr as fulldescr_lng, IF(xcart_variants.variantid IS NOT NULL,'Y','') as is_variant, IF(xcart_classes.classid IS NOT NULL,'Y','') as is_product_options, MIN(v_pricing.price) as v_price FROM xcart_products, xcart_pricing , xcart_featured_products, xcart_products_categories, xcart_categories LEFT JOIN xcart_products_lng ON xcart_products_lng.productid = xcart_products.productid AND xcart_products_lng.code = 'AR' LEFT JOIN xcart_classes ON xcart_classes.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid LEFT JOIN xcart_pricing as v_pricing ON v_pricing.variantid = xcart_variants.variantid AND v_pricing.quantity = 1 AND v_pricing.membership IN ('','') 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.membership IN ('','') AND xcart_products.product_type <> 'C' AND xcart_products.product_type <> 'B' AND xcart_pricing.variantid = 0 AND xcart_products_categories.productid=xcart_products.productid AND xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_categories.membership IN ('','') AND xcart_products.forsale='Y' GROUP BY xcart_products.productid INVALID SQL: 145 : Table './xcart2/xcart_sessions_data' is marked as crashed and should be repaired SQL QUERY FAILURE: UPDATE xcart_sessions_data SET data='a:26:{s:11:\"editor_mode\";s:0:\"\";s:8:\"is_robot\";s:1:\"N\";s:5:\"robot\";s:0:\"\";s:11:\"is_location\";s:0:\"\";s:9:\"adaptives\";a:1:{s:14:\"is_first_start\";s:1:\"Y\";}s:11:\"logout_user\";s:0:\"\";s:26:\"session_failed_transaction\";s:0:\"\";s:16:\"add_to_cart_time\";s:0:\"\";s:17:\"always_allow_shop\";s:0:\"\";s:4:\"wlid\";s:0:\"\";s:10:\"js_enabled\";s:1:\"Y\";s:11:\"top_message\";s:0:\"\";s:7:\"partner\";s:0:\"\";s:15:\"partner_clickid\";s:0:\"\";s:14:\"adv_campaignid\";s:0:\"\";s:15:\"referer_session\";b:0;s:5:\"login\";s:0:\"\";s:10:\"login_type\";s:0:\"\";s:6:\"logged\";s:0:\"\";s:4:\"cart\";s:0:\"\";s:12:\"stats_pageid\";s:1:\"2\";s:15:\"stats_page_time\";i:1327747991;s:18:\"stats_pages_string\";s:1:\"2\";s:19:\"stats_transactionid\";s:0:\"\";s:22:\"stats_transaction_step\";s:0:\"\";s:11:\"search_data\";a:1:{s:8:\"products\";N;}}' WHERE sessid='b8b1797aa451901bfb5f051dee163463' INVALID SQL: 1054 : Unknown column 'xcart_products.productid' in 'on clause' SQL QUERY FAILURE: SELECT xcart_products.productid, xcart_products.product, xcart_products.productcode, xcart_products.avail, MIN(xcart_pricing.price) AS price, IF (xcart_classes.classid IS NULL,'','Y') as is_product_options, IF(xcart_variants.variantid IS NULL,'','Y') as is_variant FROM xcart_products, xcart_categories, xcart_products_categories, xcart_pricing LEFT JOIN xcart_classes ON xcart_classes.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid WHERE 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.membership='' OR xcart_pricing.membership='') AND (xcart_categories.membership='' OR xcart_categories.membership='') AND xcart_products.forsale='Y' AND xcart_pricing.variantid = 0 AND xcart_products.product_type <> 'C' AND xcart_products.product_type <> 'B' AND xcart_products.sales_stats>0 GROUP BY xcart_products.productid ORDER BY xcart_products.sales_stats DESC, xcart_products.views_stats DESC LIMIT 5
compras.com.mx
INVALID SQL: 145 : Table './xcart2/xcart_sessions_data' is marked as crashed and should be repaired SQL QUERY FAILURE: UPDATE xcart_sessions_data SET data='a:26:{s:11:\"editor_mode\";s:0:\"\";s:8:\"is_robot\";s:1:\"N\";s:5:\"robot\";s:0:\"\";s:11:\"is_location\";s:0:\"\";s:9:\"adaptives\";a:1:{s:14:\"is_first_start\";s:1:\"Y\";}s:11:\"logout_user\";s:0:\"\";s:26:\"session_failed_transaction\";s:0:\"\";s:16:\"add_to_cart_time\";s:0:\"\";s:17:\"always_allow_shop\";s:0:\"\";s:4:\"wlid\";s:0:\"\";s:10:\"js_enabled\";s:1:\"Y\";s:11:\"top_message\";s:0:\"\";s:7:\"partner\";s:0:\"\";s:15:\"partner_clickid\";s:0:\"\";s:14:\"adv_campaignid\";s:0:\"\";s:15:\"referer_session\";b:0;s:5:\"login\";s:0:\"\";s:10:\"login_type\";s:0:\"\";s:6:\"logged\";s:0:\"\";s:4:\"cart\";s:0:\"\";s:12:\"stats_pageid\";s:1:\"2\";s:15:\"stats_page_time\";i:1327747991;s:18:\"stats_pages_string\";s:1:\"2\";s:19:\"stats_transactionid\";s:0:\"\";s:22:\"stats_transaction_step\";s:0:\"\";s:11:\"search_data\";a:1:{s:8:\"products\";N;}}' WHERE sessid='b8b1797aa451901bfb5f051dee163463'