sql syntax error while symfony doctrine:generate-module command

So, my problem is..

i`m trying to execute this command:

php symfony doctrine:generate-module --env="my_env" --non-verbose-templates backend city_theme CityTheme

After a pause, i get this 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 '?) LIMIT 1' at line 1. Failing Query: "SELECT c.id AS c__id, c.city_theme_id AS c__city_theme_id, c.description AS c_description, c.excursions AS c_excursions, c.image AS c_image, c.keywords AS c_keywords, c.name AS c_name, c.slug AS c_slug, c.title AS c__title FROM city_theme_data c WHERE (c.city_theme_id = ?) LIMIT 1"

My schema.yml for this model is:

CityTheme: columns: city_id: integer lang: string(2) guides: string relations: City: class: City local: city_id foreign: id foreignAlias: CityThemes onDelete: CASCADE CityThemeData: columns: city_theme_id: integer description: {type: string(255)} excursions: string image: {type: string(255)} keywords: {type: string(255)} name: {type: string(255)} slug: {type: string(255)} title: {type: string(255)} relations: CityTheme: class: CityTheme local: city_theme_id foreign: id foreignAlias: CityThemesData onDelete: CASCADE

Any suggestions?

Thanks in advance.

Category:php Views:0 Time:2011-11-18

Related post

  • Symfony doctrine:generate-module custom theme: cannot find templates for i18n embedded field 2010-09-05

    I generated a custom theme by copying plugins/sfDoctrinePlugin/data/generator/sfDoctrineModule/default" into plugins/sfDoctrinePlugin/data/generator/sfDoctrineModule/mytheme1" I changed the templates to match my needs (no tables, custom errors displa

  • SQL syntax errors when using php echo $_SERVER['PHP_SELF']; 2009-12-30

    I'm trying to submit a page onto itself by using php echo $_SERVER['PHP_SELF']; but keep receiving the following error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use n

  • Simple query throwing an SQL syntax error 2010-02-22

    I've got a simple SQL query that keeps throwing an SQL syntax error. It looks like this: $sql = "SELECT COUNT(*) AS TOTAL FROM PRODUCT WHERE ID_PRODUCT = ".$id; $result = mysql_query($sql) or die(mysql_error()); Which throws : You have an error in yo

  • SQL Syntax error on one machine but not the other 2010-08-11

    I have a legacy web-site that I am maintaining (built mostly in classic ASP with vbscript). I am making some modifications to it, and got tired of waiting 5 minutes everytime I had to go through one of the pages that was loading 99000 records from th

  • SQL Syntax error when using SQLCommand.EndExecuteNonQuery 2011-01-13

    I'm trying to run two SQL statements (MSSQL 2005), asynchronously in a background worker. However, when I call the EndExecuteNonQuery method on the first SqlCommand I get a 'SQL syntax error near' error. Here is my code: try { SqlCommand sqlCmd = uow

  • Parse error: syntax error, unexpected $end /path/php.module(74) 2011-06-25

    I'm making a form with CAPTCHA to email me the form. I made the PHP code but I'm having an error: Parse error: syntax error, unexpected $end /path/php.module(74) : eval()'d code on line 103 Here is the code: http://pastebin.com/S2ZvdXTX Can anyone pl

  • symfony doctrine:generate-migrations-diff not creating version file 2011-08-31

    I already did some migrations with symfony 1.4, but for some reason, it's no longer working. I have my OLD model, and i added a brand new table to my schema.yml. When I write symfony doctrine:generate-migrations-diff i have the following ouput. >

  • Strange SQL Syntax error 2011-12-28

    With a the code, mysql_query("INSERT INTO Messages (Message, toUser, From, Date) VALUES ('$mes','$to','$from','$date')") I'm getting an SQL syntax error. What is the reason for this? I see nothing wrong with the syntax. --------------Solutions-------

  • sql syntax error when creating column 2012-01-01

    I am trying to run the following query, but am getting a sql syntax error, but dreamweaver doesnt seem to be highlighting any error so im not sure where it is ?. thanks :-) <?php $form_id = $_POST[form_id]; $query = mysql_query(" IF NOT EXISTS (SE

  • PHP with MYSQL; SQL syntax error 2012-01-30

    I keep getting the following SQL syntax error: ERROR MESSAGE 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 'desc, tag ) VALUES( '1', '1', '1', 'Jakis pis', 'Jakis

  • CREATE OR REPLACE PACKAGE PKG_UTILITY AS ./pkg_utility.sql: CREATE: not found ./pkg_utility.sql: syntax error at line 6: `(' unexpected 2012-04-25

    CREATE OR REPLACE PACKAGE PKG_UTILITY AS PROCEDURE housekeep_data (I_DAYS IN NUMBER, o_retc out NUMBER, o_retmsg out VARCHAR2); END PKG_UTILITY; / CREATE OR REPLACE PACKAGE BODY PKG_UTILITY AS PROCEDURE housekeep_data (I_DAYS IN NUMBER, o_retc out NU

  • iam trying to get a pdf file to open but it keeps telling me that i have a sql syntax error how do i fix this 2014-05-25

    hello i have an email in outlook express that i need to open a pdf file in, everytime i try to open the pdf file it tells me that i have an SQL Syntax error how do i fix this problem --------------Solutions------------- Hi, I would suggest you to fol

  • Unable to uninstall a program error: E9030 unable to generate uninstallation command line for ca aintivirus. 2013-11-18

    Original title: unable to uninstall program error msg I'm unable to uninstall a program, a error message keeps popping up saying "error E9030 unable to generate uninstallation command line for ca aintivirus can anyone help??? --------------Solutions-

  • SQL syntax error using Python and psycopg 2009-11-22

    How can you fix this SQL-code? My Python code: import os, pg, sys, re, psycopg2 conn = psycopg2.connect("dbname=tk user=masi password=123") cur = conn.cursor() cur.execute("""INSERT INTO courses ('course_nro') VALUES ( `:1` )""", ['hen']) I get: Trac

  • What action is my Symfony/Doctrine generated form actually going to? 2010-06-04

    In my Symfony 1.4 project I am using the doctrine:generate-admin task to create the modules that compose my backend system. One such module is "journeys". When I view the source of the "journeys/new" page (which displays the form to create a new jour

  • Where is the SQL syntax error in this query? 2011-01-11

    mysqli_error() clearly states: 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 'group, uploaded_by, date_uploaded, url) VALUES (1, 1, NOW(), '/gallery/1/h' at line

  • Named scope SQL syntax error 2011-04-23

    Looks like I have some problems with quotes? My named scope: named_scope :find_by_name, lambda {|name| {:conditions => ["first_name LIKE '%?%' or last_name LIKE '%?%'", name.split(' ').first, name.split(' ').last]}} And here's how I'm doing a sear

  • Why am I getting this sql syntax error from a Django query? 2011-07-15

    In Django I have the following queries in a view applicant=Applicants.objects.get(ben=entity_number) f471s=applicant.form471_set.order_by("-funding_year","number") enrollment=f471s.values("schooldata__ben").annotate(f=Max("number")).filter( number=F(

  • SQL Syntax Error with Jruby under EngineYard 2011-11-14

    I am having some fun with Jruby, but I am having troubles getting my app deployed on EngineYard. Under deploy I am getting the follow error: ActiveRecord::JDBCError: You have an error in your SQL syntax; check the manual that corresponds to your MySQ

Copyright (C) dskims.com, All Rights Reserved.

processed in 0.069 (s). 11 q(s)