[turba] Turba 1.1 - 1.2 SQL schema change?

[Network Administrator]

Quoting Andrew Morgan <morgan at orst.edu>:

> 
> 
> On Thu, 13 Mar 2003, Network Administrator wrote:
> 
> > I just downloaded the turba 1.2 and I noticed that after I installed it,
> my
> > addressbook was not coming up (we were using turba 1.1).  In trying to add
> a
> > new entry, I saw an error in the horde.log about "no such field" for
> > "object_type" and I do see that there is a schema difference between the
> two
> > products.
> >
> > So my question is simply, "is the only way to migrate from a turba 1.1 sql
> > addressbook to a turba 1.2 sql addressbook via dumping the data, dropping
> the
> > turba_objects table, reloading the table with the new schema, modifying the
> data
> > (by adding a column to represent the new field) and reloading it into the
> table?"
> >
> > (I'm using pgSQL for the record)
> >
> > or
> >
> > did I miss something in the documentation?
> >
> > I'm hoping someone sees this tonight so that I can get my clients
> addressbook
> > back up.  Your webmail system is absolutely the best I've seen and so far
> our
> > clients seem to like it too.  I can't wait 'til Kronolith goes g.a..
> >
> > Thanks in advance for any help or further recommended proceedings.
> >
> > --
> > Keith C. Perry
> > Director of Networks & Applications
> > VCSN, Inc.
> > http://vcsn.com
> 
> Keith,
> 
> Have a look at turba/scripts/drivers/mysql_upgrade_1.1_to_1.2.sql.  You'll
> probably have to modify this to make it work with Postgres, but you'll get
> the idea of the changes required.  You do NOT have to dump the data, at
> least with mysql.  I suspect that postgres can alter tables on the fly
> also.
> 
> 	Andy

Ahh, of course I was looking right at that file and didn't read.  Ok, I made
some change but I don't think pgSQL can modify the field types on the fly.  I'm
still at 7.1.3 on this server but that seems to be the case for 7.3 as well.  So
no big deal, I'll just do it the old fashioned way :)  using the mysql upgrade
file as a guide.

Thanks for the quick come back Andy.


-- 
Keith C. Perry
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com

____________________________________
This email account is being host by:
VCSN, Inc : http://vcsn.com