fixtures, getReference() ne fonctionne pas

Version imprimable

bonsoir !
j'ai un souci depuis hier, mais je m'en sors pas. je veux réutiliser les objets créées dans les fixtures mais ça marche pas.
donc dans le userfixtures j'ai
Code:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 $user1 = new User(); $user1->setUsername("xxx"); $user1->setUsernameCanonical("xxx"); $user1->setEmail("xxxx@gmail.com"); $user1->setEmailCanonical(xxxx@gmail.com"); $user1->setEnabled(true); $user1->setLocked(0); $user1->setExpired(0); $user1->addRole('ROLE_ADMIN'); $user1->setIsPremium(1); $user1->setPlainPassword("test"); $user1->setSalt(md5(time())); $encoder = new MessageDigestPasswordEncoder('sha512'); $password = $encoder->encodePassword('test', $user1->getSalt()); $user1->setPassword($password); $manager->persist($user1); $this->addReference('user-1',$user1);
dans robotfixtures
Code:

1 2 3 4 5 6 7 $robot1 = new Robot(); $robot1->setName("Optimus prime"); $robot1->setDescription("superbe robot"); $robot1->setPrice(259.99); $robot1->setSlug($robot1->getName()); $manager->persist($robot1); $this->addReference('robot-1', $robot1);
puis dans possessFixtures qui est ma table de liaison
Code:

1 2 3 4 5 $possess1 = new RobotPossess(); $possess1->setUser($manager->merge($this->getReference('user-1'))); $possess1->setRobot($manager->merge($this->getReference('robot-1'))); $this->addReference('possess-1',$possess1); $manager->persist($possess1);
quand je fais ça il ne retrouve pas les références de user-1 et robot-1 du coup ma requête foire avec cette erreur

Citation:

SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens

j'ai regardé le fichier log, voici la requête générée, il est normal qu'elle ne fonctionne pas puisqu'il manque le user_id et le robot_id

Citation:

[2012-02-18 14:33:59] doctrine.DEBUG: INSERT INTO posseder_robot (robot_id, user_id, created, updated) VALUES (?, ?, ?, ?) ({"1":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"2":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"}}) [] []

merci de votre aide, je bloque dessus depuis hier

ah oui je tiens à préciser que ce n'est pas à cause du getOrder, puisque je récupère le user-1 et le robot-1 après leur création et pas avant.

Si tu ne fais pas appel à la méthode flush aucune requete n'est exécuté. c'est plutôt étonnant que tu aies une erreur.
Dans les logs as tu d'autres requêtes exécutée?
Code:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 //userfixtures ... $manager->persist($user1); $manager->flush();//$user est persisté et a désormais un id $this->addReference('user-1',$user1); //robotFixtures ... $manager->persist($robot1); $manager->flush(); $this->addReference('robot-1', $robot1); //possesFixtures ... $possess1->setUser($this->getReference('user-1'));//dans mes fixtures je n'ai pas besoin d'ajouter merge $possess1->setRobot($this->getReference('robot-1')); $manager->persist($possess1); $manager->flush();
PS:

utilises la balise code dans tes messages
il y a une extension sluggable pour doctrine
normalement une table de liaison de devrait pas étre mappé à une entité (as-tu vraiment besoin de createdAt et updatedAt?)

20/02/2012, 08h42
RapotOR
Dans tes classes de fixtures, as tu bien utilisé :
Code:

1 2 3 4 5 public function getOrder() { return 1; // ordre d'appel }
Par exemple:
User doit avoir 1
Robot doit avoir 2
RobotPossess doit avoir 3 => bah oui les premières références doivent être créées avant!

[quote=arnooo999;6515784]Si tu ne fais pas appel à la méthode flush aucune requete n'est exécuté. c'est plutôt étonnant que tu aies une erreur.
Dans les logs as tu d'autres requêtes exécutée?

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
 
//userfixtures
...
$manager->persist($user1);
$manager->flush();//$user est persisté et a désormais un id
$this->addReference('user-1',$user1);
 
//robotFixtures
...
 
$manager->persist($robot1);
$manager->flush();
$this->addReference('robot-1', $robot1);
 
//possesFixtures
...
$possess1->setUser($this->getReference('user-1'));//dans mes fixtures je n'ai pas besoin d'ajouter merge
$possess1->setRobot($this->getReference('robot-1'));
$manager->persist($possess1);
$manager->flush();

PS:

Citation:

utilises la balise code dans tes messages
il y a une extension sluggable pour doctrine
normalement une table de liaison de devrait pas étre mappé à une entité (as-tu vraiment besoin de createdAt et updatedAt?)

merci pour ta réponse, mais je fais déjà le $manager->flush je ne l'ai juste pas mis dans le code que j'ai posté.
ok pour l'extension sluggable, je vais regarder
pour le createdAt et l'updatedAt j'en ai pas vraiment besoin mais je m'étais dit qu'un champ date pourra me servir plus tard.
oui j'ai d'autres requêtes qui s'executent dans le log

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
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO user_table (username, username_canonical, email, email_canonical, enabled, salt, password, last_login, locked, expired, expires_at, confirmation_token, password_requested_at, roles, credentials_expired, credentials_expire_at, is_premium) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ({"1":"xxx","2":"xxx","3":"xxxx@gmail.com","4":"xxxxx@gmail.com","5":true,"6":"nxqb7oz8qggsow0g44kg80ks0o48oww","7":"KAKQQJaP+GUuBk0yGvzrnyM4Z+0LZo4SCXuE\/72qcQBT7SvdtZ+21rCsR\/G2NoEY3w3Sbq9OvB8y6ZpQcvOnRA==","8":null,"9":0,"10":false,"11":null,"12":"4daxef9g3hgkg88socw8kwo444sk4888kg8go0csksowsg8cc0","13":null,"14":["ROLE_ADMIN"],"15":false,"16":null,"17":1}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO user_table (username, username_canonical, email, email_canonical, enabled, salt, password, last_login, locked, expired, expires_at, confirmation_token, password_requested_at, roles, credentials_expired, credentials_expire_at, is_premium) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ({"1":"xxx","2":"xxx","3":"xxxx@gmail.com","4":"xxxx@gmail.com","5":true,"6":"9bfoqglp14gs4ssg0ss08ksg04k8sc0","7":"aVx796byB5K63nop\/+ZMq7nd8GasmB5hKd8Ik4wo+imzQ4BnjeFBLe0U9NLom9NYLS0WM+H1JwyC+9OYE8MFRw==","8":null,"9":0,"10":false,"11":null,"12":"1rzi5oqu14is0o0sog8c00w0sc4o4c80gos8g88owcckcww8k8","13":null,"14":["ROLE_ADMIN"],"15":false,"16":null,"17":1}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO user_table (username, username_canonical, email, email_canonical, enabled, salt, password, last_login, locked, expired, expires_at, confirmation_token, password_requested_at, roles, credentials_expired, credentials_expire_at, is_premium) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ({"1":"ccxxxx","2":"rxxx","3":"xxxxx@gmail.com","4":"xxxxx@gmail.com","5":true,"6":"em4kjxd2tuogwcokgog0o84cwwokwsc","7":"YIcSp3J4kw1I3kvSgtsdxsx9+3ZARVTnBCE+ysrJ6edFSam1Us9dep2+OEx7qG8lUKpe5faad0TUsKp5YJX6Gg==","8":null,"9":0,"10":false,"11":null,"12":"3p1vwci1k3eocgs4000sok4cw4gkcso4go8kw0844cc4wck08s","13":null,"14":["ROLE_ADMIN"],"15":false,"16":null,"17":1}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO forum_forums (name) VALUES (?) ({"1":"Symfony2"}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO forum_forums (name) VALUES (?) ({"1":"Autres"}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO robot (name, picture, price, description, created, updated, slug) VALUES (?, ?, ?, ?, ?, ?, ?) ({"1":"Optimus prime","2":"logo.png","3":259.99,"4":"superbe robot","5":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"6":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"7":"optimus-prime"}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO robot (name, picture, price, description, created, updated, slug) VALUES (?, ?, ?, ?, ?, ?, ?) ({"1":"Optimus II","2":"logo.png","3":359.99,"4":"description du super robot","5":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"6":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"7":"optimus-ii"}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO robot (name, picture, price, description, created, updated, slug) VALUES (?, ?, ?, ?, ?, ?, ?) ({"1":"Optimus XXL","2":"logo.png","3":559.99,"4":"RAS","5":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"6":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"7":"optimus-xxl"}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO robot (name, picture, price, description, created, updated, slug) VALUES (?, ?, ?, ?, ?, ?, ?) ({"1":"Prime","2":"logo.png","3":59.99,"4":"robot","5":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"6":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"7":"prime"}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO article_cat (name) VALUES (?) ({"1":"Applications"}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO article_cat (name) VALUES (?) ({"1":"Test"}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO article_cat (name) VALUES (?) ({"1":"Hardware"}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO forum_forums_sub (title, description, forum_id, slug) VALUES (?, ?, ?, ?) ({"1":"Tutoriaux","2":"Forum du fonctionnement g\u00e9n\u00e9ral de LegTux.","3":23,"4":"tutoriaux"}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO forum_forums_sub (title, description, forum_id, slug) VALUES (?, ?, ?, ?) ({"1":"Tutoriaux","2":"Forum du fonctionnement g\u00e9n\u00e9ral de LegTux.","3":23,"4":"tutoriaux"}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO forum_forums_sub (title, description, forum_id, slug) VALUES (?, ?, ?, ?) ({"1":"Vos projets","2":"Forum du fonctionnement g\u00e9n\u00e9ral de LegTux.","3":24,"4":"vos-projets"}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO forum_forums_sub (title, description, forum_id, slug) VALUES (?, ?, ?, ?) ({"1":"Discussions libres","2":"Forum du fonctionnement g\u00e9n\u00e9ral de LegTux.","3":24,"4":"discussions-libres"}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO article (title, author, content, image, tags, slug, category_id, created, updated) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) ({"1":"The pool on the roof must have a leak","2":"Zero Cool","3":"Vestibulum vulputate mauris eget erat congue dapibus imperdiet justo scelerisque. Na. Cras elementum molestie vestibulum. Morbi id quam nisl. Praesent hendrerit, orci sed elementum lobortis.","4":"pool_leak.jpg","5":"pool, leaky, hacked, movie, hacking, symarticle","6":"the-pool-on-the-roof-must-have-a-leak","7":37,"8":{"date":"2011-07-23 06:12:33","timezone_type":3,"timezone":"UTC"},"9":{"date":"2011-07-23 06:12:33","timezone_type":3,"timezone":"UTC"}}) [] []

[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO article (title, author, content, image, tags, slug, category_id, created, updated) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) ({"1":"The grid - A digital frontier","2":"Kevin Flynn","3":"Lorem commodo. Vestibulum vulputate mauris eget erat congue dapibus imperdiet justo scelerisque. Nulla consectetur tempus nisl vitae viverra.","4":"the_grid.jpg","5":"grid, daftpunk, movie, symarticle","6":"the-grid-a-digital-frontier","7":39,"8":{"date":"2011-06-02 18:54:12","timezone_type":3,"timezone":"UTC"},"9":{"date":"2011-06-02 18:54:12","timezone_type":3,"timezone":"UTC"}}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO article (title, author, content, image, tags, slug, category_id, created, updated) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) ({"1":"You're either a one or a zero. Alive or dead","2":"Gary Winston","3":"Lorem ipsum dolor sit amet, consectetur adipiscing elittibulum vulputate mauris eget erat congue dapibus imperdiet justo scelerisque.","4":"one_or_zero.jpg","5":"binary, one, zero, alive, dead, !trusting, movie, symarticle","6":"you-re-either-a-one-or-a-zero-alive-or-dead","7":null,"8":{"date":"2011-04-25 15:34:18","timezone_type":3,"timezone":"UTC"},"9":{"date":"2011-04-25 15:34:18","timezone_type":3,"timezone":"UTC"}}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO forum_topic (title, forum_sub_id) VALUES (?, ?) ({"1":"Probl\u00e8me de cache","2":37}) [] []
[2012-02-18 14:33:59] doctrine.DEBUG: INSERT INTO comment (user, comment, approved, article_id, created, updated) VALUES (?, ?, ?, ?, ?, ?) ({"1":"symfony","2":"To make a long story short. You can't go wrong by choosing Symfony! And no one has ever been fired for using Symfony.","3":true,"4":46,"5":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"6":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"}}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO comment (user, comment, approved, article_id, created, updated) VALUES (?, ?, ?, ?, ?, ?) ({"1":"David","2":"To make a long story short. Choosing a framework must not be taken lightly; it is a long-term commitment. Make sure that you make the right selection!","3":true,"4":46,"5":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"6":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"}}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO comment (user, comment, approved, article_id, created, updated) VALUES (?, ?, ?, ?, ?, ?) ({"1":"Dade","2":"Anything else, mom? You want me to mow the lawn? Oops! I forgot, New York, No grass.","3":true,"4":47,"5":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"6":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"}}) [] []

[2012-02-18 14:33:59] doctrine.DEBUG: INSERT INTO comment (user, comment, approved, article_id, created, updated) VALUES (?, ?, ?, ?, ?, ?) ({"1":"Gary","2":"Bill Who?","3":true,"4":50,"5":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"6":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"}}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO category_product (name, parent_id, description, picture, created, updated, slug) VALUES (?, ?, ?, ?, ?, ?, ?) ({"1":"Categorie1","2":null,"3":"e the 1500s, when an unknown printer unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop","4":"logo.png","5":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"6":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"7":"categorie1"}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO category_product (name, parent_id, description, picture, created, updated, slug) VALUES (?, ?, ?, ?, ?, ?, ?) ({"1":"Categorie 2","2":null,"3":"Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words,","4":"logo.png","5":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"6":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"7":"categorie-2"}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO category_product (name, parent_id, description, picture, created, updated, slug) VALUES (?, ?, ?, ?, ?, ?, ?) ({"1":"Categorie 3","2":null,"3":"the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.","4":"logo.png","5":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"6":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"7":"categorie-3"}) [] []
[2012-02-18 14:33:59] doctrine.DEBUG: UPDATE category_product SET parent_id = ? WHERE id = ? ([46,47]) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO category_product (name, parent_id, description, picture, created, updated, slug) VALUES (?, ?, ?, ?, ?, ?, ?) ({"1":"Domestique","2":null,"3":"when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged.  de test","4":"logo.png","5":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"6":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"7":"domestique"}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO category_product (name, parent_id, description, picture, created, updated, slug) VALUES (?, ?, ?, ?, ?, ?, ?) ({"1":"Categorie1","2":null,"3":"e the 1500s, when an unknown printer unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop","4":"logo.png","5":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"6":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"7":"categorie1"}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO product (name, description, price, picture, enabled, brief_description, product_code, in_stock, customer_votes, category_id, created, slug, updated, path) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ({"1":"Lycos","2":"Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it ","3":5.9,"4":"icon.png","5":false,"6":"va chercher !!!","7":"x32x2","8":0,"9":0,"10":49,"11":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"12":"lycos","13":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"14":null}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO product (name, description, price, picture, enabled, brief_description, product_code, in_stock, customer_votes, category_id, created, slug, updated, path) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ({"1":"Irobot","2":"hich don't look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn't anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true gener","3":3.9,"4":"icon.png","5":false,"6":"Why do we use it","7":"xxx322","8":0,"9":0,"10":46,"11":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"12":"irobot","13":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"14":null}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO product (name, description, price, picture, enabled, brief_description, product_code, in_stock, customer_votes, category_id, created, slug, updated, path) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ({"1":"bot","2":"hich don't look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn't anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true gener","3":3.9,"4":"icon.png","5":false,"6":"briefing","7":"xxx322","8":0,"9":0,"10":46,"11":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"12":"bot","13":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"14":null}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO product (name, description, price, picture, enabled, brief_description, product_code, in_stock, customer_votes, category_id, created, slug, updated, path) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ({"1":"Irobot","2":"hich don't look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn't anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true gener","3":0,"4":"icon.png","5":false,"6":"Why do we use it","7":"xxx322","8":0,"9":0,"10":46,"11":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"12":"irobot","13":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"14":null}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO product (name, description, price, picture, enabled, brief_description, product_code, in_stock, customer_votes, category_id, created, slug, updated, path) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ({"1":"Irobot II","2":"hich don't look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn't anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true gener","3":18.9,"4":"icon.png","5":false,"6":"Why ?","7":"xxx322","8":0,"9":0,"10":46,"11":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"12":"irobot-ii","13":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"14":null}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO product (name, description, price, picture, enabled, brief_description, product_code, in_stock, customer_votes, category_id, created, slug, updated, path) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ({"1":"Ibot","2":"hsum as their default model text, and a search for 'lorem ipsum' will uncover many web sites still in this the first true gener","3":3.9,"4":"icon.png","5":false,"6":"Where does it come from","7":"xxx322","8":0,"9":0,"10":47,"11":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"12":"ibot","13":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"14":null}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: UPDATE category_product SET parent_id = ? WHERE id = ? ([50,49]) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO posseder_robot (robot_id, user_id, created, updated) VALUES (?, ?, ?, ?) ({"1":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"2":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"}}) [] []

20/02/2012, 10h01
eliysha
Citation:
Envoyé par RapotOR

Dans tes classes de fixtures, as tu bien utilisé :

Code:

1 2 3 4 5 public function getOrder() { return 1; // ordre d'appel }

Par exemple:
User doit avoir 1
Robot doit avoir 2
RobotPossess doit avoir 3 => bah oui les premières références doivent être créées avant!
oui j'utilise le getOrder, j'ai mis le user en premier, ensuite le robot et enfin RobotPossess

Donc les premieres fixtures sont bien utilisées.
Qu'est ce que ça donnes en ajoutant ça dans PossesFixtures:
Code:

1 2 3 4 5 6 7 $user1=$this->getReference('user-1'); echo "\n\t user1 est de classe",get_class($user1),' son id est ',$user1->getId(); $possess1->setUser($user1); $possess1->setRobot($this->getReference('robot-1')); $manager->persist($possess1); $manager->flush();
à voir également
Est-ce que tout fonctionne si tu désactives ProcessFixtures?
Est-ce qu'il y a des fixtures ou tu utilises le getReference avec succées ?
Est-ce que tu as généré un crud sur PossesFixtures et que celui-ci fonctionne ?
Est-ce que ça peut venir du mapping plutôt que des doctrine fixtures?

Je reste perplexe sur l'entité ProcessFixtures et sur la signification de created et updated.
sur une table de liaison on ne gére finalement que des insert et des delete.
Il y a également une extension Loggable mais je ne sais pas si elle fonctionne pour des relations ManyToMany

Citation:
Envoyé par arnooo999
Donc les premieres fixtures sont bien utilisées.
Qu'est ce que ça donnes en ajoutant ça dans PossesFixtures:
Code:

1 2 3 4 5 6 7 $user1=$this->getReference('user-1'); echo "\n\t user1 est de classe",get_class($user1),' son id est ',$user1->getId(); $possess1->setUser($user1); $possess1->setRobot($this->getReference('robot-1')); $manager->persist($possess1); $manager->flush();
à voir également
Est-ce que tout fonctionne si tu désactives ProcessFixtures?
Est-ce qu'il y a des fixtures ou tu utilises le getReference avec succées ?
Est-ce que tu as généré un crud sur PossesFixtures et que celui-ci fonctionne ?
Est-ce que ça peut venir du mapping plutôt que des doctrine fixtures?

Je reste perplexe sur l'entité ProcessFixtures et sur la signification de created et updated.
sur une table de liaison on ne gére finalement que des insert et des delete.
Il y a également une extension Loggable mais je ne sais pas si elle fonctionne pour des relations ManyToMany
je viens de tester sans les fixtures concernant la table de liaison ça passe nickel
j'ai testé aussi ton astuce avec le echo voici le résultat
Code:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 eliysha:ironbot eliysha$ php app/console doctrine:fixtures:load > purging database > loading xxxx\UserBundle\DataFixtures\ORM\UserFixtures > loading xxxx\BlogBundle\DataFixtures\ORM\ForumFixtures > loading xxxx\MarketBundle\DataFixtures\ORM\RobotFixtures > loading xxxx\BlogBundle\DataFixtures\ORM\CategoryFixtures > loading xxxx\BlogBundle\DataFixtures\ORM\SubForumFixtures > loading xxxx\BlogBundle\DataFixtures\ORM\ArticleFixtures > loading xxxx\BlogBundle\DataFixtures\ORM\TopicFixtures > loading xxxx\BlogBundle\DataFixtures\ORM\CommentFixtures > loading xxxx\BlogBundle\DataFixtures\ORM\PostFixtures > loading xxxx\MarketBundle\DataFixtures\ORM\CategoryProductFixtures > loading xxxx\MarketBundle\DataFixtures\ORM\ProductFixtures > loading xxxx\MarketBundle\DataFixtures\ORM\RobotPossessFixtures user1 est de classeProxies\IronbotUserBundleEntityUserProxy son id est 1 robot 1 est de classeProxies\IronbotMarketBundleEntityRobotProxy son id est 1 [PDOException] SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens
dans les autres fixtures je fais seulement addReference, il n y a que celui que je fais le getReference.
pour le created et le updated c'est vrai que c'est pas pertinent dans une table de liaison mais je doute que le problème vienne de la...

J'ai le même message dans mes fixtures, j'ai l'impression que le problème est ailleurs que dans getReference.

Est-ce que tu as essayé de mettre la création de tes 3 objets (User-1,Robot-1 et PossessRobot-1) dans la classe UserFixture (donc sans utiliser get / set reference)?

essaie également ce code
Code:

1 2 3 4 5 6 7 8 9 10 11 public function load(\Doctrine\Common\Persistence\ObjectManager $manager $manager){ ... echo "\n\t user1 est de classe",get_class($user1),' son id est ',$user1->getId(); if($manager->contains($user1)){ echo "user1 est managé par l\'entity manager"; }else{ echo "user1 n'est pas managé par l'\entity manager"; } ... }

21/02/2012, 21h40
eliysha

toujours pas :cry:
je commence à penser que le probleme vient peut etre de mes entités, peut etre que mes relations ne sont pas bonnes.
Tu penses que cela peut etre la cause ?
22/02/2012, 10h16
arnooo999

peux tu poster le code de test entités

voici mes entités

Entity/user.php

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
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
 
<?php
 
namespace xxxx\UserBundle\Entity;
 
use FOS\UserBundle\Entity\User as BaseUser;
use Doctrine\ORM\Mapping as ORM;
use Symfony\Component\Validator\Constraints as Assert;
use Doctrine\Common\Collections\ArrayCollection;
/**
 * @ORM\Entity
 * @ORM\Table(name="user_table")
 * @ORM\Entity(repositoryClass="xxxx\UserBundle\Repository\UserRepository")
 */
class User extends BaseUser
{
    /**
     * @ORM\Id
     * @ORM\Column(type="integer")
     * @ORM\generatedValue(strategy="AUTO")
     */
    protected $id;
 
    /**
     * @ORM\ManyToMany(targetEntity="xxxx\UserBundle\Entity\Group")
     * @ORM\JoinTable(name="user_group",
     *      joinColumns={@ORM\JoinColumn(name="user_id", referencedColumnName="id")},
     *      inverseJoinColumns={@ORM\JoinColumn(name="group_id", referencedColumnName="id")}
     * )
     */
    protected $groups;
 
     /**
     * @ORM\OneToMany(targetEntity="xxxx\MarketBundle\Entity\Checkout", mappedBy="user")
     */
    protected $orders;
 
 
    /**
    * @ORM\Column(type="boolean")
    */
    protected $is_premium;
 
    public function __construct()
    {
        $this->setIsPremium(0);
        $this->orders = new ArrayCollection();
        //$this->robots = new ArrayCollection();
        parent::__construct();
    }
 
    /**
     * Get id
     *
     * @return integer 
     */
    public function getId()
    {
        return $this->id;
    }
 
    /**
     * Set is_premium
     *
     * @param boolean $isPremium
     */
    public function setIsPremium($isPremium)
    {
        $this->is_premium = $isPremium;
    }
 
    /**
     * Get is_premium
     *
     * @return boolean
     */
    public function getIsPremium()
    {
        return $this->is_premium;
    }
 
 
    public function setSalt($salt)
    {
        $this->$salt = $salt;
    }
 
    public function getSalt()
    {
        return $this->salt;
    }
 
    /**
     * Get groups
     *
     * @return Doctrine\Common\Collections\Collection 
     */
    public function getGroups()
    {
        return $this->groups;
    }
 
    /**
     * Add orders
     *
     * @param xxxx\MarketBundle\Entity\Checkout $orders
     */
    public function addCheckout(\xxxx\MarketBundle\Entity\Checkout $orders)
    {
        $this->orders[] = $orders;
    }
 
    /**
     * Get orders
     *
     * @return Doctrine\Common\Collections\Collection 
     */
    public function getOrders()
    {
        return $this->orders;
    }
 
    /**
     * Add groups
     *
     * @param xxxx\UserBundle\Entity\Group $groups
     */
    public function addGroups(\xxxx\UserBundle\Entity\Group $groups)
    {
        $this->groups[] = $groups;
    }
 
}

Entity\Robot.php

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
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
 
<?php
 
namespace xxxx\MarketBundle\Entity;
use Doctrine\Common\Collections\ArrayCollection;
use Doctrine\ORM\Mapping as ORM;
 
/**
 * xxxx\MarketBundle\Entity\Robot
 *
 * @ORM\Table(name="robot")
 * @ORM\Entity(repositoryClass="xxxx\MarketBundle\Repository\RobotRepository")
 */
class Robot
{
    /**
     * @var integer $id
     *
     * @ORM\Column(name="id", type="integer")
     * @ORM\Id
     * @ORM\GeneratedValue(strategy="AUTO")
     */
    private $id;
 
    /**
     * @var string $name
     *
     * @ORM\Column(name="name", type="string", length=255)
     */
    private $name;
 
    /**
     * @var string $picture
     *
     * @ORM\Column(name="picture", type="string", length=255)
     */
    private $picture;
 
    /**
     * @var float $price
     *
     * @ORM\Column(name="price", type="float")
     */
    private $price;
 
    /**
     * @var text $description
     *
     * @ORM\Column(name="description", type="text")
     */
    private $description;
 
    /**
     * @var datetime $created
     *
     * @ORM\Column(name="created", type="datetime")
     */
    private $created;
 
    /**
     * @var datetime $updated
     *
     * @ORM\Column(name="updated", type="datetime")
     */
    private $updated;
 
    /**
     * @var string $slug
     *
     * @ORM\Column(name="slug", type="string", length=255)
     */
    private $slug;
 
 
    public function __construct()
    {
        $this->setCreated(new \DateTime());
        $this->setUpdated(new \DateTime());
        $this->setPicture("logo.png");
 
    }
 
 
    /**
     * Get id
     *
     * @return integer 
     */
    public function getId()
    {
        return $this->id;
    }
 
    /**
     * Set name
     *
     * @param string $name
     */
    public function setName($name)
    {
        $this->name = $name;
    }
 
    /**
     * Get name
     *
     * @return string 
     */
    public function getName()
    {
        return $this->name;
    }
 
    /**
     * Set picture
     *
     * @param string $picture
     */
    public function setPicture($picture)
    {
        $this->picture = $picture;
    }
 
    /**
     * Get picture
     *
     * @return string 
     */
    public function getPicture()
    {
        return $this->picture;
    }
 
    /**
     * Set price
     *
     * @param float $price
     */
    public function setPrice($price)
    {
        $this->price = $price;
    }
 
    /**
     * Get price
     *
     * @return float 
     */
    public function getPrice()
    {
        return $this->price;
    }
 
    /**
     * Set description
     *
     * @param text $description
     */
    public function setDescription($description)
    {
        $this->description = $description;
    }
 
    /**
     * Get description
     *
     * @return text 
     */
    public function getDescription()
    {
        return $this->description;
    }
 
    /**
     * Set created
     *
     * @param datetime $created
     */
    public function setCreated($created)
    {
        $this->created = $created;
    }
 
    /**
     * Get created
     *
     * @return datetime 
     */
    public function getCreated()
    {
        return $this->created;
    }
 
    /**
     * Set updated
     *
     * @param datetime $updated
     */
    public function setUpdated($updated)
    {
        $this->updated = $updated;
    }
 
    /**
     * Get updated
     *
     * @return datetime 
     */
    public function getUpdated()
    {
        return $this->updated;
    }
 
    /**
     * Set slug
     *
     * @param string $slug
     */
    public function setSlug($slug)
    {
        $this->slug = $this->slugify($slug);
    }
 
    /**
     * Get slug
     *
     * @return string 
     */
    public function getSlug()
    {
        return $this->slug;
    }
 
    public function slugify($text)
    {
        // replace non letter or digits by -
        $text = preg_replace('#[^\\pL\d]+#u', '-', $text);
 
        // trim
        $text = trim($text, '-');
 
        // transliterate
        if (function_exists('iconv'))
        {
            $text = iconv('utf-8', 'us-ascii//TRANSLIT', $text);
        }
 
        // lowercase
        $text = strtolower($text);
 
        // remove unwanted characters
        $text = preg_replace('#[^-\w]+#', '', $text);
 
        if (empty($text))
        {
            return 'n-a';
        }
 
        return $text;
    }
 
}

Entity\RobotPossess.php

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
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
 
<?php
 
namespace xxxx\MarketBundle\Entity;
 
use Doctrine\ORM\Mapping as ORM;
 
/**
 * xxxx\MarketBundle\Entity\RobotPossess
 *
 * @ORM\Table(name="posseder_robot")
 * @ORM\Entity(repositoryClass="xxxx\MarketBundle\Repository\RobotPossessRepository")
 */
class RobotPossess
{
    /**
     * @var integer $id
     *
     * @ORM\Column(name="id", type="integer")
     * @ORM\Id
     * @ORM\GeneratedValue(strategy="AUTO")
     */
    private $id;
 
    /**
     * @ORM\Id
     * @ORM\ManyToOne(targetEntity="xxxx\MarketBundle\Entity\Robot", cascade={"persist"})
     * @ORM\JoinColumn(name="robot_id", referencedColumnName="id")
     */
    private $robot;
 
    /**
     * @ORM\Id
     * @ORM\ManyToOne(targetEntity="xxxx\UserBundle\Entity\User", cascade={"persist"})
     * @ORM\JoinColumn(name="user_id", referencedColumnName="id")
     */
    private $user;
 
    /**
     * @var datetime $created
     *
     * @ORM\Column(name="created", type="datetime")
     */
    private $created;
 
    /**
     * @var datetime $updated
     *
     * @ORM\Column(name="updated", type="datetime")
     */
    private $updated;
 
 
    public function __construct()
    {
        $this->setCreated(new \DateTime());
        $this->setUpdated(new \DateTime());
 
    }
 
    /**
     * Get id
     *
     * @return integer 
     */
    public function getId()
    {
        return $this->id;
    }
 
    /**
     * Set created
     *
     * @param datetime $created
     */
    public function setCreated($created)
    {
        $this->created = $created;
    }
 
    /**
     * Get created
     *
     * @return datetime 
     */
    public function getCreated()
    {
        return $this->created;
    }
 
    /**
     * Set updated
     *
     * @param datetime $updated
     */
    public function setUpdated($updated)
    {
        $this->updated = $updated;
    }
 
    /**
     * Get updated
     *
     * @return datetime 
     */
    public function getUpdated()
    {
        return $this->updated;
    }
 
    /**
     * Set robot
     *
     * @param xxxx\MarketBundle\Entity\Robot $robot
     */
    public function setRobot(\xxxx\MarketBundle\Entity\Robot $robot)
    {
        $this->robot = $robot;
    }
 
    /**
     * Get robot
     *
     * @return xxxx\MarketBundle\Entity\Robot 
     */
    public function getRobot()
    {
        return $this->robot;
    }
 
    /**
     * Set user
     *
     * @param xxxx\UserBundle\Entity\User $user
     */
    public function setUser(\xxxx\UserBundle\Entity\User $user)
    {
        $this->user = $user;
    }
 
    /**
     * Get user
     *
     * @return xxxx\UserBundle\Entity\User 
     */
    public function getUser()
    {
        return $this->user;
    }
}

voila le code de mes entités.
je voulais juste te remercier deja de l'aide que tu m'as apporté jusqu'à présent, :ccool:

Il y a un probleme de mapping sur PossesRobot
il y a trop d'identifiants à mon avis:
soit tu enleves les annotations Id sur User et Robot

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
 
    /**
     * @var integer $id
     *
     * @ORM\Column(name="id", type="integer")
     * @ORM\Id
     * @ORM\GeneratedValue(strategy="AUTO")
     */
    private $id;
 
    /**
     * @ORM\ManyToOne(targetEntity="xxxx\MarketBundle\Entity\Robot", cascade={"persist"})
     * @ORM\JoinColumn(name="robot_id", referencedColumnName="id")
     */
    private $robot;
 
    /**
     * @ORM\ManyToOne(targetEntity="xxxx\UserBundle\Entity\User", cascade={"persist"})
     * @ORM\JoinColumn(name="user_id", referencedColumnName="id")
     */
    private $user;

soit tu supprime ta colonne id

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
 
    /**
     * @ORM\Id
     * @ORM\ManyToOne(targetEntity="xxxx\MarketBundle\Entity\Robot", cascade={"persist"})
     * @ORM\JoinColumn(name="robot_id", referencedColumnName="id")
     */
    private $robot;
 
    /**
     * @ORM\Id
     * @ORM\ManyToOne(targetEntity="xxxx\UserBundle\Entity\User", cascade={"persist"})
     * @ORM\JoinColumn(name="user_id", referencedColumnName="id")
     */
    private $user;

sois tu supprimes completement l'entité et tu crée une relation ManyToMany entre User et Robot (ce qui serais le plus propre)

Au passage il existe également une extension Timestampable (dans le même bundle que Sluggable)

22/02/2012, 20h50
eliysha

OUI!! OUI!!!
ça marche !!! j'ai opté pour la dernière solution: ManytoMany sur Robot et User et j'ai supprimé RobotPossess.

merci encore