You should really use one of YAML, XML or Annotation drivers - the PHP driver is supposed to be used by very experienced users with very custom use cases
Marco Pivetta http://twitter.com/Ocramius http://ocramius.github.com/ On 1 February 2014 21:26, Parsifal <[email protected]> wrote: > > Thanks a lot, I was to auto-generate PHP metadata in /src folder. Here is > my bootstrap.php file: > > require_once "vendor/autoload.php"; > use Doctrine\ORM\Tools\Setup; > use Doctrine\ORM\EntityManager; > $paths = array(__DIR__."/src"); > $isDevMode = false; > // the connection configuration > $dbParams = array( > 'driver' => 'pdo_mysql', > 'host' => 'localhost', > 'user' => 'MY_DB_USER', > 'password' => 'MY_DB_PASS', > > 'dbname' => 'MY_DB_NAME', > ); > $evm = new Doctrine\Common\EventManager; > // Table Prefix > $db_prefix = "prefix_"; > $tablePrefix = new Doctrine\ORM\DoctrineExtensions\TablePrefix($db_prefix); > $evm->addEventListener(Doctrine\ORM\Events::loadClassMetadata, > $tablePrefix); > $config = Setup::createAnnotationMetadataConfiguration($paths, $isDevMode); > $em = Doctrine\ORM\EntityManager::create($dbParams, $config, $evm); > $platform = $em->getConnection()->getDatabasePlatform(); > $platform->registerDoctrineTypeMapping('enum', 'string'); > $platform->registerDoctrineTypeMapping('set', 'string'); > $driver = new Doctrine\ORM\Mapping\Driver\PHPDriver('src'); > $em->getConfiguration()->setMetadataDriverImpl($driver); > 1) As I am using PHP metadata and NOT Annotated metadata, I should change > the $config like above to what? (I mean: > createAnnotationMetadataConfiguration, as you noticed I am using > PHPDriver above.) > > == > Here is my test.php to just run a simple query: > > require_once "bootstrap.php"; > $qb = $em->createQueryBuilder(); > $qb->select('*') > ->from('clients',''); > $query = $qb->getQuery(); > // Execute Query > $result = $query->getResult(); > //$single = $query->getSingleResult(); > //$array = $query->getArrayResult(); > //$scalar = $query->getScalarResult(); > //$singleScalar = $query->getSingleScalarResult(); > > 2) but for any execute commands above I get the following errors, what > should I do to fix it? > > Fatal error: Uncaught exception 'Doctrine\ORM\Query\QueryException' with > message 'SELECT * FROM clients ' in > /home2/[edited]/composer/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php:41 > Stack trace: > #0 > /home2/[edited]/composer/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(448): > Doctrine\ORM\Query\QueryException::dqlError('SELECT * FROM p...') > #1 > /home2/[edited]/composer/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2167): > Doctrine\ORM\Query\Parser->syntaxError('IdentificationV...', Array) > #2 > /home2/[edited]/composer/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(1158): > Doctrine\ORM\Query\Parser->SelectExpression() > #3 > /home2/[edited]/composer/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(874): > Doctrine\ORM\Query\Parser->SelectClause() > #4 > /home2/[edited]/composer/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(843): > Doctrine\ORM\Query\Parser->SelectStatement() > #5 > /home2/[edited]/composer/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(268): > Doctrine\ORM\Qu in > /home2/[edited]/composer/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php > on line 52 > > -- > You received this message because you are subscribed to the Google Groups > "doctrine-user" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/doctrine-user. > For more options, visit https://groups.google.com/groups/opt_out. > -- You received this message because you are subscribed to the Google Groups "doctrine-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/doctrine-user. For more options, visit https://groups.google.com/groups/opt_out.
