CakePHP Error: Database table acos for model Aco was not found

I have a Mac running Mac OS X Leopard at work as well as at home and a PC at work as well.

I have the project I'm currently working on set up on all 3, it works fine at my work computers but on my home Mac I get the error in the title. The project is on SVN so I just checked it out ran the SQL script for my DB schema and set up the same user I have in my work DB and it will not work still.

I also cleared out the cache folders as suggested in other posts with a similar problem and it still won't work.

Obviously I have checked the database table and it is present in my DB. Anyone have any other clues as to what might be happening?

In the end the error was in my database user configuration. It seems I forgot to set CRUD permissions to the user I use to access the database and that's what gave me the error

If you aren't in debug mode, I would suggest doing that to help troubleshoot. If it works in debug mode, then you've got some sort of caching issue. If it doesn't work in debug mode, my next question is - are your work computers windows? If so, I would look at case-sensitivity issues because Windows and Macs handle case differently.

Just encountered the same error. Table creation worked fine from the shell, so it seemed dubious that it wouldn't be able to read it afterwards.

In my case, the fix was to empty cache / tmp folder, as suggested on this french forum.