Re: [Phpgroupware-users] Session halted

[Bob Crandell]

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
>
>

--
Bob Crandell, CLS, CNS
Assured Computing, Inc.
When you need to be sure.
http://www.assuredcomp.com/
921 Country Club Road, Suite 100
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.