[pLog-svn] Notification of required database changes

[Mark Wu]

I try 3 or 4 time upgrade from 1.1->1.1

It always show me "Error performing changes to the articles table (3)"

I think it is because there is no lt_trackbacks table in 1.1. When I click
next, it will go back to step one again.

Mark
> -----Original Message-----
> From: plog-svn-bounces at devel.lifetype.net 
> [mailto:plog-svn-bounces at devel.lifetype.net] On Behalf Of 
> Oscar Renalias
> Sent: Wednesday, April 05, 2006 9:05 PM
> To: plog-svn at devel.lifetype.net
> Subject: Re: [pLog-svn] Notification of required database changes
> 
> Are you sure it doesn't work?
> 
> Most of the new fields are just counters and the update 
> process in the wizard just counts the number of rows 
> fulfilling certain condition and setting the resulting value 
> in the new column. It doesn't really matter when or how many 
> times you run these queries, they'll always give the right result.
> 
> Oscar
> 
> On 4/5/06, Mark Wu <markplace at gmail.com> wrote:
> > I think it will get success in "database" change pahse, but 
> will fail 
> > in "data" change pashe...
> >
> > Because data change pashe only work from 1.0 -> 1.1
> >
> > I try it several times...  :P
> >
> > Mark
> >
> > > -----Original Message-----
> > > From: plog-svn-bounces at devel.lifetype.net
> > > [mailto:plog-svn-bounces at devel.lifetype.net] On Behalf Of Oscar 
> > > Renalias
> > > Sent: Wednesday, April 05, 2006 2:08 PM
> > > To: plog-svn at devel.lifetype.net
> > > Subject: Re: [pLog-svn] Notification of required database changes
> > >
> > > It should be possible to run the wizard as many times as 
> needed in 
> > > the current development version of 1.1. If the new columns are 
> > > already available in the db, it won't do anything and if they're 
> > > not, it will execute an ALTER statement that will take care of 
> > > creating them.
> > >
> > > Oscar
> > >
> > > On 4/5/06, Paul Westbrook <paul at westbrooks.org> wrote:
> > > > Hello,
> > > >     When a schema change is made, what is the "right" way
> > > to run these
> > > > upgrades if lifetype is already installed?  Should the
> > > wizard be run
> > > > again?  Does the wizard handle upgrades within a major
> > > version number
> > > > (i.e. an earlier version of 1.1 when upgrading to a later
> > > version of
> > > > 1.1)
> > > >
> > > >    Or should we run the sql statements by hand?
> > > >
> > > > --Paul
> > > >
> > > >
> > > > --
> > > > Paul Westbrook
> > > > paul at westbrooks.org
> > > > <http://www.westbrooks.org>
> > > >
> > > >
> > > > _______________________________________________
> > > > pLog-svn mailing list
> > > > pLog-svn at devel.lifetype.net
> > > > http://devel.lifetype.net/mailman/listinfo/plog-svn
> > > >
> > > _______________________________________________
> > > pLog-svn mailing list
> > > pLog-svn at devel.lifetype.net
> > > http://devel.lifetype.net/mailman/listinfo/plog-svn
> >
> > _______________________________________________
> > pLog-svn mailing list
> > pLog-svn at devel.lifetype.net
> > http://devel.lifetype.net/mailman/listinfo/plog-svn
> >
> _______________________________________________
> pLog-svn mailing list
> pLog-svn at devel.lifetype.net
> http://devel.lifetype.net/mailman/listinfo/plog-svn