SQL Error SELECT /* ProductSearch */ product.CLASS_KEY, product.ID, product.PROPERTY_SET_ID, product.NAME, product.SUMMARY, product.TAGLINE, product.DESCRIPTION, product.VISIBLE, product.FEATURED, product.POPULAR, product.DEFAULT_VARIANT_ID, product.DEFAULT_PRICE, product.PRODUCT_AVAILABLE, product.PRODUCT_IN_STOCK, product.PRODUCT_ON_OFFER, product.PER_VARIANT_IMAGES, product.BEST_PRICE, product.EXTRA_PRODUCT_INFO, product.ONE_PRICING, product.ONE_AVAILABILITY, product.ONE_DELIVERY, product.ONE_BUNDLE, product.ONE_STOCK, product.ONE_OPTION_SET, product.PROPORTIONAL_PRICING, product.PRODUCT_PROPORTIONAL_PRICING_ID, product.BUNDLE_POLICY_ID, product.META_DATA_ID, product.WISHES, product.LIKES, product.RATING, product.SLUG, product.LATITUDE, product.LONGITUDE, product.MAP_ICON, product.CREATED_AT, product.CREATED_BY, product.UPDATED_AT, product.UPDATED_BY, product_variant.ID, product_variant.CLASS_KEY, product_variant.PRODUCT_ID, product_variant.VARIANT_IMAGE_ID, product_variant.AVAILABLE, product_variant.FOR_SALE_FROM, product_variant.DISCONTINUED_AT, product_variant.IN_STORE_ONLY, product_variant.PRICE, product_variant.ON_OFFER, product_variant.ORIGINAL_PRICE, product_variant.CURRENCY, product_variant.VAT_RATE_ID, product_variant.COST_PRICE, product_variant.BEST_PRICES, product_variant.EXTRA_VARIANT_INFO, product_variant.SKU, product_variant.STOCK_MANAGEMENT, product_variant.SUPPLIER_PACK_SIZE, product_variant.LOW_STOCK_THRESHOLD, product_variant.AVAILABLE_TO_BACK_ORDER, product_variant.BACK_ORDER_MESSAGE, product_variant.STOCK, product_variant.HEIGHT, product_variant.LENGTH, product_variant.WIDTH, product_variant.WEIGHT, product_variant.FRAGILE, product_variant.PERISHABLE, product_variant.HAZARDOUS, product_variant.BUNDLE_UNITS, product_variant.DELIVERY_SURCHARGE, product_variant.DELIVERY_CLASS_ID, product_variant.SORTABLE_RANK, product_variant.SLUG, product_variant.CREATED_AT, product_variant.CREATED_BY, product_variant.UPDATED_AT, product_variant.UPDATED_BY, product_image.ID, product_image.TITLE, product_image.PRODUCT_ID, product_image.IMAGE_ID, product_image.SORTABLE_RANK, product_image.SLUG, product_image.CREATED_AT, product_image.CREATED_BY, product_image.UPDATED_AT, product_image.UPDATED_BY, image.ID, image.ASSET_ID, image.TITLE, image.WIDTH, image.HEIGHT, image.LIBRARY, image.SOURCE_ID, image.OBJ_CLASS, image.OBJ_ID, image.SIZES, image.MIME_TYPE, image.IMAGE_TYPE, image.FILE_EXTENSION, image.EXIF_DATA, image.TAKEN_AT, image.ORIGINAL_FILENAME, image.LATITUDE, image.LONGITUDE, image.MAP_ICON, image.SLUG, image.CREATED_AT, image.CREATED_BY, image.UPDATED_AT, image.UPDATED_BY FROM `product` CROSS JOIN (SELECT product.CLASS_KEY, product.ID, product.PROPERTY_SET_ID, product.NAME, product.SUMMARY, product.TAGLINE, product.DESCRIPTION, product.VISIBLE, product.FEATURED, product.POPULAR, product.DEFAULT_VARIANT_ID, product.DEFAULT_PRICE, product.PRODUCT_AVAILABLE, product.PRODUCT_IN_STOCK, product.PRODUCT_ON_OFFER, product.PER_VARIANT_IMAGES, product.BEST_PRICE, product.EXTRA_PRODUCT_INFO, product.ONE_PRICING, product.ONE_AVAILABILITY, product.ONE_DELIVERY, product.ONE_BUNDLE, product.ONE_STOCK, product.ONE_OPTION_SET, product.PROPORTIONAL_PRICING, product.PRODUCT_PROPORTIONAL_PRICING_ID, product.BUNDLE_POLICY_ID, product.META_DATA_ID, product.WISHES, product.LIKES, product.RATING, product.SLUG, product.LATITUDE, product.LONGITUDE, product.MAP_ICON, product.CREATED_AT, product.CREATED_BY, product.UPDATED_AT, product.UPDATED_BY, 1 AS Rank FROM `product` INNER JOIN `product_category` `allCat_absorbent_pad` ON (product.ID=allCat_absorbent_pad.PRODUCT_ID) INNER JOIN `product_category` `allCat_low_melting_point` ON (product.ID=allCat_low_melting_point.PRODUCT_ID) WHERE product.VISIBLE=:p1 AND allCat_absorbent_pad.CATEGORY_ID = 84 AND allCat_low_melting_point.CATEGORY_ID = 27 GROUP BY product.ID ORDER BY product.NAME ASC LIMIT 18) AS foundProduct LEFT JOIN `product_variant` ON (product.ID=product_variant.PRODUCT_ID) LEFT JOIN `product_image` ON (product.ID=product_image.PRODUCT_ID) LEFT JOIN `image` ON (product_image.IMAGE_ID=image.ID) WHERE product.ID = foundProduct.ID
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1030 Got error 28 from storage engine' in /home/indicoll/public_html/indicoll_crm/v5/lib/propel/runtime/lib/query/ModelCriteria.php:1253 Stack trace: #0 /home/indicoll/public_html/indicoll_crm/v5/lib/propel/runtime/lib/query/ModelCriteria.php(1253): PDOStatement->execute() #1 /home/indicoll/public_html/indicoll_crm/v5/lib/propel/runtime/lib/query/ModelCriteria.php(1125): ModelCriteria->getSelectStatement(NULL) #2 /home/indicoll/public_html/indicoll_crm/v5/lib/ProductSearch.php(587): ModelCriteria->find() #3 /home/indicoll/public_html/indicoll_crm/v5/lib/ProductSearch.php(571): ProductSearch->populateResults() #4 /home/indicoll/public_html/indicoll_crm/v5/lib/ProductSearch.php(201): ProductSearch->buildQuery() #5 /home/indicoll/public_html/snef/swm/app/controllers/main.php(94): ProductSearch->init('category-all/ab...') #6 [internal function]: main->product_finder('61') #7 /home/indicoll/public_html/indicoll_crm/v5/lib/Router.php(28 in /home/indicoll/public_html/indicoll_crm/v5/lib/propel/runtime/lib/query/ModelCriteria.php on line 1261