kentcowgill.org/blog

So, I'm a moron.

Seems I'm not making proper use of the Model:: modules. I had originally found an old out of date tutorial making use of the Class::DBI helper scripts, so that's what I used in making this blog. Problem is, the tutorial was woefully incomplete, AND CDBI seems to work - at the surface - without any additional configuration.

Except when you have a stupid datamodel that requires you join a table to itself and get a count of child rows for each parent row.

These days, using Class::DBI seems frowned upon by the catalyst community, so I think instead of trying to fix what's broken, I'll just use a different model to access my data - HOPEfully one that isn't woefully broken, lets me write some of my own nasty SQL and actually reference the correct results to stuff into TemplateToolkit.

Too bad I'm busy working on my wishlist, otherwise I'd tackle this issue straight away.

The first time around, I was using a flat(ish) SQLite file, which worked just fine from my development platform, i.e. running the server as myself, connecting to it on port 3000.

All well and good, but once I moved the application over to running under mod_perl, I kept getting errors like "Can't open readonly file" "Can't open any file" etc. I was sure it was permissions, so I chown'd the database file to nobody, and iteratively worked up to chmod'ing it to 777 - even moved it to a more publicly accessible location.

I still don't know what it was. Instead, I moved my database schema over to a mysql database, regenerated my Model modules with the helper script, changed the Model module's references (before I refered to the Model module as blog::Model::CDBI::Blog, but I had to change that to blog::Model::CDBI::mysql::Blog in two places in my Controller - but other than that, *every*thing else worked flawlessly, including the ability to add new posts :-)