In category view, products do not show images and are out of stock

Properties ID: 000016
Filed under:
For Magento 1.3.x run this query:
UPDATE eav_attribute SET used_in_product_listing=1 
WHERE entity_type_id IN (
  SELECT entity_type_id FROM eav_entity_type 
  WHERE entity_type_code='catalog_product'
) AND attribute_code IN (
  'name', 'description', 'short_description', 
  'price', 'special_price', 'special_from_date', 'special_to_date', 
  'image', 'small_image', 'thumbnail', 
  'status', 'tax_class_id', 'url_key', 'required_options', 
  'price_type', 'weight_type', 'price_view', 'shipment_type', 
  'image_label', 'small_image_label', 'thumbnail_label'
); 
For Magento 1.4.x run this query:
UPDATE catalog_eav_attribute SET used_in_product_listing=1 
WHERE attribute_id IN (
  SELECT attribute_id FROM eav_attribute 
  INNER JOIN eav_entity_type USING(entity_type_id) 
  WHERE entity_type_code='catalog_product' AND attribute_code IN (
    'name', 'description', 'short_description', 
    'price', 'special_price', 'special_from_date', 'special_to_date', 
    'image', 'small_image', 'thumbnail', 
    'status', 'tax_class_id', 'url_key', 'required_options', 
    'price_type', 'weight_type', 'price_view', 'shipment_type', 
    'image_label', 'small_image_label', 'thumbnail_label'
  )
); 
Refresh Magento cache.