RE: [Phpgroupware-users] root

[The Emilsons]

How do install without losing my tables, or do I just install the apps,
and then which apps would that be?
If I do a fresh install or copy,where do I get the download from , if
the phpgroupware site is down?

I am just afraid that if I reinstall I will have tables rewritten?

Regards
 
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 10, 2003 11:12 AM
To: address@hidden
Subject: Re: [Phpgroupware-users] root

The Emilsons wrote:
> Sorry, thought I mentioned that I accident cleared all tables , and we

If you cleared all tables, just reinstall via setup. Theres nothing to 
loose then.

> have no ssh, I can  get it, but my provider will only offer temporary,
> is there an sql table someone can send me?
> 
> 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 10, 2003 4:45 AM
> To: address@hidden
> Subject: Re: [Phpgroupware-users] root
> 
> 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
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