Probleme de creation de table

Version imprimable

Bonjour,

je suis débutant sous symfony et j'essaye de créer un projet.

Voici mes différents fichiers yml :

schema.yml

Code:

1
2
3
4
5
6
7
8
db_symfony:
  contact:
    _attributes:
      readOnly:       true
    id:
    nom:        varchar(255)
    prenom:     varchar(255)
    anciennete: tinyint

databases.yml

Code:

1
2
3
4
5
6
all:
  propel:
    class: sfPropelDatabase
    param:
      dsn: mysql://user:passwd@localhost/db_symfony
      encoding: utf8

Ensuite je crée le projet comme suit :

Code:

1
2
3
4
 
symfony init-project project
symfony init-app appli
symfony propel:build-all

je reçois ça comme message :

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
 
>> schema    converting "/usr/local/apache2/...oject/config/schema.yml" to XML
>> schema    putting /usr/local/apache2/htdo...ect/config/generated-schema.xml
>> propel    Running "om" phing task
[propel-om] Could not perform XLST transformation.  Make sure PHP has been compi                                                                             led/configured to support XSLT.
>> file-     /usr/local/apache2/htdocs/project/config/generated-schema.xml
>> autoload  reloading autoloading
 
  Phing was run before and used many custom classes that might conflict with
  your model classes. In case of errors try running "propel:build-forms" and
  "propel:build-filters" alone. This is due to a PHP limitation that cannot be
  fixed in symfony.
 
>> propel    generating form classes
>> tokens    /usr/local/apache2/htdocs/project/lib/form/ContactForm.class.php
>> tokens    /usr/local/apache2/htdocs/proje...b/form/BaseFormPropel.class.php
>> tokens    /usr/local/apache2/htdocs/proje.../base/BaseContactForm.class.php
>> propel    generating filter form classes
>> tokens    /usr/local/apache2/htdocs/proje...ter/ContactFormFilter.class.php
>> tokens    /usr/local/apache2/htdocs/proje...BaseContactFormFilter.class.php
>> tokens    /usr/local/apache2/htdocs/proje.../BaseFormFilterPropel.class.php
>> schema    converting "/usr/local/apache2/...oject/config/schema.yml" to XML
>> schema    putting /usr/local/apache2/htdo...ect/config/generated-schema.xml
>> propel    Running "sql" phing task
[propel-sql] Could not perform XLST transformation.  Make sure PHP has been comp                                                                             iled/configured to support XSLT.
>> file-     /usr/local/apache2/htdocs/project/config/generated-schema.xml
 
  This command will remove all data in your database.
  Are you sure you want to proceed? (y/N)
 
y
>> schema    converting "/usr/local/apache2/...oject/config/schema.yml" to XML
>> schema    putting /usr/local/apache2/htdo...ect/config/generated-schema.xml
>> file-     /usr/local/apache2/htdocs/project/config/generated-schema.xml
PHP Notice:  Undefined variable: ret in /usr/local/lib/php/symfony/plugins/sfPro                                                                             pelPlugin/lib/task/sfPropelInsertSqlTask.class.php on line 130
 
Notice: Undefined variable: ret in /usr/local/lib/php/symfony/plugins/sfPropelPl                                                                             ugin/lib/task/sfPropelInsertSqlTask.class.php on line 130

Mon souci est que la table contact n'a pas été crée.

Y a t il quelque chose que j'ai oublié de faire ?

Merci de votre aide

Apres avoir installé xslt, j'ai toujours le m^me probleme.

En fait j'ai ce message :
Code:

1 2 3 4 5 Phing was run before and used many custom classes that might conflict with your model classes. In case of errors try running "propel:build-forms" and "propel:build-filters" alone. This is due to a PHP limitation that cannot be fixed in symfony.
Quelqu'un a une idée là dessus ?

Merci

Bon pour ceux que ça intéresse, j'ai résolu le probléme.

Dabord il me manquait l'extenson pdo_mysql

donc j'ai installé pdo_mysql via pecl

Code:

pecl install pdo_mysql

ensuite j'ai recompilé php comme suit

Code:

./configure --with-apxs2=/usr/local/apache2/bin/apxs --with-mysql --enable-mbstring --with-gd --with-jpeg-dir=/usr/local --enable-bcmath --with-zlib --with-xsl --enable-pdo --with-pdo_mysql

Ensuite je crée le project symfony et l'appli
Code:

1 2 3 4 5 cd /usr/local/apache2/htdocs mkdir project_symfony cd project_symfony symfony init-project project_symfony symfony init-app appli
Pour créer la base de données via le schema.yml, créer dabord la base de donnée symfony_project.

Ensuite :

le fichier databases.yml dans project_synfony/config
Code:

1 2 3 4 5 6 7 8 9 all: propel: class: sfPropelDatabase param: phptype: mysql dsn: mysql:dbname=symfony_project;host=localhost databasename: symfony_project username: root password: ???
le fichier propel.ini
Code:

1 2 3 4 5 6 7 8 9 10 propel.targetPackage = lib.model propel.packageObjectModel = true propel.project = symfony_project propel.database = mysql propel.database.driver = mysql propel.database.url = mysql:dbname=symfony_project;host=localhost propel.database.creole.url = mysql://root:???@localhost/symfony_project propel.database.createUrl = mysql://root:???@localhost propel.database.user = root propel.database.password = ???
et le schema.yml
Code:

1 2 3 4 5 6 7 8 9 propel: table: champs1: { type: integer, required: true, primaryKey: true, autoIncrement:true} champs2: { type: varchar, size: 255,required: true} table2: champs1: { type: integer, required: true, primaryKey: true, autoIncrement:true} champs2: { type: varchar, size: 255,required: true}
Il n'y a plus qu'à executer les commandes suivantes :
Code:

1 2 3 cd .. symfony propel:build-sql symfony propel:insert-sql
et vous avez vos deux tables crées !

bon il se peut que j'ai omis certaines choses étant donné que je débute dans symfony donc n'hésitez pas à me corriger.

A+