From: <ge...@en...> - 2010-11-02 17:56:07
|
Hi Jonny - thanks I've just re-run the installer and the db error did not occur second time around - but I still have the admin problem The admin user has not actually 'fallen out' out of the Admins Group - its odd because admin still has some permissions - one of which user admin - so I've checked that. Also there wasn't any "little form" that was shown. When you say 'remove them all' I assume you mean keep the categories as named - otherwise you'll lose all the content assignments - but just remove the specific permissions assigned. This might make sense even when there are a lot of them - since it might be easier to rebuild them in the 'new' way from scratch since the old simple category permissions don't work anyway. Perhaps I will use custom profiles - as this might be a bit quicker than all the (still) quite complicated assignments you need to do with the new category permissions screens Looks like I should roll back the site to the 3.8 instance and try that route More anon no doubt g -----Original Message----- From: Jonny Bradley [mailto:jo...@ti...] Sent: 02 November 2010 17:32 To: ge...@en...; Tikiwiki developers Subject: Re: [Tikiwiki-devel] 3.8 to 6.0b3 upgrade problem Hi Geoff & list Good to get some feedback from the betas - the UPDATE users_objectpermissions error you get will be from one of the category perms overhaul that happened in tiki 4. It's a php script so not "ignorable" (does it happen again if you re-run the installer?) I have found the best thing for Tiki 3 sites using category perms is to remove them all and start again - the way you had to do stuff in 3.x was so convoluted that what seems like a really complicated setup in 3 should be comparatively simple in 4+. However, i know you have sites with a lot of groups and categs so this may not be possible... The mapping of perms that these scripts do is the best we can manage, mainly because before 4 categ perms were essentially broken, and so people had to do all sorts of workarounds to achieve their desired effect, and each case can be quite different. As far as the admin not having tiki_p_admin goes - i believe this can happen when the admin user "falls out of" the Admins group (sometimes this can happen if Admins is renamed). There should be a little form to fix this on the installer when you update from 3 to 6 - did you see it? (and use it?) 6.0 needs to be released very soon (see next mail), and upgrading from the previous LTS is obviously essential - so i hope we can get these resolved and/or the release notes amended to tell people how to cope with these things. jonny (p.s. if you can send over the database i'll have a go myself if/when i can clear some time) On 2 Nov 2010, at 16:38, geoff@enmore wrote: > Hi - I've just done my first test upgrade from 3.8 to 6.0b3 and I got > one SQL query db error in the installer > > UPDATE `users_objectpermissions` SET `permName`=? WHERE `permName`=? > Duplicate entry > '2fc8b475c69d8e6248bf5a3aef2c9388-category-Admins-tiki_p_view_cat' for > key 1 > > There wasn't any tick box for 'ignoring' so I am assuming this isn't a patch ?? > > Much more of a problem is that when I logged in as admin after the > installer completed - I no longer had all the admin permissions so I > can't do much - not even clear the caches > > I'm assuming these two effects are related !!! > > Would appreciate some advice/help > > This is just a development site which has been progressively upgraded in the normal way over several years - but should be indicative of other 3.x to 6.0 upgrades that I am planning to do, so I'm a bit worried at the moment! > > cheers > > geoff > No virus found in this message. > Checked by AVG - www.avg.com > Version: 10.0.1153 / Virus Database: 424/3232 - Release Date: 11/01/10 > > ---------------------------------------------------------------------- > -------- Nokia and AT&T present the 2010 Calling All Innovators-North > America contest Create new apps & games for the Nokia N8 for consumers > in U.S. and Canada $10 million total in prizes - $4M cash, 500 > devices, nearly $6M in marketing Develop with Nokia Qt SDK, Web > Runtime, or Java and Publish to Ovi Store > http://p.sf.net/sfu/nokia-dev2dev_____________________________________ > __________ > Tikiwiki-devel mailing list > Tik...@li... > https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel _____ No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1153 / Virus Database: 424/3232 - Release Date: 11/01/10 |