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 ([EMAIL PROTECTED]) 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 ([EMAIL PROTECTED]) �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 > > [email protected] > > http://lists.gnu.org/mailman/listinfo/phpgroupware-users > > > > > > _______________________________________________ > Phpgroupware-users mailing list > [email protected] > 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. _______________________________________________ Phpgroupware-users mailing list [email protected] http://lists.gnu.org/mailman/listinfo/phpgroupware-users
