On 12/9/05, Henri Yandell <[EMAIL PROTECTED]> wrote: > On 12/8/05, Dave Johnson <[EMAIL PROTECTED]> wrote: > > I've tested the upgrade scripts and code with MySQL and PostgreSQL and > > I've given a copy of the build to the fellow who reported the problem > > so that he can verify the fix. > > > > Additional testing would be very nice. > > Well, I got various errors still, but I'm still taking a 0.99 database > and trying to run every script to get it to 2.0. It'll take me a while > to deploy each and every Roller release as I go, but I'll give that a > shot if time permits. I'm building from > http://svn.apache.org/repos/asf/incubator/roller/branches/roller_2.0/. > > I get three types of error. > > 1) Some null value errors, which are probably because I've not been > turning on Roller. An example is: > > ERROR: column "timezone" contains null values
We need to run an update after we add the column to set the newly null values to be the default values. I'll go ahead and get that added. > 2) ERROR: constraint "att_entryid_fk" for relation "entryattribute" > already exists Side-effect of the bugs below, so no big deal. > > and most worringly: > > 3) Lots of syntax errors. ie: > > > ERROR: syntax error at or near "pt" at character 19 This just seemed to be crap sql. Will fix. > ERROR: syntax error at or near "foreign" at character 26 > (more below) The drop index and drop foreign key statements are bad for postgres. It looks painful to do this in Postgres, so the current thought (sitting next to Dave talking about it) is to just ignore them for Postgres. Here's a page talking about how to drop these in postgres, it's vomit worthy in its pain: http://www.freebsddiary.org/postgresql-dropping-constraints.php > Also I'm worried about > http://svn.apache.org/repos/asf/incubator/roller/branches/roller_2.0/trunk/ > > We seem to have files both in the trunk directory and in the directory > around it. Nothing wrong per se, but it seems likely to have been a > mistake. I've deleted the trunk directory. Hen
