Re: [Phpgroupware-developers] phpgwapi/inc/class.acl.inc.php $this->account_id ERROR

[Dave Hall]

Robert Warren <address@hidden> wrote:

> Hello,
> I'm resubmitting this because I haven't gotten a response. Check 
> out the LOOK 
> notes in the errors. I'm using the .9.14.001 tarball installation. 

I did not reply to this post 2 days ago because I have been busy and you
have not provided any info about the box you are running phpgw on. 
Please provide the following info:

OS(distro)
Apache version
PHP version
authentication system used
RDBMS and version
and anything that might be relevant

This may help us start to be able to track down the problem.

Also look at
http://savannah.gnu.org/cgi-bin/viewcvs/phpgroupware/phpgwapi/doc/php-configuration.txt?rev=1.2&content-type=text/vnd.viewcvs-markup
and make sure your setting match those.

Cheers

Dave
> 
> On Sunday 26 January 2003 04:39 pm, Robert Warren wrote:
> > Hello,
> >
> > I am getting the following error when I follow the the links 
> below and
> > logged in with user id 6.
> >
> >
> > admin ->user accounts -> view -> ACL rights ->  Deny access to site
> > configuration ( or any other link on this page )
> > --------
> > Database error: Invalid SQL: select * from phpgw_acl where 
> (acl_account in
> > (,0,11,2))
>    ^
>    LOOK no value for $this->account_id
> >
> > File: /home/www/phpgroupware/phpgwapi/inc/class.acl.inc.php
> > Line: 94
> >
> > Session halted.
> > ----------
> >
> > The problem is that the value of $this->account_id was not 
> assigned to the
> > set in the sql statement on line 86 of 
> phpgwapi/inc/class.acl.inc.php.>
> > Here is the line:
> >  $sql = 'select * from phpgw_acl where (acl_account in
> > ('.$this->account_id.',0';
> >
> > I found that if I removed the '(' then the value would then be 
> assigned> correctly. But of course the sql statment was still in 
> error.> Here is the new line:
> >  $sql = 'select * from phpgw_acl where (acl_account in
> > '.$this->account_id.',0';
> >
> > When I refresh the page using the new 'incorect' line I get the 
> new error
> > -----
> > Database error: Invalid SQL: select * from phpgw_acl where 
> (acl_account in
> > 6,0,11,2))
>    ^
>    LOOK the value for $this->account_id comes through.
> 
> >
> > File: /home/www/phpgroupware/phpgwapi/inc/class.acl.inc.php
> > Line: 94
> >
> > Session halted.
> >  Fatal error: Call to undefined function: parse_navbar_end() in
> > /home/www/phpgroupware/phpgwapi/inc/footer.inc.php on line 62
> > -------
> >
> > Thank you,
> 
> -- 
> Robert Warren
> address@hidden
> (970) 349 1523
> 
> 
> _______________________________________________
> Phpgroupware-developers mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
>

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