Magento – Product images dissappear after re-index

So I actually solved the problem so I figured it would be helpful for others to know the answer:

Firstly, I backed up and restored the production database to my local. I then looked up the attribute (ID 159) and found its model. I learned it was "Varchar"

Then I searched the database for that ID

SELECT * FROM catalog_product_entity_varchar where attribute_id = 159;

I then found the entity ID 9243 (So I could have just did a query for both)

The value was something like this '555,369,555'

I grabbed the value_id and removed the row (on my test system)

delete FROM catalog_product_entity_varchar where value_id = 1134979;

I then re-indexed and it worked!

Looking at Mage_Catalog_Helper_Image->resize

/**
 * Schedule resize of the image
 * $width *or* $height can be null - in this case, lacking dimension will be calculated.
 *
 * @see Mage_Catalog_Model_Product_Image
 * @param int $width
 * @param int $height
 * @return Mage_Catalog_Helper_Image
 */
public function resize($width, $height = null)
{
    $this->_getModel()->setWidth($width)->setHeight($height);
    $this->_scheduleResize = true;
    return $this;
}

So resize by ->keepFrame(true)->resize(null, 300)