On Tue, Dec 08, 2009 at 07:24:11PM -0500, Peter McAlpine wrote:
Thanks, I've upgraded to the latest CPAN and am now getting:
...
failed: Duplicate column name 'type' at perl/lib/Leaguerunner/DBInit.pm line 562.
Crap. Those "Duplicate column name" errors mean that the first time around, the upgrader managed to upgrade those tables, but didn't complete the entire upgrade. The only way to fix it is via manually comparing the mysql schema to the expected one in the upgrade script, and making the necessary changes. If you're lucky, the only difference will be a failure of the upgrade script to bump the database version number.
On a related note, at my paying job, we use PostgreSQL rather than Mysql, which lets you make database schema changes in a transaction, so this sort of thing can't happen. What would people think of PostgreSQL support in Leaguerunner?
Cheers, Dave _______________________________________________ Leaguerunner mailing list [email protected] http://www.dmo.ca/cgi-bin/mailman/listinfo/leaguerunner
