Re: [Phpgroupware-users] Session halted

[Guillaume Courtois]

Cool :-)

Bob Crandell (address@hidden) écrivait:
>
> Thank you sir.  That did it.  They are now happy campers.
>
> Guillaume Courtois (address@hidden) wrote:
> >
> > 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
> > >
> >
> >
> >
> > _______________________________________________
> > 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
>