Re: [phpesp-general] Upgrading?...

[James E. F. <jf...@ac...>]

On Wed, 5 Dec 2001, Sean M Alderman wrote:

> Gang,
> 	Is it possible to do an upgrade from one version to another?  We're
> running an old version (I'm guessing by the date stamps v1.1.  I just
> downloaded the latest cvs tree (which seems to be significantly
> different, especially at the DB level).  But I didn't see any notes
> about upgrading.

Upgrading is not so trivial anymore. Unfortunately, I
didn't design the original DB especially well. Consequently
I ended up rewriting a lot of it. So the quick answer is
"no" there is no upgrade path from pre-1.3, to 1.3+. The
long answer is "of course". It just involves dumping your
data to a file, then writing a nice perl script (or the
like) that pushes the data around so that it will fit in
the new database layout.

I really did plan on providing an upgrade script for the
v1.3 release. I still want one to be in the 1.3 final
release (don't forget the most recent one [1.3RC1] is a
release *candidate*, and I have already found and fixed
several bugs in it). Is it possible for you to email me
(off-list) the current table definitions you are using, or
just tell me what the version id is on phpESP.sql that you
loaded them from? I will hopefully get a perl script
written to automate the upgrade procedure, in time for the
1.3 FINAL release.

-James