One problem is in your schema - there you have differents integer types - type: integer(4), integer - if you want to build a relationship you have to have the same integer types. (integer on both, or integer(4) or integer(8)...
On 1 čnc, 17:46, Shawn <electricbonf...@gmail.com> wrote: > After running through the Jobeet Tutorial i decided to try building my > own application. I created the yaml file for the data mapping and am > having some errors: > > when i run symfony doctrine:build --model: > Notice: Undefined index: class in /Users/shawn/Documents/work/sites/ > whatsup/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/ > doctrine/Doctrine/Import/Builder.php on line 672 > > Notice: Undefined index: alias in /Users/shawn/Documents/work/sites/ > whatsup/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/ > doctrine/Doctrine/Import/Builder.php on line 673 > > I would post the yaml file but it is rather large, you can view it > here:http://dev.wheelheadstudios.com/schema.yml > > Also, I first created the Database using MySQL, however i was > uncertain how to create relationships this way (CONSTRAINTS ?), so i > then ran symfony doctrine:build-schema, added the relationships and > then ran: doctrine:build --sql. I found the same error as above. > > Feeling adventurous i decided to then try doctrine:insert-sql > receiving this error: > SQLSTATE[HY000]: General error: 1005 Can't create table 'whatsup.#sql- > c1_9' (errno: 150). Failing Query: "ALTER TABLE ad ADD CONSTRAINT > ad_venue_id_venue_id FOREIGN KEY (venue_id) REFERENCES venue(id) ON > DELETE CASCADE". Failing Query: ALTER TABLE ad ADD CONSTRAINT > ad_venue_id_venue_id FOREIGN KEY (venue_id) REFERENCES venue(id) ON > DELETE CASCADE > > The SQL created in the data/sql/schema.sql can be found > here:http://dev.wheelheadstudios.com/schema.sql > > So here i sit confused and at a standstill. If you have any advise or > can point me in a direction i would appreciate it! > > Thanks, > Shawn -- 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 symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en
