RE: [Phpgroupware-users] root

[The Emilsons]

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
digital ROCK, Becker & Macht GbR            Telefon +49 (631) 31657-51
Leibnizstraße 17                            Telefax +49 (631) 31657-52
D-67663 Kaiserslautern                 EMail address@hidden



_______________________________________________
Phpgroupware-users mailing list
address@hidden
http://mail.gnu.org/mailman/listinfo/phpgroupware-users