Hi every:
First of all my apologies if this isn't the right place to ask this. I
have created a schema.yml file from scratch containing this:
ProjectData:
actAs:
Timestampable:
Searchable:
fields: [pid, pname, pdescription, pstatus]
columns:
id: ~
pid: string(50)
pname: string(150)
pdescription: string(150)
pstatus: boolean
When I run the task:
#symfony doctrine:build-all
All it's fine until the task try to create the tables on the DB. See the
logs:
#symfony doctrine:build-all
This command will remove all data in your database connections named:
doctrine
Are you sure you want to proceed? (y/N)
y
>> >> doctrine dropping databases
>> >> doctrine Successfully dropped database for connection named
'doctrine'
>> >> doctrine creating databases
>> >> doctrine Successfully created database for connection named
'doctrine'
>> >> doctrine generating model classes
>> >> autoload Reloading autoloaders
>> >> file-
/var/www/buscador/cache/backend/dev/config/config_autoload.yml.php
>> >> doctrine generating form classes
>> >> tokens /var/www/buscador/lib/form/BaseForm.class.php
>> >> tokens
/var/www/buscador/lib/form/doctrine/ProjectDataForm.class.php
>> >> tokens
/var/www/buscador/lib/form/doctrine/ProjectDataIndexForm.class.php
>> >> tokens
/var/www/buscador/lib/form/doctrine/base/BaseProjectDataForm.class.php
>> >> tokens
/var/www/buscador/lib/form/doctrine/base/BaseProjectDataIndexForm.class.php
>> >> tokens
/var/www/buscador/lib/form/doctrine/BaseFormDoctrine.class.php
>> >> autoload Reloading autoloaders
>> >> file-
/var/www/buscador/cache/backend/dev/config/config_autoload.yml.php
>> >> doctrine generating filter form classes
>> >> tokens
/var/www/buscador/lib/filter/doctrine/base/BaseProjectDataFormFilter.class.php
>> >> tokens
/var/www/buscador/lib/filter/doctrine/base/BaseProjectDataIndexFormFilter.class.php
>> >> tokens
/var/www/buscador/lib/filter/doctrine/ProjectDataIndexFormFilter.class.php
>> >> tokens
/var/www/buscador/lib/filter/doctrine/ProjectDataFormFilter.class.php
>> >> tokens
/var/www/buscador/lib/filter/doctrine/BaseFormFilterDoctrine.class.php
>> >> autoload Reloading autoloaders
>> >> file-
/var/www/buscador/cache/backend/dev/config/config_autoload.yml.php
>> >> doctrine generating sql for models
>> >> doctrine Generated SQL successfully for models
>> >> doctrine created tables successfully
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 ' keyword
VARCHAR(200), field VARCHAR(50), position BIGINT, PRIMARY KEY(id, keywo'
at line 1. Failing Query: CREATE TABLE project_data_index (id , keyword
VARCHAR(200), field VARCHAR(50), position BIGINT, PRIMARY KEY(id,
keyword, field, position)) ENGINE = INNODB
What's wrong here? I'm using Symfony 1.3ALPHA1
--
Cheers
ReynierPM
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
