INVALID SQL: 1176 : Key 'protocol' doesn't exist in table 'xcart_payment_methods'
SQL QUERY FAILURE: SELECT paymentid FROM xcart_payment_methods USE INDEX (protocol) WHERE protocol = 'https'

Warning: Cannot modify header information - headers already sent by (output started at /hermes/bosweb/web065/b657/ipw.i9stores/public_html/shop/include/func.ph in /hermes/bosweb/web065/b657/ipw.i9stores/public_html/shop/referer.php on line 61

Warning: Cannot modify header information - headers already sent by (output started at /hermes/bosweb/web065/b657/ipw.i9stores/public_html/shop/include/func.ph in /hermes/bosweb/web065/b657/ipw.i9stores/public_html/shop/include/get_language.php on line 126

Warning: Cannot modify header information - headers already sent by (output started at /hermes/bosweb/web065/b657/ipw.i9stores/public_html/shop/include/func.ph in /hermes/bosweb/web065/b657/ipw.i9stores/public_html/shop/include/get_language.php on line 127

Warning: Cannot modify header information - headers already sent by (output started at /hermes/bosweb/web065/b657/ipw.i9stores/public_html/shop/include/func.ph in /hermes/bosweb/web065/b657/ipw.i9stores/public_html/shop/include/get_language.php on line 132

Warning: Cannot modify header information - headers already sent by (output started at /hermes/bosweb/web065/b657/ipw.i9stores/public_html/shop/include/func.ph in /hermes/bosweb/web065/b657/ipw.i9stores/public_html/shop/include/get_language.php on line 133
INVALID SQL: 1176 : Key 'code' doesn't exist in table 'xcart_languages'
SQL QUERY FAILURE: SELECT xcart_languages.code, xcart_countries.*, lng_c.value as country, lng_l.value as language FROM xcart_languages USE INDEX (code), xcart_countries, xcart_languages as lng_c, xcart_languages as lng_l WHERE lng_c.name = CONCAT('country_', xcart_countries.code) AND lng_c.code = 'US' AND lng_l.code = 'US' AND lng_l.name = CONCAT('language_', xcart_countries.code) AND xcart_languages.code=xcart_countries.code GROUP BY xcart_languages.code ORDER BY xcart_languages.code
INVALID SQL: 1176 : Key 'code' doesn't exist in table 'xcart_languages'
SQL QUERY FAILURE: SELECT xcart_languages.code, xcart_countries.*, lng_c.value as country, lng_l.value as language FROM xcart_languages USE INDEX (code), xcart_countries, xcart_languages as lng_c, xcart_languages as lng_l WHERE lng_c.name = CONCAT('country_', xcart_countries.code) AND lng_c.code = 'US' AND lng_l.code = 'US' AND lng_l.name = CONCAT('language_', xcart_countries.code) AND xcart_languages.code=xcart_countries.code GROUP BY xcart_languages.code ORDER BY xcart_languages.code
INVALID SQL: 1176 : Key 'code' doesn't exist in table 'xcart_languages'
SQL QUERY FAILURE: SELECT xcart_languages.code, xcart_countries.*, lng_c.value as country, lng_l.value as language FROM xcart_languages USE INDEX (code), xcart_countries, xcart_languages as lng_c, xcart_languages as lng_l WHERE lng_c.name = CONCAT('country_', xcart_countries.code) AND lng_c.code = 'DE' AND lng_l.code = 'DE' AND lng_l.name = CONCAT('language_', xcart_countries.code) AND xcart_languages.code=xcart_countries.code GROUP BY xcart_languages.code ORDER BY xcart_languages.code
INVALID SQL: 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND avail='N'' at line 1
SQL QUERY FAILURE: SELECT COUNT(*) FROM xcart_categories USE INDEX (ia) WHERE categoryid IN () AND avail='N'
INVALID SQL: 1146 : Table 'i9stores_xcart.xcart_categories_subcount' doesn't exist
SQL QUERY FAILURE: SELECT subcategory_count FROM xcart_categories_subcount WHERE categoryid='305' AND membership = ''
INVALID SQL: 1146 : Table 'i9stores_xcart.xcart_categories_subcount' doesn't exist
SQL QUERY FAILURE: SELECT xcart_categories.categoryid,xcart_categories.parentid,xcart_categories.categoryid_path,xcart_categories.category,xcart_categories.product_count,xcart_categories.avail,xcart_categories.order_by,IF(xcart_categories_lng.category != '', xcart_categories_lng.category, xcart_categories.category) as category,xcart_categories_subcount.subcategory_count, xcart_categories_subcount.product_count,IF(xcart_icons.image != '','Y','') as is_icon, xcart_icons.image_path 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_categories_subcount USE INDEX (PRIMARY) ON xcart_categories_subcount.categoryid = xcart_categories.categoryid AND xcart_categories_subcount.membership = xcart_categories.membership LEFT JOIN xcart_icons ON xcart_categories.categoryid = xcart_icons.categoryid WHERE xcart_categories.avail='Y' AND xcart_categories.membership IN('', '') GROUP BY xcart_categories.categoryid ORDER BY xcart_categories.order_by, xcart_categories.category
INVALID SQL: 1146 : Table 'i9stores_xcart.xcart_products_categories' doesn't exist
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 = 'US' 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='305' 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

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /hermes/bosweb/web065/b657/ipw.i9stores/public_html/shop/include/func.php on line 102
INVALID SQL: 1146 : Table 'i9stores_xcart.xcart_products_categories' doesn't exist
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, 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_products_categories, xcart_categories LEFT JOIN xcart_products_lng ON xcart_products_lng.productid = xcart_products.productid AND xcart_products_lng.code = 'US' 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_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_categories.categoryid='305' 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 /hermes/bosweb/web065/b657/ipw.i9stores/public_html/shop/include/func.php on line 102
:: 9Stores.com
9Stores Header.jpg
Rebel T-Shirt Store
Replica Gun Store
Airsoft Gun Store
Blank Guns Store
Rebel Stuff Store
Civil War Store
Flags Store
Pirate Costume Store
Pool Cue Store
Product Search:      Advanced search   
HOME | MY ACCOUNT | HELP | CONTACT US | LINKS  
 
     9 Great Stores


     Authentication
Secure login
Register
Recover password

If you have disabled Javascript in your browser click here


     Your cart
Cart is empty

View cart
Checkout


     Help
Contact us
Privacy statement
Terms & Conditions


9Stores.com Logo.jpg


146 Brighton Circle
Brunswick, Ga. 31525
Toll Free Phone:
(866) 314-0791

Email Us







 
9Stores.com :: 

  Civil War Store/Civil War Uniforms
There are no available products under this category.  
 

 

© 2004-2010 9Stores.com