Missing Table with Simpletest in CakePHP reloaded

Question

Hey, the solution given here:

http://stackoverflow.com/questions/693071/missing-table-with-simpletest-in-cakephp

used to work for me. But now I'm facing weird problems like empty DESCRIBE statements:

Query: DESCRIBE

Query: DESCRIBE

Query: DESCRIBE

Query: SELECT UserDatum.nome FROM AS UserDatum WHERE user_type_id IS NULL ORDER BY nome ASC LIMIT 1

and then the error:

"Database table user_data for model UserDatum was not found."

even when I put 'app.user_datum' in the fixtures array. Does anyone know what it can possibly be? I'm using cake 1.3.

Answer 1

Hi Ze,

I ran into trouble with cakephp and simpletest some time ago. I remember that I played around a bit and it appeared to me that cake+simple did not "tear up" the database tables in every case, yet in some. I created the db tables manually (I used a dedicated test db, not the same as the app) and that did the trick. In addition I really had to make sure that all related fixtures were correctly included, and the database.php correctly set up. These ideas should only be treated as a "worked for me" and I cannot exlude the possibility of a ID10T error from my side, so I don't blame the framework for weak testing integration.

Kind regards, Benjamin.