[pLog-svn] user permissions

[Jon Daley]

For userid 4, only the first line was done by the upgrade, the later lines 
I added via the administration permission gui.

See userid 10 for how it was upgraded.

I manually deleted userid 66 from the database, because the purge users 
didn't work.

mysql> select * from plog_users_permissions;
+-----+---------+---------+---------------+
| id  | user_id | blog_id | permission_id |
+-----+---------+---------+---------------+
| 162 |       4 |       0 |             1 |
| 163 |       3 |       0 |            49 |
| 164 |       3 |       0 |            58 |
| 165 |       3 |       0 |            52 |
| 166 |       3 |       0 |            43 |
| 167 |       3 |       0 |            46 |
| 168 |       3 |       0 |            55 |
| 169 |       3 |       0 |            39 |
| 170 |       3 |       0 |            41 |
| 171 |       3 |       0 |            66 |
| 172 |       3 |       0 |            65 |
| 173 |       3 |       0 |            51 |
| 174 |       3 |       0 |            60 |
| 175 |       3 |       0 |            62 |
| 176 |       3 |       0 |            54 |
| 177 |       3 |       0 |            45 |
| 178 |       3 |       0 |            64 |
| 179 |       3 |       0 |            48 |
| 180 |       3 |       0 |            57 |
| 181 |       3 |       0 |            42 |
| 182 |       3 |       0 |            50 |
| 183 |       3 |       0 |            59 |
| 184 |       3 |       0 |            61 |
| 185 |       3 |       0 |            53 |
| 186 |       3 |       0 |            44 |
| 187 |       3 |       0 |            63 |
| 188 |       3 |       0 |            47 |
| 189 |       3 |       0 |            56 |
| 190 |       3 |       0 |            40 |
| 191 |       3 |       0 |             1 |
| 192 |      10 |       0 |             1 |
| 194 |       4 |       1 |            24 |
| 195 |       4 |       1 |             6 |
| 196 |       4 |       1 |             9 |
| 197 |       4 |       1 |            12 |
| 198 |       4 |       1 |             3 |
| 199 |       4 |       1 |            22 |
| 200 |       4 |       1 |             2 |
| 201 |       4 |       1 |            25 |
| 202 |       4 |       1 |            15 |
| 203 |       4 |       1 |            20 |
| 204 |       4 |       1 |            10 |
| 205 |       4 |       1 |            13 |
| 206 |       4 |       1 |             4 |
| 207 |       4 |       1 |            23 |
| 208 |       4 |       1 |            17 |
| 209 |       4 |       1 |            36 |
| 210 |       4 |       1 |            34 |
| 211 |       4 |       1 |            33 |
| 212 |       4 |       1 |            30 |
| 213 |       4 |       1 |             8 |
| 214 |       4 |       1 |            16 |
| 215 |       4 |       1 |            21 |
| 216 |       4 |       1 |            11 |
| 217 |       4 |       1 |            14 |
| 218 |       4 |       1 |             5 |
| 219 |       4 |       1 |            26 |
| 220 |       4 |       1 |            18 |
+-----+---------+---------+---------------+


On Sat, 3 Mar 2007, Oscar Renalias wrote:

> 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
>>
>
> _______________________________________________
> pLog-svn mailing list
> pLog-svn at devel.lifetype.net
> http://limedaley.com/mailman/listinfo/plog-svn
>

-- 
Jon Daley
http://jon.limedaley.com/

Anything dropped in the bathroom falls in the toilet.
-- Flucard's Corollary