|
From: | Ralf Becker |
Subject: | Re: [Phpgroupware-users] root |
Date: | Sun, 10 Aug 2003 17:12:15 +0200 |
User-agent: | Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4) Gecko/20030626 |
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] rootIt 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/phpgroupwareRalf 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] rootIt 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 > 22) 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 sameresult,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 amunableto attach a fileWarning: mkdir(home/viking/files/infolog): No such file or directoryin/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?RalfWarning: mkdir(home/viking/files/infolog/1): No such file ordirectoryin /home/viking/public_html/office/infolog/inc/class.vfs.inc.php online1783 vfs_sql.mkdir('/infolog/1','Array'), cant mkdir('home/viking/files/infolog/1') Warning: copy(home/viking/files/infolog/1/New Text Document.txt):failedto 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/filesIt should be owned by the webserver and have 700 permissions only accessible by the webserver. Your webserver-user depends on yourdistro(SuSE: wwwrun, RH: apache, ...) You need to create the home-dir manualy /home/viking/files/home,InfoLogwill create it's subdir automaticaly. Ralf The Emilsons wrote:Can someone tell me the difference between server root and includeroot?Trying to use both infolog and phpwebhosting? I have attempted to create files/folders for both these apps andhavefailed 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 getthisapp to work, I am ready to give up.I am running the latest vers. I have done home/viking/public_html/officeI 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 youallis that 1:I am on a virtual host2: the phpgroupware is in a subdomain http://office.mysite.com/ please I am not sure what other info you need to help me resolvethis,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
[Prev in Thread] | Current Thread | [Next in Thread] |