[OGo-Users] Project files disappeared

[Adam Tauno Williams]

On Wed, 2006-11-01 at 12:44 -0300, Eduardo Elgueta wrote:
> On 11/1/06, Adam Tauno Williams <adam@morrison-ind.com> wrote:
> > On Wed, 2006-11-01 at 12:05 -0300, Eduardo Elgueta wrote:
> > > On 10/31/06, Adam Tauno Williams <adam@morrison-ind.com> wrote:
> > > > > We were using OGo 1.0beta.2. After we upgraded to 1.1.5 we see no
> > > > > project files. However, if I try to upload the files again, zidestore
> > > > > reports the path already exists (like if the files are already there).
> > > > Did you make sure your defaults are the same?  Are you uploading via
> > > > ZideStore or the WebUI?
> > > AFAIK, Defaults are the same (the old server died, so I'm not a
> > > hundred percent sure).
> > > What are relevant defaults that could cause
> > > this behaviuor? The problem happens both via ZideStore and WebUI
> > SkyFSPath ("/var/lib/opengroupware.org/fs") for filesystem projects.
> > I'm not certain what the one for DB projects is,  the default Default
> > should be correct (usually "/var/lib/opengroupware.org/documents")
> All of our projects are db based. I thought documets were stored in
> the db in this case! Should I copy files from the old server to the
> new one? (It's being serviced and it'll be ready tomorrow)

Yes.  Only references are stored in the database;  you need the files
from the old server.

> > > > > Sounds like we need to upgrade the database schema. If so, how is this done?
> > > > Unlikely.
> > > What else, then?
> > I'd assume either location or file permissions; assuming you have a good
> > restore of your lost database.  The database schema hasn't changed for
> > ages.
> The database it's in a different server which has had no problem so
> far. It's not a restore.

Cool

> > Do you see the documents listed in the projects?  IE, they are listed
> > but not accessible?  Or do they just not appear?
> No, I don't see them listed, they don't appear. When I try to upload a
> file I know was there before but it's not seen, I get the error.
> Completely new files have no problem.

Yep, I think you just need to
restore /var/lib/opengroupware.org/documents or your equivalent
directory.