Did you tried to force the table name to have its name in lower case?: @orm:Table(name="wish")
On Tue, Mar 1, 2011 at 8:14 PM, olimination <[email protected]> wrote: > 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 > -- 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
