Hello,
I have used the console command "php app\console doctrine:schema:create"
for automatically creating my database schema out of my annotated class
"Wish" in Mysql.
The command creates a correct table with the name "wish", it uses
lower-case letters at the beginning. On my local dev machine with Win7
and Xampp this works great, but on my shared hosting provider's Mysql I
receive then the following error message from Symfony2(PDOException):
"Base table or view not found: 1146 Table 'mydatabase_name.Wish' doesn't
exist"
Because the system of the provider is a unix system, Mysql handles the
table names in a case-sensitive manner. When I change then the name of
the table to "Wish"(with upper-case letter) it works.
My Doctrine orm query looks like that:
"SELECT w FROM MyBundle\Entity\Wish w ORDER BY w.id DESC'"
I have tried then to use the "Table"-annotation for defining the table
name: "@orm:Table(name="Wish")"
But the doctrine console command always creates lower-case table names.
Is there a possibility to configure Doctrine to generate SQL queries
with lower-case table names? Because the generated Doctrine SQL query
refers to the table "Wish" and the doctrine console
command(doctrine:schema:create) generates the table with "wish" as name
and this then doesn't work on my shared hosting provider with unix system.
The annotated class looks like that:
/**
* @orm:Entity
*/
class Wish
{
/**
* @orm:Id
* @orm:Column(type="integer")
* @orm:GeneratedValue(strategy="AUTO")
*/
protected $id;
/**
* @orm:Column(type="string", length="128")
*/
protected $title;
....
Thanks for your help!
greets,
Oli
--
If you want to report a vulnerability issue on symfony, please send it to
security at symfony-project.com
You received this message because you are subscribed to the Google
Groups "symfony users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
