SELECT * FROM sf_guard_user AS u
INNER JOIN sf_guard_user_profile AS p ON u.id = p.user_id
WHERE p.validate = '>your validation code here<';

$sfGuardUser = Doctrine_Query::create()
->from("sfGuardUser u")
->innerJoin("u.Profile p )->where('p.validate = ?", $validate)
->fetchOne();

SELECT * FROM sf_guard_user s INNER JOIN sf_guard_user_profile s2 ON s.id = s2.user_id AND (s2.validate = 'YOUR_VALIDATE_CODE')

500 | Internal Server Error | Doctrine_Table_Exception
Unknown relation alias Profile

sfGuardUserProfile:
  inheritance:
    type: simple
    extends: sfGuardUserProfileBasis
  # Don't forget this!
  relations:
    User:
      class: sfGuardUser
      foreign: id
      local: user_id
      type: one
      onDelete: cascade
      foreignType: one
      foreignAlias: Profile

Unknown column validate

# at Doctrine_Query->fetchOne()
in SF_ROOT_DIR/plugins/sfForkedDoctrineApplyPlugin/lib/action/sfApplyActionsLibrary.class.php line 151 ...
#     $sfGuardUser = Doctrine_Query::create()
#         ->from("sfGuardUser u")
#         ->innerJoin("u.Profile p with p.validate = ?", $validate)
#         ->fetchOne();

./symphony doctrine:generate-migrations-diff
//I review migrations then
./symphony doctrine:migrate
./symphony doctrine:build --all-classes
./symphony cc

Fatal error: Class 'sfValidatorNotDefault' not found in /opt/lampp/htdocs/unfuddle2/hcnfresco/lib/form/doctrine/sfApplyApplyForm.class.php on line 123

The "sfGuardUserProfile" model has to "SfGuardUser" relation.