Re: [Phpgroupware-users] root

[Ralf Becker]

It must be something else then. Deleting all rows, but the first two, 
gives you a clean "new" vfs-table.

The only thing I can offer you now, is to log into your box and check 
it. If you want to proceed this way, create a user-account to which I'm 
able to login via ssh and mail me the details (*privat* mail not the 
list) or meet me on irc://irc.freenode.net/phpgroupware

Ralf

The Emilsons wrote:
> Aye, and I still get the error, where can I find the sql for the
> phpgw_vfs table or how best to insert with a drop table?
>
> Thnx, for your input and guidance on this Ralf
>
>
>
> Viking NetWerkz
> Unix Web Hosting and Design Services
> Viking NetWerkz Your Next Site!
> http://www.vikingnetwerkz.com
>
>
> -----Original Message-----
> From: address@hidden
> [mailto:address@hidden On
> Behalf Of Ralf Becker
> Sent: August 9, 2003 12:39 PM
> To: address@hidden
> Subject: Re: [Phpgroupware-users] root
>
> It seems your vfs-install is out of sync with the filesystem, I would 
> suggest the following:
> 1) remove from the phpgw_vfs table all entries but the first 2, eg: 
> delete from phpgw_vfs where file_id > 2
> 2) remove all files/dir in /home/viking/files beside the home-dir
>
> That should fix your prob.
>
> Ralf
>
> The Emilsons wrote:
>
> > Yes I see that now, I fixed that, you are correct, an oversite.
> > So I fixed that, then I checked permissions, and still the same
>
> result,
>
> > then I changed permissions to 777. and I received this new error one
> > which says file exists but its not and and then I was halted wit this:
> >
> > Warning: mkdir(/home/viking/files/infolog): File exists in
> > /home/viking/public_html/office/infolog/inc/class.vfs.inc.php on line
> > 1783
> > vfs_sql.mkdir('/infolog','Array'), cant
> > mkdir('/home/viking/files/infolog')
> >
> >
> > Warning: mkdir(/home/viking/files/infolog/1): File exists in
> > /home/viking/public_html/office/infolog/inc/class.vfs.inc.php on line
> > 1783
> > vfs_sql.mkdir('/infolog/1','Array'), cant
> > mkdir('/home/viking/files/infolog/1')
> >
> > Database error: Invalid SQL: UPDATE phpgw_vfs SET WHERE file_id='3'
>
> AND
>
> > ((mime_type != 'journal' AND mime_type != 'journal-deleted') OR
> > mime_type IS NULL)
> > MySQL Error: 1064 (You have an error in your SQL syntax. Check the
> > manual that corresponds to your MySQL server version for the right
> > syntax to use near 'WHERE file_id='3' AND ((mime_type != 'journal' AND
> > mime_type !=)
> >
> > File: /home/viking/public_html/office/infolog/inc/class.vfs.inc.php
> > Line: 1969
> > Session halted.
> >
> >
> >
> > Regards, and thank you for your continuing efforts
> >
> >
> > Viking NetWerkz
> > Unix Web Hosting and Design Services
> > Viking NetWerkz Your Next Site!
> > http://www.vikingnetwerkz.com
> >
> >
> > -----Original Message-----
> > From: address@hidden
> > [mailto:address@hidden On
> > Behalf Of Ralf Becker
> > Sent: August 9, 2003 5:32 AM
> > To: address@hidden
> > Subject: Re: [Phpgroupware-users] root
> >
> > Hi,
> >
> > The Emilsons wrote:
> >
> >
> > > My www directory is home/viking/public_html/
> > > My server directory is home/viking/
> >
> >
> > Why do you omit the / in fron or /home/viking is that not an absolut
> > path?
> >
> >
> >
> > > I have tried creating manually these folders in server as you stated,
> > > 700 permiss on apache, and  the phpwebhosting still cannot created a
> > > directory
> > >
> > > And in info log I get these errors above althoul I can log I am unable
> > > to attach a file 
> > >
> > > Warning: mkdir(home/viking/files/infolog): No such file or directory
> >
> > in
> >
> >
> > > /home/viking/public_html/office/infolog/inc/class.vfs.inc.php on line
> > > 1783
> > > vfs_sql.mkdir('/infolog','Array'), cant
> > > mkdir('home/viking/files/infolog')
> >
> >
> > That message means there is no /home/viking/files dir.
> >
> > Are you shure you created it / can you check its there and 
> > read-/writeable by the webserver?
> >
> > Ralf
> >
> >
> >
> > > Warning: mkdir(home/viking/files/infolog/1): No such file or directory
> > > in /home/viking/public_html/office/infolog/inc/class.vfs.inc.php on
> >
> > line
> >
> >
> > > 1783
> > > vfs_sql.mkdir('/infolog/1','Array'), cant
> > > mkdir('home/viking/files/infolog/1')
> > >
> > >
> > > Warning: copy(home/viking/files/infolog/1/New Text Document.txt):
> >
> > failed
> >
> >
> > > to open stream: No such file or directory in
> > > /home/viking/public_html/office/infolog/inc/class.vfs.inc.php on line
> > > 1376
> > >
> > >
> > > Does this help, or have I broken the piped again :)
> > > Viking NetWerkz
> > > Unix Web Hosting and Design Services
> > > Viking NetWerkz Your Next Site!
> > > http://www.vikingnetwerkz.com
> > >
> > >
> > > -----Original Message-----
> > > From: address@hidden
> > > [mailto:address@hidden On
> > > Behalf Of Ralf Becker
> > > Sent: August 8, 2003 11:14 AM
> > > To: address@hidden
> > > Subject: Re: [Phpgroupware-users] root
> > >
> > > Do I understand you right:
> > > 1) Docroot: /home/viking/public_html/office
> > > 2) URL:     http://office.mysite.com
> > >
> > > Files dir could be: /home/viking/files
> > > It should be owned by the webserver and have 700 permissions only 
> > > accessible by the webserver. Your webserver-user depends on your
> >
> > distro 
> >
> >
> > > (SuSE: wwwrun, RH: apache, ...)
> > >
> > > You need to create the home-dir manualy /home/viking/files/home,
> >
> > InfoLog
> >
> >
> > > will create it's subdir automaticaly.
> > >
> > > Ralf
> > >
> > > The Emilsons wrote:
> > >
> > >
> > >
> > > > Can someone tell me the difference between server root and include
> > >
> > > root?
> > >
> > >
> > >
> > > > Trying to use both infolog and phpwebhosting?
> > > > I have attempted to create files/folders for both these apps and have
> > > > failed miserably.
> > > >
> > > > I have followed all emails to this topic, and I understand to make
> > > > outside of document for files, but for the life of me I cannot get
> > >
> > > this
> > >
> > >
> > >
> > > > app to work, I am ready to give up.
> > > >
> > > > I am running the latest vers. 
> > > > I have done home/viking/public_html/office
> > > > I have done
> > > > /office
> > > >
> > > > I have checked permissions for 777
> > > > I even manually created folders
> > > >
> > > > The only thing I do differently than what Ive read so far from you
>
> all
>
> > > > is that 
> > > > 1:I am on a virtual host
> > > > 2: the phpgroupware is in a subdomain   http://office.mysite.com/
> > > >
> > > > please I am not sure what other info you need to help me resolve
>
> this,
>
> > > > if this isn't enough info, please advise as such

--
----------------------------------------------------------------------
Ralf Becker
OUTDOOR UNLIMITED Training GmbH                Telefon 0631 / 31657-0
Leibnizstraße 17                               Telefax 0631 / 31657-26
D-67663 Kaiserslautern            EMail address@hidden