|
From: Mattias T. <mth...@ac...> - 2007-11-09 21:15:48
|
Hello everyone, I have just implemented the User Groups feature, which allows administrators to manage user permissions in groups rather than just assigning permissions directly to each user. You'll find this in revision 1058 (but get 1059 because it fixes a simple error). To install this, you'd update to the latest revision, then run the following: php s2a.php -m usr% It will prompt you whether you want to install the new modules, so say yes to that. Now here's the wrinkle. It all worked fine on my local machine which runs MySQL 5.0.45. Our demo server, however, is running 4.1.18, and it returns the following error whenever a non-admin user tries to log in: 1271 ** Illegal mix of collations for operation 'UNION' Not pretty, at all, at all. According to the MySQL bug reports, this is supposedly fixed in MySQL 4.1.19. So, if this happens to you, this means you would need to update your MySQL server to a more recent version than 4.1.18. Alternatively, as a stop-gap measure, you could edit the lib/classes/user.class.php file by commenting out the new SQL statement that begins at line 73, and uncommenting the old line, just above it. This means disabling the user group permission functionality however. If you have any other questions or observations, please contact me. Cheers, Mattias -- Mattias Thorslund Active Agenda, Inc. mth...@ac... Company: http://www.activeagenda.net Weblog: http://activeagenda.net/blog/ |