You can try phpMyAdmin or command-line sql. Bob Crandell ([EMAIL PROTECTED]) �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 ([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 > > > > > > 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
