Re: [Phpgroupware-users] Session halted

[Guillaume Courtois]

You can try phpMyAdmin or command-line sql.

Bob Crandell (address@hidden) écrivait:
>
> Looks like the missing part is a group number.  Logging in as Admin I can't
> get into her account to assign a group.  It gives the same error.  Webmin
> won't let me edit phpgw_acl becasue:
> Data in this table cannot be edited because it has no primary key.
>
> How do I get a correct value in there?
>
> Thanks
>
> Guillaume Courtois (address@hidden) wrote:
> >
> > The problem is in the 6,0,,26,5 part. There should be a value between the 2
> > empty "," .
> >
> > Maybe the accounts are missing something ? Can you compare the values in the
> > users table in the db ?
> >
> > Bob Crandell (address@hidden) écrivait:
> > >
> > > Hi,
> > >
> > > I have a client that is getting this error when logging in:
> > > Database error: Invalid SQL: select * from phpgw_acl where (acl_account 
> > > in (6,
> > > 0,,26,5))
> > > MySQL Error: 1064 (You have an error in your SQL syntax near '26,5))' at 
> > > line
> > > 1)
> > >
> > > File: /home/web/htdocs/phpgroupware/phpgwapi/inc/class.acl.inc.php
> > > Line: 137
> > >
> > > Session halted.
> > >
> > > This is happening to only a couple of users.
> > > The latest CVS.
> > > Apache/1.3.33
> > > Mysql 3.23.58
> > > PHP 4.3.3
> > >
> > > I repaired:
> > > phpgw_acl
> > > phpgw_accounts
> > > phpgw_access_log
> > >
> > > Thanks
> > >
> > > Eugene, OR 97402
> > > Voice - 541-868-0331
> > > FAX - 541-463-1627
> > >
> > > This message is intended solely for the use of the individual and entity 
> > > to
> > > whom it is addressed, and may contain information that is privileged,
> > > confidential, and exempt from disclosure under applicable state and 
> > > federal
> > > laws. If you are not the addressee, or are not authorized to receive for 
> > > the
> > > intended addressee, you are hereby notified that you may not use, copy,
> > > distribute, or disclose to anyone this message or the information 
> > > contained
> > > herein. If you have received this message in error, immediately advise the
> > > sender by reply email and destroy this message.
> > >
> > >
> > >
> > >
> > > _______________________________________________
> > > Phpgroupware-users mailing list
> > > address@hidden
> > > http://lists.gnu.org/mailman/listinfo/phpgroupware-users
> > >
> >
> >
> >
> > _______________________________________________
> > Phpgroupware-users mailing list
> > address@hidden
> > http://lists.gnu.org/mailman/listinfo/phpgroupware-users
> >
> >
>
> Eugene, OR 97402
> Voice - 541-868-0331
> FAX - 541-463-1627
>
> This message is intended solely for the use of the individual and entity to
> whom it is addressed, and may contain information that is privileged,
> confidential, and exempt from disclosure under applicable state and federal
> laws. If you are not the addressee, or are not authorized to receive for the
> intended addressee, you are hereby notified that you may not use, copy,
> distribute, or disclose to anyone this message or the information contained
> herein. If you have received this message in error, immediately advise the
> sender by reply email and destroy this message.
>
>
>
>
> _______________________________________________
> Phpgroupware-users mailing list
> address@hidden
> http://lists.gnu.org/mailman/listinfo/phpgroupware-users
>