INVALID SQL: 5 : Out of memory (Needed 2093064 bytes)
SQL QUERY FAILURE:SELECT usertype, COUNT(*) as count, is_registered FROM xcart_users_online WHERE IF(usertype = 'C', 'Y', is_registered) = 'Y' AND usertype = 'C' GROUP BY usertype, IF(usertype = 'C', is_registered, '')
Warning: Cannot modify header information - headers already sent by (output started at /home/marinesu/public_html/include/func/func.db.php:215) in /home/marinesu/public_html/include/get_language.php on line 166
Warning: Cannot modify header information - headers already sent by (output started at /home/marinesu/public_html/include/func/func.db.php:215) in /home/marinesu/public_html/include/func/func.core.php on line 1858
INVALID SQL: 5 : Out of memory (Needed 1680480 bytes)
SQL QUERY FAILURE:SELECT xcart_categories.categoryid as cid, xcart_categories.categoryid, xcart_categories.parentid, xcart_categories.categoryid_path, xcart_categories.category, xcart_categories.avail, xcart_categories.order_by, IF(xcart_categories_lng.categoryid IS NOT NULL AND xcart_categories_lng.category != '', xcart_categories_lng.category, xcart_categories.category) as category, xcart_categories_subcount.subcategory_count, xcart_categories_subcount.product_count, xcart_images_C.image_path, xcart_images_C.image_x, xcart_images_C.image_y FROM xcart_categories USE INDEX (am) LEFT JOIN xcart_categories_lng USE INDEX (PRIMARY) ON xcart_categories_lng.code='US' AND xcart_categories_lng.categoryid=xcart_categories.categoryid LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = xcart_categories.categoryid LEFT JOIN xcart_categories_subcount USE INDEX (PRIMARY) ON xcart_categories_subcount.categoryid = xcart_categories.categoryid AND xcart_categories_subcount.membershipid = '' LEFT JOIN xcart_images_C ON xcart_categories.categoryid = xcart_images_C.id WHERE xcart_categories.parentid IN ('0','2019') AND xcart_categories.avail ='Y' AND (xcart_category_memberships.membershipid IS NULL OR xcart_category_memberships.membershipid = '') GROUP BY xcart_categories.categoryid ORDER BY xcart_categories.order_by, category
INVALID SQL: 5 : Out of memory (Needed 2064880 bytes)
SQL QUERY FAILURE:SELECT COUNT(xcart_products.productid) FROM xcart_products LEFT JOIN xcart_quick_flags ON xcart_quick_flags.productid = xcart_products.productid LEFT JOIN xcart_products_categories ON xcart_products_categories.productid = xcart_products.productid LEFT JOIN xcart_categories ON xcart_products_categories.categoryid = xcart_categories.categoryid LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = xcart_categories.categoryid LEFT JOIN xcart_product_memberships ON xcart_product_memberships.productid = xcart_products.productid LEFT JOIN xcart_product_votes ON xcart_product_votes.productid = xcart_products.productid INNER JOIN xcart_pricing ON xcart_pricing.productid = xcart_products.productid AND xcart_pricing.membershipid = '0' LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid AND xcart_pricing.variantid = xcart_variants.variantid WHERE 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 in ('Y', 'H') AND xcart_products_categories.categoryid='2019' AND (xcart_products_categories.main='Y' OR xcart_products_categories.main!='Y') AND (xcart_products.forsale = 'Y' ) GROUP BY xcart_products.productid
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/marinesu/public_html/include/func/func.db.php on line 171
INVALID SQL: 5 : Out of memory (Needed 1680200 bytes)
SQL QUERY FAILURE:SELECT xcart_products.productid, xcart_products.provider, xcart_products.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_images_T.image_path FROM xcart_pricing, xcart_products 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_images_T ON xcart_images_T.id = 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 = '0' OR xcart_category_memberships.membershipid IS NULL) AND xcart_products.forsale='Y' AND (xcart_product_memberships.membershipid = '0' 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 xcart_products_categories.categoryid IN ('2019') AND xcart_products.sales_stats >= '1' GROUP BY xcart_products.productid ORDER BY xcart_products.sales_stats DESC, xcart_products.views_stats DESC LIMIT 3
Shakespeare Antenna on sale, ready to ship at MarineSupplyDock.com
Home - Shakespeare - Shakespeare Antenna

There are no available products under this category.
image top
image bottom