Problem loading fixtures.

[javiereguiluz]

Problem loading fixtures.

[javiereguiluz]

@Bruno-P Ventas has a multiple primary key (formed by $oferta and $usuario properties). Please, could you confirm me that the error also shows when loading the simplified fixtures? (use the command php app/console doctrine:fixtures:load --fixtures=app/Resources)

Secondly, could you please share some information about your database vendor and version (and OS)?

Lastly, is this just a PHP notice or is it a fatal error that stops execution?

[brpaz]

The simplified fixtures gives me the Truncating table with foreign keys fails exception.

The error says runtime notice but nothing is inserted into the db.
I am using Windows 7 Professional x86 and mysql 5.5.8.

I have removed manually the "Vendas" fixture and the importing went fine.

I think i found the problem The "usuario" fixture was the last one being inserted. Since "Vendas" has a foreign key to "usuario" table it crashes.

[javiereguiluz]

@Bruno-P I'm afraid that's impossible:

• If you use the basic fitures, usuarios are clearly inserted before ventas
• If you use the regular fixtures, they are strictly ordered to avaoid problems. usuarios fixture has a 40 order value and ventas fixture has 50, so it's impossible to load usuariosfirst.