[Xerte-dev] Re: Changing Ownership in Management PHP

Tom Reijnders reijnders at tor.nl
Fri Mar 1 20:22:05 GMT 2013


Jeee.... that was an interesting stupid mistake.

Every other LO was not shown, so if you had 9 LO's, only 5 were shown.

Fixed.

Op 1-3-2013 13:27, Tom Reijnders schreef:
> I'll check....
> Op 1-3-2013 12:07, Ron Mitchell schreef:
>>
>> Hi Tom
>>
>> sorry juggling other things and very short of time to get everything 
>> done before the end of the day :-(
>>
>> The previous version seemed to work on xampp but not on the Ubuntu 
>> server I was testing with.
>>
>> The new version works on the Ubuntu server and I tested changing 
>> ownership of a project which worked but...
>>
>> I changed ownership, logged in as the new owner in a separate browser 
>> and could see and edit the changed project so that bit works and the 
>> filtering of users works. But when I select the new owner via users 
>> templates I don't see the new project even after logging out and back 
>> in again to management. It is gone from the previous owner but isn't 
>> showing under the new owner in management even though it is available 
>> to the new owner in their workspace.
>>
>> HTH
>>
>> Ron
>>
>> *From:*xerte-dev-bounces at lists.nottingham.ac.uk 
>> [mailto:xerte-dev-bounces at lists.nottingham.ac.uk] *On Behalf Of *Tom 
>> Reijnders
>> *Sent:* 01 March 2013 10:13
>> *To:* For Xerte technical developers
>> *Subject:* [Xerte-dev] Re: Changing Ownership in Management PHP
>>
>> Hmmm.... don't know why it even worked here...
>>
>> Is this one better?
>>
>> Tom
>>
>> Op 1-3-2013 10:44, Tom Reijnders schreef:
>>
>>     What platform are you on?
>>
>>     Can you send me your version of _debug (in functions.php)
>>
>>     There should be diagnostic info there.
>>
>>     Tom
>>
>>     Op 1-3-2013 10:29, Ron Mitchell schreef:
>>
>>         Hi Tom
>>
>>         I changed the debug.log path to write to error_logs and set
>>         development to true and then tried again but still getting
>>         the same message without any error log being written.
>>
>>         If I put the svn code back I see all the users and templates.
>>
>>         HTH
>>
>>         Ron
>>
>>         *From:*xerte-dev-bounces at lists.nottingham.ac.uk
>>         <mailto:xerte-dev-bounces at lists.nottingham.ac.uk>
>>         [mailto:xerte-dev-bounces at lists.nottingham.ac.uk] *On Behalf
>>         Of *Tom Reijnders
>>         *Sent:* 01 March 2013 09:07
>>         *To:* For Xerte technical developers
>>         *Subject:* [Xerte-dev] Re: Changing Ownership in Management PHP
>>
>>         Ron,
>>
>>         It indicates the code is basically working, because you get a
>>         reply. Something goes wrong with one of the mysql queries though.
>>
>>         Could you please try this one (should be in
>>         website_code/php/management), turn on debugging and look in 
>>         '/tmp/debug.log' file for 'Query for templates of user' (and
>>         the next line)?
>>
>>         Any php errors?
>>
>>
>>         Tom
>>
>>         Op 1-3-2013 9:49, Ron Mitchell schreef:
>>
>>             Hi Tom
>>
>>             When clicking on users templates I see the drop down list
>>             with names but if I select a user and then view I get
>>             This user has no templates at present which isn't correct
>>             e.g. if I select my account which has lots of LO's I get
>>             the same message.
>>
>>             HTH
>>
>>             Ron
>>
>>             *From:*xerte-dev-bounces at lists.nottingham.ac.uk
>>             <mailto:xerte-dev-bounces at lists.nottingham.ac.uk>
>>             [mailto:xerte-dev-bounces at lists.nottingham.ac.uk] *On
>>             Behalf Of *Tom Reijnders
>>             *Sent:* 01 March 2013 07:19
>>             *To:* For Xerte technical developers
>>             *Subject:* [Xerte-dev] Re: Changing Ownership in
>>             Management PHP
>>
>>             This should be it...
>>
>>             Op 1-3-2013 0:46, Pat @ Pgogy schreef:
>>
>>                 I have no server to test, Ron and Julian would need a
>>                 patch
>>
>>                 Pgogy Webstuff - http://www.pgogywebstuff.com
>>
>>                 Makers of web things of a fair to middling quality
>>
>>
>>                 On 28 Feb 2013, at 20:54, Tom Reijnders
>>                 <reijnders at tor.nl <mailto:reijnders at tor.nl>> wrote:
>>
>>                     I've got it...
>>
>>                     This is the result:
>>
>>                     <fcgabbgg.png>
>>
>>                     <bcachfib.png>
>>
>>                     Do you want me to check this in, or do you want
>>                     the files first....
>>
>>                     Tom
>>
>>                     Op 28-2-2013 11:44, Pat @ Pgogy schreef:
>>
>>                         I will write a how to guide to do it, whilst
>>                         doing it
>>
>>                         *returns to cave* *plots*
>>
>>                         Pgogy Webstuff - http://www.pgogywebstuff.com
>>
>>                         Makers of web things of a fair to middling
>>                         quality
>>
>>
>>                         On 28 Feb 2013, at 10:25, Tom Reijnders
>>                         <reijnders at tor.nl <mailto:reijnders at tor.nl>>
>>                         wrote:
>>
>>                             I'll have a look. I am not too familiar
>>                             with Ajax and xot, but... one is never
>>                             too old to learn ;-)
>>
>>                             Tom
>>
>>                             Op 28-2-2013 10:49, Julian Tenney schreef:
>>
>>                                 I think you might be missing the
>>                                 subtle manager speak in 'would that
>>                                 be hard to do'
>>
>>                                 ;-)
>>
>>                                 *From:*xerte-dev-bounces at lists.nottingham.ac.uk
>>                                 <mailto:xerte-dev-bounces at lists.nottingham.ac.uk>
>>                                 [mailto:xerte-dev-bounces at lists.nottingham.ac.uk]
>>                                 *On Behalf Of *Pat @ Pgogy
>>                                 *Sent:* 28 February 2013 09:37
>>                                 *To:* For Xerte technical developers
>>                                 *Subject:* [Xerte-dev] Re: Changing
>>                                 Ownership in Management PHP
>>
>>                                 Rewrite the query as a list of
>>                                 usernames, make the username an Ajax
>>                                 function which fires and then returns
>>                                 just the data for that user
>>
>>                                 One new js function, and splitting
>>                                 the existing php into two files
>>
>>                                 Pgogy Webstuff -
>>                                 http://www.pgogywebstuff.com
>>
>>                                 Makers of web things of a fair to
>>                                 middling quality
>>
>>
>>                                 On 28 Feb 2013, at 09:08, Julian
>>                                 Tenney
>>                                 <Julian.Tenney at nottingham.ac.uk
>>                                 <mailto:Julian.Tenney at nottingham.ac.uk>>
>>                                 wrote:
>>
>>                                     It still times out. I think we
>>                                     probably need to limit the
>>                                     searching to a particular user
>>                                     name, entered by the admin user.
>>                                     I think that makes more sense, I
>>                                     don't really need to browse all
>>                                     users LOs, would that be hard to do?
>>
>>                                     *From:*xerte-dev-bounces at lists.nottingham.ac.uk
>>                                     <mailto:xerte-dev-bounces at lists.nottingham.ac.uk>
>>                                     [mailto:xerte-dev-bounces at lists.nottingham.ac.uk]
>>                                     *On Behalf Of *Tom Reijnders
>>                                     *Sent:* 28 February 2013 08:59
>>                                     *To:* For Xerte technical developers
>>                                     *Subject:* [Xerte-dev] Re:
>>                                     Changing Ownership in Management PHP
>>
>>                                     There were a lot of queries
>>                                     inside loops. If you have say
>>                                     8000 LO's and 800 users, it would
>>                                     do at least 8800 queries.
>>
>>                                     Try this one (this is a minor
>>                                     rewrite just re-arranging
>>                                     queries, it does 2 queries)
>>
>>                                     Tom
>>
>>                                     Op 27-2-2013 18:05, Pat @ Pgogy
>>                                     schreef:
>>
>>                                         Guess that page is timing out.
>>
>>                                         The page will need rewriting,
>>                                         or a new query doing I guess.
>>
>>                                         Pgogy Webstuff -
>>                                         http://www.pgogywebstuff.com
>>
>>                                         Makers of web things of a
>>                                         fair to middling quality
>>
>>
>>                                         On 27 Feb 2013, at 16:23,
>>                                         Julian Tenney
>>                                         <Julian.Tenney at nottingham.ac.uk
>>                                         <mailto:Julian.Tenney at nottingham.ac.uk>>
>>                                         wrote:
>>
>>                                             This is what happens:
>>
>>                                             <image001.png>
>>
>>                                             Nothing more.
>>
>>                                             *From:*xerte-dev-bounces at lists.nottingham.ac.uk
>>                                             <mailto:xerte-dev-bounces at lists.nottingham.ac.uk>
>>                                             [mailto:xerte-dev-bounces at lists.nottingham.ac.uk]
>>                                             *On Behalf Of *Pat @ Pgogy
>>                                             *Sent:* 27 February 2013
>>                                             14:41
>>                                             *To:* For Xerte technical
>>                                             developers
>>                                             *Subject:* [Xerte-dev]
>>                                             Re: Changing Ownership in
>>                                             Management PHP
>>
>>                                             Management.php is all
>>                                             ajaxed - so the front
>>                                             page should work regardless.
>>
>>                                             You can watch the speed
>>                                             of requests in console in
>>                                             firebug or chrome to see
>>                                             if that is a problem
>>
>>                                             Pgogy Webstuff -
>>                                             http://www.pgogywebstuff.com
>>
>>                                             Makers of web things of a
>>                                             fair to middling quality
>>
>>
>>                                             On 27 Feb 2013, at 13:36,
>>                                             Julian Tenney
>>                                             <Julian.Tenney at nottingham.ac.uk
>>                                             <mailto:Julian.Tenney at nottingham.ac.uk>>
>>                                             wrote:
>>
>>                                                 I had thought it was
>>                                                 due to the size of
>>                                                 the database, because
>>                                                 I noticed it really
>>                                                 starting slow up as
>>                                                 the number of LOs
>>                                                 increased -- we have
>>                                                 about 8000 now. Does
>>                                                 management.php work
>>                                                 OK on the sandpit On?
>>                                                 You've got a similar
>>                                                 number of LOs in
>>                                                 there haven't you?
>>
>>                                                 *From:*xerte-dev-bounces at lists.nottingham.ac.uk
>>                                                 <mailto:xerte-dev-bounces at lists.nottingham.ac.uk>
>>                                                 [mailto:xerte-dev-bounces at lists.nottingham.ac.uk]
>>                                                 *On Behalf Of *Pat @
>>                                                 Pgogy
>>                                                 *Sent:* 27 February
>>                                                 2013 12:53
>>                                                 *To:* For Xerte
>>                                                 technical developers
>>                                                 *Subject:*
>>                                                 [Xerte-dev] Re:
>>                                                 Changing Ownership in
>>                                                 Management PHP
>>
>>                                                 Yes changing
>>                                                 ownership has been
>>                                                 there for ages.
>>
>>                                                 If it freezes it
>>                                                 suggests a JavaScript
>>                                                 problem has occurred
>>
>>                                                 Pgogy Webstuff -
>>                                                 http://www.pgogywebstuff.com
>>
>>                                                 Makers of web things
>>                                                 of a fair to middling
>>                                                 quality
>>
>>
>>                                                 On 27 Feb 2013, at
>>                                                 11:56, Julian Tenney
>>                                                 <Julian.Tenney at nottingham.ac.uk
>>                                                 <mailto:Julian.Tenney at nottingham.ac.uk>>
>>                                                 wrote:
>>
>>                                                     Can I change
>>                                                     ownership in
>>                                                     management.php?
>>                                                     When I log in, it
>>                                                     just appears to
>>                                                     freeze, clicking
>>                                                     any of the top
>>                                                     menus doesn't
>>                                                     appear to do
>>                                                     anything,
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>                                                     _______________________________________________
>>                                                     Xerte-dev mailing
>>                                                     list
>>                                                     Xerte-dev at lists.nottingham.ac.uk
>>                                                     <mailto:Xerte-dev at lists.nottingham.ac.uk>
>>                                                     http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev
>>
>>                                                 _______________________________________________
>>                                                 Xerte-dev mailing list
>>                                                 Xerte-dev at lists.nottingham.ac.uk
>>                                                 <mailto:Xerte-dev at lists.nottingham.ac.uk>
>>                                                 http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev
>>
>>                                             _______________________________________________
>>                                             Xerte-dev mailing list
>>                                             Xerte-dev at lists.nottingham.ac.uk
>>                                             <mailto:Xerte-dev at lists.nottingham.ac.uk>
>>                                             http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>                                         _______________________________________________
>>
>>                                         Xerte-dev mailing list
>>
>>                                         Xerte-dev at lists.nottingham.ac.uk  <mailto:Xerte-dev at lists.nottingham.ac.uk>
>>
>>                                         http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev
>>
>>
>>
>>
>>
>>
>>
>>                                     -- 
>>
>>                                     --
>>
>>                                       
>>
>>                                     Tom Reijnders
>>
>>                                     TOR Informatica
>>
>>                                     Chopinlaan 27
>>
>>                                     5242HM Rosmalen
>>
>>                                     Tel: 073 5226191
>>
>>                                     Fax: 073 5226196
>>
>>                                       
>>
>>
>>
>>
>>
>>
>>                                     _______________________________________________
>>                                     Xerte-dev mailing list
>>                                     Xerte-dev at lists.nottingham.ac.uk
>>                                     <mailto:Xerte-dev at lists.nottingham.ac.uk>
>>                                     http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev
>>
>>
>>
>>
>>
>>
>>                                 _______________________________________________
>>
>>                                 Xerte-dev mailing list
>>
>>                                 Xerte-dev at lists.nottingham.ac.uk  <mailto:Xerte-dev at lists.nottingham.ac.uk>
>>
>>                                 http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev
>>
>>
>>
>>
>>
>>                             -- 
>>
>>                             --
>>
>>                               
>>
>>                             Tom Reijnders
>>
>>                             TOR Informatica
>>
>>                             Chopinlaan 27
>>
>>                             5242HM Rosmalen
>>
>>                             Tel: 073 5226191
>>
>>                             Fax: 073 5226196
>>
>>                               
>>
>>
>>
>>
>>
>>                             _______________________________________________
>>                             Xerte-dev mailing list
>>                             Xerte-dev at lists.nottingham.ac.uk
>>                             <mailto:Xerte-dev at lists.nottingham.ac.uk>
>>                             http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>                         _______________________________________________
>>
>>                         Xerte-dev mailing list
>>
>>                         Xerte-dev at lists.nottingham.ac.uk  <mailto:Xerte-dev at lists.nottingham.ac.uk>
>>
>>                         http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev
>>
>>
>>
>>
>>
>>                     -- 
>>
>>                     --
>>
>>                       
>>
>>                     Tom Reijnders
>>
>>                     TOR Informatica
>>
>>                     Chopinlaan 27
>>
>>                     5242HM Rosmalen
>>
>>                     Tel: 073 5226191
>>
>>                     Fax: 073 5226196
>>
>>                       
>>
>>                     _______________________________________________
>>                     Xerte-dev mailing list
>>                     Xerte-dev at lists.nottingham.ac.uk
>>                     <mailto:Xerte-dev at lists.nottingham.ac.uk>
>>                     http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>                 _______________________________________________
>>
>>                 Xerte-dev mailing list
>>
>>                 Xerte-dev at lists.nottingham.ac.uk  <mailto:Xerte-dev at lists.nottingham.ac.uk>
>>
>>                 http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev
>>
>>
>>
>>
>>
>>             -- 
>>
>>             --
>>
>>               
>>
>>             Tom Reijnders
>>
>>             TOR Informatica
>>
>>             Chopinlaan 27
>>
>>             5242HM Rosmalen
>>
>>             Tel: 073 5226191
>>
>>             Fax: 073 5226196
>>
>>               
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>             _______________________________________________
>>
>>             Xerte-dev mailing list
>>
>>             Xerte-dev at lists.nottingham.ac.uk  <mailto:Xerte-dev at lists.nottingham.ac.uk>
>>
>>             http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev
>>
>>
>>
>>
>>         -- 
>>
>>         --
>>
>>           
>>
>>         Tom Reijnders
>>
>>         TOR Informatica
>>
>>         Chopinlaan 27
>>
>>         5242HM Rosmalen
>>
>>         Tel: 073 5226191
>>
>>         Fax: 073 5226196
>>
>>           
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>         _______________________________________________
>>
>>         Xerte-dev mailing list
>>
>>         Xerte-dev at lists.nottingham.ac.uk  <mailto:Xerte-dev at lists.nottingham.ac.uk>
>>
>>         http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev
>>
>>
>>
>>     -- 
>>
>>     --
>>
>>       
>>
>>     Tom Reijnders
>>
>>     TOR Informatica
>>
>>     Chopinlaan 27
>>
>>     5242HM Rosmalen
>>
>>     Tel: 073 5226191
>>
>>     Fax: 073 5226196
>>
>>       
>>
>>
>>
>>
>>
>>
>>
>>     _______________________________________________
>>
>>     Xerte-dev mailing list
>>
>>     Xerte-dev at lists.nottingham.ac.uk  <mailto:Xerte-dev at lists.nottingham.ac.uk>
>>
>>     http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev
>>
>>
>>
>> -- 
>> --
>>   
>> Tom Reijnders
>> TOR Informatica
>> Chopinlaan 27
>> 5242HM Rosmalen
>> Tel: 073 5226191
>> Fax: 073 5226196
>>   
>>
>>
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> Xerte-dev mailing list
>> Xerte-dev at lists.nottingham.ac.uk
>> http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev
>
> -- 
> --
>
> Tom Reijnders
> TOR Informatica
> Chopinlaan 27
> 5242HM Rosmalen
> Tel: 073 5226191
> Fax: 073 5226196
>
>
>
>
>
>
> _______________________________________________
> Xerte-dev mailing list
> Xerte-dev at lists.nottingham.ac.uk
> http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev

-- 
--

Tom Reijnders
TOR Informatica
Chopinlaan 27
5242HM Rosmalen
Tel: 073 5226191
Fax: 073 5226196

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nottingham.ac.uk/pipermail/xerte-dev/attachments/20130301/abb606f3/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: get_templates_for_user.php
Type: application/x-httpd-php
Size: 7014 bytes
Desc: not available
URL: <http://lists.nottingham.ac.uk/pipermail/xerte-dev/attachments/20130301/abb606f3/attachment-0001.bin>


More information about the Xerte-dev mailing list