Missing ACOs table after 'cake schema generate'

I just wasted spent two days off-project because of a variable name change and my git ignorance.

Problems started when trying to use CakePHP's schema generation, which makes versioning the app's database structure (and then rebuilding from that version) quite easy.  However, something broke between my last structure update a month ago and the last time I tried earlier this week: the acos table was being dumped from the schema file.

It turns out that there was a change to cake/libs/model/cake_schema.php, but in my gross ignorance of handling CakePHP's core as a git submodule, I was debugging against different versions and (shock!) coming up with inconsistent results.  So, first: get your submodules sorted before debugging.

Now, for the root problem.  I spent a few hours isolating this, but finally discovered that a commit containing some variable name changes failed to include one of the variable names that needed changing.  Seemingly innocuous, this actually resulted in an unintentional clobbering of some output which, in my case, dropped the acos table from the scema.php output from 'cake schema generate'.  Bad news, that.  But a bug report was quickly taken up and the issue is resolved now.

With that fix and knowing better how to use git for submodules, I've changed core to origin/1.3 in order to incorporate that bug fix.  Now everything is working as expected.

freetags:

Add new comment