Want to fix deploy_manager_entities data for the bean module after upgrading to 1.2 or 1.4? Try this query.

fix-bean-deploy_manager_entities.sql

UPDATE deploy_manager_entities dme
  JOIN (
    SELECT br.bid, MAX(br.vid) max_vid 
    FROM bean_revision br 
    INNER JOIN deploy_manager_entities dme
      ON br.bid = dme.entity_id
    GROUP BY br.bid
  ) b
    ON b.bid = dme.entity_id
SET dme.revision_id = b.max_vid
WHERE dme.entity_type = 'bean';