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

[Robert Warren]

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. 

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