INVALID SQL: 1176 : Key 'am' doesn't exist in table 'xcart_categories'
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.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, IF(xcart_images_C.id IS NOT NULL, 'Y', '') as is_icon, xcart_images_C.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_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','0') 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, xcart_categories.category
Adaxial Technology Solutions :: Log In
adaxialts.com home shopping cart home view cart contact us
Adaxial Technology Solutions - Home
Product Search
Adaxial Technology Solutions :: Log In

If you already have an account, you can authenticate yourself by filling in the form below. The fields marked with * are mandatory.

Log In
Login *
Password *
 
 
Submit
Recover password

If you do not have an account, you can easily
register here  
 

Log In
Your Cart
View Cart Items: 0
Total: $0.00


» Wish list
» Orders history

News
No news available at the moment

Your email:

Subscribe 

Contact us  |  Privacy statement |  Terms & Conditions
Copyright © 2004-2010 Adaxial Technology Solutions