[pLog-svn] user permissions

[Oscar Renalias]

For each one of the rows in the "old" users_permissions table whose  
permission_id value is not '3' (2 equals to blog user and 3 to blog  
owner, although that's not used), the wizard will insert an  
equivalent set of permissions in the new framework.

But I don't quite understand what happened, could you send us the  
results of running SELECT * FROM lt_users_permissions in the same  
database after the upgrade? I'd like to see whether the conversion  
was done correctly.

On 2 Mar 2007, at 22:44, Jon Daley wrote:

>  	There is something funny with the user permissions.  Most of my
> blogs get updated via subversion, and at different points, I think  
> they
> have all gotten messed up with permissions.  One looks better than the
> others, so I'll see if that upgrades to 1.2 successfully.
>  	My blog removed permissions from the non-owner users.
>
>
> Here was my users_permissions table prior to upgrading.  I am  
> user_id = 3,
> and the site_admin flag is set only for me in the users table.
>
> +----+---------+---------+---------------+
> | id | user_id | blog_id | permission_id |
> +----+---------+---------+---------------+
> | 22 |       4 |       1 |             2 |
> | 38 |      10 |       1 |             2 |
> | 39 |      66 |       1 |             2 |
> +----+---------+---------+---------------+
>
>
> I was looking at the wizard code, because that is currently  
> stopping the
> wizard from being able to be re-run, since it copies the new
> users_permissions to tmp_users, and tries to add a gazillion  
> permissions
> for each row.  Probably the place where it says != 3 needs to be  
> smarter,
> and maybe the code needs to be smarter and not even create the  
> tmp_users
> table if the permission tables have already been upgraded.
>
> None of my installations have a permission_id of 3 for any of the  
> users.
>
> I am confused.
>
> -- 
> Jon Daley
> http://jon.limedaley.com/
>
> Experience is something you don't get until just after you need it.
> -- Olivier
> _______________________________________________
> pLog-svn mailing list
> pLog-svn at devel.lifetype.net
> http://limedaley.com/mailman/listinfo/plog-svn
>