Re: RE: [Phpgroupware-users] root

[Dave Hall]

I have sort of being following this thread, but the history seems a
little hazy.  What version of phpgw are you running?

If it is 14 (maybe 16 also) try checking that register_globals = on in
your php.ini

Cheers

Dave

The Emilsons <address@hidden> wrote:

> I managed to install those table no problem, I still get errors
> directory cant be created, yet they are manually made and the files go
> in them no problem even when the errors get printed to screen.
> But if I wish to view the subs or edit the infolog attachment I egt 
> thiserror, maybe I have a corrupt table somewhere and this is whats
> happening to both phpwebhosting and infolog?
> 
> InfoLog 
> Database error: Invalid SQL: SELECT COUNT(*) FROM phpgw_infolog i 
> WHERE( (info_owner=3 OR info_owner IN (3) OR (info_access='public' AND
> info_owner IN(3))) AND info_id_parent= ) 
> 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 ')' at line 1)
> 
> File:
> /home/viking/public_html/office/infolog/inc/class.soinfolog.inc.php
> Line: 405
> Session halted. 
> 
> Does this offer any more insite?
> 
> 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:phpgroupware-users-
> 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:phpgroupware-users-
> 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
> 
> 
> 
> _______________________________________________
> Phpgroupware-users mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>

dave.hall.vcf
Description: Card for <dave.hall@mbox.com.au>