No type specified for the "uri" and "label" columns in the failing query: CREATE TABLE layar_actions (id BIGINT UNIQUE AUTO_INCREMENT, uri , label , entrepeneur_id BIGINT, INDEX entrepeneur_id_idx (entrepeneur_id), PRIMARY KEY(id)) ENGINE = INNODB
As to why is this I can't say. gabriel On Oct 25, 9:02 pm, Peter Paauwe <pe...@brauwser.nl> wrote: > Hi all, > > I developed a simple datamodel with ORM designer and exported to > Doctrine YML. Then used symfony to generated all ($php symfony > doctrine:build --all). Everything worked fine, except for the sql > insertion. This resulted in the following error: > > SQLSTATE[42000]: Syntax error or access violation: 1064 You have an > error in your SQL syntax; check the manual that corresponds to your > MySQL server version for the right syntax to use near ' label , > entrepeneur_id BIGINT, INDEX entrepeneur_id_idx (entrepeneur_id), > PRIMA' at line 1. Failing Query: "CREATE TABLE layar_actions (id > BIGINT UNIQUE AUTO_INCREMENT, uri , label , entrepeneur_id BIGINT, > INDEX entrepeneur_id_idx (entrepeneur_id), PRIMARY KEY(id)) ENGINE = > INNODB". Failing Query: CREATE TABLE layar_actions (id BIGINT UNIQUE > AUTO_INCREMENT, uri , label , entrepeneur_id BIGINT, INDEX > entrepeneur_id_idx (entrepeneur_id), PRIMARY KEY(id)) ENGINE = INNODB > > I can't seem to figure out where the problem lies. Anybody any ideas? > Below is my YML file: > > Entrepeneur: > columns: > id: > primary: true > type: integer > notnull: true > autoincrement: true > name: > type: string > short_description: > type: string > lat: > type: integer > lon: > type: integer > layar_line2: > type: string > layar_line3: > type: string > layar_line4: > type: string > small_image: > type: string > introduction: > type: string > street: > type: string > street_number: > type: string > zipcode: > type: string > place: > type: string > phone: > type: string > email: > type: string > website: > type: string > event_or_open: > type: boolean > monday: > type: string > tuesday: > type: string > wednesday: > type: string > thursday: > type: string > friday: > type: string > saturday: > type: string > sunday: > type: string > event_date: > type: string > event_time: > type: string > event_location: > type: string > event_price: > type: string > event_age: > type: string > event_tickets: > type: string > event_extra_info: > type: string > social1: > type: string > social2: > type: string > social3: > type: string > social4: > type: string > maps_link: > type: string > Category_id: > type: integer > notnull: true > relations: > Category: > onDelete: CASCADE > local: Category_id > foreign: id > LayarActions: > columns: > id: > primary: true > type: integer > notnull: true > autoincrement: true > uri: > type: string > label: > type: string > Entrepeneur_id: > type: integer > notnull: true > relations: > Entrepeneur: > local: Entrepeneur_id > foreign: id > Category: > columns: > id: > primary: true > type: integer > notnull: true > autoincrement: true > name: > type: string > title: > type: string > short_description: > type: string > small_image: > type: string > sort_order: > type: integer > cat_type: > type: integer > Category_id: > type: integer > relations: > Category: > onDelete: CASCADE > local: Category_id > foreign: id > Page: > columns: > id: > primary: true > type: integer > notnull: true > autoincrement: true > title: > type: string > text: > type: string > page_type: > type: integer > Category_id: > type: integer > notnull: true > relations: > Category: > onDelete: CASCADE > local: Category_id > foreign: id > Highlight: > columns: > id: > primary: true > type: integer > notnull: true > autoincrement: true > type: > type: string > title: > type: string > short_description: > type: string > smal_limage: > type: string > long_description: > type: string > large_image: > type: string > item_title: > type: string > date: > type: string > time: > type: string > location: > type: string > price: > type: string > entrepeneur_link: > type: string > category_link: > type: string > Category_id: > type: integer > notnull: true > relations: > Category: > onDelete: CASCADE > local: Category_id > foreign: id > AgendaItem: > columns: > id: > primary: true > type: integer > notnull: true > autoincrement: true > short_title: > type: string > short_description: > type: string > small_image: > type: string > long_title: > type: string > long_dscription: > type: string > large_image: > type: string > Entrepeneur_id: > type: integer > notnull: true > relations: > Entrepeneur: > onDelete: CASCADE > local: Entrepeneur_id > foreign: id > MediaItem: > columns: > id: > primary: true > type: integer > notnull: true > autoincrement: true > title: > type: string > small_image: > type: string > short_description: > type: string > media_type: > type: string > Entrepeneur_id: > type: integer > notnull: true > relations: > Entrepeneur: > onDelete: CASCADE > local: Entrepeneur_id > foreign: id > Photo: > columns: > id: > primary: true > type: integer > notnull: true > autoincrement: true > url: > type: string > sort_order: > type: integer > MediaItem_id: > type: integer > notnull: true > relations: > MediaItem: > onDelete: CASCADE > local: MediaItem_id > foreign: id > > Thanks Peter -- 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