[Activeagenda-general] User Groups and a wrinkle

[Mattias T. <mth...@ac...>]

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/