Thanks I'll work out the tables manually. I've found mysql to have much better performance than postresql.
On Wed, Dec 9, 2009 at 8:59 AM, Dave O'Neill <[email protected]> wrote: > 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 >
_______________________________________________ Leaguerunner mailing list [email protected] http://www.dmo.ca/cgi-bin/mailman/listinfo/leaguerunner
