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 'WHERE survey_type != 'D'' at line 1 SQL QUERY FAILURE:SELECT surveyid FROM WHERE survey_type != 'D' INVALID SQL: 1054 : Unknown column 'xcart_countries.charset' in 'field list' SQL QUERY FAILURE:SELECT xcart_languages.code, xcart_countries.charset FROM xcart_languages, xcart_countries WHERE xcart_languages.code = xcart_countries.code GROUP BY xcart_languages.code INVALID SQL: 1146 : Table 'shop_dev_upgrade.xcart_images_c' 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.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='en' 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