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.
