Hi. I'm on a Unix like machine (Fedora Linux) and I never ran into that problem. I would say it is some sort of Doctrine bug. You should post on a Doctrine mailing list; they should know more about it.
2011/3/2 Gustavo Adrian <[email protected]> > 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 > -- 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
