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

Tom Reijnders reijnders at tor.nl
Fri Mar 1 09:06:54 GMT 2013


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] *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
> 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/60c01fca/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: get_templates_for_user.php
Type: application/x-httpd-php
Size: 7012 bytes
Desc: not available
URL: <http://lists.nottingham.ac.uk/pipermail/xerte-dev/attachments/20130301/60c01fca/attachment-0001.bin>


More information about the Xerte-dev mailing list